javaweb-连接mysql数据库增删改查

《javaweb-连接mysql数据库增删改查》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、连接MYSQL数据库的简单增删改查项目框架如图所示：所需工具：所需工具：所需工具：所需工具：程序代码：packagecom.user.action;importjava.io.IOException;importjavax.servlet.ServletException;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse

2、;importcom.user.bean.UserBean;importcom.user.dao.UserDao;publicclassInsertOrUpdateActionextendsHttpServlet{/****/privatestaticfinallongserialVersionUID=1L;privateUserDaouserDao;publicvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletEx

3、ception,IOException{doPost(request,response);}publicvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{request.setCharacterEncoding("utf-8");response.setCharacterEncoding("utf-8");userDao=newUserDao();Stringstr=re

4、quest.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=reques

5、t.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("InsertUserAct

6、ion".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.set

7、Id(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;im

8、portjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;publicclassLoginActionextendsHttpServlet{/