struts2用户注册系统

《struts2用户注册系统》由会员分享，可在线阅读，更多相关《struts2用户注册系统（28页珍藏版）》请在装配图网上搜索。

1、用户注册系统所有的jsp页面就不写啦这是用户的封装类package lxy.struts.useraction;public class user private String username;private String password;private String repassword;private String birthday;private String email;private String webset;private String id;public String getUsername() return username;public void setUsername

2、(String username) this.username = username;public String getPassword() return password;public void setPassword(String password) this.password = password;public String getRepassword() return repassword;public void setRepassword(String repassword) this.repassword = repassword;public String getBirthday

3、() return birthday;public void setBirthday(String birthday) this.birthday = birthday;public String getEmail() return email;public void setEmail(String email) this.email = email;public String getWebset() return webset;public void setWebset(String webset) this.webset = webset;public String getId() ret

4、urn id;public void setId(String id) this.id = id;这是操作数据的类package lxy.struts.dbaction;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;import java.util.ArrayList;import lxy.struts.useraction.user;public class OrCon private static Connection

5、con;private static Statement st;private static ResultSet rs;public static void open() try DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver();con = DriverManager.getConnection(jdbc:oracle:thin:localhost:1521:orcl, SYSTEM,Orcl1234); catch (Exception e) / TODO: handle exceptionpublic st

