JavaWeb.zip

package com.hnjd.servlet; import java.io.IOException; import java.io.PrintWriter; import java.sql.ResultSet; import java.sql.SQLException; 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 com.hnjd.bean.javabean; import com.hnjd.utils.DbHelp; /** * Servlet implementation class projectServlet */ @WebServlet("/projectServlet") public class projectServlet extends HttpServlet { private static final long serialVersionUID = 1L; /** * Default constructor. */ public projectServlet() { // TODO Auto-generated constructor stub } /** * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub response.setContentType("text/html;charset=utf-8"); request.setCharacterEncoding("utf-8"); String type = request.getParameter("type"); DbHelp db = new DbHelp(); if(type.equals("list")) { String sql = "select * from t_project"; ResultSet rs = db.query(sql,null); List<javabean> list = new ArrayList<>(); try { while(rs.next()) { String projectId = rs.getString("projectId"); String projectName = rs.getString("projectName"); String deputyName = rs.getString("deputyName"); String telephone = rs.getString("telephone"); String addr = rs.getString("addr"); javabean b = new javabean(projectId,projectName,deputyName,telephone,addr); list.add(b); } }catch(SQLException e){ e.printStackTrace(); } request.getSession().setAttribute("list", list); response.sendRedirect("project_list.jsp"); }else if(type.equals("add")) { //添加信息 String projectId = request.getParameter("textfield"); String projectName = request.getParameter("textfield2"); String deputyName = request.getParameter("textfield9"); String telephone = request.getParameter("textfield6"); String addr = request.getParameter("textfield7"); //添加的sql语句 String sql = "insert into t_project values(?,?,?,?,?)"; int n = db.update(sql, new String[] {projectId,projectName,deputyName,telephone,addr}); response.sendRedirect("projectServlet?type=list"); }else if(type.equals("del")) { String id = request.getParameter("id"); String sql = "delete from t_project where projectId ='"+id+"'"; int n = db.update(sql, null); if(n > 0){ PrintWriter out = response.getWriter(); out.print("<script>window.alert('删除成功！')</script>"); out.print("<script>window.location='projectServlet?type=list'</script>"); } }else if(type.equals("updata")) { String projectId = request.getParameter("textfield"); String projectName = request.getParameter("textfield2"); String deputyName = request.getParameter("textfield9"); String telephone = request.getParameter("textfield6"); String addr = request.getParameter("textfield7"); String sql = "update t_project set projectName = ?,deputyName = ?,telephone = ?,addr = ? where projectId = ?"; int n = db.update(sql, new Object[] {projectName,deputyName,telephone,addr,projectId}); if(n>0) { PrintWriter out = response.getWriter(); out.print("<script>window.alert('修改成功')</script>"); out.print("<script>window.location='projectServlet?type=list'</script>"); }else { PrintWriter out = response.getWriter(); out.print("<script>window.alert('修改失败！')</script>"); out.print("<script>window.location='projectServlet?type=updata'</script>"); } } } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub doGet(request, response); } }