uteacherbean.java

在线教育平台： 从小学

package edu;

import java.sql.*;

public class UteacherBean {

	private int id;

	private int t_id;

	private String about;

	private int startrow;

	private int pagesize;

	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 int getId() {
		return id;
	}

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

	public int getT_id() {
		return t_id;
	}

	public void setT_id(int t_id) {
		this.t_id = t_id;
	}

	public String getAbout() {
		return about;
	}

	public void setAbout(String about) {
		this.about = about;
	}

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

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

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

	public void updateTeacher() {

		String sql = "update uteacher " + " set t_about='" + about
				+ "'where id='" + id + "' ";
		SqlBean db = new SqlBean();
		db.executeInsert(sql);

	}

	public void deleteTeacher() {

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

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

	public void addTeacher() {
		String sql = "insert into uteacher(t_id,t_about)" + "VALUES('" + t_id
				+ "','" + about + "')";
		SqlBean db = new SqlBean();

		db.executeInsert(sql);
	}

}