teacher.java~15~

教学管理系统的JAVA实现代码

package base;
import java.sql.*;

import base.db.*;
public class Teacher {
    public Teacher() {
    }

    private String id;
    private String name;
    private String password;
    private String department;

    public String getDepartment() {
           return department;
       }

       public String getId() {
           return id;
       }

       public String getName() {
           return name;
       }

       public String getPassword() {
           return password;
       }

       public void setDepartment(String department) {
           this.department = department;
       }

       public void setId(String id) {
           this.id = id;
       }

       public void setName(String name) {
           this.name = name;
       }

       public void setPassword(String password) {
           this.password = password;
    }

    public ResultSet getTea(String id){
        String sql="select * from teacher where id='"+id+"'";
        Conn con= new Conn();
        Statement stmt;
        ResultSet rs=null;
        stmt = con.getStmtread();
        try {
            rs = stmt.executeQuery(sql);
        } catch (SQLException ex) {
        }
        return rs;
    }

    public ResultSet getCourse(String id){
        String sql="select * from course where id ="+id+";";
        Data data =new Data();
        ResultSet rs=data.select(sql);
        return rs;
    }

    public void mark(String Stu_no,String cou_na,String mark){
        String sql="update choose SET mark='"+mark+"' WHERE stu_no='"+Stu_no+"' AND cou_no='"+cou_na+"'";
        Data data=new Data();
        data.insert(sql);
    }

    public ResultSet getStu(String cou_na){
        String sql=
            "select * from choose where cou_no='"+cou_na+"'";
        Data data=new Data();
        ResultSet rs=data.select(sql);
        return rs;
    }



    public void changeTime(String Cou_no,String time){
        String sql="update course "
        +" set time='"+time+"'"+", "
        +"where no='"+Cou_no+"' ";
        Data data= new Data();
        data.update(sql);
    }


}