增删改查(志愿者服务)

效果图：

Javabean:

 1 package dao;
 2 
 3 public class Information {
 4     private String name;
 5     private String sex;
 6     private String nation;
 7     private String time;
 8     private String age;
 9     private String id;
10     private String service;
11     public Information() {
12         // TODO Auto-generated constructor stub
13     }
14     public String getName() {
15         return name;
16     }
17     public void setName(String name) {
18         this.name = name;
19     }
20     public String getSex() {
21         return sex;
22     }
23     public void setSex(String sex) {
24         this.sex = sex;
25     }
26     public String getNation() {
27         return nation;
28     }
29     public void setNation(String nation) {
30         this.nation = nation;
31     }
32     public String getTime() {
33         return time;
34     }
35     public void setTime(String time) {
36         this.time = time;
37     }
38     public String getAge() {
39         return age;
40     }
41     public void setAge(String age) {
42         this.age = age;
43     }
44     public String getId() {
45         return id;
46     }
47     public void setId(String id) {
48         this.id = id;
49     }
50     public String getService() {
51         return service;
52     }
53     public void setService(String service) {
54         this.service = service;
55     }
56 
57 }

数据库操作：

 1 package util;
 2 import java.sql.*;
 3 public class Sql_handle {
 4 
 5     public Sql_handle() {
 6         // TODO Auto-generated constructor stub
 7     }
 8     private static String url="jdbc:mysql://localhost:3306/volunteer?useUnicode=true&characterEncoding=utf8&serverTimezone=UTC";
 9     public static Statement getStatement() {
10         Connection conn=null;
11         Statement state=null;
12             try {
13                 Class.forName("com.mysql.cj.jdbc.Driver");
14             } catch (ClassNotFoundException e) {
15                 // TODO Auto-generated catch block
16                 e.printStackTrace();
17             }  
18             try {
19                  conn=DriverManager.getConnection(url,"","");
20                  state=conn.createStatement();
21             } catch (SQLException e) {
22                 // TODO Auto-generated catch block
23                 e.printStackTrace();
24             }
25             return state;
26     }
27     public static boolean handle(String sql) {
28         boolean flag=false;
29         try {
30             Statement state=getStatement();
31             int rs=state.executeUpdate(sql);
32             if(rs>0)
33                 flag=true;
34         } catch (SQLException e) {
35             // TODO Auto-generated catch block
36             e.printStackTrace();
37         }
38         return flag;
39     }
40     public static ResultSet select(String sql){
41         ResultSet rs=null;
42         Statement state=getStatement();
43         try {
44             rs=state.executeQuery(sql);
45         } catch (SQLException e) {
46             // TODO Auto-generated catch block
47             e.printStackTrace();
48         }
49         return rs;
50     }
51 }

servlet部分：

Rservlet:

 1 package servlet;
 2 
 3 import java.io.IOException;
 4 import java.io.PrintWriter;
 5 import java.sql.ResultSet;
 6 import java.sql.SQLException;
 7 import java.util.ArrayList;
 8 
 9 import javax.servlet.ServletException;
10 import javax.servlet.annotation.WebServlet;
11 import javax.servlet.http.HttpServlet;
12 import javax.servlet.http.HttpServletRequest;
13 import javax.servlet.http.HttpServletResponse;
14 
15 import com.mysql.cj.Session;
16 import java.util.*;
17 
18 import dao.Information;
19 import util.Sql_handle;
20 
21 /**
22  * Servlet implementation class Rservlet
23  */
24 @WebServlet("/Rservlet")
25 public class Rservlet extends HttpServlet {
26     private static final long serialVersionUID = 1L;
27        
28     /**
29      * @see HttpServlet#HttpServlet()
30      */
31     public Rservlet() {
32         super();
33         // TODO Auto-generated constructor stub
34     }
35 
36     /**
37      * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
38      */
39     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
40         // TODO Auto-generated method stub
41 //        response.getWriter().append("Served at: ").append(request.getContextPath());
42         request.setCharacterEncoding("utf-8");
43         response.setCharacterEncoding("utf-8");
44         String judge=request.getParameter("judge");  //判断执行那个功能
45         String sql="";
46         switch (judge) {
47         case "1":{                                  //增加
48             String tempstr="";
49             String str[]=request.getParameterValues("service");
50             for(String i:str)
51                 tempstr+=(i+";");
52             sql="insert into volunteer values('"+request.getParameter("name")+"','"+request.getParameter("sex")+"','"+request.getParameter("nation")+"','"+request.getParameter("time")+"','"+request.getParameter("age")+"','"+request.getParameter("id")+"','"+tempstr+"')";
53             Sql_handle.handle(sql);
54         }
55             
56             break;
57         case "2":{                                    //删除
58             sql="delete from volunteer where name='"+request.getParameter("name")+"'";
59             Sql_handle.handle(sql);
60         }
61             
62             break;
63         case "3":{                                    //修改
64             String tempstr="";
65             String str[]=request.getParameterValues("service");
66             for(String i:str)
67                 tempstr+=(i+";");
68             sql="update volunteer set name='"+request.getParameter("name")+"',sex='"+request.getParameter("sex")+"',nation='"+request.getParameter("nation")+"',time='"+request.getParameter("time")+"',age='"+request.getParameter("age")+"',id='"+request.getParameter("id")+"',service='"+tempstr+"' where name='"+request.getParameter("name")+"'";
69             Sql_handle.handle(sql);
70         }
71             
72             break;
73         }
74         request.getRequestDispatcher("Rservlet_scan").forward(request, response);
75     }
76 
77     /**
78      * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
79      */
80     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
81         // TODO Auto-generated method stub
82         
83     }
84 
85 }

