cexitemsadapter.java

我的系在线考试系统我的系在线考试系统我的系在线考试系统我的系在线考试系统我的系在线考试系统我的系在线考试系统我的系在线考试系统我的系在线考试系统

package net.intuitsoft.xeon.table.sale.ex;

import intuitsoft.eclipse.table.common.DatabaseConnection;
import intuitsoft.eclipse.table.common.ToolKit;
import intuitsoft.eclipse.table.common.WriteLog;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.LinkedList;
import java.util.List;

/**
 * <p>
 * Title: 零售连锁管理系统
 * </p>
 * <p>
 * Description: 零售业最佳应用
 * </p>
 * <p>
 * Copyright: Copyright (c) 1999 - 2004
 * </p>
 * <p>
 * Company: 直觉软件科技
 * </p>
 * 
 * @author: KENT
 * @version 1.0 Since 2004-03-22 04-10
 */

public class CExItemsAdapter extends ExItemsBean implements ExItemsAdapter {
	public CExItemsAdapter(String jndi) {
		super(jndi);
	}

	private String gdsStandard = "";

	public String getGdsStandard() {
		return this.gdsStandard;
	}

	public void setGdsStandard(String sV) {
		if (sV != null) {
			this.gdsStandard = sV;
		}
	}

	public List getItemsByExSheetCode(String code) {
		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		List list = null;

		ExItemsAdapter adapter = null;
		try {
			DatabaseConnection dc = new DatabaseConnection(getJndiName());
			conn = dc.getConnection();
			list = new LinkedList();

			String sql = "select a.id,c.gdsNo,c.gdsName,c.unit,c.gdsStandard from exItems a,goods c  where a.goodsID=c.goodsID and a.exSheetCode=? "
					+ ToolKit.getOrderSort(getJndiName());
			pstmt = conn.prepareStatement(sql);
			pstmt.setString(1, code);
			rs = pstmt.executeQuery();
			while (rs.next()) {
				adapter = new CExItemsAdapter(getJndiName());
				adapter.setID(rs.getInt("id"));
				adapter.content();
				adapter.setGdsNo(rs.getString("gdsNo"));
				adapter.setGdsName(rs.getString("gdsName"));
				adapter.setUnit(rs.getString("unit"));
				adapter.setGdsStandard(rs.getString("gdsStandard"));
				list.add(adapter);
			}
			return list;
		} catch (Exception ex) {
			ex.printStackTrace();
			new WriteLog(getJndiName(), 0, 10000, "core", "database", "kernel",
					this.getClass().getName() + ": " + ex.getMessage(), true, 0);
			return list;
		} finally {
			try {
				if (rs != null) {
					rs.close();
				}
				if (pstmt != null) {
					pstmt.close();
				}
				if (conn != null) {
					conn.close();
				}
			} catch (Exception ex) {
				ex.printStackTrace();
			}
		}
	}

	public boolean deleteByExSheetCode(String code) {
		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		try {
			DatabaseConnection dc = new DatabaseConnection(getJndiName());
			conn = dc.getConnection();
			String sql = "delete from exItems  where exSheetCode=?";
			pstmt = conn.prepareStatement(sql);
			pstmt.setString(1, code);

			pstmt.execute();
			return true;
		} catch (Exception ex) {
			ex.printStackTrace();
			new WriteLog(getJndiName(), 0, 10000, "core", "database", "kernel",
					this.getClass().getName() + ": " + ex.getMessage(), true, 0);
			return false;
		} finally {
			try {
				if (rs != null) {
					rs.close();
				}
				if (pstmt != null) {
					pstmt.close();
				}
				if (conn != null) {
					conn.close();
				}
			} catch (Exception ex) {
				ex.printStackTrace();
			}
		}
	}

}