teacher.java~9~

来自「教学管理系统的JAVA实现代码」· JAVA~9~ 代码 · 共 51 行

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

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


    public ResultSet getTea(String tea){
        String sql="select * from teacher where no='"+tea+"'";
        Conn con= new Conn();
        Statement stmt;
        ResultSet rs=null;
        stmt = con.getStmtread();
        try {
            rs = stmt.executeQuery(sql);
        } catch (SQLException ex) {
        }
        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);
    }
}