计算机毕业设计：Java实现的学校官网教务图书馆管理系统(源码+说明)，保证可靠运行，附赠计算机答辩PPT模板

package cn.com.dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import cn.com.entity.Score; import cn.com.entity.Student; import cn.com.utils.DBUtils; public class StuDao { Connection conn; PreparedStatement pst; ResultSet rs; public Student stulogin(Student stu) { // TODO Auto-generated method stub try { conn = DBUtils.getConn(); String sql = "select * from student where sid = ? and sname = ? and spwd = ?"; pst = conn.prepareStatement(sql); pst.setString(1, stu.getSid()); pst.setString(2, stu.getSname()); pst.setString(3, stu.getSpwd()); rs = pst.executeQuery(); while(rs.next()){ Student st = new Student(); st.setSid(rs.getString("sid")); st.setSname(rs.getString("sname")); st.setSeid(rs.getString("seid")); st.setSpwd(rs.getString("spwd")); st.setSsex(rs.getInt("ssex")); st.setSof(rs.getString("sof")); st.setScountenance(rs.getString("sid")); st.setSchooling(rs.getString("schooling")); st.setStatus(rs.getInt("status")); st.setSxuezhi(rs.getString("sxuezhi")); st.setPhone(rs.getString("phone")); st.setMid(rs.getInt("mid")); st.setCid(rs.getInt("cid")); return st; } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ DBUtils.closeResouce(conn, pst, rs); } return null; } public List<Student> stuByshow(String sid) { // TODO Auto-generated method stub try { conn = DBUtils.getConn(); String sql = "select * from student s,major m,class c where s.mid = m.mid and s.cid = c.cid and s.sid = ?"; pst = conn.prepareStatement(sql); pst.setString(1, sid); rs = pst.executeQuery(); List<Student> bylist = new ArrayList(); while(rs.next()){ Student st = new Student(); st.setSid(rs.getString("sid")); st.setSname(rs.getString("sname")); st.setSeid(rs.getString("seid")); st.setSpwd(rs.getString("spwd")); st.setSsex(rs.getInt("ssex")); st.setSof(rs.getString("sof")); st.setScountenance(rs.getString("scountenance")); st.setSchooling(rs.getString("schooling")); st.setStatus(rs.getInt("status")); st.setSxuezhi(rs.getString("sxuezhi")); st.setPhone(rs.getString("phone")); st.setSphone(rs.getString("sphone")); st.setSqq(rs.getString("sqq")); st.setSmail(rs.getString("smail")); st.setMid(rs.getInt("mid")); st.setCid(rs.getInt("cid")); st.setMname(rs.getString("mname")); st.setCname(rs.getString("cname")); bylist.add(st); System.out.println(bylist+"???"); } return bylist; } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ DBUtils.closeResouce(conn, pst, rs); } return null; } public Student stu2(String sid) { // TODO Auto-generated method stub try { conn = DBUtils.getConn(); String sql = "select * from student where sid = ?"; pst = conn.prepareStatement(sql); pst.setString(1, sid); rs = pst.executeQuery(); while(rs.next()){ Student st = new Student(); st.setSid(rs.getString("sid")); st.setSname(rs.getString("sname")); st.setSeid(rs.getString("seid")); st.setSpwd(rs.getString("spwd")); st.setSsex(rs.getInt("ssex")); st.setSof(rs.getString("sof")); st.setScountenance(rs.getString("sid")); st.setSchooling(rs.getString("schooling")); st.setStatus(rs.getInt("status")); st.setSxuezhi(rs.getString("sxuezhi")); st.setPhone(rs.getString("phone")); st.setMid(rs.getInt("mid")); st.setCid(rs.getInt("cid")); st.setSmail(rs.getString("smail")); return st; } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ DBUtils.closeResouce(conn, pst, rs); } return null; } public List<Student> spwd(String sid) { // TODO Auto-generated method stub try { conn = DBUtils.getConn(); String sql = "select spwd from student where sid = ?"; pst = conn.prepareStatement(sql); pst.setString(1, sid); List<Student> slist = new ArrayList<>(); rs = pst.executeQuery(); while(rs.next()){ Student st = new Student(); st.setSpwd(rs.getString("spwd")); slist.add(st); System.out.println(slist+"!@@@"); } return slist; } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ DBUtils.closeResouce(conn, pst, rs); } return null; } public List<Score> stuScoreByshow(String sid) { // TODO Auto-generated method stub try { conn = DBUtils.getConn(); String sql = "select * from student st,score s,teacher t where st.sid = s.sid and s.tid = t.tid and st.sid = ?"; pst = conn.prepareStatement(sql); pst.setString(1, sid); rs = pst.executeQuery(); List<Score> bylist = new ArrayList(); while(rs.next()){ Score sc = new Score(); sc.setScid(rs.getInt("scid")); sc.setSyear(rs.getString("syear")); sc.setStem(rs.getString("stem")); sc.setScname(rs.getString("scname")); sc.setStype(rs.getInt("stype")); sc.setSkhfs(rs.getInt("skhfs")); sc.setScore(rs.getInt("score")); sc.setSxf(rs.getInt("sxf")); sc.setSid(rs.getString("sid")); sc.setTid(rs.getString("tid")); sc.setTname(rs.getString("tname")); bylist.add(sc); System.out.println(bylist+"???"); } return bylist; } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ DBUtils.closeResouce(conn, pst, rs); } return null; } public void updateInfo(Student stu) { // TODO Auto-generated method stub try { conn = DBUtils.getConn(); String sql = "update student set phone = ?,sphone = ?,sqq = ?,smail = ? where sid = ?"; pst = conn.prepareStatement(sql); pst.setString(1, stu.getPhone()); pst.setString(2, stu.getSphone()); pst.setString(3, stu.getSqq()); pst.setString(4, stu.getSmail()); pst.setString(5, stu.getSid()); pst.executeUpdate(); System.out.println("!!!!!!!!!!"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ DBUtils.closeResouce(conn, pst); } } public void updateSpwd(Student stu) { // TODO Auto-generated method stub try { conn = DBUtils.getConn(); String sql = "update student set spwd = ? where sid = ?"; pst = conn.prepareStatement(sql); pst.setString(1, stu.getSpwd()); pst.setString(2, stu.getSid()); pst.executeUpdate(); System.out.println("!!!!!!!!!!"); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ DBUtils.closeResouce(conn, pst); } } public void checkDel(Student student) { // TODO Auto-generated method stub try { conn = DBUtils.getConn(); String sql = "delete from student where sid = ?"; pst = conn.prepareStatement(sql); pst.setString(1, student.getSid()); pst.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ DBUtils.closeResouce(conn, pst); } } public List<Student> studentByid(Student student) { // TODO Auto-generated method stub List<Student> list = new ArrayList<Student>(); try { conn = DBUtils.getConn(); String sql = "select * from student where sid = ?"; pst = conn.prepareStatement(sql); pst.setString(1, student.getSid()); rs = pst.executeQuery(); while(rs.next()){ Student st = new Student(); st.setSid(rs.getString("sid")); st.setSname(rs.getString("sname")); st.setSeid(rs.getString("seid")); st.set