goodtypeoperate.java

JAVA实现的酒店管理系统

package file1;

import javax.swing.*;
import java.sql.*;
import java.util.ArrayList;
import sun.jdbc.rowset.*;

/*
 * 功能描述:针对货品类型记录的操作类，实现对货品类型的增删改查操作
 * @Author:黄顺武
 * Create Time:2007-12-9
 * Modify Reason:数据库连接类DBConnection 的内部结构设计得到优化
 */
public class GoodTypeOperate implements Operate {

	public GoodTypeOperate() {
	}

	public void insertToDB(Object object) {// 增加货品类型记录时调用的方法
		DBConnection con = new DBConnection();
		GoodType goodtype = (GoodType) object;
		String typeName = goodtype.getTypeName();
		String query = "select* from GoodType where typeName='" + typeName
				+ "'";
		try {
			CachedRowSet crs = con.getResultSet(query);
			if (crs.next()) {
				JOptionPane.showMessageDialog(null, "该记录已经存在!", "提示",
						JOptionPane.INFORMATION_MESSAGE);
				return;
			}
		} catch (SQLException sqle) {
			sqle.printStackTrace();
		} catch (ClassNotFoundException cnfe) {
			cnfe.printStackTrace();
		}
		String sqlStr = "insert into GoodType values('" + typeName + "')";
		con.addSql(sqlStr);
		try {
			con.doDML();
		} catch (SQLException sqle) {
			sqle.printStackTrace();
		} catch (ClassNotFoundException cnfe) {
			cnfe.printStackTrace();
		}
	}

	public void deleteFromDB(Object object) {// 删除货品类型记录时调用的方法
		DBConnection con = new DBConnection();
		GoodType goodtype = (GoodType) object;
		String sqlStr = "delete from GoodType where ID=" + goodtype.getID();
		con.addSql(sqlStr);
		try {
			con.doDML();
		} catch (SQLException sqle) {
			sqle.printStackTrace();
		} catch (ClassNotFoundException cnfe) {
			cnfe.printStackTrace();
		}
	}

	public void modifyToDB(Object object) {// 修改货品类型记录时调用的方法
		DBConnection con = new DBConnection();
		GoodType goodtype = (GoodType) object;
		String sqlStr = "update GoodType set typeName='"
				+ goodtype.getTypeName() + "' where ID=" + goodtype.getID();
		con.addSql(sqlStr);
		try {
			con.doDML();
		} catch (SQLException sqle) {
			sqle.printStackTrace();
		} catch (ClassNotFoundException cnfe) {
			cnfe.printStackTrace();
		}
	}

	public ArrayList selectFromDB(Object object) {// 查询货品类型记录时调用的方法
		DBConnection con = new DBConnection();
		GoodType goodtype = (GoodType) object;
		ArrayList valuesList = new ArrayList();
		StringBuffer sqlsb = new StringBuffer("");
		CachedRowSet crs = null;
		if (goodtype.getID() == 0) {// 表示查询数据库中的全部货品类型记录，传参数的时候一定要注意
			sqlsb.append("select* from GoodType");
		}
		if (goodtype.getID() != -1 && goodtype.getID() != 0) {// 表示查询数据库中的某一货品类型记录，传参数的时候一定要注意
			sqlsb.append("select* from GoodType where id=" + goodtype.getID());
		}
		try {
			crs = con.getResultSet(sqlsb.toString());
			while (crs.next()) {
				GoodType newGoodTypeInstance = new GoodType();
				newGoodTypeInstance.setID(crs.getInt(1));
				newGoodTypeInstance.setTypeName(crs.getString(2).trim());
				valuesList.add(newGoodTypeInstance);
			}
		} catch (SQLException sqle) {
			sqle.printStackTrace();
		} catch (ClassNotFoundException cnfe) {
			cnfe.printStackTrace();
		}
		return valuesList;
	}
}