基于java的作业管理系统

package com.zuoyeshangjiaoxitong.model; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; public class t_Servlet { private Connection conn; private PreparedStatement pstmt; public t_Servlet() { conn = new com.zuoyeshangjiaoxitong.connect.connect().getConnect(); } //由老师增加一项新的作业 public boolean addHomework(homeworkTable ht){ try{ pstmt=conn.prepareStatement("insert into hwtable" + "(homeworkname,homeworkpath,homeworkdesc) " + "values(?,?,?)"); pstmt.setString(1, ht.getHomeworkname()); pstmt.setString(2, ht.getHomeworkpath()); pstmt.setString(3, ht.getHomeworkdesc()); pstmt.executeUpdate(); return true; } catch(Exception e){ e.printStackTrace(); return false; } } //老师查看已经布置过的全部作业 public List queryHw() { List array = new ArrayList(); try { pstmt = conn.prepareStatement("select * from hwtable"); ResultSet rs = pstmt.executeQuery(); while (rs.next()) { homeworkTable hw = new homeworkTable(); hw.setHomeworkid(rs.getInt(1)); hw.setHomeworkname(rs.getString(2)); hw.setHomeworkpath(rs.getString(3)); hw.setHomeworkdesc(rs.getString(4)); array.add(hw); } return array; } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); return null; } } //老师查看某一次作业的上交情况 public List queryStuHw(int homeworkid) { List array0 = new ArrayList(); try { pstmt = conn.prepareStatement("select * from user_hwtable where homeworkid=?"); pstmt.setInt(1, homeworkid); ResultSet rs = pstmt.executeQuery(); while (rs.next()) { user_hwTable uhw = new user_hwTable(); uhw.setUserid(rs.getInt(1)); uhw.setHomeworkid(rs.getInt(2)); uhw.setHomeworkname(rs.getString(3)); uhw.setHomeworkpath(rs.getString(4)); uhw.setHomeworkgrade(rs.getInt(5)); uhw.setUsername(rs.getString(6)); uhw.setStuId(rs.getString(7)); uhw.setMyhwname(rs.getString(8)); uhw.setId(rs.getInt(9)); array0.add(uhw); } return array0; } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); return null; } } //老师通过学生的学号和作业的ID得到对应的记录，插入该学生本次作业的成绩 public boolean addGrade(int homeworkgrade,String stuId,int homeworkid){ if(homeworkgrade>0){ try{ pstmt=conn.prepareStatement("update user_hwtable set homeworkgrade=? where stuId=? and homeworkid=?"); pstmt.setInt(1, homeworkgrade); pstmt.setString(2, stuId); pstmt.setInt(3, homeworkid); pstmt.executeUpdate(); return true; } catch(Exception e){ e.printStackTrace(); return false; } } else return false; } //老师通过homeworkid删除一除作业记录 public boolean deleteHw(int homeworkid) { //此处后续可研究一下用级联或者触发器来进行删除 try { pstmt = conn.prepareStatement("delete from hwtable where homeworkid=?"); pstmt.setInt(1, homeworkid); pstmt.executeUpdate(); pstmt = conn.prepareStatement("delete from user_hwtable where homeworkid=?"); pstmt.setInt(1, homeworkid); pstmt.executeUpdate(); return true; } catch (Exception e) { e.getStackTrace(); return false; } } //老师查看学生信息表 public List t_queryuser() { List user = new ArrayList(); try { pstmt = conn.prepareStatement("select * from usertable"); ResultSet rs = pstmt.executeQuery(); while (rs.next()) { userTable ut = new userTable(); ut.setUser_id(rs.getInt(1)); ut.setUser_name(rs.getString(2)); ut.setUser_password(rs.getString(3)); ut.setUser_type_id(rs.getInt(4)); ut.setUtypename(rs.getString(5)); ut.setUser_email(rs.getString(6)); ut.setStuId(rs.getString(7)); user.add(ut); } return user; } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); return null; } } //通过ID号来查找学生信息 public userTable t_queryById(int user_id){ try{ pstmt = conn.prepareStatement("select * from usertable where userid=?"); pstmt.setInt(1, user_id); ResultSet rs = pstmt.executeQuery(); if(rs.next()){ userTable ut = new userTable(); ut.setUser_id(rs.getInt(1)); ut.setUser_name(rs.getString(2)); ut.setUser_password(rs.getString(3)); ut.setUser_type_id(rs.getInt(4)); ut.setUtypename(rs.getString(5)); ut.setUser_email(rs.getString(6)); ut.setStuId(rs.getString(7)); return ut; } return null; } catch(SQLException e){ e.printStackTrace(); return null; } } //通过学号来查找学生信息 public userTable t_queryBystuId(String stuId){ try{ pstmt = conn.prepareStatement("select * from usertable where stuId=?"); pstmt.setString(1, stuId); ResultSet rs = pstmt.executeQuery(); if(rs.next()){ userTable ut = new userTable(); ut.setUser_id(rs.getInt(1)); ut.setUser_name(rs.getString(2)); ut.setUser_password(rs.getString(3)); ut.setUser_type_id(rs.getInt(4)); ut.setUtypename(rs.getString(5)); ut.setUser_email(rs.getString(6)); ut.setStuId(rs.getString(7)); return ut; } return null; } catch(SQLException e){ e.printStackTrace(); return null; } } //修改用户信息 public boolean updateUser(userTable user){ try{ pstmt = conn.prepareStatement("update usertable set username=? ,password=? ,utypeid=? ,utypename=? ,email=? ,stuId=? where userid=?"); //pstmt=conn.prepareStatement("update usertable set username=? where userid=?"); pstmt.setString(1,user.getUser_name()); pstmt.setString(2, user.getUser_password()); pstmt.setInt(3, user.getUser_type_id()); pstmt.setString(4, user.getUtypename()); pstmt.setString(5, user.getUser_email()); pstmt.setString(6, user.getStuId()); pstmt.setInt(7, user.getUser_id()); //pstmt.setString(1, username); //pstmt.setInt(2, userid); pstmt.executeUpdate(); return true; } catch(SQLException e){ e.printStackTrace(); return false; } } //老师增加新用户 public boolean addUser(userTable user){ try{ pstmt=conn.prepareStatement("insert usertable" +"(username,password,utypeid,utypename,email,stuId) " + "values(?,?,?,?,?,?)"); pstmt.setString(1, user.getUser_name()); pstmt.setString(2, user.getUser_password()); pstmt.setInt(3, user.getUser_type_id()); pstmt.setString(4, user.getUtypename()); pstmt.setString(5, user.getUser_email()); pstmt.setString(6, user.getStuId()); pstmt.executeUpdate(); return true; } catch(SQLException e){ e.printStackTrace(); return false; } } //老师指增加学生 public boolean addStus(String stuId,String username){ try{ pstmt=conn.prepareStatement("insert usertable" +"(username,password,utypeid,utypename,stuId) " +"values(?,?,?,?,?)"); pstmt.setString(1, username); pstmt.setString(2, "123456"); pstmt.setInt(3, 1); pstmt.setString(4, "学生"); pstmt.setString(5, stuId); pstmt.executeUpdate(); return true; } catch(Exception e){ e.printStackTrace(); return false; } } //老师通过userid删除一除作业记录 public boolean deleteUser(int userid) { //此处后续可研究一下用级联或者触发器来进行删除 try { pstmt = conn.prepareStatement("delete from usertable where userid=?"); pstmt.setInt(1, userid); pstmt.executeUpdate(); pstmt = conn.prepareStatement("delete from user_hwtable where userid=?"); pstmt.setInt(1, userid); pstmt.executeUpdate(); return true; } catch (SQLException e) { e.getStackTrace(); return false; } } //老师查看user_hwtable表