2017年12月18日

class DB.java

 1 package bean;
 2 
 3 import java.sql.*;
 4 public class DB {
 5     private String url = "jdbc:mysql://localhost:3306/togo";
 6     private String className = "com.mysql.jdbc.Driver";
 7     private String userName = "root";
 8     private String password = "toor";
 9     private Connection con = null;
10     private Statement stm = null;
11     private ResultSet rs = null;
12     
13     public DB(){
14         try{
15             Class.forName(className).newInstance();
16         }catch(Exception e){
17             e.printStackTrace();
18         }
19     }
20     public void createCon(){
21         try{
22             con = DriverManager.getConnection(url,userName,password);
23         }catch(Exception e){
24             e.printStackTrace();
25         }
26     }
27     public void getStm(){
28         createCon();
29         try{
30             stm = con.createStatement();
31         }catch(Exception e){
32             e.printStackTrace();
33         }
34     }
35     public boolean executeUpdate(String sql){
36         boolean mark=false;
37         try{
38             getStm();
39             int iCount = stm.executeUpdate(sql);
40             if(iCount>0)
41                 mark=true;
42             else
43                 mark=false;
44         }catch(Exception e){
45             e.printStackTrace();
46         }
47         return mark;
48     }
49     public ResultSet executeQuery(String sql){
50         try{
51             getStm();
52             rs = stm.executeQuery(sql);
53         }catch(Exception e){
54             e.printStackTrace();
55         }
56         return rs;
57     }
58     
59     public void close(){
60         try{
61             if(rs!=null)
62                 rs.close();
63             if(stm!=null)
64                 stm.close();
65             if(con!=null)
66                 con.close();
67         }catch(Exception e){
68             e.printStackTrace();
69         }
70     }
71 }

tool.java

 1 package bean;
 2 public class Tool {
 3     /**
 4      * 字符串转码
 5      * @param str
 6      * @return
 7      */
 8     public static String toChinese(String str){
 9         String s="";
10         try{
11             s = new String(str.getBytes("ISO-8859-1"),"utf-8");
12         }catch(Exception e){
13             e.printStackTrace();
14         }
15         return s;
16     }
17 }

UserBean.java

 1 package bean;
 2 
 3 public class UserBean {
 4     private String tel;
 5     private String passwd;
 6     private String name;
 7     private String sex;
 8     private String addr;
 9     
10     public UserBean() {
11         
12     }
13     public UserBean(String tel,String pass,String name,String sex,String addr) {
14         this.addr = addr;
15         this.name = name;
16         this.sex = sex;
17         this.tel = tel;
18         this.passwd = pass;
19     }
20     public String getTel() {
21         return tel;
22     }
23     public void setTel(String tel) {
24         this.tel = tel;
25     }
26     public String getPasswd() {
27         return passwd;
28     }
29     public void setPasswd(String passwd) {
30         this.passwd = passwd;
31     }
32     public String getName() {
33         return name;
34     }
35     public void setName(String name) {
36         this.name = name;
37     }
38     public String getSex() {
39         return sex;
40     }
41     public void setSex(String sex) {
42         this.sex = sex;
43     }
44     public String getAddr() {
45         return addr;
46     }
47     public void setAddr(String addr) {
48         this.addr = addr;
49     }
50     
51 }

UserManager.java

  1 package bean;
  2 import java.sql.*;
  3 import java.util.ArrayList;
  4 import java.util.List;
  5 public class UserManager {
  6     DB connection;
  7     public UserManager() {
  8         connection = new DB();
  9     }
 10     
 11     public boolean addUser(UserBean user) {
 12         boolean flag = false;
 13         
 14         String sql = "insert into user values('"+user.getTel()+"','"+user.getPasswd()+"','','','');";
 15         try {
 16             flag = connection.executeUpdate(sql);
 17         }catch(Exception e){
 18             e.printStackTrace();
 19         }
 20         return flag;
 21     }
 22     
 23     public boolean isUser(String tel,String pass) {
 24         boolean flag = false;
 25         
 26         String sql = "select * from user where tel='"+tel+"' and passwd='"+pass+"';";
 27         try {
 28             ResultSet rs = connection.executeQuery(sql);
 29             while(rs.next()) {
 30                 flag = true;
 31             }
 32         }catch(Exception e){
 33             e.printStackTrace();
 34         }
 35         return flag;
 36     }
 37     
 38     public boolean change_password(String tel,String pass) {
 39         boolean flag = false;
 40         
 41         String sql = "update user set passwd='"+pass+"' where tel='"+tel+"';";
 42         try {
 43             flag = connection.executeUpdate(sql);
 44         }catch(Exception e){
 45             e.printStackTrace();
 46         }
 47         return flag;
 48     }
 49     
 50     public UserBean queryUser(String tel) {
 51         UserBean user =null;
 52         String sql = "select * from user where tel='"+tel+"';";
 53         try {
 54             ResultSet rs = connection.executeQuery(sql);
 55             while(rs.next()) {
 56                 user = new UserBean(rs.getString(1),rs.getString(2),rs.getString(3),rs.getString(4),rs.getString(5));
 57             }
 58         }catch(Exception e){
 59             e.printStackTrace();
 60         }
 61         return user;
 62     }
 63     
 64     public boolean change_info(UserBean user) {
 65         boolean flag = false;
 66         
 67         String sql = "update user set name='"+user.getName()+"',addr='"+user.getAddr()+"',sex='"+user.getSex()+"' where tel='"+user.getTel()+"';";
 68         try {
 69             flag = connection.executeUpdate(sql);
 70         }catch(Exception e){
 71             e.printStackTrace();
 72         }
 73         return flag;
 74     }
 75     
 76     public List select_alluser() {
 77         UserBean user =null;
 78         String sql = "select * from user;";
 79         List list = new ArrayList();
 80         try {
 81             ResultSet rs = connection.executeQuery(sql);
 82             while(rs.next()) {
 83                 user = new UserBean(rs.getString(1),rs.getString(2),rs.getString(3),rs.getString(4),rs.getString(5));
 84                 list.add(user);
 85             }
 86         }catch(Exception e){
 87             e.printStackTrace();
 88         }
 89         return list;
 90     }
 91     
 92     public boolean delete(String tel) {
 93         boolean flag = false;
 94         
 95         String sql = "delete from user where tel='"+tel+"';";
 96         try {
 97             flag = connection.executeUpdate(sql);
 98         }catch(Exception e){
 99             e.printStackTrace();
100         }
101         return flag;
102     }
103     
104 //    public static void main(String[] args) {
105 //        UserBean user = new UserBean();
106 //        user.setTel("12300");
107 //        user.setPasswd("5645");
108 //        new UserManager().addUser(user);
109 //    }
110 }

