简单的学生信息管理系统

1、 /连接数据库方法类JDBCConnection.javapackage gj;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;public class JDBCConnection String driverName = com.mysql.jdbc.Driver; /驱动程序名 String userName = root; /数据库用户名 String userPwd = text; /密码 String dbName = user; /数据库名 String ta

2、bleName = user_list3; /数据表名 String url =; public String getDriverName() return driverName;public void setDriverName(String driverName) this.driverName = driverName;public String getUserName() return userName;public void setUserName(String userName) this.userName = userName;public String getUserPwd()

3、 return userPwd;public void setUserPwd(String userPwd) this.userPwd = userPwd;public String getDbName() return dbName;public void setDbName(String dbName) this.dbName = dbName;public String getTableName() return tableName;public void setTableName(String tableName) this.tableName = tableName;public S

4、tring getUrl() return url;public void setUrl(String url) this.url = url;/实现数据库连接的方法 public Connection getConnection() throws SQLException, ClassNotFoundException /实现数据库连接的方法 String url1=jdbc:mysql:/localhost:3306/+dbName; String url2 =?user=+userName+&password=+userPwd; String url3=&useUnicode=true&

5、characterEncoding=GB2312; url =url1+url2+url3; Class.forName(driverName); return DriverManager.getConnection(url); /用户登录界面Index.jspMy JSP index.jsp starting page function validate() var userName=document.formsform1.UserName.value; var password=document.formsform1.pd.value; if(userName.length=0) aler

6、t(用户名不能为空！); else if(password=0) alert(密码不能为空！); else document.formsform1.submit(); 用户登录 用户名：密  码：          注册    /用户登录后台验证类CheckLogin.javapackage gj;import java.sql.Connection;import java.sql.ResultSet;import java.sql.SQLException;import java.s

7、ql.Statement;public class CheckLogin private String name;private String password;public String getName() return name;public void setName(String name) = name;public String getPassword() return password;public void setPassword(String password) this.password = password;public CheckLogin(Strin

8、g name, String password) super(); = name;this.password = password;public int Check() throws SQLException, ClassNotFoundException JDBCConnection kkk = new JDBCConnection();Connection con = kkk.getConnection();Statement statement;try statement = con.createStatement();String sql = select * fro

