项目结构

1、使用spring配置jdbcTemplate，首先要配置applicationContext.xml文件

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
        <property name="driverClassName"><value>oracle.jdbc.driver.OracleDriver</value></property>
        <property name="url"><value>jdbc:oracle:thin:@172.0.0.1:1521:orcl1</value></property>
        <property name="username"><value>xxxxxx</value></property>
        <property name="password"><value>xxxxxx</value></property>
    </bean>

    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource"><ref bean="dataSource" /></property>
    </bean>

    <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
        <property name="dataSource"><ref bean="dataSource" /></property>
    </bean>
	
	<bean id="ordersDao" class="dao.OrdersDao" >
	    <property name="jdbcTemplate"><ref bean="jdbcTemplate" /></property>
	</bean>
			
</beans>

package entity;

public class Orders implements Serializable {
    private static final long serialVersionUID = -2811014017129339092L;
	
 	private int id;

	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}

}

3、dao中新建一个dao类

package dao;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.stereotype.Repository;

import entity.Orders;

@Repository
public class OrdersDao {
	
	@Autowired
	private JdbcTemplate jdbcTemplate;

	//setter方法注入
	public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
		this.jdbcTemplate = jdbcTemplate;
	}

	/**
	 * 查询
	 * @param status
	 * @return
	 */
	public List<Orders> getOrders(int id){
		return jdbcTemplate.query("select * from orders where id> ?",
				new Object[] { id }, new OrdersMapper());
	}

	/**
	 * 插入
	 * @param 
	 * @return
	 */
	public int insert(int id) {
		return jdbcTemplate.update(
			" insert into orders select * from orders_other where id=? ",
			new Object[] { id });
	}

	/**
	 * 更新
	 * @param or 
	 * @param 
	 * @return
	 */
	public int update(Orders or) {
		return jdbcTemplate.update(
			" update orders set name=? where id=? ",
			new Object[] { or.getName(), or.getId() });
	}
	/**
	 * 删除
	 * @param or  
	 * @return
	 */
	public int delete(Orders or) {
		return jdbcTemplate.update(" delete from orders where id = ? ",
				new Object[] { or.getId() });
	}
	private  class OrdersMapper implements RowMapper {
		public Orders mapRow(Resu