UserServlet.java

  1 package servlet;
  2 
  3 import java.io.IOException;
  4 import java.util.List;
  5 
  6 import javax.servlet.RequestDispatcher;
  7 import javax.servlet.ServletException;
  8 import javax.servlet.annotation.WebServlet;
  9 import javax.servlet.http.HttpServlet;
 10 import javax.servlet.http.HttpServletRequest;
 11 import javax.servlet.http.HttpServletResponse;
 12 
 13 import bean.AdminManager;
 14 import bean.Tool;
 15 import bean.UserBean;
 16 import bean.UserManager;
 17 
 18 /**
 19  * Servlet implementation class UserServlet
 20  */
 21 @WebServlet("/UserServlet")
 22 public class UserServlet extends HttpServlet {
 23     private static final long serialVersionUID = 1L;
 24        
 25     /**
 26      * @see HttpServlet#HttpServlet()
 27      */
 28     public UserServlet() {
 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         String action = (String)request.getParameter("action");
 39         if(action.equals("register")) {
 40             register(request,response);
 41         }else if(action.equals("login")) {
 42             login(request,response);
 43         }else if(action.equals("changepassword")) {
 44             changepassword(request,response);
 45         }else if(action.equals("changeinfo")) {
 46             changeinfo(request,response);
 47         }else if(action.equals("alluser")) {
 48             alluser(request,response);
 49         }else if(action.equals("delete")) {
 50             delete(request,response);
 51         }
 52     }
 53 
 54     /**
 55      * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
 56      */
 57     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
 58         // TODO Auto-generated method stub
 59         doGet(request, response);
 60     }
 61     
 62     protected void register(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
 63         String tel = (String)request.getParameter("tel");
 64         String pass1 = (String)request.getParameter("pass1");
 65         UserBean user = new UserBean();
 66         user.setTel(tel);
 67         user.setPasswd(pass1);
 68         if(new UserManager().addUser(user)) {
 69             RequestDispatcher rd = null;
 70             rd = request.getRequestDispatcher("homePage.jsp");
 71             rd.forward(request, response);
 72         }
 73     }
 74     
 75     protected void login(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
 76         String tel = (String)request.getParameter("tel");
 77         String pass = (String)request.getParameter("pass");
 78         if(new AdminManager().isAdmin(tel, pass)) {
 79             RequestDispatcher rd = null;
 80             rd = request.getRequestDispatcher("admincenter.jsp");
 81             rd.forward(request, response);
 82         }else if(new UserManager().isUser(tel, pass)) {
 83             RequestDispatcher rd = null;
 84             UserBean loginer = new UserManager().queryUser(tel);
 85             request.getSession().setAttribute("loginer",loginer );
 86             rd = request.getRequestDispatcher("usercenter.jsp");
 87             rd.forward(request, response);
 88         }
 89     }
 90     
 91     protected void changepassword(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
 92         String pass1 = (String)request.getParameter("pass1");
 93         String pass2 = (String)request.getParameter("pass2");
 94         String pass3 = (String)request.getParameter("pass3");
 95         UserBean loginer = (UserBean)request.getSession().getAttribute("loginer");
 96         if(new UserManager().change_password(loginer.getTel(), pass3)) {
 97             RequestDispatcher rd = null;
 98             request.setAttribute("message", "修改成功");
 99             rd = request.getRequestDispatcher("usercenter.jsp");
100             rd.forward(request, response);
101         }
102     }
103     protected void changeinfo(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
104         String name = (String)request.getParameter("name");
105         String sex = (String)request.getParameter("sex");
106         String addr = (String)request.getParameter("addr");
107         UserBean loginer = (UserBean)request.getSession().getAttribute("loginer"); 
108         loginer.setAddr(Tool.toChinese(addr));
109         loginer.setName(Tool.toChinese(name));
110         loginer.setSex(Tool.toChinese(sex));
111         if(new UserManager().change_info(loginer)) {
112             RequestDispatcher rd = null;
113             request.setAttribute("message", "修改成功");
114             rd = request.getRequestDispatcher("usercenter.jsp");
115             rd.forward(request, response);
116         }
117     }
118     
119     protected void alluser(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
120         RequestDispatcher rd = null;
121         List list = new UserManager().select_alluser();
122         request.setAttribute("list", list);
123         rd = request.getRequestDispatcher("alluser.jsp");
124         rd.forward(request, response);
125     }
126     
127     protected void delete(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
128         String tel = (String)request.getParameter("tel");
129         new UserManager().delete(tel);
130         alluser(request,response);
131     }
132 }

 

posted @ 2017-12-18 13:51  xiaoyao1949  阅读(209)  评论(0)  编辑  收藏  举报