簡單的學(xué)生信息管理系統(tǒng)

1、精選優(yōu)質(zhì)文檔傾情為你奉上精選優(yōu)質(zhì)文檔傾情為你奉上專心專注專業(yè)專心專注專業(yè)精選優(yōu)質(zhì)文檔傾情為你奉上專心專注專業(yè) /連接數(shù)據(jù)庫方法類JDBCConnection.javapackage gj;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;public class JDBCConnection String driverName = com.mysql.jdbc.Driver; /驅(qū)動程序名 String userName = root; /數(shù)據(jù)庫用戶名 String use

2、rPwd = text; /密碼 String dbName = user; /數(shù)據(jù)庫名 String tableName = user_list3; /數(shù)據(jù)表名 String url =; public String getDriverName() return driverName;public void setDriverName(String driverName) this.driverName = driverName;public String getUserName() return userName;public void setUserName(String userNam

3、e) this.userName = userName;public String getUserPwd() 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

4、(String tableName) this.tableName = tableName;public String getUrl() return url;public void setUrl(String url) this.url = url;/實現(xiàn)數(shù)據(jù)庫連接的方法 public Connection getConnection() throws SQLException, ClassNotFoundException /實現(xiàn)數(shù)據(jù)庫連接的方法 String url1=jdbc:mysql:/localhost:3306/+dbName; String url2 =?user=+user

5、Name+&password=+userPwd; String url3=&useUnicode=true&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=do

6、cument.formsform1.pd.value; if(userName.length=0) alert(用戶名不能為空！); 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.sql.Statement;p

7、ublic 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(String name, String password)

8、 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 * from user_list3 where name= + name +

9、 ;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();con.close(); catch (Exception e) e.

10、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(return,用戶名不存在！注冊？);request.getReque

11、stDispatcher(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) / TODO Auto-generated catch bloc

12、ke1.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 userName) UserName = userName;pub

13、lic 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; var password=document.formsform2

14、.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(); 用戶注冊 用 戶 名:密 碼:再次輸入: 返回登錄界面/用戶注冊寫入數(shù)據(jù)庫servletRegister.jsppackage servlet

15、;import gj.JDBCConnection;import gj.getSQL;import java.io.IOException;import java.sql.SQLException;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;public class register extends Http

16、Servlet public register() super();public void destroy() super.destroy(); / Just puts destroy string in log/ Put your code herepublic void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException doPost(request, response);public void doPost(HttpServletReques

17、t request, HttpServletResponse response)throws ServletException, IOException request.setCharacterEncoding(GB2312);String name = request.getParameter(name);String password = request.getParameter(password);JDBCConnection j = new JDBCConnection();try j.getConnection(); catch (SQLException e) / TODO Aut

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

19、TODO Auto-generated catch blocke.printStackTrace();request.setAttribute(success, 注冊成功！);request.getRequestDispatcher(register.jsp).forward(request, response);/向數(shù)據(jù)庫中添加數(shù)據(jù)類package gj;import java.sql.Connection;import java.sql.SQLException;import java.sql.Statement;public class getSQL private String nam

20、e;private String password;public getSQL(String name, String password) super(); = name;this.password = password;public void getValue() throws ClassNotFoundException, SQLException JDBCConnection kkk=new JDBCConnection(); Connection con=kkk. getConnection() ; Statement statement = con.createStatement()

