1.Spring中使用JdbcTemplate封装对Jdbc的支持，使用Spring JdbcTeamplate的例子如下：
(1).假设如下SQL表中有数据username=test1,passwd=test1,address=test1 ：
[java] view plaincopyprint CREATE TABLE `login` ( `username` varchar(10) default NULL, `passwd` varchar(10) default NULL, `address` varchar(10) default NULL ) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
(2).在Spring配置文件中添加关于数据源和JdbcTeamplate的配置如下：
[xhtml] view plaincopyprint
(3).Java持久化对象如下：
[java] view plaincopyprint package SpringJDBCSupport.ReadData; import com.mysql.jdbc.Driver; public class Person { private String name; private String password; private String address; public Person(){ } public Person(String name,String password,String address){ this.name=name; this.password=password; this.address=address; } public String getAddress() { return address; } public void setAddress(String address) { this.address = address; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } public String toString(){ return this.getName()+"-"+this.getPassword()+"-"+this.getAddress(); } }
(4).使用JdbcTeamplate的DAO如下：
[java] view plaincopyprint package SpringJDBCSupport.ReadData; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Types; import java.util.List; import org.springframework.jdbc.core.BatchPreparedStatementSetter; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.jdbc.core.RowCallbackHandler; public class PersonDAO { private JdbcTemplate jdbcTemplate; public JdbcTemplate getJdbcTemplate() { return jdbcTemplate; } public void setJdbcTemplate(JdbcTemplate jdbcTemplate) { this.jdbcTemplate = jdbcTemplate; } public int insertPersonUseUpdate(Person person){ String sql="insert into login values( , , )"; Object[] params=new Object[]{ person.getName(), person.getPassword(), person.getAddress() }; return this.getJdbcTemplate().update(sql,params); } public int insertPersonUseExecute(Person person){ String sql="insert into login values( , , )"; Object[] params=new Object[]{ person.getName(), person.getPassword(), person.getAddre