Rservlet_scan:

 1 package servlet;
 2 
 3 import java.io.IOException;
 4 import java.io.PrintWriter;
 5 import java.sql.ResultSet;
 6 import java.sql.SQLException;
 7 import java.util.ArrayList;
 8 
 9 import javax.servlet.ServletException;
10 import javax.servlet.annotation.WebServlet;
11 import javax.servlet.http.HttpServlet;
12 import javax.servlet.http.HttpServletRequest;
13 import javax.servlet.http.HttpServletResponse;
14 
15 import com.mysql.cj.Session;
16 import java.util.*;
17 
18 import dao.Information;
19 import util.Sql_handle;
20 
21 /**
22  * Servlet implementation class Rservlet
23  */
24 @WebServlet("/Rservlet")
25 public class Rservlet extends HttpServlet {
26     private static final long serialVersionUID = 1L;
27        
28     /**
29      * @see HttpServlet#HttpServlet()
30      */
31     public Rservlet() {
32         super();
33         // TODO Auto-generated constructor stub
34     }
35 
36     /**
37      * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
38      */
39     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
40         // TODO Auto-generated method stub
41 //        response.getWriter().append("Served at: ").append(request.getContextPath());
42         request.setCharacterEncoding("utf-8");
43         response.setCharacterEncoding("utf-8");
44         String judge=request.getParameter("judge");  //判断执行那个功能
45         String sql="";
46         switch (judge) {
47         case "1":{                                  //增加
48             String tempstr="";
49             String str[]=request.getParameterValues("service");
50             for(String i:str)
51                 tempstr+=(i+";");
52             sql="insert into volunteer values('"+request.getParameter("name")+"','"+request.getParameter("sex")+"','"+request.getParameter("nation")+"','"+request.getParameter("time")+"','"+request.getParameter("age")+"','"+request.getParameter("id")+"','"+tempstr+"')";
53             Sql_handle.handle(sql);
54         }
55             
56             break;
57         case "2":{                                    //删除
58             sql="delete from volunteer where name='"+request.getParameter("name")+"'";
59             Sql_handle.handle(sql);
60         }
61             
62             break;
63         case "3":{                                    //修改
64             String tempstr="";
65             String str[]=request.getParameterValues("service");
66             for(String i:str)
67                 tempstr+=(i+";");
68             sql="update volunteer set name='"+request.getParameter("name")+"',sex='"+request.getParameter("sex")+"',nation='"+request.getParameter("nation")+"',time='"+request.getParameter("time")+"',age='"+request.getParameter("age")+"',id='"+request.getParameter("id")+"',service='"+tempstr+"' where name='"+request.getParameter("name")+"'";
69             Sql_handle.handle(sql);
70         }
71             
72             break;
73         }
74         request.getRequestDispatcher("Rservlet_scan").forward(request, response);
75     }
76 
77     /**
78      * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
79      */
80     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
81         // TODO Auto-generated method stub
82         
83     }
84 
85 }

Rservlet_consult:

 1 package servlet;
 2 
 3 import java.io.IOException;
 4 import java.sql.ResultSet;
 5 import java.sql.SQLException;
 6 import java.util.ArrayList;
 7 import java.util.List;
 8 
 9 import javax.servlet.ServletException;
