askbean.java

在线教育平台： 从小学

package edu;

import java.sql.*;

//import java.text.*;

public class AskBean {
	private String title;

	private String content;

	private int u_id;

	private int id;

	private int answer_id;

	private int class_id;

	private int grade_id;

	private int subject_id;

	private String time;

	private String searchkey;

	private int startrow;

	private int pagesize;

	private String sort;

	public void setSort(String sort) {
		this.sort = sort;
	}

	public String getSort() {
		return sort;
	}

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

	public String getTitle() {
		return title;
	}

	public void setContent(String s) {
		content = s;
	}

	public String getContent() {
		return content;
	}

	public int getId() {
		return id;
	}

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

	public int getU_id() {
		return u_id;
	}

	public void setSearchkey(String searchkey) {
		this.searchkey = searchkey;
	}

	public String getSearchkey() {
		return searchkey;
	}

	public void setU_id(int u_id) {
		this.u_id = u_id;
	}

	public int getAnswer_id() {
		return answer_id;
	}

	public void setAnswer_id(int answer_id) {
		this.answer_id = answer_id;
	}

	public int getClass_id() {
		return class_id;
	}

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

	public int getGrade_id() {
		return grade_id;
	}

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

	public int getSubject_id() {
		return subject_id;
	}

	public void setSubject_id(int subject_id) {
		this.subject_id = subject_id;
	}

	public String getTime() {
		return time;
	}

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

	public ResultSet countAsk(int id) {
		String sql = "select count(*) FROM answer where ask_id='" + id + "'";
		SqlBean db = new SqlBean();
		ResultSet rs = db.executeQuery(sql);
		return rs;
	}

	public ResultSet getAskSortName(String sort, int id) {
		String name = null, _id = null, photo = null;
		if (sort.equalsIgnoreCase("user")) {
			name = "u_name";
			_id = "u_id";
			photo = "u_photo";
		}
		if (sort.equalsIgnoreCase("teacher")) {
			name = "t_teacher";
			_id = "t_id";
			photo = "t_photo";
		}
		if (sort.equalsIgnoreCase("admin")) {
			name = "admin";
			_id = "id";
			photo = "a_photo";
		}
		String sql = "select " + name + "," + photo + " from " + sort
				+ " where " + _id + " ='" + id + "'";
		SqlBean db = new SqlBean();
		ResultSet rs = db.executeQuery(sql);
		return rs;

	}

	public ResultSet getAskList(int grade_id) {
		String sql = "SELECT * FROM ask where grade_id='" + grade_id
				+ "' ORDER BY  ask_id DESC limit " + startrow + "," + pagesize
				+ "";
		SqlBean db = new SqlBean();
		ResultSet rs = db.executeQuery(sql);
		return rs;
	}

	public ResultSet getAskListCount(int grade_id) {
		String sql = "SELECT count(*) FROM ask where grade_id='" + grade_id
				+ "' ORDER BY  ask_id DESC";
		SqlBean db = new SqlBean();
		ResultSet rs = db.executeQuery(sql);
		return rs;
	}

	public ResultSet getAskList(int grade_id, int class_id) {
		String sql = "SELECT * FROM ask where grade_id='" + grade_id
				+ "' and  class_id='" + class_id
				+ "' ORDER BY ask_id DESC limit " + startrow + "," + pagesize
				+ "";
		SqlBean db = new SqlBean();
		ResultSet rs = db.executeQuery(sql);
		return rs;
	}

	public ResultSet getAskListCount(int grade_id, int class_id) {
		String sql = "SELECT count(*) FROM ask where grade_id='" + grade_id
				+ "' and  class_id='" + class_id + "' ORDER BY ask_id DESC";
		SqlBean db = new SqlBean();
		ResultSet rs = db.executeQuery(sql);
		return rs;
	}

	public ResultSet getAskListCount() {
		String sql = "SELECT  count(*) FROM ask where grade_id='" + grade_id
				+ "'and class_id='" + class_id + "'and subject_id='"
				+ subject_id + "' ORDER BY ask_id DESC";
		SqlBean db = new SqlBean();
		ResultSet rs = db.executeQuery(sql);
		return rs;
	}

	public ResultSet getAskList() {
		String sql = "SELECT  * FROM ask where grade_id='" + grade_id
				+ "'and class_id='" + class_id + "'and subject_id='"
				+ subject_id + "' ORDER BY ask_id DESC limit " + startrow + ","
				+ pagesize + "";
		SqlBean db = new SqlBean();
		ResultSet rs = db.executeQuery(sql);
		return rs;
	}

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

	public ResultSet Count() {
		String sql = "select count(*) FROM ask ";
		SqlBean db = new SqlBean();
		ResultSet rs = db.executeQuery(sql);
		return rs;
	}

