mysql c3p0 spring_Spring使用c3p0实现数据增删改查

packagemaya.test;importjava.sql.Connection;importjava.util.ArrayList;importjava.util.List;importjavax.sql.DataSource;importorg.springframework.context.ApplicationContext;importorg.springframework.context.support.ClassPathXmlApplicationContext;importorg.springframework.jdbc.core.BeanPropertyRowMapper;importorg.springframework.jdbc.core.JdbcTemplate;importorg.springframework.jdbc.core.RowMapper;importcom.mchange.v2.c3p0.ComboPooledDataSource;importmaya.entities.Nation;public classTestC3P0 {//查单行单列

public static voidmain(String[] args) {

ApplicationContext context= new ClassPathXmlApplicationContext("beans.xml");

DataSource ds= (DataSource)context.getBean("dataSource");

JdbcTemplate j= (JdbcTemplate)context.getBean("jdbcTemplate");//查询

String sql = "select count(*) from nation";long count = j.queryForObject(sql,Long.class);

System.out.println(count);

}//查全部

public static voidmain8(String[] args) {

ApplicationContext context= new ClassPathXmlApplicationContext("beans.xml");

DataSource ds= (DataSource)context.getBean("dataSource");

JdbcTemplate j= (JdbcTemplate)context.getBean("jdbcTemplate");//查询

String sql = "select * from nation";

RowMapper rw = new BeanPropertyRowMapper(Nation.class);

List list =j.query(sql, rw);for(Nation data : list) {

System.out.println(data.getName());

}

}//查单个

public static voidmain7(String[] args) {

ApplicationContext context= new ClassPathXmlApplicationContext("beans.xml");

DataSource ds= (DataSource)context.getBean("dataSource");

JdbcTemplate j= (JdbcTemplate)context.getBean("jdbcTemplate");//查询

String sql = "select * from nation where code=?";

RowMapper rm = new BeanPropertyRowMapper(Nation.class);

Nation data= j.queryForObject(sql, rm,"n005");

System.out.println(data.getName());

}//批量增加

public static voidmain6(String[] args) {

ApplicationContext context= new ClassPathXmlApplicationContext("beans.xml");

DataSource ds= (DataSource)context.getBean("dataSource");

JdbcTemplate j= (JdbcTemplate)context.getBean("jdbcTemplate");//增加

String sql = "insert into nation values(?,?) ";//使用数组

List batchArgs = new ArrayList();

batchArgs.add(new Object[] {"n005","侗族"});

batchArgs.add(new Object[] {"n006","朝鲜族"});

j.batchUpdate(sql,batchArgs);

}//删除单个

public static voidmain5(String[] args) {

ApplicationContext context= new ClassPathXmlApplicationContext("beans.xml");

DataSource ds= (DataSource)context.getBean("dataSource");

JdbcTemplate j= (JdbcTemplate)context.getBean("jdbcTemplate");//删除

String sql = "delete from nation where code=?";

j.update(sql,"n005");

}//增加单个

public static voidmain4(String[] args) {

ApplicationContext context= new ClassPathXmlApplicationContext("beans.xml");

DataSource ds= (DataSource)context.getBean("dataSource");

JdbcTemplate j= (JdbcTemplate)context.getBean("jdbcTemplate");//增加

String sql = "insert into nation value(?,?)";

j.update(sql,"n005", "侗族");

}//修改单个

public static voidmain3(String[] args) {//JdbcTemplate。加载xml文件，创建连接池，建立连接

ApplicationContext context = new ClassPathXmlApplicationContext("beans.xml");

DataSource ds= (DataSource)context.getBean("dataSource");

JdbcTemplate j= (JdbcTemplate)context.getBean("jdbcTemplate");//修改

String sql = "update info set name=? where code=?";

j.update(sql,"张琳", "p005");//update方法可以执行insert,update,delete

}

}