answerbean.java

在线教育平台： 从小学

package edu;

import java.sql.*;

public class AnswerBean {
	private String sort;

	private String content;

	private int ask_id;

	private int id;

	private int ans_id;

	private String time;

	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 void setSort(String s) {
		sort = s;
	}

	public String getSort() {
		return sort;
	}

	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 getAsk_id() {
		return ask_id;
	}

	public void setAsk_id(int ask_id) {
		this.ask_id = ask_id;
	}

	public int getAns_id() {
		return ans_id;
	}

	public void setAns_id(int ans_id) {
		this.ans_id = ans_id;
	}

	public String getTime() {
		return time;
	}

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

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

	public ResultSet getAnswerCount(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 getAnswer(int id) {
		String sql = "select * from answer where ask_id='" + id + "' limit "
				+ startrow + "," + pagesize + "";
		SqlBean db = new SqlBean();
		ResultSet rs = db.executeQuery(sql);
		return rs;
	}

	public ResultSet getAnswerSortName(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
				+ " in (select ans_id from answer where ask_id='" + id + "')";
		SqlBean db = new SqlBean();
		ResultSet rs = db.executeQuery(sql);
		return rs;

	}

	public void updateAnswer() {

		String sql = "update answer " + " set ask_id='" + ask_id
				+ "',ans_content='" + content + "',ans_time='" + time + "',	 "
				+ "ans_id='" + ans_id + "',ans_sort='" + sort + "'"
				+ " where answer_id='" + id + "' ";
		SqlBean db = new SqlBean();
		db.executeInsert(sql);

	}

	public void updateAnswer(int id) {

		String sql = "update answer " + " set ans_content='" + content
				+ "',ans_time='" + time + "' where answer_id='" + id + "' ";
		SqlBean db = new SqlBean();
		db.executeInsert(sql);

	}

	public void deleteAnswer() {

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

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

	public void addAnswer() {
		String sql1 = "update ask set answer_id=answer_id+1 where ask_id='"
				+ ask_id + "'";
		String sql = "insert into answer(ask_id,ans_content,ans_time,ans_id,ans_sort)"
				+ "VALUES('"
				+ ask_id
				+ "','"
				+ content
				+ "','"
				+ time
				+ "','"
				+ ans_id + "','" + sort + "')";
		SqlBean db = new SqlBean();
		db.executeInsert(sql1);
		db.executeInsert(sql);
	}

}