	public ResultSet getAsks() {
		String sql = "SELECT  * FROM ask ORDER BY ask_id DESC limit "
				+ startrow + "," + pagesize + "";
		SqlBean db = new SqlBean();
		ResultSet rs = db.executeQuery(sql);
		return rs;
	}

	/*
	 * public ResultSet getOldAskTop5()throws
	 * ParseException,SQLException{//当前时间减去提问时间>3天的,且没有被回答的提问 SqlBean db= new
	 * SqlBean(); String sql1="select a_time from ask where answer_id=0";
	 * ResultSet rs_sql2=null; ResultSet rs_sql1 = db.executeQuery(sql1);
	 * while(rs_sql1.next()){ String a_time=rs_sql1.getString(1); DateFormat df =
	 * new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); java.util.Date date =
	 * df.parse(a_time); java.util.Date now = new java.util.Date();
	 * if((now.getTime()-date.getTime())/(3600*1000*24)>3){ String sql2="select *
	 * from ask where a_time='"+a_time+"' ORDER BY ask_id DESC limit 0,5";
	 * rs_sql2 = db.executeQuery(sql2); }} return rs_sql2; }
	 */
	public ResultSet getOldAskCount() {// 大约3天没有回复的(疑难问题)
		String sql = "select count(*) from ask where a_time<(now()-34*3680*24) and answer_id=0 ORDER BY ask_id DESC";
		SqlBean db = new SqlBean();
		ResultSet rs = db.executeQuery(sql);
		return rs;
	}

	public ResultSet getOldAsk() {// 大约3天没有回复的数目(疑难问题)
		String sql = "select * from ask where a_time<(now()-34*3680*24) and answer_id=0 ORDER BY ask_id DESC";
		SqlBean db = new SqlBean();
		ResultSet rs = db.executeQuery(sql);
		return rs;
	}

	public ResultSet getAsk_No() {
		SqlBean db = new SqlBean();
		String sql1 = "select * from ask where answer_id=0 ORDER BY ask_id DESC";
		ResultSet rs_sql1 = db.executeQuery(sql1);
		return rs_sql1;
	}

	public ResultSet getAsk_time(String time) {
		SqlBean db = new SqlBean();
		String sql1 = "select * from ask where a_time='" + time + "'";
		ResultSet rs_sql1 = db.executeQuery(sql1);
		return rs_sql1;
	}

	public ResultSet SearchCount() {
		String sql = "select count(*) from ask where grade_id='" + grade_id
				+ "'and class_id='" + class_id + "'and subject_id='"
				+ subject_id + "' and a_title like '" + "%" + searchkey + "%"
				+ "'  ORDER BY ask_id DESC";
		SqlBean db = new SqlBean();
		ResultSet rs = db.executeQuery(sql);
		return rs;
	}

	public ResultSet Search() {
		String sql = "select * from ask where grade_id='" + grade_id
				+ "'and class_id='" + class_id + "'and subject_id='"
				+ subject_id + "' and a_title like '" + "%" + searchkey + "%"
				+ "'  ORDER BY ask_id DESC limit " + startrow + "," + pagesize
				+ "";
		SqlBean db = new SqlBean();
		ResultSet rs = db.executeQuery(sql);
		return rs;
	}

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

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

	public void updateAsk(int id) {

		String sql = "update ask " + " set a_title='" + title + "',a_content='"
				+ content + "',a_time='" + time + "' where ask_id='" + id
				+ "' ";
		SqlBean db = new SqlBean();
		db.executeInsert(sql);

	}

	public void deleteAsk() {

		String sql = "delete from answer where ask_id='" + id + "'";
		String sql1 = "delete  from ask where ask_id ='" + id + "' ";
		SqlBean db = new SqlBean();
		db.executeDelete(sql);
		db.executeDelete(sql1);
	}

	public int deleteAsk(int id) {
		int num = 0;
		String sql = "delete from answer where ask_id='" + id + "'";
		String sql1 = "delete  from ask where ask_id ='" + id + "' ";
		SqlBean db = new SqlBean();
		db.executeDelete(sql);
		num = db.executeDelete(sql1);
		return num;
	}

	public void addAsk() {
		String sql = "insert into ask(a_title,a_content,a_time,u_id,answer_id,class_id,grade_id,subject_id,ask_sort)"
				+ "VALUES('"
				+ title
				+ "','"
				+ content
				+ "','"
				+ time
				+ "','"
				+ u_id
				+ "','"
				+ answer_id
				+ "','"
				+ class_id
				+ "','"
				+ grade_id + "','" + subject_id + "','" + sort + "')";
		SqlBean db = new SqlBean();

		db.executeInsert(sql);
	}

}