通过java语言实现数据库用户增删改查

JDBC day03

增删改查

public class UserDaoimpl implements UserDao {

DataSource ds = new ComboPooledDataSource();
QueryRunner qu = new QueryRunner(ds);
@Override
public void saveUser(User user) {//插入一条用户信息 增
	String sql = "insert into user_dao values(null,?,?,?,?,?,?)";
	try {
		qu.update(sql, user.getUsername(),user.getPassword(),user.getRealname(),user.getEmail(),user.getBirthday(),user.getGender());
	} catch (SQLException e) {
		e.printStackTrace();
	}
}

@Override
public void removeUserById(int id) {//移除用户 删
	String sql = "delete from user_dao where id = ?";
	try {
		qu.update(sql,id);
	} catch (SQLException e) {
		e.printStackTrace();
	}
}

@Override
public void modifyUser(User user) {//修改用户信息  改
	String sql = "update user_dao set id=null,username =?,password1=?,realname=?,email=?,birthday=?,gender=? where id =?