使用DBUtils实现增删改查

创建C3p0Utils类

public class C3p0Utils {
	private static DataSource ds;
	static {
		ds = new ComboPooledDataSource();
	}
	public static DataSource getDataSource() {
		return ds;
	}
}

创建DBUtilsDao类

public class DBUtilsDao {
	// 查询所有，返回List集合
	public List findAll() throws SQLException {
		// 创建QueryRunner对象
		QueryRunner runner = new QueryRunner(C3p0Utils.getDataSource());
		// 写SQL语句
		String sql = "select * from users";
		// 调用方法
		List list = (List) runner.query(sql,
                     new BeanListHandler(User.class));
		return list;
	}
	// 查询单个，返回对象
	public User find(int id) throws SQLException {
		// 创建QueryRunner对象
		QueryRunner runner = new QueryRunner(C3p0Utils.getDataSource());
		// 写SQL语句
		String sql = "select * from users where id=?";
		// 调用方法
		User user = (User) runner.query(sql, 
                 new BeanHandler(User.class), new Object[] { id });
		return user;
	}
	// 添加用户的操作
	public Boolean insert(User user) throws SQLException {
		// 创建QueryRunner对象
		QueryRunner runner = new QueryRunner(C3p0Utils.getDataSource());
		// 写SQL语句
		String sql = "insert into users (username,password) values (?,?)";
		// 调用方法
		int num = runner.update(sql,
				new Object[] { user.getUsername(), user.getPassword() });
		if (num > 0)
			return true;
		return false;
	}
	// 修改用户的操作
	public Boolean update(User user) throws SQLException {
		// 创建QueryRunner对象
		QueryRunner runner = new QueryRunner(C3p0Utils.getDataSource());
		// 写SQL语句
		String sql = "update  users set username=?,password=? where id=?";
		// 调用方法
		int num = runner.update(sql, new Object[] { user.getUsername(),
                     user.getPassword(),user.getId() });
		if (num > 0)
			return true;
		return false;
	}
	// 删除用户的操作
	public Boolean delete(int id) throws SQLException {
		// 创建QueryRunner对象
		QueryRunner runner = new QueryRunner(C3p0Utils.getDataSource());
		// 写SQL语句
		String sql = "delete from users where id=?";
		// 调用方法
		int num = runner.update(sql, id);
		if (num > 0)
			return true;
		return false;
	}
}

测试DBUtilsDao类中的增删改查操作

public class DBUtilsDaoTest {
	private  DBUtilsDao dao;
	@BeforeEach
	void init(){
		dao = new DBUtilsDao();
	}
	
	@Test
	public void testInsert() throws SQLException {
		User user = new User();
		user.setUsername("zhaoliu1");
		user.setPassword("666666");
		boolean b = dao.insert(user);
		System.out.println(b);
	}
	
	@Test
	public void testupdate() throws SQLException {
		User user = new User();
		user.setUsername("zhaoliu");
		user.setPassword("666777");
		user.setId(5);
		boolean b = dao.update(user);
		System.out.println(b);
	}
	
	@Test
	public void testdelete() throws SQLException {
		boolean b = dao.delete(5);
		System.out.println(b);
	}
	
	@Test
	public void testfind() throws SQLException {
		User user = dao.find(2);
		System.out.println(user.getId() + "," + user.getUsername() + ","
				+ user.getPassword());
	}
	
}