feedbackrecordoperate.java

JAVA实现的酒店管理系统

package file1;

/*
 * Description:对客户申诉记录解决结果的的反馈情况的调用类，根据反馈情况的属性值存取数据库
 * @Author:黄顺武
 * Create Time:2007-12-22
 */
import java.sql.*;
import java.util.*;
import sun.jdbc.rowset.*;

public class FeedBackRecordOperate implements Operate {

	public FeedBackRecordOperate() {
	}

	public void insertToDB(Object object) {// 插入反馈情况时调用的方法
		FeedBackRecord feed_back_record = (FeedBackRecord) object;
		try {
			DBConnection con = new DBConnection();
			StringBuffer sqlSB = new StringBuffer(
					"insert into FeedBackRecord values(");
			sqlSB.append(feed_back_record.getAppealID()).append(",");
			sqlSB.append(feed_back_record.getOperater()).append(",'");
			sqlSB.append(feed_back_record.getOperateTime()).append("','");
			sqlSB.append(feed_back_record.getSuggestion()).append("')");
			con.addSql(sqlSB.toString());
			con.doDML();
		} catch (ClassNotFoundException cnfe) {
			cnfe.printStackTrace();
		} catch (SQLException sqle) {
			sqle.printStackTrace();
		}
	}

	public void deleteFromDB(Object object) {// 删除反馈情况时调用的方法

		FeedBackRecord feed_back_record = (FeedBackRecord) object;
		try {
			DBConnection con = new DBConnection();
			StringBuffer sqlSB = new StringBuffer(
					"delete from  FeedBackRecord where id=");
			sqlSB.append(feed_back_record.getID());
			con.addSql(sqlSB.toString());
			con.doDML();
		} catch (ClassNotFoundException cnfe) {
			cnfe.printStackTrace();
		} catch (SQLException sqle) {
			sqle.printStackTrace();
		}
	}

	public void modifyToDB(Object object) {// 修改反馈情况时调用的方法
		FeedBackRecord feed_back_record = (FeedBackRecord) object;
		try {
			DBConnection con = new DBConnection();
			StringBuffer sqlSB = new StringBuffer("update  FeedBackRecord set ");
			sqlSB.append("AppealID=").append(feed_back_record.getAppealID())
					.append(",");
			sqlSB.append("Operater='").append(feed_back_record.getOperater())
					.append("',");
			sqlSB.append("OperateTime='").append(
					feed_back_record.getOperateTime()).append("',");
			sqlSB.append("Suggestion='").append(
					feed_back_record.getSuggestion()).append("' ");
			sqlSB.append("where id=").append(feed_back_record.getID());
			con.addSql(sqlSB.toString());
			con.doDML();
		} catch (ClassNotFoundException cnfe) {
			cnfe.printStackTrace();
		} catch (SQLException sqle) {
			sqle.printStackTrace();
		}
	}

	public ArrayList selectFromDB(Object object) {// 查询反馈情况时调用的方法

		FeedBackRecord feed_back_record = (FeedBackRecord) object;
		ArrayList valuesList = new ArrayList();
		CachedRowSet crs = null;
		try {
			DBConnection con = new DBConnection();
			StringBuffer sqlSB = new StringBuffer("");
			if (feed_back_record.getID() == 0) {
				sqlSB.append("select* from FeedBackRecord");
			}
			if (feed_back_record.getID() != -1 && feed_back_record.getID() != 0) {
				sqlSB.append("select* from FeedBackRecord where id=").append(
						feed_back_record.getID());
			}
			crs = con.getResultSet(sqlSB.toString());
			while (crs.next()) {
				FeedBackRecord feedbackRecord = new FeedBackRecord();
				feedbackRecord.setID(crs.getInt(1));
				feedbackRecord.setAppealID(crs.getInt(2));
				feedbackRecord.setOperater(crs.getInt(3));
				feedbackRecord.setOperateTime(crs.getString(4));
				feedbackRecord.setSuggestion(crs.getString(5));
				valuesList.add(feedbackRecord);
			}
		} catch (ClassNotFoundException cnfe) {
			cnfe.printStackTrace();
		} catch (SQLException sqle) {
			sqle.printStackTrace();
		}
		return valuesList;
	}
}