📄 productbasicinfoent_d8yiog__weblogic_cmp_rdbms.java
字号:
int selectForUpdateVal = __WL_pm.getSelectForUpdateValue();
java.lang.String __WL_query = null;
switch(selectForUpdateVal) {
case DDConstants.SELECT_FOR_UPDATE_DISABLED:
__WL_query = "SELECT WL0.c_pid, WL0.c_image, WL0.c_pmodel, WL0.c_pname, WL0.c_premark, WL0.c_pspec, WL0.c_ptid, WL0.c_puname FROM c_pBasicInfo WL0 WHERE ( ( WL0.c_ptid = ? ) AND ( ( WL0.c_pspec LIKE ? ) ) )";
break;
case DDConstants.SELECT_FOR_UPDATE:
__WL_query = "SELECT WL0.c_pid, WL0.c_image, WL0.c_pmodel, WL0.c_pname, WL0.c_premark, WL0.c_pspec, WL0.c_ptid, WL0.c_puname FROM c_pBasicInfo WL0 WHERE ( ( WL0.c_ptid = ? ) AND ( ( WL0.c_pspec LIKE ? ) ) ) FOR UPDATE ";
break;
case DDConstants.SELECT_FOR_UPDATE_NO_WAIT:
__WL_query = "SELECT WL0.c_pid, WL0.c_image, WL0.c_pmodel, WL0.c_pname, WL0.c_premark, WL0.c_pspec, WL0.c_ptid, WL0.c_puname FROM c_pBasicInfo WL0 WHERE ( ( WL0.c_ptid = ? ) AND ( ( WL0.c_pspec LIKE ? ) ) ) FOR UPDATE NOWAIT ";
break;
default:
throw new AssertionError(
"Unknown selectForUpdate type: '"+selectForUpdateVal+"'");
}
if(__WL_verbose) {
Debug.say("Finder produced statement string " + __WL_query);
}
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 {
__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);if (__WL_verbose) {Debug.say("paramIdx :"+1+" binded with value :"+param0);}}if (param1 == null) {__WL_stmt.setNull(2,java.sql.Types.VARCHAR);} else {__WL_stmt.setString(2, param1);if (__WL_verbose) {Debug.say("paramIdx :"+2+" binded with value :"+param1);}}
__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 find_spec while preparing or executing " +
"statement: '" + __WL_stmt + "'" + EOL +
e.toString() + EOL +
RDBMSUtils.throwable2StackTrace(e));
}
try {
java.util.Collection __WL_collection = new java.util.ArrayList();product.productBasicInfoEnt_d8yiog__WebLogic_CMP_RDBMS __WL_bean = null;Object __WL_eo = null;Object __WL_eo_rc = null;
Map __WL_pkMap = new HashMap();
while (__WL_rs.next()) {
Integer __WL_offsetIntObj = new Integer(0);Object __WL_pk = __WL_getPKFromRS(__WL_rs, __WL_offsetIntObj, __WL_classLoader);__WL_eo = null;if (__WL_pk != null) { RSInfo __WL_rsInfo = new RSInfoImpl(__WL_rs, 0, 0, __WL_pk);__WL_bean = (product.productBasicInfoEnt_d8yiog__WebLogic_CMP_RDBMS)__WL_pm.getBeanFromRS(__WL_pk, __WL_rsInfo);__WL_eo = __WL_pm.finderGetEoFromBeanOrPk(__WL_bean, __WL_pk, __WL_getIsLocal());if (__WL_verbose) Debug.say("bean after finder load: " + __WL_bean);__WL_collection.add(__WL_eo);Object __WL_retVal = __WL_pkMap.put(__WL_pk, __WL_bean);}
}
return __WL_collection;
} catch (java.sql.SQLException sqle) {
throw new javax.ejb.FinderException(
"Exception in 'find_spec' 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 'find_spec': " + EOL +
e.toString() + EOL +
RDBMSUtils.throwable2StackTrace(e));
} finally {
__WL_pm.releaseResources(__WL_con, __WL_stmt, __WL_rs);
}
}public java.util.Collection ejbFind_id(java.lang.String param0, java.lang.String param1
) throws javax.ejb.FinderException
{ if(__WL_verbose) {
Debug.say("called find_id");
}
java.sql.Connection __WL_con = null;
java.sql.PreparedStatement __WL_stmt = null;
java.sql.ResultSet __WL_rs = null;
int __WL_offset = 0;
__WL_pm.flushModifiedBeans();
int selectForUpdateVal = __WL_pm.getSelectForUpdateValue();
java.lang.String __WL_query = null;
switch(selectForUpdateVal) {
case DDConstants.SELECT_FOR_UPDATE_DISABLED:
__WL_query = "SELECT WL0.c_pid, WL0.c_image, WL0.c_pmodel, WL0.c_pname, WL0.c_premark, WL0.c_pspec, WL0.c_ptid, WL0.c_puname FROM c_pBasicInfo WL0 WHERE ( ( WL0.c_ptid = ? ) AND ( ( WL0.c_pid LIKE ? ) ) )";
break;
case DDConstants.SELECT_FOR_UPDATE:
__WL_query = "SELECT WL0.c_pid, WL0.c_image, WL0.c_pmodel, WL0.c_pname, WL0.c_premark, WL0.c_pspec, WL0.c_ptid, WL0.c_puname FROM c_pBasicInfo WL0 WHERE ( ( WL0.c_ptid = ? ) AND ( ( WL0.c_pid LIKE ? ) ) ) FOR UPDATE ";
break;
case DDConstants.SELECT_FOR_UPDATE_NO_WAIT:
__WL_query = "SELECT WL0.c_pid, WL0.c_image, WL0.c_pmodel, WL0.c_pname, WL0.c_premark, WL0.c_pspec, WL0.c_ptid, WL0.c_puname FROM c_pBasicInfo WL0 WHERE ( ( WL0.c_ptid = ? ) AND ( ( WL0.c_pid LIKE ? ) ) ) FOR UPDATE NOWAIT ";
break;
default:
throw new AssertionError(
"Unknown selectForUpdate type: '"+selectForUpdateVal+"'");
}
if(__WL_verbose) {
Debug.say("Finder produced statement string " + __WL_query);
}
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 {
__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);if (__WL_verbose) {Debug.say("paramIdx :"+1+" binded with value :"+param0);}}if (param1 == null) {__WL_stmt.setNull(2,java.sql.Types.VARCHAR);} else {__WL_stmt.setString(2, param1);if (__WL_verbose) {Debug.say("paramIdx :"+2+" binded with value :"+param1);}}
__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 find_id while preparing or executing " +
"statement: '" + __WL_stmt + "'" + EOL +
e.toString() + EOL +
RDBMSUtils.throwable2StackTrace(e));
}
try {
java.util.Collection __WL_collection = new java.util.ArrayList();product.productBasicInfoEnt_d8yiog__WebLogic_CMP_RDBMS __WL_bean = null;Object __WL_eo = null;Object __WL_eo_rc = null;
Map __WL_pkMap = new HashMap();
while (__WL_rs.next()) {
Integer __WL_offsetIntObj = new Integer(0);Object __WL_pk = __WL_getPKFromRS(__WL_rs, __WL_offsetIntObj, __WL_classLoader);__WL_eo = null;if (__WL_pk != null) { RSInfo __WL_rsInfo = new RSInfoImpl(__WL_rs, 0, 0, __WL_pk);__WL_bean = (product.productBasicInfoEnt_d8yiog__WebLogic_CMP_RDBMS)__WL_pm.getBeanFromRS(__WL_pk, __WL_rsInfo);__WL_eo = __WL_pm.finderGetEoFromBeanOrPk(__WL_bean, __WL_pk, __WL_getIsLocal());if (__WL_verbose) Debug.say("bean after finder load: " + __WL_bean);__WL_collection.add(__WL_eo);Object __WL_retVal = __WL_pkMap.put(__WL_pk, __WL_bean);}
}
return __WL_collection;
} catch (java.sql.SQLException sqle) {
throw new javax.ejb.FinderException(
"Exception in 'find_id' 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 'find_id': " + EOL +
e.toString() + EOL +
RDBMSUtils.throwable2StackTrace(e));
} finally {
__WL_pm.releaseResources(__WL_con, __WL_stmt, __WL_rs);
}
}public java.util.Collection ejbFind_model(java.lang.String param0, java.lang.String param1
) throws javax.ejb.FinderException
{ if(__WL_verbose) {
Debug.say("called find_model");
}
java.sql.Connection __WL_con = null;
java.sql.PreparedStatement __WL_stmt = null;
java.sql.ResultSet __WL_rs = null;
int __WL_offset = 0;
__WL_pm.flushModifiedBeans();
int selectForUpdateVal = __WL_pm.getSelectForUpdateValue();
java.lang.String __WL_query = null;
switch(selectForUpdateVal) {
case DDConstants.SELECT_FOR_UPDATE_DISABLED:
__WL_query = "SELECT WL0.c_pid, WL0.c_image, WL0.c_pmodel, WL0.c_pname, WL0.c_premark, WL0.c_pspec, WL0.c_ptid, WL0.c_puname FROM c_pBasicInfo WL0 WHERE ( ( WL0.c_ptid = ? ) AND ( ( WL0.c_pmodel LIKE ? ) ) )";
break;
case DDConstants.SELECT_FOR_UPDATE:
__WL_query = "SELECT WL0.c_pid, WL0.c_image, WL0.c_pmodel, WL0.c_pname, WL0.c_premark, WL0.c_pspec, WL0.c_ptid, WL0.c_puname FROM c_pBasicInfo WL0 WHERE ( ( WL0.c_ptid = ? ) AND ( ( WL0.c_pmodel LIKE ? ) ) ) FOR UPDATE ";
break;
case DDConstants.SELECT_FOR_UPDATE_NO_WAIT:
__WL_query = "SELECT WL0.c_pid, WL0.c_image, WL0.c_pmodel, WL0.c_pname, WL0.c_premark, WL0.c_pspec, WL0.c_ptid, WL0.c_puname FROM c_pBasicInfo WL0 WHERE ( ( WL0.c_ptid = ? ) AND ( ( WL0.c_pmodel LIKE ? ) ) ) FOR UPDATE NOWAIT ";
break;
default:
throw new AssertionError(
"Unknown selectForUpdate type: '"+selectForUpdateVal+"'");
}
if(__WL_verbose) {
Debug.say("Finder produced statement string " + __WL_query);
}
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 {
__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);if (__WL_verbose) {Debug.say("paramIdx :"+1+" binded with value :"+param0);}}if (param1 == null) {__WL_stmt.setNull(2,java.sql.Types.VARCHAR);} else {__WL_stmt.setString(2, param1);if (__WL_verbose) {Debug.say("paramIdx :"+2+" binded with value :"+param1);}}
__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 find_model while preparing or executing " +
"statement: '" + __WL_stmt + "'" + EOL +
e.toString() + EOL +
RDBMSUtils.throwable2StackTrace(e));
}
try {
java.util.Collection __WL_collection = new java.util.ArrayList();product.productBasicInfoEnt_d8yiog__WebLogic_CMP_RDBMS __WL_bean = null;Object __WL_eo = null;Object __WL_eo_rc = null;
Map __WL_pkMap = new HashMap();
while (__WL_rs.next()) {
Integer __WL_offsetIntObj = new Integer(0);Object __WL_pk = __WL_getPKFromRS(__WL_rs, __WL_offsetIntObj, __WL_classLoader);__WL_eo = null;if (__WL_pk != null) { RSInfo __WL_rsInfo = new RSInfoImpl(__WL_rs, 0, 0, __WL_pk);__WL_bean = (product.productBasicInfoEnt_d8yiog__WebLogic_CMP_RDBMS)__WL_pm.getBeanFromRS(__WL_pk, __WL_rsInfo);__WL_eo = __WL_pm.finderGetEoFromBeanOrPk(__WL_bean, __WL_pk, __WL_getIsLocal());if (__WL_verbose) Debug.say("bean after finder load: " + __WL_bean);__WL_collection.add(__WL_eo);Object __WL_retVal = __WL_pkMap.put(__WL_pk, __WL_bean);}
}
return __WL_collection;
} catch (java.sql.SQLException sqle) {
throw new javax.ejb.FinderException(
"Exception in 'find_model' 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 'find_model': " + EOL +
e.toString() + EOL +
RDBMSUtils.throwable2StackTrace(e));
} finally {
__WL_pm.releaseResources(__WL_con, __WL_stmt, __WL_rs);
}
}public java.lang.Object ejbFind_basic_mpk() throws javax.ejb.FinderException
{ if(__WL_verbose) {
Debug.say("called find_basic_mpk.");
}
java.sql.Connection __WL_con = null;
java.sql.PreparedStatement __WL_stmt = null;
java.sql.ResultSet __WL_rs = null;
int __WL_offset = 0;
product.productBasicInfoEnt_d8yiog__WebLogic_CMP_RDBMS __WL_bean = null;Object __WL_eo = null;Object __WL_eo_rc = null;
__WL_pm.flushModifiedBeans();
int selectForUpdateVal = __WL_pm.getSelectForUpdateValue();
java.lang.String __WL_query = null;
switch(selectForUpdateVal) {
case DDConstants.SELECT_FOR_UPDATE_DISABLED:
__WL_query = "SELECT WL0.c_pid, WL0.c_image, WL0.c_pmodel, WL0.c_pname, WL0.c_premark, WL0.c_pspec, WL0.c_ptid, WL0.c_puname FROM c_pBasicInfo WL0 WHERE ( WL0.c_pid = ( SELECT MAX(WL1.c_pid ) FROM c_pBasicInfo WL1 ) )";
break;
case DDConstants.SELECT_FOR_UPDATE:
__WL_query = "SELECT WL0.c_pid, WL0.c_image, WL0.c_pmodel, WL0.c_pname, WL0.c_premark, WL0.c_pspec, WL0.c_ptid, WL0.c_puname FROM c_pBasicInfo WL0 WHERE ( WL0.c_pid = ( SELECT MAX(WL1.c_pid ) FROM c_pBasicInfo WL1 ) ) FOR UPDATE ";
break;
case DDConstants.SELECT_FOR_UPDATE_NO_WAIT:
__WL_query = "SELECT WL0.c_pid, WL0.c_image, WL0.c_pmodel, WL0.c_pname, WL0.c_premark, WL0.c_pspec, WL0.c_ptid, WL0.c_puname FROM c_pBasicInfo WL0 WHERE ( WL0.c_pid = ( SELECT MAX(WL1.c_pid ) FROM c_pBasicInfo WL1 ) ) FOR UPDATE NOWAIT ";
break;
default:
throw new AssertionError(
"Unknown selectForUpdate type: '"+selectForUpdateVal+"'");
}
if(__WL_verbose) {
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -