student.java~41~

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

package base;
import base.db.*;
import java.sql.*;

public class Student {
    private String id;
    private String name;
    private String department;
    private String password;
    private String teacher;

    public Student() {}

    public String getDepartment() {
        return department;
    }

    public String getId() {
        return id;
    }

    public String getName() {
        return name;
    }

    public String getPassword() {
        return password;
    }

    public String getTeacher() {
        return teacher;
    }

    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 void setTeacher(String teacher) {
        this.teacher = teacher;
    }


    public void updateStu() {
        Data data = new Data();
        String sql="UPDATE student SET password=" + password + ",department="+department+",name='"+name+"' WHERE id=" +
                    id + ";";
        data.update(sql);
    }

    public void addStu() {
        Data data = new Data();
        String sql="INSERT INTO student (id,name,password,teacher,department) VALUES( " +
                id + " , '" + name + "' , " + password + " , " + teacher + " , " +
                department + " );";
       data.insert(sql);
    }

    public ResultSet getStu(String id) {
        try {
            Conn con = new Conn();
            Statement stmt;
            stmt = con.getStmtread();
            ResultSet rs = stmt.executeQuery("SELECT * FROM student WHERE id=" +
                                             id + ";");
            return rs;
        } catch (Exception e) {
            System.err.println(e.getMessage());
            e.printStackTrace();
        }
        return null;
    }

    public ResultSet getSelectCou(String id){
        try {
            Conn con = new Conn();
            Statement stmt;
            stmt = con.getStmtread();
            ResultSet rs = stmt.executeQuery("SELECT couid FROM selcou WHERE stuid=" +
                                             id + ";");
            return rs;
        } catch (Exception e) {
            System.err.println(e.getMessage());
            e.printStackTrace();
        }
        return null;

    }

    public void delCou(String couid){
        String sql="delete from selcou where couid="+couid+" and stuid="+id+";";
        Data data=new Data();
        data.delete(sql);
    }

    public String addCou(String couid){
        String sql="insert into selcou (stuid,couid) values("+id+","+couid+");";
        Data data=new Data();
        data.delete(sql);
        return sql;
    }
}