subjectbean.java

在线教育平台： 从小学

package edu;

import java.sql.*;

public class SubjectBean {
	private int id, grade_id, class_id;

	private int startrow;

	private int pagesize;

	private String subject;

	public void setStartpage(int s) {
		startrow = s;
	}

	public int getStartpage() {
		return startrow;
	}

	public void setPagesize(int s) {
		pagesize = s;
	}

	public int getPagesize() {
		return pagesize;
	}

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

	public int getId() {
		return id;
	}

	public void setSubject(String subject) {
		this.subject = subject;
	}

	public String getSubject() {
		return subject;
	}

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

	public int getGrade_id() {
		return grade_id;
	}

	public void setClass_id(int class_id) {
		this.class_id = class_id;
	}

	public int getClass_id() {
		return class_id;
	}

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

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

	public ResultSet getSubjectss() {
		String sql = "select * from subject limit " + startrow + "," + pagesize
				+ "";
		SqlBean db = new SqlBean();
		ResultSet rs = db.executeQuery(sql);
		return rs;
	}

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

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

	public void updateSubject() {

		String sql = "update subject " + " set subject='" + subject
				+ "'where subject_id='" + id + "' ";
		SqlBean db = new SqlBean();
		db.executeInsert(sql);

	}

	public void updateSubject(int id) {

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

	}

	public void deleteSubject() {

		String sql = "delete  from subject where subject_id ='" + id + "' ";
		SqlBean db = new SqlBean();
		db.executeDelete(sql);
	}

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

	public void addSubject() {
		String sql = "insert into subject(grade_id,class_id,subject)  "
				+ "VALUES('" + grade_id + "','" + class_id + "','" + subject
				+ "')";
		SqlBean db = new SqlBean();

		db.executeInsert(sql);
	}
}