stuinfo.java~49~

基于WEB的作业提交系统,是用JSP,JBUILDER,TOMCAT,MYSQL联合开发的JSP系统

package work.info;
import java.io.*;
import java.sql.*;
import java.util.*;

import work.tools.*;



public class StuInfo implements Serializable {
    private int stuNo;
    private String stuName;
    private String stuPassword;
    private String classes;
    private String status="操作成功！";
    private int doWorkTimes;
    private int haveToDoTimes;
    private ConnectBean cb=new ConnectBean();
    private int subScore;
    private PreparedStatement ps;
    private String stuno;
    public StuInfo() {


    }

    public String getClasses() {
        return classes;
    }

    public String getStuName() {
        return stuName;
    }

    public int getStuNo() {
        return stuNo;
    }

    public String getStuPassword() {
        return stuPassword;
    }

    public String getStatus() {
        return status;
    }

    public int getDoWorkTimes() {
        return doWorkTimes;
    }

    public int getHaveToDoTimes() {
        return haveToDoTimes;
    }

    public int getSubScore() {
        return subScore;
    }

    public String getStuno() {
        return stuno;
    }

    public void setClasses(String classes) {
        this.classes = classes;
    }

    public void setStuName(String stuName) {
        this.stuName = stuName;
    }

    public void setStuPassword(String stuPassword) {
        this.stuPassword = stuPassword;
    }

    public void setStuNo(int stuNo) {
        this.stuNo = stuNo;
    }

    public void setStatus(String status) {
        this.status = status;
    }

    public void setDoWorkTimes(int doWorkTimes) {
        this.doWorkTimes = doWorkTimes;
    }

    public void setHaveToDoTimes(int haveToDoTimes) {
        this.haveToDoTimes = haveToDoTimes;
    }

    public void setSubScore(int subScore) {
        this.subScore = subScore;
    }

    public void setStuno(String stuno) {
        this.stuno = stuno;
    }
    public void addDoWorkTimes(){

        cb = new ConnectBean();

        try {
            cb.openConnection();
            String query = "update stumessage set doworktimes=doworktimes+1 where stuno="+this.stuNo;
            ps = cb.createPreparedStatement(query);
            ps.executeUpdate();

        } catch (Exception se) {
            status = "写入数据发生错误！！！" + se;
        } finally {
            try {
                cb.close();
            } catch (Exception es) {
                status = "后台发生错误" + es;
            }
        }
        System.out.println("updateuser");


    }

    public void addHaveToDoTimes(){

    cb = new ConnectBean();

    try {
        cb.openConnection();
        String query = "update stumessage set havetodotimes=havetodotimes+1";
        ps = cb.createPreparedStatement(query);
        ps.executeUpdate();

    } catch (Exception se) {
        status = "写入数据发生错误！！！" + se;
    } finally {
        try {
            cb.close();
        } catch (Exception es) {
            status = "后台发生错误" + es;
        }
    }
    System.out.println("updateuser");


}


