Properties are there in the db.properties file. I have used properties file to configure datasource where all the ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 įirst thing is to set up DataSource as a bean. Database tableįor this example I have created a table called employee with the columns id, name and age in the MYSQL DB.Ĭolumn id is configured as auto increment checked so no need to pass id from your query as DB will provide value for it. Alternatively you can download the jars and add them to the class path.