package shop4; import java.io.IOException; import java.io.*; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.List; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import dao.glyhdao; import modo.glyh; /** * Servlet implementation class gluhsvlt */ @WebServlet("/gluhsvlt") public class gluhsvlt extends HttpServlet { private static final long serialVersionUID = 1L; /** * @see HttpServlet#HttpServlet() */ /** * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub doPost(request, response); } protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String pd=request.getParameter("msg"); HttpSession session = request.getSession(); if(pd==null){ glyhdao a1=new glyhdao(); List<glyh> list =new glyhdao().getlist(); request.setAttribute("list", list); request.getRequestDispatcher("/staffManage/lookStaff2.jsp").forward(request, response); list.clear(); }else if(pd.equals("tj")){ String Name=new String(request.getParameter("staffName").getBytes("ISO-8859-1"),"UTF-8"); String Sex=new String(request.getParameter("staffSex").getBytes("ISO-8859-1"),"UTF-8"); String Age=new String(request.getParameter("staffAge").getBytes("ISO-8859-1"),"UTF-8"); String Education=new String(request.getParameter("staffEducation").getBytes("ISO-8859-1"),"UTF-8"); String Department=new String(request.getParameter("staffDepartment").getBytes("ISO-8859-1"),"UTF-8"); String Date=new String(request.getParameter("staffDate").getBytes("ISO-8859-1"),"UTF-8"); String Duty=new String(request.getParameter("staffDuty").getBytes("ISO-8859-1"),"UTF-8"); String sql="insert into staff(staffName,staffSex,staffAge,staffEducation,staffDepartment,staffDate,staffDuty,staffWage) values ('"+Name+"','"+Sex+"','"+Age+"','"+Education+"','"+Department+"','"+Date+"','"+Duty+"')"; glyhdao a1=new glyhdao(); if(a1.pdff(sql)){ response.sendRedirect(request.getContextPath()+"/gluhsvlt"); }else{ request.setAttribute("msg", "tj"); request.getRequestDispatcher("/error.jsp").forward(request, response); } }else if(pd.equals("cs")){ glyhdao a1=new glyhdao(); String sql="DELETE FROM staff WHERE staffName='"+request.getParameter("id")+"'"; if(a1.pdff(sql)){ response.sendRedirect(request.getContextPath()+"/gluhsvlt"); }else{ request.setAttribute("msg", "cs"); request.getRequestDispatcher("/error.jsp").forward(request, response); } }else if(pd.equals("xg")){ String Name=new String(request.getParameter("xgstaffName").getBytes("ISO-8859-1"),"UTF-8"); String Sex=new String(request.getParameter("xgstaffSex").getBytes("ISO-8859-1"),"UTF-8"); String Age=new String(request.getParameter("xgstaffAge").getBytes("ISO-8859-1"),"UTF-8"); String Education=new String(request.getParameter("xgstaffEducation").getBytes("ISO-8859-1"),"UTF-8"); String Department=new String(request.getParameter("xgstaffDepartment").getBytes("ISO-8859-1"),"UTF-8"); String Date=new String(request.getParameter("xgstaffDate").getBytes("ISO-8859-1"),"UTF-8"); String Duty=new String(request.getParameter("xgstaffDuty").getBytes("ISO-8859-1"),"UTF-8"); String sql2="update staff set staffSex='"+Sex+"',staffAge='"+Age+"',staffEducation='"+Education+"',staffDepartment='"+Department+"',staffDate='"+Date+"',staffDuty='"+Duty+"' where staffName='"+Name+"'"; glyhdao a1=new glyhdao(); if(a1.pdff(sql2)){ response.sendRedirect(request.getContextPath()+"/gluhsvlt"); }else{ request.setAttribute("msg", "xg"); request.getRequestDispatcher("/error.jsp").forward(request, response); } } System.out.print(request.getParameter("id")); System.out.print(request.getParameter("msg")); System.out.print(session.getAttribute("msg")); /*List<glyh> glls=new ArrayList<glyh>(); response.setContentType("text/html;charset=utf-8"); request.setCharacterEncoding("utf-8"); try { Class.forName("com.mysql.jdbc.Driver"); } catch (ClassNotFoundException e) { e.printStackTrace(); System.out.println("找不到驱动 "); } // 连接URL 服务器地址 端口号 数据库名 String url="jdbc:mysql://localhost:3306/eims?useUnicode=true&characterEncoding=gbk"; Connection conn = null; Statement stmt = null; ResultSet rs = null; HttpSession session = request.getSession(); try { //数据可的登录名 登录密码 conn = (Connection) DriverManager.getConnection(url, "root", "root"); stmt = (Statement) conn.createStatement(); // SQL语句 String sql="select * from staff"; rs = stmt.executeQuery(sql);// 返回查询结果 } catch (SQLException e) { e.printStackTrace(); } // HttpSession session = request.getSession(); // session.setAttribute("username", username); try { while(rs.next()) { glls.add(new glyh(rs.getString("staffName"), rs.getString("staffSex"), rs.getString("staffAge"), rs.getString("staffEducation"), rs.getString("staffDepartment"), rs.getString("staffDate"), rs.getString("staffDuty"), rs.getString("staffWage"))); } request.setAttribute("list", glls); request.getRequestDispatcher("/staffManage/lookStaff2.jsp").forward(request, response); } catch (SQLException e) { e.printStackTrace(); } if(request.getParameter("msg").equals("tj")){ String Name=request.getParameter("staffName"); String Sex=request.getParameter("staffSex"); String Age=request.getParameter("staffAge"); String Education=request.getParameter("staffEducation"); String Department=request.getParameter("staffDepartment"); String Date=request.getParameter("staffDate"); String Duty=request.getParameter("staffDuty"); String Wage=request.getParameter("staffWage"); String sql1="insert into staff(staffName,staffSex,staffAge,staffEducation,staffDepartment,staffDate,staffDuty,staffWage) values ('"+Name+"','"+Sex+"','"+Age+"','"+Education+"','"+Department+"','"+Date+"','"+Duty+"','"+Wage+"')"; try { Statement stmt=null; stmt.executeUpdate(sql1); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }; response.sendRedirect("http://localhost:8080/shop4/glyhsvlt"); }*/ } }
最近下载更多
asddwh LV12
2023年12月28日
sonder1 LV1
2023年12月18日
政政123456 LV3
2023年12月10日
李朝磊 LV18
2023年12月8日
hmdzmsl12 LV2
2023年10月28日
2036495585 LV9
2023年9月25日
18176866431 LV4
2023年8月28日
你爹正在加载中 LV4
2023年7月15日
赵鑫cdsaljkdfsa LV6
2023年7月1日
oracleanacarge LV5
2023年6月26日
最近浏览更多
WaZiN7 LV6
昨天
xiongM LV4
4月1日
微信网友_6914427966033920 LV4
3月19日
tll123456 LV1
3月15日
pangzhihui LV12
3月3日
微信网友_6829521472425984 LV5
1月20日
吞吞吐吐她 LV5
1月18日
Liang朝伟 LV1
1月6日
yangyangyangyangzzzz LV1
1月3日
asddwh LV12
2023年12月26日