public class StudentManager
{
 private JdbcTemplate jdbcTemplate;

 private static StudentManager instance = new StudentManager();

 public static StudentManager getInstance()
 {
 return instance;
 }

 public JdbcTemplate getJdbcTemplate()
 {
 return jdbcTemplate;
 }
 public void setJdbcTemplate(JdbcTemplate jdbcTemplate)
 {
 this.jdbcTemplate = jdbcTemplate;
 }
}

<?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:context="http://www.springframework.org/schema/context"
 xsi:schemaLocation="http://www.springframework.org/schema/beans
 http://www.springframework.org/schema/beans/spring-beans-4.2.xsd
 http://www.springframework.org/schema/context
 http://www.springframework.org/schema/context/spring-context-4.2.xsd">

 <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
 <!-- 驅(qū)動(dòng)包名 -->
 <property name="driverClassName" value="com.mysql.jdbc.Driver" />
 <!-- 數(shù)據(jù)庫(kù)地址 -->
 <property name="url" value="jdbc:mysql://localhost:3306/school?useUnicode=true&amp;characterEncoding=utf8;" />
 <!-- 用戶名 -->
 <property name="username" value="root" />
 <!-- 密碼 -->
 <property name="password" value="root" />
 <!-- 最大連接數(shù)量 -->
 <property name="maxActive" value="150" />
 <!-- 最小空閑連接 -->
 <property name="minIdle" value="5" />
 <!-- 最大空閑連接 -->
 <property name="maxIdle" value="20" />
 <!-- 初始化連接數(shù)量 -->
 <property name="initialSize" value="30" />
 <!-- 連接被泄露時(shí)是否打印 -->
 <property name="logAbandoned" value="true" />
 <!-- 是否自動(dòng)回收超時(shí)連接 -->
 <property name="removeAbandoned" value="true" />
 <!-- 超時(shí)等待時(shí)間(以秒為單位) -->
 <property name="removeAbandonedTimeout" value="10" />
 </bean>

 <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
 <property name="dataSource" ref="dataSource" />
 </bean>
 <bean id="studentManager" class="com.xrq.jdbc.StudentManager" factory-method="getInstance"> 
 <property name="jdbcTemplate" ref="jdbcTemplate" />
 </bean>
</beans>

public static void main(String[] args)
{ 
 ApplicationContext ac = 
  new ClassPathXmlApplicationContext("jdbc.xml");
 System.out.println(StudentManager.getInstance());
 System.out.println(StudentManager.getInstance().getJdbcTemplate());
}

// 添加學(xué)生信息
public boolean addStudent(Student student)
{
 try
 {
 jdbcTemplate.update("insert into student values(null,?,?,?)", 
  new Object[]{student.getStudentName(), student.getStudentAge(), student.getStudentPhone()},
  new int[]{Types.VARCHAR, Types.INTEGER, Types.VARCHAR});
 return true;
 }
 catch (Exception e)
 {
 return false;
 }
}

// 根據(jù)Id刪除單個(gè)學(xué)生信息
public boolean deleteStudent(int id)
{
 try
 {
 jdbcTemplate.update("delete from student where studentId = ?", new Object[]{id}, new int[]{Types.INTEGER});
 return true;
 }
 catch (Exception e)
 {
 return false;
 }
}

// 根據(jù)Id更新指定學(xué)生信息
public boolean updateStudent(int Id, Student student)
{
 try
 {
 jdbcTemplate.update("update student set studentName = ?, studentAge = ?, studentPhone = ? where studentId = ?", 
  new Object[]{student.getStudentName(), student.getStudentAge(), student.getStudentPhone(), Id},
  new int[]{Types.VARCHAR, Types.INTEGER, Types.VARCHAR, Types.INTEGER});
 return true;
 }
 catch (Exception e)
 {
 return false;
 }
}

// 根據(jù)學(xué)生Id查詢(xún)單個(gè)學(xué)生信息
public Student getStudent(int id)
{
 try
 {
 return (Student)jdbcTemplate.queryForObject("select * from student where studentId = ?", 
  new Object[]{id}, new int[]{Types.INTEGER}, new RowMapper<Student>(){
  public Student mapRow(ResultSet rs, int arg1) throws SQLException
  {
  Student student = new Student(rs.getInt(1), rs.getString(2), rs.getInt(3), rs.getString(4));
  return student;
  }
 });
 }
 // 根據(jù)Id查詢(xún)學(xué)生信息拋異常, 不管什么原因, 認(rèn)為查詢(xún)不到該學(xué)生信息, 返回null
 catch (DataAccessException e)
 {
 return null;
 }
}

// 查詢(xún)所有學(xué)生信息
public List<Student> getStudents()
{
 List<Map<String, Object>> resultList = jdbcTemplate.queryForList("select * from student");
 List<Student> studentList = null;
 if (resultList != null && !resultList.isEmpty())
 {
 studentList = new ArrayList<Student>();
 Map<String, Object> map = null;
 for (int i = 0; i < resultList.size(); i++)
 {
  map = resultList.get(i);
  Student student = new Student(
  (Integer)map.get("studentId"), (String)map.get("studentName"),
  (Integer)map.get("studentAge"), (String)map.get("studentPhone")
  );
  studentList.add(student);
  }
 }
 return studentList;
}

<?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:context="http://www.springframework.org/schema/context"
 xsi:schemaLocation="http://www.springframework.org/schema/beans
 http://www.springframework.org/schema/beans/spring-beans-4.2.xsd
 http://www.springframework.org/schema/context
 http://www.springframework.org/schema/context/spring-context-4.2.xsd">

 <context:property-placeholder location="classpath:db.properties"/>

 <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
 <!-- 驅(qū)動(dòng)包名 -->
 <property name="driverClassName" value="${mysqlpackage}" />
 <!-- 數(shù)據(jù)庫(kù)地址 -->
 <property name="url" value="${mysqlurl}" />
 <!-- 用戶名 -->
 <property name="username" value="${mysqlname}" />
 <!-- 密碼 -->
 <property name="password" value="${mysqlpassword}" />
 <!-- 最大連接數(shù)量 -->
 <property name="maxActive" value="150" />
 <!-- 最小空閑連接 -->
 <property name="minIdle" value="5" />
 <!-- 最大空閑連接 -->
 <property name="maxIdle" value="20" />
 <!-- 初始化連接數(shù)量 -->
 <property name="initialSize" value="30" />
 <!-- 連接被泄露時(shí)是否打印 -->
 <property name="logAbandoned" value="true" />
 <!-- 是否自動(dòng)回收超時(shí)連接 -->
 <property name="removeAbandoned" value="true" />
 <!-- 超時(shí)等待時(shí)間(以秒為單位) -->
 <property name="removeAbandonedTimeout" value="10" />
 </bean>

 <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
 <property name="dataSource" ref="dataSource" />
 </bean>
 <bean id="studentManager" class="com.xrq.jdbc.StudentManager" factory-method="getInstance"> 
 <property name="jdbcTemplate" ref="jdbcTemplate" />
 </bean>
</beans>