测试单元:
packagecom.lcw.spring.jdbc;importorg.junit.Test;importorg.springframework.jdbc.core.JdbcTemplate;importorg.springframework.jdbc.datasource.DriverManagerDataSource;public classJDBCTemplate {
@Testpublic voiddemo(){
DriverManagerDataSource dataSource=newDriverManagerDataSource();
dataSource.setDriverClassName("com.mysql.jdbc.Driver");
dataSource.setUrl("jdbc:mysql:///spring");
dataSource.setUsername("root");
dataSource.setPassword("");
JdbcTemplate jdbcTemplate=newJdbcTemplate(dataSource);
jdbcTemplate.execute("create table temp(id int primary key,name varchar(32))");
}
}
很简单吧,再来看下使用结合配置文件,完整的实现对一个类的增删改查
首先DEMO目录结构:
配置appliactionContext.xml:
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">
接口:IUserDAO.java
packagecom.curd.spring.dao;importjava.util.List;importcom.curd.spring.vo.User;public interfaceIUserDAO {public voidaddUser(User user);public void deleteUser(intid);public voidupdateUser(User user);public String searchUserName(intid);public User searchUser(intid);public ListfindAll();
}