course.java

一个学生课绩管理系统

package database;

import java.sql.*;

public class course {
	private String id;

	private String name;

	private String dep;

	private String prepare;

	private int mark;

	public void setPrepare(String s) {
		prepare = s;
	}

	public String getPrepare() {
		return prepare;
	}

	public void setMark(int s) {
		mark = s;
	}

	public int getMark() {
		return mark;
	}

	public void setDep(String s) {
		dep = s;
	}

	public String getDep() {
		return dep;
	}

	public String getId() {
		return id;
	}

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

	public String getName() {
		return name;
	}

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

	// 得到所能选择的预修课
	public ResultSet getPrepares() {
		String sql = "select name,id from course";
		sqlBean db = new sqlBean();
		ResultSet rs = db.executeQuery(sql);
		return rs;
	}

	// 察看预修课所在系
	public String getPrepareDep() {
		String s = "no";
		String sql = "select dep from course where id='" + prepare + "' ";
		sqlBean db = new sqlBean();
		try {
			ResultSet rs = db.executeQuery(sql);
			if (rs.next()) {
				s = rs.getString("dep");
			}
		} catch (Exception e) {
			e.getMessage();
		}
		return s;
	}

	// 察看所有课程
	public ResultSet getCourse() {
		String sql = "select * from course   ";
		sqlBean db = new sqlBean();
		ResultSet rs = db.executeQuery(sql);
		return rs;
	}

	public int deleteCourse(String id) {
		int num = 0;
		String sql = "delete  from Course where id ='" + id + "' ";
		sqlBean db = new sqlBean();
		num = db.executeUpdate(sql);
		return num;
	}

	public String getPrepareDep(String id) {
		String dep = "";
		String sql = "select dep from course where id='" + id + "'";
		sqlBean db = new sqlBean();
		try {
			ResultSet rs = db.executeQuery(sql);
			if (rs.next())
				dep = rs.getString("dep");
		} catch (SQLException e) {
			System.out.print(e.toString());
		}
		return dep;
	}

	public void updateCourse(String id) {
		String sql = "update course " + " set name='" + name + "',prepare='"
				+ prepare + "'," + "dep='" + dep + "',mark='" + mark + "'  "
				+ " where id='" + id + "' ";
		sqlBean db = new sqlBean();
		db.executeUpdate(sql);
	}

	public void addCourse() {
		String sql = "insert into course(id,name,mark,prepare,dep) "
				+ "VALUES('" + id + "','" + name + "','" + mark + "','"
				+ prepare + "','" + dep + "') ";
		sqlBean db = new sqlBean();
		db.executeUpdate(sql);
	}

	public boolean hasLogin(String id) {
		boolean f = true;
		String sql = "select id from course where id='" + id + "'  ";
		sqlBean db = new sqlBean();
		try {
			ResultSet rs = db.executeQuery(sql);
			if (rs.next()) {
				f = false;
			}
		} catch (Exception e) {
			e.getMessage();
		}
		return f;
	}
}