companybeanfunctionset_eb9e26f7.java

j2ee源码

package com.leeman.wkexs.master.company.dao.websphere_deploy.ORACLE_V9_1;

import com.ibm.websphere.rsadapter.WSInteractionSpec;
import com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException;
import javax.resource.cci.Record;
import javax.resource.cci.IndexedRecord;
import java.sql.*;

/**
 * CompanyBeanFunctionSet_eb9e26f7
 */
public class CompanyBeanFunctionSet_eb9e26f7 extends com.ibm.ws.rsadapter.cci.WSResourceAdapterBase implements com.ibm.websphere.rsadapter.DataAccessFunctionSet {
	private java.util.HashMap functionHash;
	/**
	 * Create
	 */
	public void Create(IndexedRecord inputRecord, Object connection, WSInteractionSpec interactionSpec) throws DataStoreAdapterException {
		PreparedStatement pstmt = null;
		try {
			pstmt = prepareStatement(connection,"INSERT INTO WKEXS.COMPANY (COMPANY_ID, COMPANY_NAME_CHT, COMPANY_NAME_CHS, COMPANY_NAME_ENG, COMPANY_CHOP_NAME_CHT, COMPANY_CHOP_NAME_CHS, COMPANY_CHOP_NAME_ENG, COMPANY_ADDRESS_CHT, COMPANY_ADDRESS_CHS, COMPANY_ADDRESS_ENG, BASE_CURRENCY, POSTAL_CD, TELEPHONE, FAX, EMAIL, ACTIVE, CREATE_DTTM, CREATE_BY, LAST_MODIFY_DTTM, LAST_MODIFY_BY, COMPANY_PREFIX_CD, LAST_MTH_END, BANK_ID, COMPANY_DESC_ENG, COMPANY_DESC_CHT, COMPANY_DESC_CHS, CUSTOMER_PREFIX_CD) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");

			// For column COMPANY_ID
			{
				String tempString;


				tempString=(String)inputRecord.get(0);
				if(tempString==null)
					pstmt.setNull(1,java.sql.Types.VARCHAR);
				else
					pstmt.setString(1,tempString);
			}
			// For column COMPANY_NAME_CHT
			{
				String tempString;


				tempString=(String)inputRecord.get(1);
				if(tempString==null)
					pstmt.setNull(2,java.sql.Types.VARCHAR);
				else
					pstmt.setString(2,tempString);
			}
			// For column COMPANY_NAME_CHS
			{
				String tempString;


				tempString=(String)inputRecord.get(2);
				if(tempString==null)
					pstmt.setNull(3,java.sql.Types.VARCHAR);
				else
					pstmt.setString(3,tempString);
			}
			// For column COMPANY_NAME_ENG
			{
				String tempString;


				tempString=(String)inputRecord.get(3);
				if(tempString==null)
					pstmt.setNull(4,java.sql.Types.VARCHAR);
				else
					pstmt.setString(4,tempString);
			}
			// For column COMPANY_CHOP_NAME_CHT
			{
				String tempString;


				tempString=(String)inputRecord.get(4);
				if(tempString==null)
					pstmt.setNull(5,java.sql.Types.VARCHAR);
				else
					pstmt.setString(5,tempString);
			}
			// For column COMPANY_CHOP_NAME_CHS
			{
				String tempString;


				tempString=(String)inputRecord.get(5);
				if(tempString==null)
					pstmt.setNull(6,java.sql.Types.VARCHAR);
				else
					pstmt.setString(6,tempString);
			}
			// For column COMPANY_CHOP_NAME_ENG
			{
				String tempString;


				tempString=(String)inputRecord.get(6);
				if(tempString==null)
					pstmt.setNull(7,java.sql.Types.VARCHAR);
				else
					pstmt.setString(7,tempString);
			}
			// For column COMPANY_ADDRESS_CHT
			{
				String tempString;


				tempString=(String)inputRecord.get(7);
				if(tempString==null)
					pstmt.setNull(8,java.sql.Types.VARCHAR);
				else
					pstmt.setString(8,tempString);
			}
			// For column COMPANY_ADDRESS_CHS
			{
				String tempString;


				tempString=(String)inputRecord.get(8);
				if(tempString==null)
					pstmt.setNull(9,java.sql.Types.VARCHAR);
				else
					pstmt.setString(9,tempString);
			}
			// For column COMPANY_ADDRESS_ENG
			{
				String tempString;


				tempString=(String)inputRecord.get(9);
				if(tempString==null)
					pstmt.setNull(10,java.sql.Types.VARCHAR);
				else
					pstmt.setString(10,tempString);
			}
			// For column BASE_CURRENCY
			{
				String tempString;


				tempString=(String)inputRecord.get(10);
				if(tempString==null)
					pstmt.setNull(11,java.sql.Types.VARCHAR);
				else
					pstmt.setString(11,tempString);
			}
			// For column POSTAL_CD
			{
				String tempString;


				tempString=(String)inputRecord.get(11);
				if(tempString==null)
					pstmt.setNull(12,java.sql.Types.VARCHAR);
				else
					pstmt.setString(12,tempString);
			}
			// For column TELEPHONE
			{
				String tempString;


				tempString=(String)inputRecord.get(12);
				if(tempString==null)
					pstmt.setNull(13,java.sql.Types.VARCHAR);
				else
					pstmt.setString(13,tempString);
			}
			// For column FAX
			{
				String tempString;


				tempString=(String)inputRecord.get(13);
				if(tempString==null)
					pstmt.setNull(14,java.sql.Types.VARCHAR);
				else
					pstmt.setString(14,tempString);
			}
			// For column EMAIL
			{
				String tempString;


				tempString=(String)inputRecord.get(14);
				if(tempString==null)
					pstmt.setNull(15,java.sql.Types.VARCHAR);
				else
					pstmt.setString(15,tempString);
			}
			// For column ACTIVE
			{
				String tempString;


				tempString=(String)inputRecord.get(15);
				if(tempString==null)
					pstmt.setNull(16,java.sql.Types.VARCHAR);
				else
					pstmt.setString(16,tempString);
			}
			// For column CREATE_DTTM
			{
				java.sql.Timestamp tempTimestamp;


				tempTimestamp=(java.sql.Timestamp)inputRecord.get(16);
				if(tempTimestamp==null)
					pstmt.setNull(17,java.sql.Types.TIMESTAMP);
				else
					pstmt.setTimestamp(17,tempTimestamp);
			}
			// For column CREATE_BY
			{
				String tempString;


				tempString=(String)inputRecord.get(17);
				if(tempString==null)
					pstmt.setNull(18,java.sql.Types.VARCHAR);
				else
					pstmt.setString(18,tempString);
			}
			// For column LAST_MODIFY_DTTM
			{
				java.sql.Timestamp tempTimestamp;


				tempTimestamp=(java.sql.Timestamp)inputRecord.get(18);
				if(tempTimestamp==null)
					pstmt.setNull(19,java.sql.Types.TIMESTAMP);
				else
					pstmt.setTimestamp(19,tempTimestamp);
			}
			// For column LAST_MODIFY_BY
			{
				String tempString;


				tempString=(String)inputRecord.get(19);
				if(tempString==null)
					pstmt.setNull(20,java.sql.Types.VARCHAR);
				else
					pstmt.setString(20,tempString);
			}
			// For column COMPANY_PREFIX_CD
			{
				String tempString;


				tempString=(String)inputRecord.get(20);
				if(tempString==null)
					pstmt.setNull(21,java.sql.Types.VARCHAR);
				else
					pstmt.setString(21,tempString);
			}
			// For column LAST_MTH_END
			{
				java.sql.Timestamp tempTimestamp;


				tempTimestamp=(java.sql.Timestamp)inputRecord.get(21);
				if(tempTimestamp==null)
					pstmt.setNull(22,java.sql.Types.TIMESTAMP);
				else
					pstmt.setTimestamp(22,tempTimestamp);
			}
			// For column BANK_ID
			{
				String tempString;


				tempString=(String)inputRecord.get(22);
				if(tempString==null)
					pstmt.setNull(23,java.sql.Types.VARCHAR);
				else
					pstmt.setString(23,tempString);
			}
			// For column COMPANY_DESC_ENG
			{
				String tempString;


				tempString=(String)inputRecord.get(23);
				if(tempString==null)
					pstmt.setNull(24,java.sql.Types.VARCHAR);
				else
					pstmt.setString(24,tempString);
			}
			// For column COMPANY_DESC_CHT
			{
				String tempString;


				tempString=(String)inputRecord.get(24);
				if(tempString==null)
					pstmt.setNull(25,java.sql.Types.VARCHAR);
				else
					pstmt.setString(25,tempString);
			}
			// For column COMPANY_DESC_CHS
			{
				String tempString;


				tempString=(String)inputRecord.get(25);
				if(tempString==null)
					pstmt.setNull(26,java.sql.Types.VARCHAR);
				else
					pstmt.setString(26,tempString);
			}
			// For column CUSTOMER_PREFIX_CD
			{
				String tempString;


				tempString=(String)inputRecord.get(26);
				if(tempString==null)
					pstmt.setNull(27,java.sql.Types.VARCHAR);
				else
					pstmt.setString(27,tempString);
			}
			if (pstmt.executeUpdate()==0)
				throw new DataStoreAdapterException("DSA_ERROR",new javax.ejb.NoSuchEntityException(), this.getClass());

		}
		catch (SQLException e) {
			throw new DataStoreAdapterException("DSA_ERROR", e ,this.getClass());
		}
		finally {
			try {
				if(pstmt != null) {
					returnPreparedStatement(connection, pstmt);
				}
			}
			catch (SQLException ignored)
			{}
		}
	}
	/**
	 * Remove
	 */
	public void Remove(IndexedRecord inputRecord, Object connection, WSInteractionSpec interactionSpec) throws DataStoreAdapterException {
		PreparedStatement pstmt = null;
		try {
			pstmt = prepareStatement(connection,"DELETE FROM WKEXS.COMPANY  WHERE COMPANY_ID = ?");

			// For column COMPANY_ID
			{
				String tempString;


				tempString=(String)inputRecord.get(0);
				if(tempString==null)
					pstmt.setNull(1,java.sql.Types.VARCHAR);
				else
					pstmt.setString(1,tempString);
			}
			if (pstmt.executeUpdate()==0)
				throw new DataStoreAdapterException("DSA_ERROR",new javax.ejb.NoSuchEntityException(), this.getClass());

		}
		catch (SQLException e) {
			throw new DataStoreAdapterException("DSA_ERROR", e ,this.getClass());
		}
		finally {
			try {
				if(pstmt != null) {
					returnPreparedStatement(connection, pstmt);
				}
			}
			catch (SQLException ignored)
			{}
		}
	}
	/**
	 * Store
	 */
	public void Store(IndexedRecord inputRecord, Object connection, WSInteractionSpec interactionSpec) throws DataStoreAdapterException {
		PreparedStatement pstmt = null;
		try {
			pstmt = prepareStatement(connection,"UPDATE WKEXS.COMPANY  SET COMPANY_NAME_CHT = ?, COMPANY_NAME_CHS = ?, COMPANY_NAME_ENG = ?, COMPANY_CHOP_NAME_CHT = ?, COMPANY_CHOP_NAME_CHS = ?, COMPANY_CHOP_NAME_ENG = ?, COMPANY_ADDRESS_CHT = ?, COMPANY_ADDRESS_CHS = ?, COMPANY_ADDRESS_ENG = ?, BASE_CURRENCY = ?, POSTAL_CD = ?, TELEPHONE = ?, FAX = ?, EMAIL = ?, ACTIVE = ?, CREATE_DTTM = ?, CREATE_BY = ?, LAST_MODIFY_DTTM = ?, LAST_MODIFY_BY = ?, COMPANY_PREFIX_CD = ?, LAST_MTH_END = ?, BANK_ID = ?, COMPANY_DESC_ENG = ?, COMPANY_DESC_CHT = ?, COMPANY_DESC_CHS = ?, CUSTOMER_PREFIX_CD = ? WHERE COMPANY_ID = ?");

			// For column COMPANY_ID
			{
				String tempString;


				tempString=(String)inputRecord.get(0);
				if(tempString==null)
					pstmt.setNull(27,java.sql.Types.VARCHAR);
				else
					pstmt.setString(27,tempString);
			}
			// For column COMPANY_NAME_CHT
			{
				String tempString;


				tempString=(String)inputRecord.get(1);
				if(tempString==null)
					pstmt.setNull(1,java.sql.Types.VARCHAR);
				else
					pstmt.setString(1,tempString);
			}
			// For column COMPANY_NAME_CHS
			{
				String tempString;


				tempString=(String)inputRecord.get(2);
				if(tempString==null)
					pstmt.setNull(2,java.sql.Types.VARCHAR);
				else
					pstmt.setString(2,tempString);
			}
			// For column COMPANY_NAME_ENG
			{
				String tempString;


				tempString=(String)inputRecord.get(3);
				if(tempString==null)
					pstmt.setNull(3,java.sql.Types.VARCHAR);
				else
					pstmt.setString(3,tempString);
			}
			// For column COMPANY_CHOP_NAME_CHT
			{
				String tempString;


				tempString=(String)inputRecord.get(4);
				if(tempString==null)
					pstmt.setNull(4,java.sql.Types.VARCHAR);
				else
					pstmt.setString(4,tempString);
			}
			// For column COMPANY_CHOP_NAME_CHS
			{
				String tempString;


				tempString=(String)inputRecord.get(5);
				if(tempString==null)
					pstmt.setNull(5,java.sql.Types.VARCHAR);
				else
					pstmt.setString(5,tempString);
			}
			// For column COMPANY_CHOP_NAME_ENG
			{
				String tempString;


				tempString=(String)inputRecord.get(6);
				if(tempString==null)
					pstmt.setNull(6,java.sql.Types.VARCHAR);
				else
					pstmt.setString(6,tempString);
			}
			// For column COMPANY_ADDRESS_CHT
			{
				String tempString;


				tempString=(String)inputRecord.get(7);
				if(tempString==null)
					pstmt.setNull(7,java.sql.Types.VARCHAR);
				else
					pstmt.setString(7,tempString);
			}
			// For column COMPANY_ADDRESS_CHS
			{
				String tempString;


				tempString=(String)inputRecord.get(8);
				if(tempString==null)
					pstmt.setNull(8,java.sql.Types.VARCHAR);
				else
					pstmt.setString(8,tempString);
			}
			// For column COMPANY_ADDRESS_ENG
			{
				String tempString;


				tempString=(String)inputRecord.get(9);
				if(tempString==null)
					pstmt.setNull(9,java.sql.Types.VARCHAR);
				else
					pstmt.setString(9,tempString);
			}
			// For column BASE_CURRENCY
			{
				String tempString;


				tempString=(String)inputRecord.get(10);
				if(tempString==null)
					pstmt.setNull(10,java.sql.Types.VARCHAR);
				else
					pstmt.setString(10,tempString);
			}
			// For column POSTAL_CD
			{
				String tempString;


				tempString=(String)inputRecord.get(11);
				if(tempString==null)
					pstmt.setNull(11,java.sql.Types.VARCHAR);
				else
					pstmt.setString(11,tempString);
			}
			// For column TELEPHONE
			{
				String tempString;


				tempString=(String)inputRecord.get(12);
				if(tempString==null)
					pstmt.setNull(12,java.sql.Types.VARCHAR);
				else
					pstmt.setString(12,tempString);
			}
			// For column FAX
			{
				String tempString;


				tempString=(String)inputRecord.get(13);
				if(tempString==null)
					pstmt.setNull(13,java.sql.Types.VARCHAR);
				else
					pstmt.setString(13,tempString);
			}
			// For column EMAIL
			{
				String tempString;


				tempString=(String)inputRecord.get(14);
				if(tempString==null)
					pstmt.setNull(14,java.sql.Types.VARCHAR);
				else
					pstmt.setString(14,tempString);
			}
			// For column ACTIVE
			{
				String tempString;


				tempString=(String)inputRecord.get(15);
				if(tempString==null)
					pstmt.setNull(15,java.sql.Types.VARCHAR);
				else
					pstmt.setString(15,tempString);
			}
			// For column CREATE_DTTM
			{
				java.sql.Timestamp tempTimestamp;