jsp+servlet学生信息管理系统

package com.xc.dao.impl; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.List; import com.xc.dao.StudentDao; import com.xc.model.Student; import com.xc.util.DbConn; public class StudentDaoImpl implements StudentDao { private Connection conn = DbConn.getConn(); public boolean addStudent(Student stu) { boolean flag = false; String sql = "insert into Student(stId,stName,stSex,stAge,stTel,stDept,stCourse,stStarttime) values(?,?,?,?,?,?,?,?)"; try { PreparedStatement psmt = conn.prepareStatement(sql); psmt.setString(1, stu.getStId()); psmt.setString(2, stu.getStName()); psmt.setString(3, stu.getStSex()); psmt.setString(4, stu.getStAge()); psmt.setLong(5, stu.getStTel()); psmt.setString(6, stu.getStDept()); psmt.setString(7, stu.getstCourse()); psmt.setString(8, stu.getStStarttime()); if (psmt.executeUpdate() == 1) { flag = true; } } catch (SQLException e) { e.printStackTrace(); } return flag; } public boolean delStudent(String id) { boolean flag = false; String sql = "delete from Student where stId=?"; try { PreparedStatement psmt = conn.prepareStatement(sql); psmt.setString(1, id); if (psmt.executeUpdate() > 0) { flag = true; } } catch (SQLException e) { e.printStackTrace(); } return flag; } public boolean updateStudent(Student stu) { boolean flag = false; String sql = "update Student set stName=?,stSex=?,stAge=?,stTel=?,stDept=?,stCourse=?,stStarttime=? where stId=? "; try { PreparedStatement psmt = conn.prepareStatement(sql); psmt.setString(1, stu.getStName()); psmt.setString(2, stu.getStSex()); psmt.setString(3, stu.getStAge()); psmt.setLong(4, stu.getStTel()); psmt.setString(5, stu.getStDept()); psmt.setString(6, stu.getstCourse()); psmt.setString(7, stu.getStStarttime()); psmt.setString(8, stu.getStId()); if (psmt.executeUpdate() == 1) { flag = true; } } catch (SQLException e) { e.printStackTrace(); } return flag; } public List StSelect() { List list = new ArrayList(); String sql = "select * from Student"; try { Statement smt = conn.createStatement(); ResultSet rs = smt.executeQuery(sql); while (rs.next()) { String stId = rs.getString("stId"); String stName = rs.getString("stName"); String stSex = rs.getString("stSex"); String stAge = rs.getString("stAge"); Long stTel = rs.getLong("stTel"); String stDept = rs.getString("stDept"); String stCourse = rs.getString("stCourse"); String stStarttime = rs.getString("stStarttime"); Student stu = new Student(stId, stName, stSex, stAge, stTel, stDept, stCourse, stStarttime); list.add(stu); } } catch (SQLException e) { e.printStackTrace(); } return list; } public Student findStudentById(String id) { Student student = null; String sql = "select * from Student where stId=?"; PreparedStatement pstmt; try { pstmt = conn.prepareStatement(sql); pstmt.setString(1, id); ResultSet rs = pstmt.executeQuery(); while (rs.next()) { student = new Student(); student.setStId(rs.getString("stId")); student.setStName(rs.getString("stName")); student.setStSex(rs.getString("stSex")); student.setStAge(rs.getString("stAge")); student.setStDept(rs.getString("stDept")); student.setstCourse(rs.getString("stCourse")); student.setStTel(Long.parseLong(rs.getString("stTel"))); student.setStStarttime(rs.getString("stStarttime")); } } catch (SQLException e) { e.printStackTrace(); } return student; } }