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

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(\if(\{

List list = userDao.getAllUser(; request.setAttribute(\

request.getRequestDispatcher(\}else if(\{

String strId = request.getParameter(\int id = Integer.valueOf(strId;

UserBean userBean = userDao.selectUserById(id; request.setAttribute(\

request.getRequestDispatcher(\

}else if(\

String strId = request.getParameter(\int id = Integer.valueOf(strId; if(userDao.deleteUser(id{

response.sendRedirect(\}else{

response.sendRedirect(\} } } }

package com.user.dao; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List;

import com.user.bean.UserBean; import com.util.DBUtils; public class UserDao { private DBUtils dbUtil; /**

* 查询所有的user * @return */

public List getAllUser( {

dbUtil = new DBUtils(; List list = new ArrayList (; String sql = \ResultSet rs = dbUtil.exceteSQl(sql;

try { while(rs.next( { int i =1;

UserBean userBean = new UserBean(; 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 (SQLException e { e.printStackTrace(; }finally{ dbUtil.close(; } return list; } /**

* 根据id查询user * @param id * @return */

public UserBean selectUserById(int id{ dbUtil = new DBUtils(;

UserBean userBean = new UserBean(;

String sql = \ResultSet rs = dbUtil.exceteSQl(sql; try { if(rs.next( { int i =1;

userBean.setId(rs.getInt(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++; }

} catch (SQLException e { e.printStackTrace(; }

return userBean; } /** * 插入用户 * @param userBean * @return */

public boolean insertUser(UserBean userBean{ dbUtil = new DBUtils(;

String sql = \

int row = dbUtil.excete(sql, new

Object[]{userBean.getYx(,userBean.getZy(,userBean.getAge(,userBean.getDh(,userBean.getQq(,userBean.getSex(}; if(row>0{

return true; }

return false; } /** * 删除用户 * @param id * @return */

public boolean deleteUser(int id{ dbUtil = new DBUtils(;

String sql = \int row = dbUtil.excete(sql; if(row>0 {

return true; }

return false; } /** * 修改user * @param userBean * @return */

public boolean updateUser(UserBean userBean{ dbUtil = new DBUtils(;

String sql = \

int row = dbUtil.excete(sql, new

Object[]{userBean.getYx(,userBean.getZy(,userBean.getAge(,userBean.getDh(,userBean.getQq(,userBean.getSex(,userBean.getId(}; if(row>0