QueryRunner新增记录update
上一讲:Javaweb JDBC数据库连接 第七讲 :MapHandler&MapListHandler&ScalarHandler结果集处理
写法:
插入
public int i(DUser user){
String sql="insert into user(phone,pwd,sex,img,create_time,role,username,wechat) value(?,?,?,?,?,?,?,?)";
int i=0;
Object[] params={
user.getPhone(),
user.getPwd(),
user.getSex(),
user.getImg(),
user.getCreateTime(),
user.getRole(),
user.getUsername(),
user.getWechat()
};
try {
i=queryRunner.update(sql,params);
} catch (SQLException e) {
e.printStackTrace();
}
return i;
}
删除:
public int d(int id){
String sql="delete from user where id = ?";
int d=0;
Object [] params={id};
try {
d=queryRunner.update(sql,params);
} catch (SQLException e) {
e.printStackTrace();
}
return d;
}
————插入项目实例————
1.userdao
public class UserDao {
private QueryRunner queryRunner=new QueryRunner(DataSourceUtil.getDataSource());
public int i(DUser user){
String sql="insert into user(phone,pwd,sex,img,create_time,role,username,wechat) value(?,?,?,?,?,?,?,?)";
int i=0;
Object[] params={
user.getPhone(),
user.getPwd(),
user.getSex(),
user.getImg(),
user.getCreateTime(),
user.getRole(),
user.getUsername(),
user.getWechat()
};
try {
i=queryRunner.update(sql,params);
} catch (SQLException e) {
e.printStackTrace();
}
return i;
}
public int d(int id){
String sql="delete from user where id = ?";
int d=0;
Object [] params={id};
try {
d=queryRunner.update(sql,params);
} catch (SQLException e) {
e.printStackTrace();
}
return d;
}
}
2.UserService
public interface UserService {
int i(DUser user);
int d(int id);
}
3.UserServiceimpl
public class UserServiceimpl implements UserService {
private UserDao userDao=new UserDao();
@Override
public int i(DUser user) {
return userDao.i(user);
}
@Override
public int d(int id) {
return userDao.d(id);
}
}
4.UserServlet
@WebServlet(name= "userServlet",urlPatterns = "/user")
public class UserServlet extends HttpServlet {
private UserService userService=new UserServiceimpl();
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
String method = req.getParameter("method");
if (method.equals("save")){
DUser user=new DUser();
//如果是获取数据这样写
//user.setId(Integer.parseInt(req.getParameter("id")));
//user.setPwd(req.getParameter("pwd"));
//此处模拟数据
user.setUsername("月亮");
user.setPwd("smsmsm");
user.setPhone("1824654");
user.setRole(1);
user.setSex(1);
user.setCreateTime(new Date());
user.setWechat("aiqingya");
user.setImg("WWWWw");
int row=userService.i(user);
if (row==1){
System.out.println("插入成功");
}else {
System.out.println("插入失败");
}
}
if (method.equals("delete")){
String idStr=req.getParameter("id");
int id=Integer.parseInt(idStr);
int row=userService.d(id);
if (row==1){
System.out.println("删除成功");
}else {
System.out.println("删除失败");
}
}
}
}
截图:
插入:
请求界面
未插入前
插入后
控制台:
删除:
请求界面
数据库删除后
该行被删除
控制台: