javaWeb-连接mysql数据库增删改查(精)

连接MYSQL数据库的简单增删改查项目框架如图所示：所需工具：所需工具：所需工具：所需工具：程序代码：packagecom.user.action;importjava.io.IOException;importjavax.servlet.ServletException;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;importcom.user.bean.UserBean;importcom.user.dao.UserDao;publicclassInsertOrUpdateActionextendsHttpServlet{/****/privatestaticfinallongserialVersionUID=1L;privateUserDaouserDao;publicvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponsethrowsServletException,IOException{doPost(request,response;}publicvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponsethrowsServletException,IOException{request.setCharacterEncoding(utf-8;response.setCharacterEncoding(utf-8;userDao=newUserDao(;Stringstr=request.getRequestURI(;str=str.substring(str.lastIndexOf(/+1;Stringyx=request.getParameter(yx;Stringzy=request.getParameter(zy;Stringage=request.getParameter(age;Stringdh=request.getParameter(dh;Stringqq=request.getParameter(qq;Stringsex=request.getParameter(sex;UserBeanuserBean=newUserBean(;userBean.setYx(yx;userBean.setZy(zy;if(!.equals(age&&age!=null{userBean.setAge(Integer.valueOf(age;}else{userBean.setAge(0;}userBean.setDh(dh;userBean.setQq(qq;userBean.setSex(sex;if(InsertUserAction.equals(str{if(userDao.insertUser(userBean{response.sendRedirect(SelectAllUser;}else{response.sendRedirect(SelectAllUser;}}elseif(UpdateUserAction.equals(str{StringstrId=request.getParameter(id;if(!.equals(strId&&strId!=null{userBean.setId(Integer.valueOf(strId;}else{userBean.setId(-1;}if(userDao.updateUser(userBean{response.sendRedirect(SelectAllUser;}else{response.sendRedirect(SelectAllUser;}}}}packagecom.user.action;importjava.io.IOException;importjavax.servlet.ServletException;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;publicclassLoginActionextendsHttpServlet{/****/privatestaticfinallongserialVersionUID=1L;publicvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponsethrowsServletException,IOException{doPost(request,response;}publicvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponsethrowsServletException,IOException{Stringname=request.getParameter(name;Stringpassword=request.getParameter(password;if(.equals(name||.equals(password{response.sendRedirect(/javaWebTest/index.jsp;}else{if(123.equals(name&&123.equals(password{response.sendRedirect(SelectAllUser;}else{response.sendRedirect(/javaWebTest/index.jsp;}}}}packagecom.user.action;importjava.io.IOException;importjava.util.List;importjavax.servlet.ServletException;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;importcom.user.bean.UserBean;importcom.user.dao.UserDao;publicclassUserActionextendsHttpServlet{/****/privatestaticfinallongserialVersionUID=1L;privateUserDaouserDao;publicvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponsethrowsServletException,IOException{doPost(request,response;}publicvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponsethrowsServletException,IOException{request.setCharacterEncoding(utf-8;response.setCharacterEncoding(utf-8;userDao=newUserDao(;Stringstr=request.getRequestURI(;str=str.substring(str.lastIndexOf(/+1;if(SelectAllUser.equals(str.trim({Listlist=userDao.getAllUser(;request.setAttribute(UserList,list;request.getRequestDispatcher(/userList.jsp.forward(request,response;}elseif(SelectOneUser.equals(str{StringstrId=request.getParameter(id;intid=Integer.valueOf(strId;UserBeanuserBean=userDao.selectUserById(id;request.setAttribute(userBean,userBean;request.getRequestDispatcher(/updateUser.jsp.forward(request,response;}elseif(DeleteUserById.equals(str{StringstrId=request.getParameter(id;intid=Integer.valueOf(strId;if(userDao.deleteUser(id{response.sendRedirect(SelectAllUser;}else{response.sendRedirect(SelectAllUser;}}}}packagecom.user.dao;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.util.ArrayList;importjava.util.List;importcom.user.bean.UserBean;importcom.util.DBUtils;publicclassUserDao{privateDBUtilsdbUtil;/***查询所有的user*@return*/publicListgetAllUser({dbUtil=newDBUtils(;Listlist=newArrayList(;Stringsql=select*fromuser;ResultSetrs=dbUtil.exceteSQl(sql;try{while(rs.next({inti=1;UserBeanuserBean=newUserBean(;userBean.setId(rs.getInt(i++;userBean.setName(rs.getString(i++;userBean.setYx(rs.getString(i++;userBean.setZy(rs.getString(i++;userBean.setAge(rs.getInt(i++;userBean.setDh(rs.getString(i++;userBean.setQq(rs.getString(i++;userBean.setSex(rs.getString(i++;list.add(userBean;}}catch(SQLExceptione{e.printStackTrace(;}finally{dbUtil.close(;}returnlist;}/***根据id查询user*@paramid*@return*/publicUserBeanselectUserById(intid{dbUtil=newDBUtils(;UserBeanuserBean=newUserBean(;Stringsql=select*fromuserwhereid='+id+';ResultSetrs=dbUtil.exceteSQl(sql;try{if(rs.next({inti=1;userBean.setId(rs.getInt(i++;userBean.setYx(rs.getString(i++;userBean.setZy(rs.getString(i++;userBean.setAge(r