teacherinfo.java~32~

HomeWork <学生作业提交管理系统> 这是一个朋友做的一个学生作业提交系统,也是做为毕业设计而完成的. 使用JSP,Servelet技术,很好的实现了MVC设计模式,现在拿出来,

package work.info;

import java.sql.*;
import java.util.*;

import work.tools.*;

public class TeacherInfo {
    private int tId;
    private String tName;
    private String subject;
    private String tPassword;
    private String status="操作成功！";
    private ConnectBean cb=new ConnectBean();
    private PreparedStatement ps;
    private String tid1;
    public TeacherInfo() {
    }

    public void settId(int tId) {

        this.tId = tId;
    }

    public void settName(String tName) {

        this.tName = tName;
    }

    public void setSubject(String subject) {
        this.subject = subject;
    }

    public void settPassword(String tPassword) {
        this.tPassword = tPassword;
    }

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

    public void setTid1(String tid1) {
        this.tid1 = tid1;
    }

    public int gettId() {

        return tId;
    }

    public String gettName() {

        return tName;
    }

    public String getSubject() {
        return subject;
    }

    public String gettPassword() {
        return tPassword;
    }

    public String getStatus() {
        return status;
    }

    public String getTid1() {
        return tid1;
    }

    public ArrayList teacherMessage(){
    ArrayList allTeacher = null;
    cb = new ConnectBean();
    try {
        cb.openConnection();
        String query = "select * from teachermessage";

        cb.createPreparedStatement(query);
        cb.executeQuery();
        allTeacher = new ArrayList();
        while (cb.next()) {
            TeacherInfo teacher=new TeacherInfo();
            teacher.tId=cb.getIntData(1);
           // teacher.tid1=tId+"";
            teacher.tName=cb.getData(2);
            teacher.subject=cb.getData(3);
            System.out.println(teacher.tId);
            allTeacher.add(teacher);
        }
    } catch (Exception se) {
        status = "写入数据发生错误！！！" + se;
    } finally {
        try {
            cb.close();
        } catch (Exception es) {
            status = "后台发生错误" + es;
        }
    }

    return allTeacher;

}


    public TeacherInfo findByNo(){
     TeacherInfo tmpTeacher=null;
     cb=new ConnectBean();
     try{
         cb.openConnection();
         String query = "select * from teachermessage where tid=" + this.tId;
         cb.createPreparedStatement(query);
         cb.executeQuery();
         int i = 0;
         if(cb.next()){
             tId=cb.getIntData(1);
             tName=cb.getData(2);
             subject=cb.getData(3);
         }

     }catch (Exception se) {
         status = "写入数据发生错误！！！" + se;
     } finally {
         try {
             cb.close();
         } catch (Exception es) {
             status = "后台发生错误" + es;
         }
     }
     return tmpTeacher;
 }
 public boolean changePass(){
     boolean bl = false;
     cb = new ConnectBean();

     try {
         cb.openConnection();
         String query = "update teachermessage set tpassword= "+tPassword+" where tid="+tId;
         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 tpassword from teachermessage where tid='" +
                    tId + "'";
            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(tPassword)) {
                    System.out.println("OK!!!");
                    return bl = true;
                } else {
                    status = "密码错误!!!";
                }
            } else {
                status = "用户不存在!";
            }
        } catch (Exception e) {
            status = e + "";
        }
        return bl;
    }

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

        try {
            cb.openConnection();
            String query = "update teachermessage set tname= " + this.tName +" subject="+this.subject+
                           " where tid=" + tId;
            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 deletTeacher(){
        boolean bl = false;
    cb = new ConnectBean();
    try {
        cb.openConnection();
        String query = "delete from teachermessage  WHERE tid="+this.tId;
        System.out.println(query);
        ps = cb.createPreparedStatement(query);
        ps.executeUpdate();
        System.out.println("DAO----------------------delete teacher  OK!!!");
        bl = true;
    } catch (Exception se) {
        status = "对不起，这位老师还有作业题目存档不能删除，不能删除！！";
    } finally {
        try {
            cb.close();
        } catch (Exception es) {
            status = "后台发生错误" + es;
        }
    }

    return bl;

    }

}