学生管理系统(JSP版)(共29页).doc

《学生管理系统(JSP版)(共29页).doc》由会员分享，可在线阅读，更多相关《学生管理系统(JSP版)(共29页).doc（29页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、精选优质文档-倾情为你奉上学生管理系统(JSP版)登录界面：登录 学生管理系统 用户名： 密  码：     用户验证： Judge.jsp 跳转界面1： 学生信息 所有学生信息表 后台代码：package myBean;import java.sql.*;public class Students StringBuffer queryResult;public Students() queryResult = new StringBuffer();try Class.forName(com.microsoft.jdbc.sqlser

2、ver.SQLServerDriver);catch (Exception e) public String handleString(String s) String str = s;try byte bb = str.getBytes(GB2312);str = new String(bb);return str;catch (Exception e) return str;public StringBuffer getQueryResult() Connection conn;Statement stmt;ResultSet rs;String uri = jdbc:microsoft:

3、sqlserver:/localhost:1433;DatabaseName=stuMan;String user = sa;String password = sa;try queryResult.append();conn = DriverManager.getConnection(uri, user, password);stmt = conn.createStatement();rs = stmt.executeQuery(select * from student);queryResult.append();queryResult.append(学号);queryResult.app

4、end(姓名);queryResult.append(性别);queryResult.append(班级);queryResult.append(地址);queryResult.append(出生日期);queryResult.append(联系方式);queryResult.append(电子邮件);queryResult.append(操作列);queryResult.append();while(rs.next() queryResult.append();for(int k=1;k=8;k+)queryResult.append( + handleString(rs.getString

5、(k) + );queryResult.append(修改|删除);queryResult.append();queryResult.append();queryResult.append();queryResult.append();queryResult.append(增加);queryResult.append( );queryResult.append( );queryResult.append( );queryResult.append( );queryResult.append(返回登录界面);queryResult.append();con

6、n.close();catch (SQLException e) e.printStackTrace();return queryResult;跳转界面2： 学生信息 学生个人信息表 % String number = (String)session.getAttribute(StrName); String condition = select * from student where sno = +number +; Class.forName(com.microsoft.jdbc.sqlserver.SQLServerDriver); Connection conn ;Statement

7、 stmt;ResultSet rs;String uri = jdbc:microsoft:sqlserver:/localhost:1433;DatabaseName=stuMan;String user = sa;String password = sa;try out.print();conn = DriverManager.getConnection(uri, user, password);stmt = conn.createStatement();rs = stmt.executeQuery(condition);out.print();out.print(学号);out.pri

8、nt(姓名);out.print(性别);out.print(班级);out.print(地址);out.print(出生日期);out.print(联系方式);out.print(电子邮件);out.print(操作列);out.print();while(rs.next() out.print();for(int k=1;k=8;k+)out.print( + getString(rs.getString(k) + );out.print(修改);out.print();out.print();out.print();out.print(返回登录界面);conn.close();catch

9、 (SQLException e) e.printStackTrace(); % 添加界面： 添加学生信息界面 添加学生信息界面 学号 姓名 性别 男 女 班级 地址 出生日期 联系方式 电子邮件    返回 后台代码：package myBean;import java.sql.*;public class AddBean String strsno = ;String sname = ;String sex = ;String className = ;String address = ;String birthday = ;String phone = ;String

10、 email = ;String addMessage = ;public AddBean() try Class.forName(com.microsoft.jdbc.sqlserver.SQLServerDriver);catch (Exception e) public String getString(String str) String s = str;try byte bb = s.getBytes(GB2312);s = new String(bb);catch (Exception e) return s;public String getStrsno() return str

11、sno;public void setStrsno(String strsno) try strsno = new String(strsno.getBytes(ISO-8859-1),Gb2312);catch (Exception e) e.printStackTrace();this.strsno = strsno.trim();public String getSname() return sname;public void setSname(String sname) try sname = new String(sname.getBytes(ISO-8859-1),Gb2312);

12、catch (Exception e) e.printStackTrace();this.sname = sname.trim();public String getSex() return sex;public void setSex(String sex) try sex = new String(sex.getBytes(ISO-8859-1),Gb2312);catch (Exception e) e.printStackTrace();this.sex = sex.trim();public String getClassName() return className;public

13、void setClassName(String className) try className = new String(className.getBytes(ISO-8859-1),Gb2312);catch (Exception e) e.printStackTrace();this.className = className.trim();public String getAddress() return address;public void setAddress(String address) try address = new String(address.getBytes(I

14、SO-8859-1),Gb2312);catch (Exception e) e.printStackTrace();this.address = address.trim();public String getBirthday() return birthday;public void setBirthday(String birthday) try birthday = new String(birthday.getBytes(ISO-8859-1),Gb2312);catch (Exception e) e.printStackTrace();this.birthday = birthd

15、ay.trim();public String getPhone() return phone;public void setPhone(String phone) try phone = new String(phone.getBytes(ISO-8859-1),Gb2312);catch (Exception e) e.printStackTrace();this.phone = phone.trim();public String getEmail() return email;public void setEmail(String email) try email = new Stri

16、ng(email.getBytes(ISO-8859-1),Gb2312);catch (Exception e) e.printStackTrace();this.email = email.trim();public String getAddMessage() if(strsno.equals()addMessage = 没有插入记录;elseString condition = insert student values(?,?,?,?,?,?,?,?);/String condition = insert student values(+strsno+,+sname+,+sex+,+

17、className+,+address+,+birthday+,+phone+,+email+);String uri = jdbc:microsoft:sqlserver:/localhost:1433;DatabaseName=stuMan;String user = sa;String password = sa;Connection conn;PreparedStatement stmt;try conn = DriverManager.getConnection(uri, user, password);stmt = conn.prepareStatement(condition);

18、stmt.setString(1, strsno);stmt.setString(2, sname);stmt.setString(3, sex);stmt.setString(4, className);stmt.setString(5, address);stmt.setString(6, birthday);stmt.setString(7, phone);stmt.setString(8, email);int m = stmt.executeUpdate();if(m!=0)addMessage = 对表中添加 + m + 记录;elseaddMessage = 添加记录失败！;stmt.close();conn.close();