2014/12/11
bean.xml
<!-- Spring对jdbc支持 -->
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="${jdbc.driverClassName}"/>
<property name="url" value="${jdbc.url}"/>
<property name="username" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
</bean>
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="dataSource"/>
</bean>
<context:property-placeholder location="jdbc.properties"/>
<bean id="studentDao" class="com.dao.impl.StudentDaoImpl">
<property name="jdbcTemplate" ref="jdbcTemplate"></property>
</bean>
<bean id="studentService" class="com.service.impl.StudentServiceImpl">
<property name="studentDao" ref="studentDao"></property>
</bean>
StudentDaoImpl.java
private JdbcTemplate jdbcTemplate;
public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
this.jdbcTemplate = jdbcTemplate;
}
public int addStudent(Student student) {
String sql = "insert into student value(null,?,?)";
Object []params = new Object[]{student.getUsername(),student.getAge()};
return jdbcTemplate.update(sql,params);
}
public int updateStudent(Student student) {
String sql = "update student set username=?,age=? where id=?";
Object []params = new Object[]{student.getUsername(),student.getAge(),student.getId()};
return jdbcTemplate.update(sql,params);
}
public int deleteStudent(int id) {
String sql = "delete from student where id=?";
Object []params = new Object[]{id};
return jdbcTemplate.update(sql,params);
}
public List<Student> findStudents() {
String sql = "select * from student";
final List<Student> studentList = new ArrayList<Student>();
jdbcTemplate.query(sql, new RowCallbackHandler(){
public void processRow(ResultSet rs) throws SQLException {
Student student = new Student();
student.setAge(rs.getInt("age"));
student.setId(rs.getInt("id"));
student.setUsername(rs.getString("username"));
studentList.add(student);
}
});
return studentList;
StudentServiceImpl.java
private StudentDao studentDao;
public void setStudentDao(StudentDao studentDao) {
this.studentDao = studentDao;
}
public int addStudent(Student student) {
return studentDao.addStudent(student);
}
public int updateStudent(Student student) {
return studentDao.updateStudent(student);
}
public int deleteStudent(int id) {
return studentDao.deleteStudent(id);
}
public List<Student> findStudents() {
return studentDao.findStudents();
}
Test.java
ApplicationContext ac = new ClassPathXmlApplicationContext("bean.xml");
/*//JdbcTemplate，添加
StudentService ss = (StudentService)ac.getBean("studentService");
int addNum = ss.addStudent(new Student("刘程",17));
if(addNum == 1){
System.out.println("成功");
}*/
/*//JdbcTemplate，更新
StudentService ss = (StudentService)ac.getBean("studentService");
int updateNum = ss.updateStudent(new Student(2,"常煜",18));
if(updateNum == 1){
System.out.println("成功");
}*/
/*//JdbcTemplate，删除
StudentService ss = (StudentService)ac.getBean("studentService");
int deleteNum = ss.deleteStudent(2);
if(deleteNum == 1){
System.out.println("成功");
}*/
//JdbcTemplate，查找
StudentService ss = (StudentService)ac.getBean("studentService");
List<Student> studentList = ss.findStudents();
for(Student student:studentList){
System.out.println(student);
}
两个接口省略咯！！！
【未完待续(｡◕∀◕｡)
