helpbean.java

在线教育平台： 从小学

package edu;

import java.sql.*;

public class HelpBean {
	private int id;

	private String title;

	private String content;

	private int startrow;

	private int pagesize;

	private String time;

	public String getTime() {
		return time;
	}

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

	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 setTitle(String title) {
		this.title = title;
	}

	public String getTitle() {
		return title;
	}

	public void setContent(String content) {
		this.content = content;
	}

	public String getContent() {
		return content;
	}

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

	public ResultSet getHelp() {
		String sql = "select * from help ORDER BY  id DESC limit " + startrow + "," + pagesize
				+ "";
		SqlBean db = new SqlBean();
		ResultSet rs = db.executeQuery(sql);
		return rs;
	}

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

	public ResultSet getHelpTop5() {
		String sql = "SELECT  * FROM help ORDER BY id DESC limit 0,5";
		SqlBean db = new SqlBean();
		ResultSet rs = db.executeQuery(sql);
		return rs;
	}

	public void updateHelp() {

		String sql = "update help " + " set title='" + title + "',content='"
				+ content + "'where id='" + id + "' ";
		SqlBean db = new SqlBean();
		db.executeInsert(sql);

	}

	public void updateHelp(int id) {

		String sql = "update help " + " set title='" + title + "',content='"
				+ content + "'where id='" + id + "' ";
		SqlBean db = new SqlBean();
		db.executeInsert(sql);

	}

	public void deleteHelp() {

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

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

	public void addHelp() {
		String sql = "insert into help(title,content,time)  " + "VALUES('"
				+ title + "','" + content + "','" + time + "')";
		SqlBean db = new SqlBean();

		db.executeInsert(sql);
	}
}