javaWeb-连接mysql数据库增删改查（精）

连接MYSQL数据库的简单增删改查

项目框架如图所示：

所需工具：

所需工具：

所需工具：

所需工具：

程序代码：package com.user.action; import java.io.IOException;

import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.user.bean.UserBean; import com.user.dao.UserDao;

public class InsertOrUpdateAction extends HttpServlet {

/** * */

private static final long serialVersionUID = 1L; private UserDao userDao ;

public void doGet(HttpServletRequest request, HttpServletResponse response throws ServletException, IOException {

doPost(request, response; }

public void doPost(HttpServletRequest request, HttpServletResponse response throws ServletException, IOException {

request.setCharacterEncoding(\; response.setCharacterEncoding(\;

userDao = new UserDao(; String str = request.getRequestURI(; str = str.substring(str.lastIndexOf(\+1; String yx = request.getParameter(\; String zy = request.getParameter(\; String age = request.getParameter(\; String dh = request.getParameter(\;

String qq = request.getParameter(\; String sex = request.getParameter(\; UserBean userBean = new UserBean(; 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(\.equals(str{ if(userDao.insertUser(userBean{ response.sendRedirect(\; }else{

response.sendRedirect(\; }

}else if(\.equals(str{ String strId = request.getParameter(\; if(!\.equals(strId&&strId!=null{ userBean.setId(Integer.valueOf(strId; }else{

userBean.setId(-1; }

if(userDao.updateUser(userBean{ response.sendRedirect(\; }else{

response.sendRedirect(\; } } } }

package com.user.action; import java.io.IOException; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; public class LoginAction extends HttpServlet { /** * */

private static final long serialVersionUID = 1L;

public void doGet(HttpServletRequest request, HttpServletResponse response throws ServletException, IOException { doPost(request, response; }

public void doPost(HttpServletRequest request, HttpServletResponse response throws ServletException, IOException { String name= request.getParameter(\; String password = request.getParameter(\;

if(\.equals(name||\.equals(password {

response.sendRedirect(\; }else{

if(\.equals(name&&\.equals(password {

response.sendRedirect(\; }else{

response.sendRedirect(\; } } } }

package com.user.action; import java.io.IOException; import java.util.List;

import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.user.bean.UserBean; import com.user.dao.UserDao;

public class UserAction extends HttpServlet { /** * */