21、; String sql =insert into user_list3 values(+name+,+password+); statement. executeUpdate(sql); statement.close(); con.close(); /用戶查詢界面Query.jspMy JSP success.jsp starting page數(shù)據(jù)查詢按用戶查詢：查詢內(nèi)容如下：編號名字email%for (int i = 0; i 共有條記錄，查詢結(jié)果如上表所示！/學(xué)生類Student.javapublic class student private String number;priva

22、te String name;private String email;public String getNumber() return number;public void setNumber(String number) this.number = number;public String getName() return name;public void setName(String name) = name;public String getEmail() return email;public void setEmail(String email) this.email = emai

23、l;public student(String number, String name, String email) super();this.number = number; = name;this.email = email;public void getValue() throws ClassNotFoundException, SQLException JDBCConnection kkk=new JDBCConnection(); kkk.setTableName(student); Connection con=kkk. getConnection() ; Statement st

24、atement = con.createStatement(); String sql =insert into student values(+number+,+name+,+email+); statement. executeUpdate(sql); statement.close(); con.close(); /學(xué)生信息查詢類Query.javapackage gj.user;import gj.JDBCConnection;import java.sql.Connection;import java.sql.ResultSet;import java.sql.SQLExceptio

25、n;import java.sql.Statement;public class query public query() public user Query(String sql) throws SQLException, ClassNotFoundException JDBCConnection kkk = new JDBCConnection();Connection con = kkk.getConnection();Statement statement = con.createStatement();ResultSet rs = statement.executeQuery(sql

26、);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 + 1;rs.close();statement.close();con.close();return user2;/學(xué)生信息查詢public student QueryStu(String sql) throws SQLException, ClassNotFoundException

27、JDBCConnection kkk = new JDBCConnection();kkk.setTableName(student);Connection con = kkk.getConnection();Statement statement = con.createStatement();ResultSet rs1 = statement.executeQuery(sql);rs1.last();student stu=new studentrs1.getRow();rs1.beforeFirst();int i=0;while(rs1.next()stui=new student(r

28、s1.getString(number),rs1.getString(name),rs1.getString(email);i+=1;rs1.close();statement.close();con.close();return stu;/數(shù)據(jù)添加類Insert.jspMy JSP insert.jsp starting page function validate2() var Number=document.formsform4.number.value; var Name=.value; var Email=document.formsf

29、orm4.email.value; if(Number.length=0) alert(學(xué)號不能為空！); else if(Name=0) alert(名字不能為空！); else if(Email=0) alert(email不能為空！) else document.formsform4.submit(); 學(xué)生信息添加學(xué)號姓名email /insert.java servlet do post()public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletExceptio

30、n, IOException request.setCharacterEncoding(GB2312);String number=request.getParameter(number);String name=request.getParameter(name);String email=request.getParameter(email);student st=new student(number,name,email);try st.getValue(); catch (ClassNotFoundException e) / TODO Auto-generated catch blo

31、cke.printStackTrace(); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();request.setAttribute(ok,添加成功！);request.getRequestDispatcher(insert.jsp).forward(request,response);/數(shù)據(jù)修改Update.jspMy JSP update.jsp starting page請選擇要修改的學(xué)生編號用戶名Email%for (int i = 0; i input type=radio na

32、me=check value=/顯示要修改的學(xué)生信息My JSP update1.jsp starting pagevar rdonly = false; function validate6() var Number=document.formsform5.number.value; var Name=.value; var Email=document.formsform5.email.value; if(Number.length=0) alert(學(xué)號不能為空！); else if(Name=0) alert(名字不能為空！); else

33、 if(Email=0) alert(email不能為空！) else document.formsform5.submit(); if(rdonly) document.getElementById(txtfield1).readOnly = false; rdonly = false; else document.getElementById(txtfield1).readOnly = true; rdonly = true; 學(xué)號:input type=text name=number id=txtfield1value=姓名:input type=text name=name valu

34、e=Email:input type=text name=email value=/update.java 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);Strin

35、g email=request.getParameter(email);Update up=new Update(number,name,email);try up.update(number); catch (ClassNotFoundException e) / TODO Auto-generated catch blocke.printStackTrace(); catch (SQLException e) / TODO Auto-generated catch blocke.printStackTrace();request.setAttribute(ok,修改成功！);request

36、.getRequestDispatcher(update.jsp).forward(request,response);/數(shù)據(jù)刪除Delete.jsp刪除學(xué)生請選擇要刪除的學(xué)生 編號 用戶名 Email % for(int i=0;i input type=checkbox name=check value= /刪除類Delete.jsp刪除學(xué)生請選擇要刪除的學(xué)生 編號 用戶名 Email % for(int i=0;i input type=checkbox name=check value= /學(xué)生修改類Update.jsppackage gj.user;import gj.JDBCConnection;import java.sql.Connection;import java.sql.SQLException;import java.sql.Statement;