(7) Spring support for JDBC

Steps for using spring JDBC

1. Introduction of JAR Package

Spring-jdbc-3.2.5.release.jar

Spring-tx-3.2.5.release.jar

C3p0-0.9.1.2.jar

Mysql-connector-java-5.1.38-bin.jar

2. Configuration

C3P0 configuration of the database connection pool

JdbcTemplate Object

DAO object

3. Testing

Applicationcontext.xml

<?xml version= "1.0"  encoding= "UTF-8"? ><beans xmlns= "http://www.springframework.org/ Schema/beans "    xmlns:xsi=" Http://www.w3.org/2001/XMLSchema-instance "     xmlns:p= "http://www.springframework.org/schema/p"     xmlns:context= "http// Www.springframework.org/schema/context "    xmlns:aop=" http://www.springframework.org/ Schema/aop "    xsi:schemalocation="         http:// www.springframework.org/schema/beans        http:// www.springframework.org/schema/beans/spring-beans.xsd        http:// www.springframework.org/schema/context        http:// Www.springframework.org/schema/context/spring-context.xsd        http ://www.springframework.org/schema/aop     &Nbsp;  http://www.springframework.org/schema/aop/spring-aop.xsd "><!-- 1.  Data source objects: &NBSP;C3P0 Connection Pool  --><bean id= "DataSource"  class= "Com.mchange.v2.c3p0.ComboPooledDataSource" ><property name= "Driverclass"  value= "Com.mysql.jdbc.Driver" ></property><property  name= "Jdbcurl"  value= "Jdbc:mysql://127.0.0.1:3306/test" ></property><property name= "User"  value= "root" ></property><property name= "password"  value= "root" ></ Property><property name= "Initialpoolsize"  value= "3" ></property><property name = "Maxpoolsize"  value= "ten" ></property><property name= "Maxstatements"  value= ">" </property><property name= "Acquireincrement"  value= "2" ></property></bean> <!-- 2.  Create JdbcTemplate object  --><bean id= "JdbcTemplate"  class= " Org.springframework.jdbc.core.JdbcTemplate "><constructor-arg index= "0"  type= "javax.sql.DataSource"  ref= "DataSource" ></ constructor-arg></bean><!-- dao  Instances  --><bean id= "Deptdao"  class= " Com.rk.hibernate.i_jdbc. Departmentdao "><property name=" JdbcTemplate " ref=" JdbcTemplate "></property></bean ></beans>

Department.java

Package Com.rk.hibernate.i_jdbc;public class Department{private int deptid;private String deptname;private int version; public int Getdeptid () {return deptid;} public void Setdeptid (int deptid) {this.deptid = DeptID;} Public String Getdeptname () {return deptname;} public void Setdeptname (String deptname) {this.deptname = Deptname;} public int getversion () {return version;} public void setversion (int version) {this.version = version;} @Overridepublic String toString () {return "Department [deptid=" + DeptID + ", deptname=" + Deptname + ", version=" + versio n + "]";}}

Departmentdao.java

Package com.rk.hibernate.i_jdbc;import java.sql.resultset;import java.sql.sqlexception;import  java.util.List;import org.springframework.jdbc.core.JdbcTemplate;import  org.springframework.jdbc.core.rowmapper;public class departmentdao{private jdbctemplate  Jdbctemplate;public void setjdbctemplate (jdbctemplate jdbctemplate) {this.jdbcTemplate =  jdbctemplate;} Public void save () {string sql =  "Insert into t_department (name,dept_version )  values (?,?) "; Jdbctemplate.update (sql,  "Tom", 0);} Public department findbyid (int id) {string sql =  "SELECT * FROM T_ Department where id=? "; List<department> list = jdbctemplate.query (Sql,new myresult (), id);return  (list  != null && list.size () >0)  ? list.get (0)  : null;} Public list<department> findall() {string sql =  "select * from t_department"; List<department> list = jdbctemplate.query (Sql, new myresult ());return  List;}} class myresult implements rowmapper<department>{@Overridepublic  Department  Maprow (Resultset rs, int rownum)  throws SQLException{int id =  Rs.getint ("id"); String name = rs.getstring ("name"); Int dept_version = rs.getint ("Dept_version") ;D epartment dept = new department ();d Ept.setdeptid (ID);d ept.setdeptname (name); Dept.setversion (dept_version); return dept;}}

App.java

Package Com.rk.hibernate.i_jdbc;import Java.util.list;import Org.junit.test;import Org.springframework.context.applicationcontext;import Org.springframework.context.support.classpathxmlapplicationcontext;public class App{private ApplicationContext ac = New Classpathxmlapplicationcontext ("/com/rk/hibernate/i_jdbc/applicationcontext.xml"); @Testpublic void Test () { Departmentdao Deptdao = (Departmentdao) ac.getbean ("Deptdao");//1. Save//deptdao.save ();//2. Query by ID//department dept = deptdao.findbyid (9);//system.out.println (dept)//3. Querying all Lists <Department> list = Deptdao.findall (); System.out.println (List.size ()); SYSTEM.OUT.PRINTLN (list);}}

(7) Spring support for JDBC