9、m user_list3 where name= + name + ;ResultSet rs = statement.executeQuery(sql);ResultSet rs1 = null;if (!rs.next() return 1; else String sql1 = select * from user_list3 where password=+ password + ;rs1 = statement.executeQuery(sql1);if (!rs1.next() return 2;rs.close();rs1.close();statement.close();co

10、n.close(); catch (Exception e) e.printStackTrace();return 3;CheckLogin.java 中do post 方法request.setCharacterEncoding(GB2312);String name = request.getParameter(UserName);String pd = request.getParameter(pd);CheckLogin cl = new CheckLogin(name, pd);try switch (cl.Check() case 1:request.setAttribute(re

11、turn,用户名不存在！注册？);request.getRequestDispatcher(index.jsp).forward(request,response);break;case 2:request.setAttribute(return,密码不存在！);request.getRequestDispatcher(index.jsp).forward(request,response);break;case 3:request.getRequestDispatcher(main.jsp).forward(request,response); catch (SQLException e1)

12、 / TODO Auto-generated catch blocke1.printStackTrace(); catch (ClassNotFoundException e1) / TODO Auto-generated catch blocke1.printStackTrace();/用户类package gj.user;public class user private String UserName; private String pd;public String getUserName() return UserName;public void setUserName(String

13、userName) UserName = userName;public String getPd() return pd;public void setPd(String pd) this.pd = pd;public user(String userName, String pd) super();UserName = userName;this.pd = pd; /用户注册界面Register.JspMy JSP register.jsp starting page function fdate() var userName=.value;

14、 var password=document.formsform2.password.value; var repassword=document.formsform2.repassword.value; if(userName.length=0) alert(用户名不能为空！); else if(password=0) alert(密码不能为空！); else if(password!=repassword) alert(两次输入密码不一致！); else document.formsform2.submit(); 用户注册 用 户 名:密    码:再次输入: &nbs

15、p;             返回登录界面/用户注册写入数据库servletRegister.jsppackage servlet;import gj.JDBCConnection;import gj.getSQL;import java.io.IOException;import java.sql.SQLException;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import jav

16、ax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;public class register extends HttpServlet public register() super();public void destroy() super.destroy(); / Just puts destroy string in log/ Put your code herepublic void doGet(HttpServletRequest request, HttpServletRe

17、sponse response)throws ServletException, IOException doPost(request, response);public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException request.setCharacterEncoding(GB2312);String name = request.getParameter(name);String password = request.getP

18、arameter(password);JDBCConnection j = new JDBCConnection();try j.getConnection(); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace(); catch (ClassNotFoundException e) / TODO Auto-generated catch blocke.printStackTrace();getSQL gl = new getSQL(name, password);try gl.getValue(

19、); catch (ClassNotFoundException e) / TODO Auto-generated catch blocke.printStackTrace(); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();request.setAttribute(success, 注册成功！);request.getRequestDispatcher(register.jsp).forward(request, response);/向数据库中添加数据类package gj;impor

20、t java.sql.Connection;import java.sql.SQLException;import java.sql.Statement;public class getSQL private String name;private String password;public getSQL(String name, String password) super(); = name;this.password = password;public void getValue() throws ClassNotFoundException, SQLExceptio

21、n JDBCConnection kkk=new JDBCConnection(); Connection con=kkk. getConnection() ; Statement statement = con.createStatement(); String sql =insert into user_list3 values(+name+,+password+); statement. executeUpdate(sql); statement.close(); con.close(); /用户查询界面Query.jspMy JSP success.jsp starting page数

22、据查询按用户查询：查询内容如下：编号名字email%for (int i = 0; i 共有条记录，查询结果如上表所示！/学生类Student.javapublic class student private String number;private String name;private String email;public String getNumber() return number;public void setNumber(String number) this.number = number;public String getName() return name;public

23、 void setName(String name) = name;public String getEmail() return email;public void setEmail(String email) this.email = email;public student(String number, String name, String email) super();this.number = number; = name;this.email = email;public void getValue() throws ClassNotFoun

24、dException, SQLException JDBCConnection kkk=new JDBCConnection(); kkk.setTableName(student); Connection con=kkk. getConnection() ; Statement statement = con.createStatement(); String sql =insert into student values(+number+,+name+,+email+); statement. executeUpdate(sql); statement.close(); con.close

25、(); /学生信息查询类Query.javapackage gj.user;import gj.JDBCConnection;import java.sql.Connection;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class query public query() public user Query(String sql) throws SQLException, ClassNotFoundException JDBCConnection kkk =

26、new JDBCConnection();Connection con = kkk.getConnection();Statement statement = con.createStatement();ResultSet rs = statement.executeQuery(sql);rs.last();user user2 = new userrs.getRow();rs.beforeFirst();int i = 0;while (rs.next() user2i = new user(rs.getString(name), rs.getString(password);i = i +

27、 1;rs.close();statement.close();con.close();return user2;/学生信息查询public student QueryStu(String sql) throws SQLException, ClassNotFoundExceptionJDBCConnection kkk = new JDBCConnection();kkk.setTableName(student);Connection con = kkk.getConnection();Statement statement = con.createStatement();ResultSe

28、t rs1 = statement.executeQuery(sql);rs1.last();student stu=new studentrs1.getRow();rs1.beforeFirst();int i=0;while(rs1.next()stui=new student(rs1.getString(number),rs1.getString(name),rs1.getString(email);i+=1;rs1.close();statement.close();con.close();return stu;/数据添加类Insert.jspMy JSP insert.jsp sta

29、rting page function validate2() var Number=document.formsform4.number.value; var Name=.value; var Email=document.formsform4.email.value; if(Number.length=0) alert(学号不能为空！); else if(Name=0) alert(名字不能为空！); else if(Email=0) alert(email不能为空！) else document.formsform4.submit(); 学

30、生信息添加学号姓名email   /insert.java servlet do post()public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException request.setCharacterEncoding(GB2312);String number=request.getParameter(number);String name=request.getParameter(name);String emai

31、l=request.getParameter(email);student st=new student(number,name,email);try st.getValue(); catch (ClassNotFoundException e) / TODO Auto-generated catch blocke.printStackTrace(); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();request.setAttribute(ok,添加成功！);request.getRequestDispatcher(insert.jsp).forward(request,response);/数据修改Update.jspMy JSP update.jsp starting page请选择要修改的学生 编号用户名Email%for (int i = 0; i input type=rad