classbean.java

在线教育平台： 从小学

package edu;

import java.sql.*;

public class ClassBean {
	private int id, grade_id;

	private String classes;

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

	public int getId() {
		return id;
	}

	public void setGrade_id(int grade_id) {
		this.grade_id = grade_id;
	}

	public int getGrade_id() {
		return grade_id;
	}

	public void setClasss(String classes) {
		this.classes = classes;
	}

	public String getClasss() {
		return classes;
	}

	public ResultSet getClass_grade(int grade_id) {
		String sql = "select * from class where grade_id='" + grade_id + "'";
		SqlBean db = new SqlBean();
		ResultSet rs = db.executeQuery(sql);
		return rs;
	}

	public ResultSet getClasses(int grade_id) {
		String sql = "select * from class,grade where class.grade_id=grade.grade_id and grade.grade_id='"
				+ grade_id + "'";
		SqlBean db = new SqlBean();
		ResultSet rs = db.executeQuery(sql);
		return rs;
	}

	public ResultSet getClasses() {
		String sql = "select * from class";
		SqlBean db = new SqlBean();
		ResultSet rs = db.executeQuery(sql);
		return rs;
	}

	public ResultSet getClasss(int id) {
		String sql = "select * from class where class_id='" + id + "'";
		SqlBean db = new SqlBean();
		ResultSet rs = db.executeQuery(sql);
		return rs;
	}

	public void updateClass() {

		String sql = "update class " + " set class='" + classes
				+ "'where class_id='" + id + "' and grade_id='" + grade_id
				+ "' ";
		SqlBean db = new SqlBean();
		db.executeInsert(sql);

	}

	public void updateClass(int id) {

		String sql = "update class " + " set class='" + classes
				+ "'where class_id='" + id + "'and grade_id='" + grade_id
				+ "' ";
		SqlBean db = new SqlBean();
		db.executeInsert(sql);

	}

	public void deleteClass() {
		String sqlsubject = "delete  from subject where class_id ='" + id
				+ "' ";
		String sql = "delete  from class where class_id ='" + id + "' ";
		SqlBean db = new SqlBean();
		db.executeDelete(sqlsubject);
		db.executeDelete(sql);
	}

	public int deleteClass(int id) {
		int num = 0;
		String sqlsubject = "delete  from subject where class_id ='" + id
				+ "' ";
		String sql = "delete  from class where class_id ='" + id + "' ";
		SqlBean db = new SqlBean();
		db.executeDelete(sqlsubject);
		num = db.executeDelete(sql);
		return num;
	}

	public void addClass() {
		String sql = "insert into class(class,grade_id)  " + "VALUES('"
				+ classes + "','" + grade_id + "')";
		SqlBean db = new SqlBean();

		db.executeInsert(sql);
	}
}