10 import javax.servlet.annotation.WebServlet;
11 import javax.servlet.http.HttpServlet;
12 import javax.servlet.http.HttpServletRequest;
13 import javax.servlet.http.HttpServletResponse;
14 
15 import dao.Information;
16 import util.Sql_handle;
17 
18 /**
19  * Servlet implementation class Rservlet_consult
20  */
21 @WebServlet("/Rservlet_consult")
22 public class Rservlet_consult extends HttpServlet {
23     private static final long serialVersionUID = 1L;
24        
25     /**
26      * @see HttpServlet#HttpServlet()
27      */
28     public Rservlet_consult() {
29         super();
30         // TODO Auto-generated constructor stub
31     }
32 
33     /**
34      * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
35      */
36     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
37         // TODO Auto-generated method stub
38 //        response.getWriter().append("Served at: ").append(request.getContextPath());
39         request.setCharacterEncoding("utf-8");
40         response.setCharacterEncoding("utf-8");
41         String sql="";
42         String name=request.getParameter("name");
43         String judge=request.getParameter("judge_consult");
44         if(name==""||name==null)
45             request.getRequestDispatcher("Rservlet_scan").forward(request, response);
46         name="%"+name+"%";
47         switch (judge) {
48         case "1":sql="select * from volunteer where name like '"+name+"'";break;
49         case "2":sql="select * from volunteer where sex like '"+name+"'";break;
50         case "3":sql="select * from volunteer where nation like '"+name+"'";break;
51         case "4":sql="select * from volunteer where time like '"+name+"'";break;
52         case "5":sql="select * from volunteer where age like '"+name+"'";break;
53         case "6":sql="select * from volunteer where id like '"+name+"'";break;
54         case "7":sql="select * from volunteer where service like '"+name+"'";break;
55 
56         default:
57             break;
58         }
59         ResultSet rs=Sql_handle.select(sql);
60         List<Information> informations = new ArrayList<Information>();
61         try {
62             while(rs.next()) {
63                 Information formation=new Information();
64                 formation.setName(rs.getString("name"));
65                 formation.setSex(rs.getString("sex"));
66                 formation.setNation(rs.getString("nation"));
67                 formation.setTime(rs.getString("time"));
68                 formation.setAge(rs.getString("age"));
69                 formation.setId(rs.getString("id"));
70                 formation.setService(rs.getString("service"));
71                 informations.add(formation);
72             }
73         } catch (SQLException e) {
74             // TODO Auto-generated catch block
75             e.printStackTrace();
76         }
77         request.setAttribute("formations",informations);
78         request.getRequestDispatcher("consult.jsp").forward(request, response);
79     }
80 
81     /**
82      * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
83      */
84     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
85         // TODO Auto-generated method stub
86         doGet(request, response);
87     
88     }
89 
90 }

Rservlet_update:

 1 package servlet;
 2 
 3 import java.io.IOException;
 4 import java.sql.ResultSet;
 5 import java.sql.SQLException;
 6 import java.util.ArrayList;
 7 import java.util.List;
 8 
 9 import javax.servlet.ServletException;
10 import javax.servlet.annotation.WebServlet;
11 import javax.servlet.http.HttpServlet;
12 import javax.servlet.http.HttpServletRequest;
13 import javax.servlet.http.HttpServletResponse;
14 
15 import dao.Information;
16 import util.Sql_handle;
17 
18 /**
19  * Servlet implementation class Rservlet_update
20  */
21 @WebServlet("/Rservlet_update")
22 public class Rservlet_update extends HttpServlet {
23     private static final long serialVersionUID = 1L;
24        
25     /**
26      * @see HttpServlet#HttpServlet()
27      */
28     public Rservlet_update() {
29         super();
30         // TODO Auto-generated constructor stub
31     }
32 
33     /**
34      * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
35      */
36     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
37         // TODO Auto-generated method stub
38 //        response.getWriter().append("Served at: ").append(request.getContextPath());
39         request.setCharacterEncoding("utf-8");
40         response.setCharacterEncoding("utf-8");
41         String sql="";
42         sql="select * from volunteer where name like '"+request.getParameter("name")+"'";
43         ResultSet rs=Sql_handle.select(sql);
44         List<Information> informations = new ArrayList<Information>();
45         
46         try {
47             while(rs.next()) {
48                 Information formation=new Information();
49                 formation.setName(rs.getString("name"));
50                 formation.setSex(rs.getString("sex"));
51                 formation.setNation(rs.getString("nation"));
52                 formation.setTime(rs.getString("time"));
53                 formation.setAge(rs.getString("age"));
54                 formation.setId(rs.getString("id"));
55                 formation.setService(rs.getString("service"));
56                 informations.add(formation);
57             }
58         } catch (SQLException e) {
59             // TODO Auto-generated catch block
60             e.printStackTrace();
61         }
62         request.setAttribute("formations",informations);
63         request.getRequestDispatcher("update.jsp").forward(request, response);
64     }
65 
66     /**
67      * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
68      */
69     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
70         // TODO Auto-generated method stub
71         doGet(request, response);
72     }
73 
74 }

posted @ 2019-11-27 17:44 公鸡不下蛋阅读(179) 评论(0) 编辑收藏举报

会员力量，点亮园子希望

刷新页面返回顶部

公鸡不下蛋

增删改查(志愿者服务)

公告