📄 gbs_mcustomer_db.java
字号:
rset.getTimestamp("RES_UPDATE_DATE", date);
date.add(Calendar.HOUR, plusHour);
stBean.setResUpdateDate(format.format(date.getTime()));
}
if (!BaseCommonCheck.isEmpty(rset.getString("STRING1"))) {
stBean.setString1(rset.getString("STRING1"));
}
if (!BaseCommonCheck.isEmpty(rset.getString("SUBSIDIARY_NAME"))) {
stBean.setSubsidiaryName(rset.getString("SUBSIDIARY_NAME"));
}
if (!BaseCommonCheck.isEmpty(rset.getString("REGION_NAME"))) {
stBean.setRegionName(rset.getString("REGION_NAME"));
}
if (!BaseCommonCheck.isEmpty(rset.getString("COUNTRY_NAME"))) {
stBean.setCountryName(rset.getString("COUNTRY_NAME"));
}
//Edit by Gxk 2004/09/09 Start
if (!BaseCommonCheck.isEmpty(rset.getString("DELETE_FLG"))
&& rset.getString("DELETE_FLG").equals("D")) {
stBean.setDeleteFlag("仜");
}
//Edit by Gxk 2004/09/09 End
hitCount++;
returnList.add(stBean);
}
}
if (hitCount == 0) {
messageList.setMessage("", "", "10000004", Integer.MIN_VALUE);
} else {
returnValue.setDataValue(returnList);
}
//END GET DATA
////////////////////////////////////////////////////////////////////////////
} catch (Exception exception) {
System.out.println("[Error Happen!]");
System.out.println("[Start Trace]");
exception.printStackTrace();
System.out.println("[End Trace]");
throw exception;
} finally { //CLOSE DB CONN
try {
if (rset != null) {
rset.close();
}
if (st != null) {
st.close();
}
if (conn != null) {
conn.close();
}
} catch (SQLException se) {
}
if (messageList.size() > 0) {
returnValue.setMessageList(messageList);
returnValue.setBussinessError();
}
}
return returnValue;
} /**
* select customer info by customerId
* @param customerId
* @return
* @throws Exception
*/
public ReturnValue selectByCustmerID(String customerId) throws Exception {
//Add by Gxk 2004/09/10 Start
customerId = BaseCommonCheck.convertSql(customerId);
//Add by Gxk 2004/09/10 End
StringBuffer sql = new StringBuffer();
ReturnValue returnValue = new ReturnValue();
MessageList messageList = new MessageList();
/////////////////////////////////////////////////////////////////////////////
//EDIT SQL
sql.append(" SELECT");
sql.append(" CUSTOMER_ID, ");
//屭媞ID
sql.append(" DISP_ORDER, ");
//昞帵弴彉
sql.append(" CUSTOMER_CATEGORY, ");
//屭媞暘椶
sql.append(" CUSTOMER_CODE, ");
//屭媞僐乕僪
sql.append(" CUSTOMER_NAME, ");
//屭媞柤
sql.append(" CUSTOMER_ABBR, ");
//屭媞棯柤
sql.append(" INDUSTRY, ");
//嬈奅
sql.append(" ADDR1, ");
//廧強侾
sql.append(" ADDR2, ");
//廧強俀
sql.append(" ZIP_CODE, ");
//梄曋斣崋
sql.append(" COUNTRY_CODE, ");
//崙僐乕僪
sql.append(" TELEPHONE, ");
//揹榖斣崋
sql.append(" FAX, ");
//FAX斣崋
sql.append(" E_MAIL, ");
//E_MAIL傾僪儗僗
sql.append(" CONTACT_PERSON, ");
//愭曽扴摉幰
sql.append(" URL, ");
//URL
sql.append(" DELETE_FLG, ");
//DELETE僼儔僌
// wxf modified at 2004.08.20 Start
//sql.append(" NUMBER_OF_EMPLOYEE, "); //廬嬈堳悢
sql.append(" TO_CHAR(NUMBER_OF_EMPLOYEE,'9,999,999') AS NUMBER_OF_EMPLOYEE, ");
//廬嬈堳悢
// wxf modified at 2004.08.20 End
sql.append(" CREATE_USER, ");
//嶌惉儐乕僓乕
sql.append(" CREATE_DATE, ");
//嶌惉擔帪
sql.append(" UPDATE_USER, ");
//峏怴儐乕僓乕
sql.append(" UPDATE_DATE ");
//峏怴擔帪
sql.append(" FROM");
sql.append(" M_CUSTOMER");
sql.append(" WHERE");
sql.append(" CUSTOMER_ID='" + customerId + "'");
sql.append(" AND ( DELETE_FLG <> 'D' OR DELETE_FLG IS NULL)");
System.out.println("[INFO] sql = " + sql.toString());
//END EDIT SQL
/////////////////////////////////////////////////////////////////////////////
ResultSet rset = null;
Connection conn = null;
Statement st = null;
try {
conn = this.datasource.getConnection();
st = conn.createStatement();
rset = st.executeQuery(sql.toString());
////////////////////////////////////////////////////////////////////////////
//GET DATA FROM DB RESULTSET
GBS_Customer_stBean stBean = new GBS_Customer_stBean();
int hitCount = 0;
while (rset.next()) {
stBean.setCustomerID(rset.getString("CUSTOMER_ID"));
stBean.setDispOrder(rset.getString("DISP_ORDER"));
stBean.setCustomerCategory(rset.getString("CUSTOMER_CATEGORY"));
stBean.setCustomerCode(rset.getString("CUSTOMER_CODE"));
stBean.setCustomerName(rset.getString("CUSTOMER_NAME"));
stBean.setCustomerAbbr(rset.getString("CUSTOMER_ABBR"));
stBean.setIndustry(rset.getString("INDUSTRY"));
stBean.setAddr1(rset.getString("ADDR1"));
stBean.setAddr2(rset.getString("ADDR2"));
stBean.setZipCode(rset.getString("ZIP_CODE"));
stBean.setCountryCode(rset.getString("COUNTRY_CODE"));
stBean.setTelephone(rset.getString("TELEPHONE"));
stBean.setFax(rset.getString("FAX"));
stBean.setEmail(rset.getString("E_MAIL"));
stBean.setContactPerson(rset.getString("CONTACT_PERSON"));
stBean.setUrl(rset.getString("URL"));
stBean.setDeleteFlg(rset.getString("DELETE_FLG"));
stBean.setNumberOfEmployee(rset.getString("NUMBER_OF_EMPLOYEE"));
stBean.setCreateUser(rset.getString("CREATE_USER"));
stBean.setCreateDate(rset.getString("CREATE_DATE"));
stBean.setUpdateUser(rset.getString("UPDATE_USER"));
stBean.setUpdateDate(rset.getString("UPDATE_DATE"));
hitCount++;
}
if (hitCount == 0) {
messageList.setMessage("customerId", customerId, "10000004", Integer.MIN_VALUE);
} else {
returnValue.setDataValue(stBean);
} //END GET DATA
////////////////////////////////////////////////////////////////////////////
} catch (Exception exception) {
System.out.println("[Error Happen!]");
System.out.println("[Start Trace]");
exception.printStackTrace();
System.out.println("[End Trace]");
throw exception;
} finally { //CLOSE DB CONN
try {
if (rset != null) {
rset.close();
}
if (st != null) {
st.close();
}
if (conn != null) {
conn.close();
}
} catch (SQLException se) {
}
if (messageList.size() > 0) {
returnValue.setMessageList(messageList);
returnValue.setBussinessError();
}
}
return returnValue;
}
public ReturnValue selectAllByCustmerID(String customerId) throws Exception {
//Edit by Gxk 2004/09/10
customerId = BaseCommonCheck.convertSql(customerId);
StringBuffer sql = new StringBuffer();
ReturnValue returnValue = new ReturnValue();
MessageList messageList = new MessageList();
/////////////////////////////////////////////////////////////////////////////
//EDIT SQL
sql.append(" SELECT");
sql.append(" CUSTOMER_ID, ");
//屭媞ID
sql.append(" DISP_ORDER, ");
//昞帵弴彉
sql.append(" CUSTOMER_CATEGORY, ");
//屭媞暘椶
sql.append(" CUSTOMER_CODE, ");
//屭媞僐乕僪
sql.append(" CUSTOMER_NAME, ");
//屭媞柤
sql.append(" CUSTOMER_ABBR, ");
//屭媞棯柤
sql.append(" INDUSTRY, ");
//嬈奅
sql.append(" ADDR1, ");
//廧強侾
sql.append(" ADDR2, ");
//廧強俀
sql.append(" ZIP_CODE, ");
//梄曋斣崋
sql.append(" COUNTRY_CODE, ");
//崙僐乕僪
sql.append(" TELEPHONE, ");
//揹榖斣崋
sql.append(" FAX, ");
//FAX斣崋
sql.append(" E_MAIL, ");
//E_MAIL傾僪儗僗
sql.append(" CONTACT_PERSON, ");
//愭曽扴摉幰
sql.append(" URL, ");
//URL
sql.append(" DELETE_FLG, ");
//DELETE僼儔僌
// wxf modified at 2004.08.20 Start
//sql.append(" NUMBER_OF_EMPLOYEE, "); //廬嬈堳悢
sql.append(" TO_CHAR(NUMBER_OF_EMPLOYEE,'9,999,999') AS NUMBER_OF_EMPLOYEE, ");
//廬嬈堳悢
// wxf modified at 2004.08.20 End
sql.append(" CREATE_USER, ");
//嶌惉儐乕僓乕
sql.append(" CREATE_DATE, ");
//嶌惉擔帪
sql.append(" UPDATE_USER, ");
//峏怴儐乕僓乕
sql.append(" UPDATE_DATE ");
//峏怴擔帪
sql.append(" FROM");
sql.append(" M_CUSTOMER");
sql.append(" WHERE");
sql.append(" CUSTOMER_ID='" + customerId + "'");
//sql.append(" AND ( DELETE_FLG <> 'D' OR DELETE_FLG IS NULL)");
System.out.println("[INFO] sql = " + sql.toString());
//END EDIT SQL
/////////////////////////////////////////////////////////////////////////////
ResultSet rset = null;
Connection conn = null;
Statement st = null;
try {
conn = this.datasource.getConnection();
st = conn.createStatement();
rset = st.executeQuery(sql.toString());
////////////////////////////////////////////////////////////////////////////
//GET DATA FROM DB RESULTSET
GBS_Customer_stBean stBean = new GBS_Customer_stBean();
int hitCount = 0;
while (rset.next()) {
stBean.setCustomerID(rset.getString("CUSTOMER_ID"));
stBean.setDispOrder(rset.getString("DISP_ORDER"));
stBean.setCustomerCategory(rset.getString("CUSTOMER_CATEGORY"));
stBean.setCustomerCode(rset.getString("CUSTOMER_CODE"));
stBean.setCustomerName(rset.getString("CUSTOMER_NAME"));
stBean.setCustomerAbbr(rset.getString("CUSTOMER_ABBR"));
stBean.setIndustry(rset.getString("INDUSTRY"));
stBean.setAddr1(rset.getString("ADDR1"));
stBean.setAddr2(rset.getString("ADDR2"));
stBean.setZipCode(rset.getString("ZIP_CODE"));
stBean.setCountryCode(rset.getString("COUNTRY_CODE"));
stBean.setTelephone(rset.getString("TELEPHONE"));
stBean.setFax(rset.getString("FAX"));
stBean.setEmail(rset.getString("E_MAIL"));
stBean.setContactPerson(rset.getString("CONTACT_PERSON"));
stBean.setUrl(rset.getString("URL"));
stBean.setDeleteFlg(rset.getString("DELETE_FLG"));
stBean.setNumberOfEmployee(rset.getString("NUMBER_OF_EMPLOYEE"));
stBean.setCreateUser(rset.getString("CREATE_USER"));
stBean.setCreateDate(rset.getString("CREATE_DATE"));
stBean.setUpdateUser(rset.getString("UPDATE_USER"));
stBean.setUpdateDate(rset.getString("UPDATE_DATE"));
hitCount++;
}
if (hitCount == 0) {
messageList.setMessage("customerId", customerId, "10000004", Integer.MIN_VALUE);
} else {
returnValue.setDataValue(stBean);
} //END GET DATA
////////////////////////////////////////////////////////////////////////////
} catch (Exception exception) {
System.out.println("[Error Happen!]");
System.out.println("[Start Trace]");
exception.printStackTrace();
System.out.println("[End Trace]");
throw exception;
} finally { //CLOSE DB CONN
try {
if (rset != null) {
rset.close();
}
if (st != null) {
st.close();
}
if (conn != null) {
conn.close();
}
} catch (SQLException se) {
}
if (messageList.size() > 0) {
returnValue.setMessageList(messageList);
returnValue.setBussinessError();
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -