学生信息管理系统网站(JSP+JavaBean+Servlet)

package DAO; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import javax.naming.InitialContext; import javax.naming.NamingException; import javax.sql.DataSource; import Bean.CollegeManagerBean; import Bean.HeadTeacherBean; import Bean.StudentBean; import Bean.TeacherBean; public class CollegeManagerDAO { private static InitialContext context = null; private DataSource dataSource = null; private static final String WHETHER_STUDENT_DELETE_SQL= "SELECT * FROM student_table WHERE id=? and college=?"; private static final String DELETE_STUDENT_SQL = "DELETE FROM student_table WHERE id=?"; private static final String ADD_STUDENT_SQL = "insert into student_table values(?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; private static final String UPDATE_STUDENT_SQL="update student_table set name=?,gender=?,classes=?,professional=?,entrance_year=?,degree=?,phone=?,email=?,address=?,postcode=?,username=?,password=? where id=?"; private static final String SELECT_STUDENT_SQL = "SELECT * FROM student_table WHERE id=? and college=?"; private static final String WHETHER_TEACHER_DELETE_SQL = "SELECT * FROM teacher_table WHERE id=? and college=?"; private static final String DELETE_TEACHER_SQL = "DELETE FROM teacher_table WHERE id=?"; private static final String ADD_TEACHER_SQL = "insert into teacher_table values(?,?,?,?,?,?)"; private static final String UPDATE_TEACHER_SQL="update teacher_table set classes=?,professional=?,username=?,password=? where id=?"; private static final String SELECT_COLLEGEMANAGER_SQL = "SELECT * FROM collegemanager_table WHERE username=? and password=?"; private static final String WHETHER_HEADTEACHER_DELETE_SQL = "SELECT * FROM headteacher_table WHERE id=? and college=?"; private static final String DELETE_HEADTEACHER_SQL = "DELETE FROM headteacher_table WHERE id=?"; private static final String ADD_HEADTEACHER_SQL = "insert into headteacher_table values(?,?,?,?,?,?)"; private static final String UPDATE_HEADTEACHER_SQL="update headteacher_table set classes=?,professional=?,username=?,password=? where id=?"; private static final String SELECT_BY_COLLEGE_SQL = "SELECT * FROM student_table WHERE college=?"; public CollegeManagerDAO() { try { if (context == null) { context = new InitialContext(); } dataSource = (DataSource) context .lookup("java:comp/env/jdbc/sampleDS"); } catch (NamingException e2) { } } public Connection getConnection() { Connection conn = null; try { conn = dataSource.getConnection(); } catch (SQLException e) { } return conn; } public boolean whetherstudentcanbedelete(String id,String college){ boolean b=false; Connection conn = null; PreparedStatement pstmt = null; ResultSet rst = null; try { conn = dataSource.getConnection(); pstmt = conn.prepareStatement(WHETHER_STUDENT_DELETE_SQL); pstmt.setString(1, id); pstmt.setString(2, college); rst = pstmt.executeQuery(); if (rst.next()) b=true; rst.close(); pstmt.close(); return b; } catch (Exception se) { return b; } } public void deleteStudent(String id) { Connection conn = null; PreparedStatement pstmt = null; try { conn = dataSource.getConnection(); pstmt = conn.prepareStatement(DELETE_STUDENT_SQL); pstmt.setString(1, id); pstmt.executeUpdate(); pstmt.close(); } catch (Exception se) { } return; } public void addStudent(String id,String name,String gender,String classes,String professional,String college,String entrance_year,String degree,String phone,String email,String address,String postcode,String username,String password) { Connection conn = null; PreparedStatement pstmt = null; try { conn = dataSource.getConnection(); pstmt = conn.prepareStatement(ADD_STUDENT_SQL); pstmt.setString(1,id); pstmt.setString(2,name); pstmt.setString(3,gender); pstmt.setString(4,classes); pstmt.setString(5, professional); pstmt.setString(6,college); pstmt.setString(7, entrance_year); pstmt.setString(8, degree); pstmt.setString(9, phone); pstmt.setString(10, email); pstmt.setString(11,address); pstmt.setString(12,postcode); pstmt.setString(13, username); pstmt.setString(14, password); pstmt.executeUpdate(); pstmt.close(); } catch (Exception se) { } return ; } public void updateStudent(String name,String gender,String classes,String professional,String entrance_year,String degree,String phone,String email,String address,String postcode,String username,String password,String id) { Connection conn = null; PreparedStatement pstmt = null; try { conn = dataSource.getConnection(); pstmt = conn.prepareStatement(UPDATE_STUDENT_SQL); pstmt.setString(1,name); pstmt.setString(2,gender); pstmt.setString(3,classes); pstmt.setString(4,professional); pstmt.setString(5,entrance_year); pstmt.setString(6,degree); pstmt.setString(7,phone); pstmt.setString(8,email); pstmt.setString(9,address); pstmt.setString(10,postcode); pstmt.setString(11, username); pstmt.setString(12, password); pstmt.setString(13,id); pstmt.executeUpdate(); pstmt.close(); return; } catch (Exception se) { } return ; } public StudentBean collegemanagersearchStudent(String id,String college) { Connection conn = null; PreparedStatement pstmt = null; ResultSet rst = null; StudentBean student = new StudentBean(); try { conn = dataSource.getConnection(); pstmt = conn.prepareStatement(SELECT_STUDENT_SQL); pstmt.setString(1, id); pstmt.setString(2,college); rst = pstmt.executeQuery(); if (rst.next()) { student.setId(rst.getString("id")); student.setName(rst.getString("name")); student.setGender(rst.getString("gender")); student.setClasses(rst.getString("classes")); student.setProfessional(rst.getString("professional")); student.setCollege(rst.getString("college")); student.setEntrance_year(rst.getString("entrance_year")); student.setDegree(rst.getString("degree")); student.setPhone(rst.getString("phone")); student.setEmail(rst.getString("email")); student.setAddress(rst.getString("id")); student.setPostcode(rst.getString("postcode")); student.setUsername(rst.getString("username")); student.setPassword(rst.getString("password")); } rst.close(); pstmt.close(); } catch (Exception se) { return null; } return student; } public boolean whetherteachercanbedelete(String id,String college){ boolean b=false; Connection conn = null; PreparedStatement pstmt = null; ResultSet rst = null; try { conn = dataSource.getConnection(); pstmt = conn.prepareStatement(WHETHER_TEACHER_DELETE_SQL); pstmt.setString(1, id); pstmt.setString(2, college); rst = pstmt.executeQuery(); if (rst.next()) b=true; rst.close(); pstmt.close(); return b; } catch (Exception se) { return b; } } public void deleteTeacher(String id) { Connection conn = null; PreparedStatement pstmt = null; try { conn = dataSource.getConnection(); pstmt = conn.prepareStatement(DELETE_TEACHER_SQL); pstmt.setString(1, id); pstmt.executeUpdate(); pstmt.close(); } catch (Exception se) { } return; } public void addTeacher(String id,String classes,String professional,String college,String username,String password) { Connection conn = null; PreparedStatement pstmt = null; try { conn = dataSource.getConnection(); pstmt = conn.prepareStatement(ADD_TEACHER_SQL); pstmt.setString(1