course.java~1~

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

package base;

import java.sql.*;
import base.db.*;
public class Course {
    private String id;
    private String name;
    private String credit;
    private String time;
    private String room;
    private String max;
    private String teacher;
    private String department;
    private String cur;
    public Course() {
    }

    public String getCredit() {
        return credit;
    }

    public String getCur() {
        return cur;
    }

    public String getDepartment() {
        return department;
    }

    public String getId() {
        return id;
    }

    public String getMax() {
        return max;
    }

    public String getName() {
        return name;
    }

    public String getRoom() {
        return room;
    }

    public String getTeacher() {
        return teacher;
    }

    public String getTime() {
        return time;
    }

    public void setCredit(String credit) {
        this.credit = credit;
    }

    public void setCur(String cur) {
        this.cur = cur;
    }

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

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

    public void setMax(String max) {
        this.max = max;
    }

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

    public void setRoom(String room) {
        this.room = room;
    }

    public void setTeacher(String teacher) {
        this.teacher = teacher;
    }

    public void setTime(String time) {
        this.time = time;
    }

    public ResultSet getCourse(String id){
        String sql="select * from course 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 void updateCou() {
        Data data = new Data();
        String sql="UPDATE course SET name='" + name + "',room='" + room + "',time='"+time+"',max=" + max + ",credit=" + credit + " WHERE id=" +
                    id + ";";
        data.update(sql);
    }

    public String insertCou() {
        Data data = new Data();
        String sql="insert into course (id,name,teacher,time,department,room,max,credit) values("+id+",'"+name+"',"+teacher+",'"+time+"',"+department+",'"+room+"',"+max+","+credit+");";
        data.insert(sql);
        return sql;
    }
}