6、atic void close()try if (rs != null)rs.close();if (st != null)st.close();if (con != null)con.close(); catch (Exception e) / TODO: handle exceptionpublic static Object getOne(String sql)Object o=new Object();open();try st = con.createStatement();rs = st.executeQuery(sql);if(rs.next()o=rs.getObject(1)

7、; catch (Exception e) / TODO: handle exceptionclose();return o;public static ArrayList getManyliudb(String sql)System.out.println(sql);ArrayList ulist=new ArrayList();open();try st = con.createStatement();rs = st.executeQuery(sql);while(rs.next()user u=new user();u.setUsername(rs.getString(1);u.setP

8、assword(rs.getString(2);u.setBirthday(rs.getString(3);u.setEmail(rs.getString(4);u.setWebset(rs.getString(5);u.setId(rs.getString(6);ulist.add(u); catch (Exception e) / TODO: handle exceptionclose();return ulist;public static user getOneliudb(String sql)System.out.println(sql);user u=new user();open

9、();try st = con.createStatement();rs = st.executeQuery(sql);while(rs.next()u.setUsername(rs.getString(1);u.setPassword(rs.getString(2);u.setBirthday(rs.getString(3);u.setEmail(rs.getString(4);u.setWebset(rs.getString(5);System.out.println(u.getWebset();u.setId(rs.getString(6);System.out.println(u.ge

10、tId(); catch (Exception e) / TODO: handle exceptionclose();return u;public static void executeQu(String sql)System.out.println(sql);open();try st = con.createStatement();rs = st.executeQuery(sql); catch (Exception e) / TODO: handle exceptionclose();这是登录的类package lxy.struts.kanaction;import lxy.strut

11、s.dbaction.OrCon;import lxy.struts.useraction.user;public class kan public static boolean nihao(user u)boolean f=false;String sql=select count(*) from liudb1 +where username=+u.getUsername()+and password=+u.getPassword()+;if(OrCon.getOne(sql).toString().equals(1)f=true;return f;这是用户自己的登录类package lxy

12、.struts.action;import lxy.struts.dbaction.OrCon;import lxy.struts.kanaction.kan;import lxy.struts.useraction.user;import com.opensymphony.xwork2.ActionSupport;public class dengluAction extends ActionSupport private user u;public user getU() return u;public void setU(user u) this.u = u;public String

13、execute() if(kan.nihao(u)String sql=select * from liudb1 where username=+u.getUsername()+;u=OrCon.getOneliudb(sql);return this.SUCCESS;elsereturn this.ERROR;这是系统的注册类package lxy.struts.action;import lxy.struts.dbaction.OrCon;import lxy.struts.useraction.user;import com.opensymphony.xwork2.ActionSuppo

14、rt;public class zhuceAction extends ActionSupport private user u;public user getU() return u;public void setU(user u) this.u = u;public String execute() String sql=insert into liudb1 values(+u.getUsername()+,+u.getPassword()+,+u.getBirthday()+,+u.getEmail()+,+u.getWebset()+,+u.getId()+);OrCon.execut

15、eQu(sql);return SUCCESS;Overridepublic void validate() if(!u.getPassword().equals(u.getRepassword()addActionError(the password be same!);super.validate();这是用户的查看自己的类package lxy.struts.action;import lxy.struts.dbaction.OrCon;import lxy.struts.kanaction.kan;import lxy.struts.useraction.user;import com

16、.opensymphony.xwork2.ActionSupport;public class xiangxiAction extends ActionSupport private user u;private String username;public String getUsername() return username;public void setUsername(String username) this.username = username;public user getU() return u;public void setU(user u) this.u = u;pub

17、lic String execute() String sql=select * from liudb1 where username=+this.username+;u=OrCon.getOneliudb(sql);return this.SUCCESS;这是用户修改类package lxy.struts.action;import lxy.struts.dbaction.OrCon;import lxy.struts.useraction.user;import com.opensymphony.xwork2.ActionSupport;public class xiugaiAction

18、extends ActionSupport private String username;private user u;public String getUsername() return username;public void setUsername(String username) this.username = username;public user getU() return u;public void setU(user u) this.u = u;public String execute() String sql=select * from liudb1 where use

19、rname=+this.username+;u=OrCon.getOneliudb(sql);return SUCCESS;package lxy.struts.action;import java.util.ArrayList;import lxy.struts.dbaction.OrCon;import lxy.struts.useraction.user;import com.opensymphony.xwork2.ActionSupport;public class savexiugaiAction extends ActionSupport private user u;public

20、 user getU() return u;public void setU(user u) this.u = u;public String execute() String sql=update liudb1 set password=+u.getPassword()+,birthday=+u.getBirthday()+,email=+u.getEmail()+,webset=+u.getWebset()+,id=+u.getId()+where username=+u.getUsername()+;OrCon.executeQu(sql);String sql1=select * fr

21、om liudb1 where username=+u.getUsername()+;u=OrCon.getOneliudb(sql1);return SUCCESS;这是管理员登录类package lxy.struts.adminaction;import java.util.ArrayList;import javax.servlet.http.HttpSession;import org.apache.struts2.ServletActionContext;import lxy.struts.dbaction.OrCon;import lxy.struts.kanaction.kan;

22、import lxy.struts.useraction.user;import com.opensymphony.xwork2.ActionSupport;public class admindengluAction extends ActionSupport private user u;private ArrayList ulist;public user getU() return u;public void setU(user u) this.u = u;public ArrayList getUlist() return ulist;public void setUlist(Arr

23、ayList ulist) this.ulist = ulist;public String execute() throws Exception if(kan.nihao(u)String sql = select * from liudb1 ;ulist = OrCon.getManyliudb(sql);String sql1=select * from liudb1 where username=+u.getUsername()+;String id=OrCon.getOneliudb(sql1).getId();u=OrCon.getOneliudb(sql1);System.out

24、.println(u.getId();if(id.equals(admin) HttpSession session=ServletActionContext.getRequest().getSession();session.setAttribute(ni, u.getId();return this.SUCCESS;elsereturn this.ERROR; return hehe;这是管理员修改所有用户类package lxy.struts.adminaction;import java.util.ArrayList;import lxy.struts.dbaction.OrCon;i

25、mport lxy.struts.useraction.user;import com.opensymphony.xwork2.ActionSupport;public class adminupdateAction extends ActionSupport private String username;private user u;public String getUsername() return username;public void setUsername(String username) this.username = username;public user getU() r

26、eturn u;public void setU(user u) this.u = u;public String execute() String sql=select * from liudb1 where username=+this.username+;u=OrCon.getOneliudb(sql);return SUCCESS;这是管理员删除用户类package lxy.struts.adminaction;import java.util.ArrayList;import lxy.struts.dbaction.OrCon;import com.opensymphony.xwor

27、k2.ActionSupport;public class admindeleteAction extends ActionSupport private String username;private ArrayList ulist;public String getUsername() return username;public void setUsername(String username) this.username = username;public ArrayList getUlist() return ulist;public void setUlist(ArrayList

28、ulist) this.ulist = ulist;Overridepublic String execute() throws Exception String sql=delete from liudb1 where username=+this.username+;OrCon.executeQu(sql);String sql1=select * from liudb1 ;ulist=OrCon.getManyliudb(sql1);return super.execute();这是管理员保存修改用户类package lxy.struts.adminaction;import java.

29、util.ArrayList;import lxy.struts.dbaction.OrCon;import lxy.struts.useraction.user;import com.opensymphony.xwork2.ActionSupport;public class adminsaveupdateAction extends ActionSupport private user u;private ArrayList ulist;public user getU() return u;public void setU(user u) this.u = u;public ArrayL

30、ist getUlist() return ulist;public void setUlist(ArrayList ulist) this.ulist = ulist;public String execute() String sql=update liudb1 set password=+u.getPassword()+,birthday=+u.getBirthday()+,email=+u.getEmail()+,webset=+u.getWebset()+;OrCon.executeQu(sql);String sql1=select * from liudb1 ;ulist=OrC

31、on.getManyliudb(sql1);return SUCCESS;这是管理员给用户分配用户权限的类package lxy.struts.adminaction;import java.util.ArrayList;import javax.servlet.http.HttpSession;import org.apache.struts2.ServletActionContext;import lxy.struts.dbaction.OrCon;import lxy.struts.useraction.user;import com.opensymphony.xwork2.Action

32、Support;public class adminquanxianAction extends ActionSupport private user u;private ArrayList ulist;public ArrayList getUlist() return ulist;public void setUlist(ArrayList ulist) this.ulist = ulist;public user getU() return u;public void setU(user u) this.u = u;Overridepublic String execute() thro

33、ws Exception HttpSession session=ServletActionContext.getRequest().getSession();session.getAttribute(ni);String sql=update liudb1 set id=+u.getId()+where username=+u.getUsername()+;OrCon.executeQu(sql);String sql1=select * from liudb1 ;ulist=OrCon.getManyliudb(sql1);return super.execute();这是教务关系系统的部

34、分代码不写jsp代码啦这是学生的封装类package com.struts.modelaction;public class student private int s_id; / sequense private String s_number; / not nullprivate String s_name; / not nullprivate String s_password; / not nullprivate String repassword;private String c_name;private String c_type;private int c_id; / not n

35、ullprivate int id;private int id1;private String username;private String password;private String usertype;public String getUsername() return username;public void setUsername(String username) this.username = username;public String getPassword() return password;public void setPassword(String password)

36、 this.password = password;public String getUsertype() return usertype;public void setUsertype(String usertype) this.usertype = usertype;public int getId() return id;public void setId(int id) this.id = id;public int getId1() return id1;public void setId1(int id1) this.id1 = id1;public long getS_id()

37、return s_id;public String getS_number() return s_number;public void setS_number(String s_number) this.s_number = s_number;public String getS_name() return s_name;public void setS_name(String s_name) this.s_name = s_name;public String getS_password() return s_password;public void setS_password(String

38、 s_password) this.s_password = s_password;public String getRepassword() return repassword;public void setRepassword(String repassword) this.repassword = repassword;public String getC_name() return c_name;public void setC_name(String c_name) this.c_name = c_name;public String getC_type() return c_typ

39、e;public void setC_type(String c_type) this.c_type = c_type;public int getC_id() return c_id;public void setC_id(int c_id) this.c_id = c_id;public void setS_id(int s_id) this.s_id = s_id;这是同学操作类package com.struts.dbaction;import java.sql.Connection;import java.sql.DriverManager;import java.sql.Resul

40、tSet;import java.sql.SQLException;import java.sql.Statement;import java.util.ArrayList;import javax.servlet.http.HttpSession;import org.apache.struts2.ServletActionContext;import com.struts.modelaction.admin;import com.struts.modelaction.exam;import com.struts.modelaction.grade;import com.struts.mod

41、elaction.lesson1;import com.struts.modelaction.student;import com.struts.modelaction.teacher;public class OrCon private static Connection con;private static Statement st;private static ResultSet rs;public static void open() try DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver();con =

42、 DriverManager.getConnection(jdbc:oracle:thin:localhost:1521:orcl, SYSTEM,Orcl1234); catch (Exception e) / TODO: handle exceptionpublic static void close() try if (rs != null)rs.close();if (st != null)st.close();if (con != null)con.close(); catch (Exception e) / TODO: handle exceptionpublic static a

43、dmin getadone(String sql)admin a=new admin();open();try st = con.createStatement();rs = st.executeQuery(sql);while(rs.next()a.setA_id(rs.getInt(1);a.setA_name(rs.getString(2);a.setA_password(rs.getString(3);a.setA_type(rs.getString(4); catch (Exception e) / TODO: handle exceptionclose();return a;pub

44、lic static ArrayList getadmany(String sql)ArrayList ulist=new ArrayList();open();try st = con.createStatement();rs = st.executeQuery(sql);while(rs.next()admin a=new admin();a.setA_id(rs.getInt(1);a.setA_name(rs.getString(2);a.setA_password(rs.getString(3);a.setA_type(rs.getString(4);ulist.add(a); ca

45、tch (Exception e) / TODO: handle exceptionclose();return ulist;public static Object getOne(String sql) System.out.println(sql);Object o = new Object();open();try st = con.createStatement();rs = st.executeQuery(sql);if (rs.next()o = rs.getObject(1); catch (Exception e) / TODO: handle exceptionclose()

46、;return o;public static student getOnestudent(String sql) System.out.println(sql);student stu = new student();open();try st = con.createStatement();rs = st.executeQuery(sql);while (rs.next() stu.setS_id(rs.getInt(1);System.out.println(stu.getS_id();stu.setS_number(rs.getString(2);stu.setS_name(rs.ge

47、tString(3);stu.setS_password(rs.getString(4);stu.setC_name(rs.getString(5);stu.setC_type(rs.getString(6);stu.setC_id(rs.getInt(7);stu.setId(rs.getInt(8);stu.setId1(rs.getInt(9); catch (Exception e) / TODO: handle exceptionclose();return stu;public static void executeNoQ1(String sql) System.out.print

48、ln(sql); open();try st = con.createStatement();st.executeUpdate(sql); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace(); close(); 这是登录类package com.struts.action;import java.util.ArrayList;import javax.servlet.http.HttpSession;import org.apache.struts2.ServletActionContext;i

49、mport com.opensymphony.xwork2.ActionSupport;import com.struts.dbaction.OrCon;import com.struts.kanaction.kan;import com.struts.modelaction.admin;import com.struts.modelaction.student;import com.struts.modelaction.teacher;public class loginAction extends ActionSupport private student u;private teache

50、r t;private admin a;public admin getA() return a;public void setA(admin a) this.a = a;public teacher getT() return t;public void setT(teacher t) this.t = t;public student getU() return u;public void setU(student u) this.u = u;public String execute() if(u.getUsertype().equals(1) String sql=select cou

51、nt(*) from student +where s_number=+u.getUsername()+and s_password=+u.getPassword()+; HttpSession session=ServletActionContext.getRequest().getSession(); session.setAttribute(ni, u.getUsername();if(OrCon.getOne(sql).toString().equals(1)String sql2=select * from student where s_number=+u.getUsername(

52、)+;u=OrCon.getOnestudent(sql2);session.setAttribute(hao, u.getS_name();session.setAttribute(ba, u.getId();session.setAttribute(liu, u.getId1();return student;if(u.getUsertype().equals(2)String sql=select count(*) from teacher +where teacherID=+u.getUsername()+and teacherPWD=+u.getPassword()+; HttpSe

53、ssion session=ServletActionContext.getRequest().getSession(); if(OrCon.getOne(sql).toString().equals(1)String sql1=select * from teacher where teacherID=+u.getUsername()+;t=OrCon.getOneSoftuser(sql1);session.setAttribute(wo, u.getUsername();session.setAttribute(xiao, t.getTeacherNAME();return teacher;if(u.getUsertyp