学生考勤信息管理系统

package dao; import java.sql.*; import java.util.ArrayList; import java.util.List; import bean.Student; public class studentDao{ public int addStudent(String studentId,String studentName,String classname,String sex) throws Exception{ Connection con =null; PreparedStatement ps = null; ResultSet rs = null; String dbURL="jdbc:sqlserver://localhost:1433;DatabaseName=School"; String userName="sa"; String userPwd="123"; int count = 0; try { Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); con = DriverManager.getConnection(dbURL,userName,userPwd); String sql = "insert into T_student values(?,?,?,?)"; ps = con.prepareStatement(sql); ps.setString(1, studentId); ps.setString(2,studentName); ps.setString(3,sex); ps.setString(4,classname); count = ps.executeUpdate(); } catch (Exception e) { e.printStackTrace(); } finally { try {// 关闭连接 if (rs != null) rs.close(); if (ps != null) ps.close(); if (con != null) con.close(); } catch (Exception e) { } } return count; } public int delStudent(String studentId) throws Exception{ Connection con =null; PreparedStatement ps = null; ResultSet rs = null; String dbURL="jdbc:sqlserver://localhost:1433;DatabaseName=School"; String userName="sa"; String userPwd="123"; int count = 0; try { Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); con = DriverManager.getConnection(dbURL,userName,userPwd); String sql = "DELETE FROM T_student WHERE studentId = ? "; ps = con.prepareStatement(sql); ps.setString(1,studentId); count = ps.executeUpdate(); } catch (Exception e) {} finally { try {// 关闭连接 if (rs != null) rs.close(); if (ps != null) ps.close(); if (con != null) con.close(); } catch (Exception e) { } } return count; } public int altStudent(String studentId,String xg,String x) throws Exception{ Connection con =null; PreparedStatement ps = null; ResultSet rs = null; String dbURL="jdbc:sqlserver://localhost:1433;DatabaseName=School"; String userName="sa"; String userPwd="123"; int count = 0; try { Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); con = DriverManager.getConnection(dbURL,userName,userPwd); String sql = "update T_student set ? = ? where studentId = ?"; ps = con.prepareStatement(sql); ps.setString(1,xg); ps.setString(2,x); ps.setString(3,studentId); count = ps.executeUpdate(); } catch (Exception e) {} finally { try {// 关闭连接 if (rs != null) rs.close(); if (ps != null) ps.close(); if (con != null) con.close(); } catch (Exception e) { } } return count; } public List queStudent(String studentId) throws Exception{ Connection con =null; PreparedStatement ps = null; ResultSet rs = null; String dbURL="jdbc:sqlserver://localhost:1433;DatabaseName=School"; String userName="sa"; String userPwd="123"; List list = new ArrayList(); try { Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); con = DriverManager.getConnection(dbURL,userName,userPwd); String sql = "SELECT * FROM T_student WHERE studentId = ? "; ps = con.prepareStatement(sql); ps.setString(1,studentId); rs = ps.executeQuery(); if(rs.next()){ Student student = new Student(); student.setClassname(rs.getString("classname")); student.setStudentId(rs.getString("studentId")); student.setSex(rs.getString("sex")); student.setStudentName(rs.getString("studentName")); list.add(student); } } catch (Exception e) {} finally { try {// 关闭连接 if (rs != null) rs.close(); if (ps != null) ps.close(); if (con != null) con.close(); } catch (Exception e) { } } return list; } public int passwordyz(String studentId) throws Exception{ Connection con =null; PreparedStatement ps = null; ResultSet rs = null; String dbURL="jdbc:sqlserver://localhost:1433;DatabaseName=School"; String userName="sa"; String userPwd="123"; int count = 0; try { Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); con = DriverManager.getConnection(dbURL,userName,userPwd); String sql = "SELECT * FROM T_student WHERE studentId = ?"; ps = con.prepareStatement(sql); ps.setString(1,studentId); rs = ps.executeQuery(); while(rs.next()){ count++; } } catch (Exception e) {} finally { try {// 关闭连接 if (rs != null) rs.close(); if (ps != null) ps.close(); if (con != null) con.close(); } catch (Exception e) { } } return count; } public List allStudent() throws Exception{ Connection con =null; PreparedStatement ps = null; ResultSet rs = null; String dbURL="jdbc:sqlserver://localhost:1433;DatabaseName=School"; String userName="sa"; String userPwd="123"; List list = new ArrayList(); try { Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); con = DriverManager.getConnection(dbURL,userName,userPwd); String sql = "SELECT * FROM T_student"; ps = con.prepareStatement(sql); rs = ps.executeQuery(); while(rs.next()){ Student student = new Student(); student.setClassname(rs.getString("classname")); student.setStudentId(rs.getString("studentId")); student.setSex(rs.getString("sex")); student.setStudentName(rs.getString("studentName")); list.add(student); } } catch (Exception e) {} finally { try {// 关闭连接 if (rs != null) rs.close(); if (ps != null) ps.close(); if (con != null) con.close(); } catch (Exception e) { } } return list; } public List teaStudent(String courseId) throws Exception{ Connection con =null; PreparedStatement ps = null; ResultSet rs = null; String dbURL="jdbc:sqlserver://localhost:1433;DatabaseName=School"; String userName="sa"; String userPwd="123"; List list = new ArrayList(); try { Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); con = DriverManager.getConnection(dbURL,userName,userPwd); String sql = "SELECT * FROM T_student,T_xuanke where T_student.studentId=T_xuanke.studentId and T_xuanke.courseId= ?"; ps = con.prepareStatement(sql); ps.setString(1,courseId); rs = ps.executeQuery(); while(rs.next()){ Student student = new Student(); student.setClassname(rs.getString("classname")); student.setStudentId(rs.getString("studentId")); student.setSex(rs.getString("sex")); student.setStudentName(rs.getString("studentName")); list.add(student); } } catch (Exception e) {} finally { try {// 关闭连接 if (rs != null) rs.close(); if (ps != null) ps.close(); if (con != null) con.close(); } catch (Exception e) { } } return list; } }