📄 customerbean_b3dzi6__weblogic_cmp_rdbms.java
字号:
Debug.say("called findByCustomerName");
}
java.sql.Connection __WL_con = null;
java.sql.PreparedStatement __WL_stmt = null;
java.sql.ResultSet __WL_rs = null;
String selectForUpdate = __WL_pm.selectForUpdate();
try {
__WL_con = __WL_pm.getConnection();
}
catch (java.lang.Exception e) {
__WL_pm.releaseResources(__WL_con, __WL_stmt, __WL_rs);
throw new javax.ejb.FinderException("Couldn't get connection: " + EOL +
e.toString() + EOL +
RDBMSUtils.throwable2StackTrace(e));
}
try {
java.lang.String __WL_query = "SELECT WL0.customerName, WL0.abbreviation, WL0.address, WL0.bankAccount, WL0.bankName, WL0.companyPhone, WL0.creditlimit, WL0.customerZone, WL0.email, WL0.fax, WL0.fixedPhone, WL0.homesite, WL0.linkman, WL0.mobilePhone, WL0.pyCode, WL0.remark, WL0.zipCode FROM customer WL0 WHERE ( (WL0.customerName LIKE ? ) ) " + selectForUpdate;
if(__WL_verbose) {
Debug.say("Finder produced statement string " + __WL_query);
}
__WL_stmt = __WL_con.prepareStatement(__WL_query);
// preparedStatementParamIndex reset.
if (param0 == null) { __WL_stmt.setNull(1,java.sql.Types.VARCHAR); } else { __WL_stmt.setString(1, param0); }
__WL_rs = __WL_stmt.executeQuery();
}
catch (java.lang.Exception e) {
__WL_pm.releaseResources(__WL_con, __WL_stmt, __WL_rs);
throw new javax.ejb.FinderException(
"Exception in findByCustomerName while preparing or executing " +
"statement: '" + __WL_stmt + "'" + EOL +
e.toString() + EOL +
RDBMSUtils.throwable2StackTrace(e));
}
try {
java.util.Collection __WL_collection = new java.util.ArrayList(); stockmanagementpro.CustomerBean_b3dzi6__WebLogic_CMP_RDBMS __WL_bean = null;
Set __WL_pkSet = new HashSet();
while (__WL_rs.next()) {
Integer __WL_offsetIntObj = new Integer(0); Object __WL_pk = __WL_getPKFromRS(__WL_rs, __WL_offsetIntObj, __WL_classLoader); if (__WL_pk != null) { __WL_pkSet.add(__WL_pk); __WL_bean = (stockmanagementpro.CustomerBean_b3dzi6__WebLogic_CMP_RDBMS)__WL_pm.getBeanFromPool(); __WL_bean.__WL_initialize(); __WL_bean = __WL_loadGroup0FromRS(__WL_rs, __WL_offsetIntObj, __WL_bean); if (__WL_verbose) Debug.say("bean after finder load: " + __WL_bean); __WL_collection.add(__WL_bean); }
}
return __WL_collection;
} catch (java.sql.SQLException sqle) {
throw new javax.ejb.FinderException(
"Exception in 'findByCustomerName' while using " +
"result set: '" + __WL_rs + "'" + EOL +
sqle.toString() + EOL +
RDBMSUtils.throwable2StackTrace(sqle));
} catch (java.lang.Exception e) {
throw new javax.ejb.FinderException(
"Exception executing finder 'findByCustomerName': " + EOL +
e.toString() + EOL +
RDBMSUtils.throwable2StackTrace(e));
} finally {
__WL_pm.releaseResources(__WL_con, __WL_stmt, __WL_rs);
}
}public java.util.Collection ejbFindByCustomerZone(java.lang.String param0) throws javax.ejb.FinderException
{ if(__WL_verbose) {
Debug.say("called findByCustomerZone");
}
java.sql.Connection __WL_con = null;
java.sql.PreparedStatement __WL_stmt = null;
java.sql.ResultSet __WL_rs = null;
String selectForUpdate = __WL_pm.selectForUpdate();
try {
__WL_con = __WL_pm.getConnection();
}
catch (java.lang.Exception e) {
__WL_pm.releaseResources(__WL_con, __WL_stmt, __WL_rs);
throw new javax.ejb.FinderException("Couldn't get connection: " + EOL +
e.toString() + EOL +
RDBMSUtils.throwable2StackTrace(e));
}
try {
java.lang.String __WL_query = "SELECT WL0.customerName, WL0.abbreviation, WL0.address, WL0.bankAccount, WL0.bankName, WL0.companyPhone, WL0.creditlimit, WL0.customerZone, WL0.email, WL0.fax, WL0.fixedPhone, WL0.homesite, WL0.linkman, WL0.mobilePhone, WL0.pyCode, WL0.remark, WL0.zipCode FROM customer WL0 WHERE ( (WL0.customerZone LIKE ? ) ) " + selectForUpdate;
if(__WL_verbose) {
Debug.say("Finder produced statement string " + __WL_query);
}
__WL_stmt = __WL_con.prepareStatement(__WL_query);
// preparedStatementParamIndex reset.
if (param0 == null) { __WL_stmt.setNull(1,java.sql.Types.VARCHAR); } else { __WL_stmt.setString(1, param0); }
__WL_rs = __WL_stmt.executeQuery();
}
catch (java.lang.Exception e) {
__WL_pm.releaseResources(__WL_con, __WL_stmt, __WL_rs);
throw new javax.ejb.FinderException(
"Exception in findByCustomerZone while preparing or executing " +
"statement: '" + __WL_stmt + "'" + EOL +
e.toString() + EOL +
RDBMSUtils.throwable2StackTrace(e));
}
try {
java.util.Collection __WL_collection = new java.util.ArrayList(); stockmanagementpro.CustomerBean_b3dzi6__WebLogic_CMP_RDBMS __WL_bean = null;
Set __WL_pkSet = new HashSet();
while (__WL_rs.next()) {
Integer __WL_offsetIntObj = new Integer(0); Object __WL_pk = __WL_getPKFromRS(__WL_rs, __WL_offsetIntObj, __WL_classLoader); if (__WL_pk != null) { __WL_pkSet.add(__WL_pk); __WL_bean = (stockmanagementpro.CustomerBean_b3dzi6__WebLogic_CMP_RDBMS)__WL_pm.getBeanFromPool(); __WL_bean.__WL_initialize(); __WL_bean = __WL_loadGroup0FromRS(__WL_rs, __WL_offsetIntObj, __WL_bean); if (__WL_verbose) Debug.say("bean after finder load: " + __WL_bean); __WL_collection.add(__WL_bean); }
}
return __WL_collection;
} catch (java.sql.SQLException sqle) {
throw new javax.ejb.FinderException(
"Exception in 'findByCustomerZone' while using " +
"result set: '" + __WL_rs + "'" + EOL +
sqle.toString() + EOL +
RDBMSUtils.throwable2StackTrace(sqle));
} catch (java.lang.Exception e) {
throw new javax.ejb.FinderException(
"Exception executing finder 'findByCustomerZone': " + EOL +
e.toString() + EOL +
RDBMSUtils.throwable2StackTrace(e));
} finally {
__WL_pm.releaseResources(__WL_con, __WL_stmt, __WL_rs);
}
}public java.util.Collection ejbFindCreditCustomer() throws javax.ejb.FinderException
{ if(__WL_verbose) {
Debug.say("called findCreditCustomer");
}
java.sql.Connection __WL_con = null;
java.sql.PreparedStatement __WL_stmt = null;
java.sql.ResultSet __WL_rs = null;
String selectForUpdate = __WL_pm.selectForUpdate();
try {
__WL_con = __WL_pm.getConnection();
}
catch (java.lang.Exception e) {
__WL_pm.releaseResources(__WL_con, __WL_stmt, __WL_rs);
throw new javax.ejb.FinderException("Couldn't get connection: " + EOL +
e.toString() + EOL +
RDBMSUtils.throwable2StackTrace(e));
}
try {
java.lang.String __WL_query = "SELECT WL0.customerName, WL0.abbreviation, WL0.address, WL0.bankAccount, WL0.bankName, WL0.companyPhone, WL0.creditlimit, WL0.customerZone, WL0.email, WL0.fax, WL0.fixedPhone, WL0.homesite, WL0.linkman, WL0.mobilePhone, WL0.pyCode, WL0.remark, WL0.zipCode FROM customer WL0 WHERE ( (WL0.creditlimit > 0) ) " + selectForUpdate;
if(__WL_verbose) {
Debug.say("Finder produced statement string " + __WL_query);
}
__WL_stmt = __WL_con.prepareStatement(__WL_query);
// preparedStatementParamIndex reset.
__WL_rs = __WL_stmt.executeQuery();
}
catch (java.lang.Exception e) {
__WL_pm.releaseResources(__WL_con, __WL_stmt, __WL_rs);
throw new javax.ejb.FinderException(
"Exception in findCreditCustomer while preparing or executing " +
"statement: '" + __WL_stmt + "'" + EOL +
e.toString() + EOL +
RDBMSUtils.throwable2StackTrace(e));
}
try {
java.util.Collection __WL_collection = new java.util.ArrayList(); stockmanagementpro.CustomerBean_b3dzi6__WebLogic_CMP_RDBMS __WL_bean = null;
Set __WL_pkSet = new HashSet();
while (__WL_rs.next()) {
Integer __WL_offsetIntObj = new Integer(0); Object __WL_pk = __WL_getPKFromRS(__WL_rs, __WL_offsetIntObj, __WL_classLoader); if (__WL_pk != null) { __WL_pkSet.add(__WL_pk); __WL_bean = (stockmanagementpro.CustomerBean_b3dzi6__WebLogic_CMP_RDBMS)__WL_pm.getBeanFromPool(); __WL_bean.__WL_initialize(); __WL_bean = __WL_loadGroup0FromRS(__WL_rs, __WL_offsetIntObj, __WL_bean); if (__WL_verbose) Debug.say("bean after finder load: " + __WL_bean); __WL_collection.add(__WL_bean); }
}
return __WL_collection;
} catch (java.sql.SQLException sqle) {
throw new javax.ejb.FinderException(
"Exception in 'findCreditCustomer' while using " +
"result set: '" + __WL_rs + "'" + EOL +
sqle.toString() + EOL +
RDBMSUtils.throwable2StackTrace(sqle));
} catch (java.lang.Exception e) {
throw new javax.ejb.FinderException(
"Exception executing finder 'findCreditCustomer': " + EOL +
e.toString() + EOL +
RDBMSUtils.throwable2StackTrace(e));
} finally {
__WL_pm.releaseResources(__WL_con, __WL_stmt, __WL_rs);
}
}public javax.ejb.EntityBean ejbFindByPrimaryKey(java.lang.String param0) throws javax.ejb.FinderException
{ if(__WL_verbose) {
Debug.say("called findByPrimaryKey.");
}
java.sql.Connection __WL_con = null;
java.sql.PreparedStatement __WL_stmt = null;
java.sql.ResultSet __WL_rs = null;
stockmanagementpro.CustomerBean_b3dzi6__WebLogic_CMP_RDBMS __WL_bean = null;
String selectForUpdate = __WL_pm.selectForUpdate();
try {
__WL_con = __WL_pm.getConnection();
}
catch (java.lang.Exception e) {
__WL_pm.releaseResources(__WL_con, __WL_stmt, __WL_rs);
throw new javax.ejb.FinderException("Couldn't get connection: " + EOL +
e.toString() + EOL +
RDBMSUtils.throwable2StackTrace(e));
}
try {
java.lang.String __WL_query = "SELECT WL0.customerName, WL0.abbreviation, WL0.address, WL0.bankAccount, WL0.bankName, WL0.companyPhone, WL0.creditlimit, WL0.customerZone, WL0.email, WL0.fax, WL0.fixedPhone, WL0.homesite, WL0.linkman, WL0.mobilePhone, WL0.pyCode, WL0.remark, WL0.zipCode FROM customer WL0 WHERE ( (WL0.customerName = ?) ) " + selectForUpdate;
if(__WL_verbose) {
Debug.say("Finder produced statement string " + __WL_query);
}
__WL_stmt = __WL_con.prepareStatement(__WL_query);
// preparedStatementParamIndex reset.
if (param0 == null) { __WL_stmt.setNull(1,java.sql.Types.VARCHAR); } else { __WL_stmt.setString(1, param0); }
__WL_rs = __WL_stmt.executeQuery();
Set __WL_pkSet = new HashSet();
while (__WL_rs.next()) {
Integer __WL_offsetIntObj = new Integer(0); Object __WL_pk = __WL_getPKFromRS(__WL_rs, __WL_offsetIntObj, __WL_classLoader); if (__WL_pk != null) { __WL_pkSet.add(__WL_pk); __WL_bean = (stockmanagementpro.CustomerBean_b3dzi6__WebLogic_CMP_RDBMS)__WL_pm.getBeanFromPool(); __WL_bean.__WL_initialize(); __WL_bean = __WL_loadGroup0FromRS(__WL_rs, __WL_offsetIntObj, __WL_bean); if (__WL_verbose) Debug.say("bean after finder load: " + __WL_bean); }
}
if (__WL_pkSet.size() == 0) {
if(__WL_verbose) {
Debug.say("Throwing FinderException because bean wasn't found.");
}
throw new javax.ejb.ObjectNotFoundException("Bean with primary key '" + param0.toString() + "' was not found by 'findByPrimaryKey'.");
}
if (__WL_pkSet.size() != 1) {
throw new javax.ejb.FinderException("finder/ejbSelect 'findByPrimaryKey'" +
"has returned more than one value. We were expecting only ONE value. "+
" See EJB Spec 10.5.6.1, 10.5.7.1");
}
return __WL_bean;
} catch (javax.ejb.FinderException fe) {
throw fe;
} catch (java.sql.SQLException sqle) {
throw new javax.ejb.FinderException(
"Problem in findByPrimaryKey while preparing or executing " +
"statement: '" +
__WL_stmt + "': " + EOL +
sqle.toString() + EOL +
RDBMSUtils.throwable2StackTrace(sqle));
} catch (Exception e) {
throw new javax.ejb.FinderException(
"Exception raised in findByPrimaryKey " + EOL +
e.toString() + EOL +
RDBMSUtils.throwable2StackTrace(e));
} finally {
__WL_pm.releaseResources(__WL_con, __WL_stmt, __WL_rs);
}
}
// loadGroup method for the 'defaultGroup' group. public void __WL_loadGroup0() throws Exception {
java.sql.Connection __WL_con = null;
java.sql.PreparedStatement __WL_stmt = null;
java.sql.ResultSet __WL_rs = null;
String selectForUpdate = __WL_pm.selectForUpdate();
try {
if (__WL_verbose) {
Debug.say("__WL_loadGroup0 for pk=" + __WL_ctx.getPrimaryKey());
}
java.lang.String __WL_pk = (java.lang.String) __WL_ctx.getPrimaryKey();
__WL_con = __WL_pm.getConnection();
java.lang.String __WL_query =
"SELECT WL0.abbreviation, WL0.address, WL0.bankAccount, WL0.bankName, WL0.companyPhone, WL0.creditlimit, WL0.customerName, WL0.customerZone, WL0.email, WL0.fax, WL0.fixedPhone, WL0.homesite, WL0.linkman, WL0.mobilePhone, WL0.pyCode, WL0.remark, WL0.zipCode FROM customer WL0 WHERE WL0.customerName = ? " +
selectForUpdate;
__WL_stmt = __WL_con.prepareStatement(__WL_query);
// preparedStatementParamIndex reset.
if(!__WL_pm.setParamNull(__WL_stmt, 1, __WL_pk, "customerName")) { __WL_stmt.setString(1, __WL_pk); }
if (__WL_verbose) {
Debug.say("__WL_loadGroup0 for pk=" + __WL_ctx.getPrimaryKey() +
", executeQuery: "+__WL_query);
}
__WL_rs = __WL_stmt.executeQuery();
if (__WL_rs.next()) {
if (__WL_verbose) {
Debug.say("__WL_loadGroup0 for pk=" + __WL_ctx.getPrimaryKey() +
" now read columns from Results.");
}
if (!(this.__WL_isLoaded[3] || this.__WL_isModified[3])) { this.abbreviation = (java.lang.String)__WL_rs.getString(1+__WL_offset); if (__WL_rs.wasNull()) { this.abbreviation = null; } }⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -