项目结构
1、使用spring配置jdbcTemplate，首先要配置applicationContext.xml文件
< xml version="1.0" encoding="UTF-8" >
oracle.jdbc.driver.
OracleDriver
jdbc:oracle:thin:@172.0.0.1:1521:orcl1
2、随便写个实体类：
[java]
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类
[java]
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 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(ResultSet rs, int rowNum) throws SQLException {
Orders order = new Orders();
order.setId(rs.getLong("ID"));
//.......
return order;
}
}
}
4、写个测试类
[java]
package test;
import java.util.ArrayList;
import java.util.List;
import org.apache.log4j.Logger;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import dao.OrdersDao;
import entity.Orders;
/**
* @author Administrator
*
*/
public class TestOrders {
private static Logger log = Logger.getLogger(TestOrdersAdd.class);
@Test
public void test(){
ApplicationContext ac = new ClassPathXmlApplicationContext("applicationContext.xml");
