DBUtils的增删改代码实例

package dBUtils;

import java.sql.SQLException;

import org.apache.commons.dbutils.QueryRunner;
import org.junit.Test;

import c3p0.c3p0工具类;
/**
 * 测试DBUtils
 * @author xxx
 *
 */
public class DBUtils增删改 {
	/**
	 * 修改数据
	 */
	@Test
	public void testUpdataUser() {
		try {
		//创建核心QueryRunner
		QueryRunner qr = new QueryRunner(c3p0工具类.getDataSource());
		//2.编写sql语句
		String sql = "update user set uname=? where uid=?";
		//为占位符设置参数
		Object[] params = {"安珏",4};
		//执行语句
			int row = qr.update(sql,params);
			if(row>0) {
				System.out.println("修改成功");
			}else {
				System.out.println("修改失败");
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	/**
	 * 增加一个
	 */
	@Test
	public void testAddUser() {
		try {
		//创建核心QueryRunner
		QueryRunner qr = new QueryRunner(c3p0工具类.getDataSource());
		//2.编写sql语句
		String sql = "insert into user values(null ,?,?)";
		//为占位符设置参数
		Object[] params = {"余淮","耿耿"};
		//执行语句
			int row = qr.update(sql,params);
			if(row>0) {
				System.out.println("添加成功");
			}else {
				System.out.println("添加失败");
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}