    public StuInfo stuMessage(){
        ArrayList allStu = null;
        cb = new ConnectBean();
        try {
            cb.openConnection();
            String query = "select * from stumessage";

            cb.createPreparedStatement(query);
            cb.executeQuery();
            allStu = new ArrayList();
            while (cb.next()) {
                StuInfo student=new StuInfo();
                student.stuNo = cb.getIntData(1);
                student.stuno=student.stuNo+"";
                student.stuName=cb.getData(2);
                student.classes=cb.getData(4);
                allStu.add(student);
            }
        } catch (Exception se) {
            status = "写入数据发生错误！！！" + se;
        } finally {
            try {
                cb.close();
            } catch (Exception es) {
                status = "后台发生错误" + es;
            }
        }

        return allStu;

    }
    public StuInfo findByNo(int pk){
        StuInfo tmpStu=null;
        cb=new ConnectBean();
        try{
            cb.openConnection();
            String query = "select * from stumessage where stuno=" + pk;
            cb.createPreparedStatement(query);
            cb.executeQuery();
            int i = 0;
            if(cb.next()){
                stuNo=cb.getIntData(1);
                stuName=cb.getData(2);
                stuPassword=cb.getData(3);
                classes=cb.getData(4);
                doWorkTimes=cb.getIntData(5);
                haveToDoTimes=cb.getIntData(6);
                subScore=cb.getIntData(7);
                tmpStu=this;
            }

        }catch (Exception se) {
            status = "写入数据发生错误！！！" + se;
        } finally {
            try {
                cb.close();
            } catch (Exception es) {
                status = "后台发生错误" + es;
            }
        }
        return tmpStu;

    }
    public boolean changePass(){
        boolean bl = false;
        cb = new ConnectBean();

        try {
            cb.openConnection();
            String query = "update stumessage set stupassword= "+stuPassword+" where stuno="+stuNo;
            ps = cb.createPreparedStatement(query);
            ps.executeUpdate();
            bl=true;
        }catch (Exception se) {
            status = "写入数据发生错误！！！" + se;
        } finally {
            try {
                cb.close();
            } catch (Exception es) {
                status = "后台发生错误" + es;
            }
        }
        System.out.println("updateuser");
        return bl;


    }

    public boolean login() {
        String oldPassword;
        boolean bl = false;
        try {
            cb.openConnection();
            String query =
                    "select stupassword from stumessage where stuno='" +
                    stuNo + "'";
            System.out.println(query);
            cb.createPreparedStatement(query);

            System.out.println("ok");
            cb.executeQuery();
            if (cb.next()) {
                //userId = cb.getIntData(1); ;
                oldPassword = cb.getData(1);
                if (oldPassword.trim().equals(stuPassword)) {
                    System.out.println("OK!!!");
                    return bl = true;
                } else {
                    status = "密码错误!!!";
                }
            } else {
                status = "用户不存在!";
            }
        } catch (Exception e) {
            status = e+"";
        }
        return bl;
    }

    public boolean updateStu() {
      boolean bl = false;
      cb = new ConnectBean();

      try {
          cb.openConnection();
          String query = "update stumessage set stuname='" + this.stuName +"',class='"+this.classes+
                         "' where stuno=" + this.stuNo;
          ps = cb.createPreparedStatement(query);
          ps.executeUpdate();
          bl = true;
      } catch (Exception se) {
          status = "写入数据发生错误！！！" + se;
      } finally {
          try {
              cb.close();
          } catch (Exception es) {
              status = "后台发生错误" + es;
          }
      }
      System.out.println("updateuser");
      return bl;

  }



    public boolean deletStu() {
        boolean bl = false;
        cb = new ConnectBean();
        try {
            cb.openConnection();
            String query = "delete from stumessage  WHERE tid="+this.stuNo;
            System.out.println(query);
            ps = cb.createPreparedStatement(query);
            ps.executeUpdate();
            System.out.println("DAO----------------------delete student  OK!!!");
            bl = true;
        } catch (Exception se) {
            status = "对不起，改学生还有作业存档，不能删除！！";
        } finally {
            try {
                cb.close();
            } catch (Exception es) {
                status = "后台发生错误" + es;
            }
        }

        return bl;

     }

     public boolean insertStu() {
         boolean bl = false;
         status = "学生添加失败";
         cb = new ConnectBean();
         if (!cb.openConnection()) {
             status = "连接数据库失败!!!";
         }
         try {
             ps = cb.createPreparedStatement(
                     "insert into stumessage values(?,?,?,?,?,?,?)");
             ps.setInt(1, this.stuNo);
             ps.setString(2, this.stuName);
             ps.setString(3, "123456");
             ps.setString(4, this.classes);
             ps.setInt(5, 0);
             ps.setInt(6, 0);
             ps.setInt(7, 0);
             ps.executeUpdate();
             bl = true;
             status = "用户添加成功";
         } catch (Exception se) {
             status = "写入数据发生错误！！！" + se;
         } finally {
             try {
                 cb.close();
             } catch (Exception es) {
                 status = "后台发生错误" + es;
             }
         }
         return bl;

     }


    }