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
计算机毕业设计：Java实现的学校官网教务图书馆管理系统(源码+说明)，保证可靠运行，附赠计算机答辩PPT模板
版权申诉
4 浏览量
2024-03-08
18:22:59
上传
评论 1
收藏 352.2MB ZIP 举报
计算机毕业设计：Java实现的学校官网教务图书馆管理系统(源码+说明)，保证可靠运行，附赠计算机答辩PPT模板 （1562个子文件） 
StuDao.class 10KB TeaDao.class 9KB AdminDao.class 7KB BookDao.class 7KB Student.class 6KB LoginServlet.class 4KB ItemDao.class 4KB ClassDao.class 3KB ShowMemDao.class 3KB LenbookDao.class 3KB Score.class 3KB Books.class 3KB ShowItemDao.class 3KB ForgetPwd.class 3KB Lenbook.class 3KB AddBook.class 3KB AddItemServlet.class 3KB Studentupdate.class 3KB AddStu.class 2KB AddMemberServlet.class 2KB forgetpwd.class 2KB AddLenb.class 2KB ShowMemberServlet.class 2KB Class.class 2KB SelectByIdMemDao.class 2KB StudentUpdateA.class 2KB AddAdminServlet.class 2KB UpdateMemServlet.class 2KB Admin.class 2KB AddPJ.class 2KB DeleteItemServlet.class 2KB StuLogin.class 2KB TeaLogin.class 2KB ShowQuestion.class 2KB yanzheng.class 2KB ShowStuAll.class 2KB ShowItemServlet.class 2KB ShowBook.class 2KB Question.class 2KB ShowAdmin.class 2KB ClassByShwo.class 2KB UpdateMemDao.class 2KB StuByShwo.class 2KB ShowStumohu.class 2KB UpdateBookServlet.class 2KB UpdateAdminServlet.class 2KB UpdateSpwd.class 2KB DBUtils.class 2KB DButils.class 2KB StuScoreByShwo.class 2KB UpdateItemServlet.class 2KB ShowClass.class 2KB Member.class 2KB DeleteAdmin.class 2KB UpdateSinfo.class 2KB MailUtil.class 2KB SelectByIdItem.class 2KB AdminService.class 2KB StuService.class 2KB SelectByIdBook.class 2KB note.class 2KB ShowBookByi.class 2KB SelectByIdMem.class 2KB QuDao.class 2KB BookNote.class 2KB SelectByIdAdmin.class 2KB CheckDel.class 2KB Teacher.class 2KB MemDao.class 2KB DeleteMemServlet.class 2KB DeleteBook.class 2KB Page.class 1KB BookServices.class 1KB Page.class 1KB DeleteMemDao.class 1KB ShowLenb.class 1KB LoginoutServlet.class 1KB Item.class 1KB TeaService.class 1KB EncodingFilter.class 1KB Major.class 1KB ItemService.class 1KB ClassService.class 979B ShowMemService.class 926B LenbookService.class 877B Stuyzm.class 839B SelectByIdMemService.class 804B ShowItemService.class 696B MailUtil$1.class 680B DeleteMemService.class 578B UpdateMemService.class 567B MemberService.class 566B QuService.class 554B .classpath 841B org.eclipse.wst.common.component 488B org.eclipse.wst.jsdt.ui.superType.container 49B bootstrap.css 129KB dandelion.css 62KB easyui.css 59KB easyui.css 58KB共 1562 条
- 1
- 2
- 3
- 4
- 5
- 6
- 16
资源评论
