By extended the Jdbcdaosupport, set the DataSource and JdbcTemplate in your class are no longer required, you just need to Inject the correct datasource into Jdbccustomerdao. And you can get the JdbcTemplate by using a getjdbctemplate () method.
Public class extends Implements customerdao{ //no need to set DataSourcehere public void Insert (Customer customer) { = ' INSERT into Customer ' + ' (cust_id, NAME, age) VALUES (?,?,?) " ; New object[] {customer.getcustid (), customer.getname (), Customer.getage () });
<Beansxmlns= "Http://www.springframework.org/schema/beans"Xmlns:xsi= "Http://www.w3.org/2001/XMLSchema-instance"xsi:schemalocation= "Http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/ Spring-beans-2.5.xsd "> <BeanID= "DataSource"class= "Org.springframework.jdbc.datasource.DriverManagerDataSource"> < Propertyname= "Driverclassname"value= "Com.mysql.jdbc.Driver" /> < Propertyname= "url"value= "Jdbc:mysql://localhost:3306/mkyongjava" /> < Propertyname= "username"value= "root" /> < Propertyname= "Password"value= "Password" /> </Bean></Beans>
<Beansxmlns= "Http://www.springframework.org/schema/beans"Xmlns:xsi= "Http://www.w3.org/2001/XMLSchema-instance"xsi:schemalocation= "Http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/ Spring-beans-2.5.xsd "> <BeanID= "Customerdao"class= "Com.mkyong.customer.dao.impl.JdbcCustomerDAO"> < Propertyname= "DataSource"ref= "DataSource" /> </Bean></Beans>
Example with Jdbcdaosupport