Spring（七）--Spring JDBC

2018-09-18 06:34:20来源：博客园阅读 ()

Spring JDBC

1.需要的实体类和数据库

2.需要的dao层

 1 package com.xdf.dao;
 2 
 3 import com.xdf.bean.Student;
 4 import org.springframework.jdbc.core.RowMapper;
 5 import org.springframework.jdbc.core.support.JdbcDaoSupport;
 6 
 7 import java.io.Serializable;
 8 import java.sql.ResultSet;
 9 import java.sql.SQLException;
10 import java.util.List;
11 
12 /**
13  * dao的实现类
14  * 书写sql
15  * JdbcDaoSupport====>BaseDao
16  * JdbcDaoSupport有两个重要的属性
17  * 01.jdbcTemplate    模版
18  * 02.需要 dataSource  ===>数据源
19  *
20  * JdbcDaoSupport  所有的增删改 都是update
21  *                            查询是query
22  *
23  */
24 public class StudentDaoImpl extends JdbcDaoSupport implements StudentDao {
25 
26        public int add(Student student) {
27         String sql="insert into student values(?,?)";
28         return getJdbcTemplate().update(sql,student.getsId(),student.getsName());
29       }
30 
31     public int del(Serializable id) {
32            String sql="delete from student where sid=?";
33         return getJdbcTemplate().update(sql,id);
34     }
35 
36     public int update(Student student) {
37            String sql="update student set sname=?  where sid=?";
38         return getJdbcTemplate().update(sql,student.getsName(),student.getsId());
39     }
40 
41     public List<Student> getAll() {
42            String sql="select * from student";
43            //使用匿名内部类
44         return getJdbcTemplate().query(sql,new RowMapper<Student>(){
45                 /**
46                  * 这里的ResultSet是返回一个对象！
47                  * 我们之前使用的是 一个结果集！
48                  */
49                 public Student mapRow(ResultSet rs, int rowNum) throws SQLException {
50                     //创建student对象  依次返回
51                     Student student=new Student();
52                     student.setsId(rs.getInt("sid"));
53                     student.setsName(rs.getString("sname"));
54                     return student;
55                 }
56         });
57     }
58 }

3.需要的service层

 1 package com.xdf.service;
 2 
 3 import com.xdf.bean.Student;
 4 import com.xdf.dao.StudentDao;
 5 
 6 import java.io.Serializable;
 7 import java.util.List;
 8 
 9 public class StudentServiceImpl implements   StudentService {
10 
11     //交给spring容器实例化dao层对象
12     private StudentDao dao;
13 
14     public StudentDao getDao() {
15         return dao;
16     }
17 
18     public void setDao(StudentDao dao) {
19         this.dao = dao;
20     }
21 
22     public int add(Student student) {
23         return dao.add(student);
24     }
25 
26     public int del(Serializable id) {
27         return dao.del(id);
28     }
29 
30     public int update(Student student) {
31         return dao.update(student);
32     }
33 
34     public List<Student> getAll() {
35         return dao.getAll();
36     }
37 }

4.需要的jdbc.properties

5.需要的核心配置文件

 1 <?xml version="1.0" encoding="UTF-8"?>
 2 <beans xmlns="http://www.springframework.org/schema/beans"
 3        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 4        xmlns:context="http://www.springframework.org/schema/context"
 5        xmlns:aop="http://www.springframework.org/schema/aop"
 6        xmlns:tx="http://www.springframework.org/schema/tx"
 7        xmlns:p="http://www.springframework.org/schema/p"
 8        xmlns:c="http://www.springframework.org/schema/c"
 9        xsi:schemaLocation="
10         http://www.springframework.org/schema/beans
11         http://www.springframework.org/schema/beans/spring-beans.xsd
12         http://www.springframework.org/schema/context
13         http://www.springframework.org/schema/context/spring-context.xsd
14         http://www.springframework.org/schema/tx
15         http://www.springframework.org/schema/tx/spring-tx.xsd
16         http://www.springframework.org/schema/aop
17         http://www.springframework.org/schema/aop/spring-aop.xsd">
18     <!--引入需要的jdbc.properties文件-->
19     <context:property-placeholder location="classpath:jdbc.properties"/>
20 
21     <!--01.使用spring自带的数据源
22     <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
23          <property name="driverClassName" value="${jdbc.driverClassName}"/>
24          <property name="url" value="${jdbc.url}"/>
25          <property name="username" value="${jdbc.userName}"/>
26          <property name="password" value="${jdbc.password}"/>
27     </bean>-->
28 
29     <!--02.使用c3p0自带的数据源
30     <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
31          <property name="driverClass" value="${jdbc.driverClassName}"/>
32          <property name="jdbcUrl" value="${jdbc.url}"/>
33          <property name="user" value="${jdbc.userName}"/>
34          <property name="password" value="${jdbc.password}"/>
35     </bean>-->
36 
37 
38     <!--03.使用dbcp自带的数据源-->
39     <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
40          <property name="driverClassName" value="${jdbc.driverClassName}"/>
41          <property name="url" value="${jdbc.url}"/>
42          <property name="username" value="${jdbc.userName}"/>
43          <property name="password" value="${jdbc.password}"/>
44     </bean>
45     <!--配置dao层对象-->
46     <bean  id="studentDao" class="com.xdf.dao.StudentDaoImpl">
47         <property name="dataSource" ref="dataSource"/>
48     </bean>
49 
50     <!-- 配置service层对象-->
51      <bean  id="studentService" class="com.xdf.service.StudentServiceImpl">
52          <property name="dao" ref="studentDao"/>
53      </bean>
54 </beans>