📄 gbs_mmember_db.java
字号:
Connection conn = null;
Statement st = null;
try {
//Getting DB Connection
conn = this.datasource.getConnection();
st = conn.createStatement();
System.out.println("[INFO] sqla = " + sqla.toString());
rseta = st.executeQuery(sqla.toString());
ArrayList listMemberCommittee = new ArrayList();
ArrayList listMemberSupport = new ArrayList();
ArrayList listMemberOperation = new ArrayList();
ArrayList listMemberLocal = new ArrayList();
ArrayList listMemberSubsidiary = new ArrayList();
//set GBS Corporate Office data
while (rseta.next()) {
//add by YM 2004/09/10 start
/*if ((admins.equals("1")
|| (BaseCommonCheck.convertNullToSpace(rseta.getString("VISIBLE")).equals("Y")
&& !BaseCommonCheck.convertNullToSpace(rseta.getString("DELETE_FLG")).equals("D")))
|| (loginId.equals(rseta.getString("USER_ID")))) {*/
if(BaseCommonCheck.convertNullToSpace(rseta.getString("VISIBLE")).equals("Y") &&
!BaseCommonCheck.convertNullToSpace(rseta.getString("DELETE_FLG")).equals("D")){
//add by YM 2004/09/10 end
String menberKind = BaseCommonCheck.convertNullToSpace(rseta.getString("MEMBER_KIND"));
//Committee members.
if (menberKind.equals("1")) {
GBS_MemberList_stBean memBean = new GBS_MemberList_stBean();
memBean.setMemberName(
BaseCommonCheck.convertNullToSpace(rseta.getString("MEMBER_NAME_FIRST"))
+ " "
+ BaseCommonCheck.convertNullToSpace(rseta.getString("MEMBER_NAME_LAST")));
memBean.setDept(rseta.getString("DEPT"));
memBean.setEmail(rseta.getString("E_MAIL"));
memBean.setTelephone(rseta.getString("TELEPHONE"));
listMemberCommittee.add(memBean);
}
//Support members.
if (menberKind.equals("2")) {
GBS_MemberList_stBean memBean = new GBS_MemberList_stBean();
memBean.setMemberName(
BaseCommonCheck.convertNullToSpace(rseta.getString("MEMBER_NAME_FIRST"))
+ " "
+ BaseCommonCheck.convertNullToSpace(rseta.getString("MEMBER_NAME_LAST")));
memBean.setDept(rseta.getString("DEPT"));
memBean.setEmail(rseta.getString("E_MAIL"));
memBean.setTelephone(rseta.getString("TELEPHONE"));
listMemberSupport.add(memBean);
}
//Operation members.
if (menberKind.equals("3")) {
GBS_MemberList_stBean memBean = new GBS_MemberList_stBean();
memBean.setMemberName(
BaseCommonCheck.convertNullToSpace(rseta.getString("MEMBER_NAME_FIRST"))
+ " "
+ BaseCommonCheck.convertNullToSpace(rseta.getString("MEMBER_NAME_LAST")));
memBean.setDept(rseta.getString("DEPT"));
memBean.setEmail(rseta.getString("E_MAIL"));
memBean.setTelephone(rseta.getString("TELEPHONE"));
listMemberOperation.add(memBean);
}
//Local members.
if (menberKind.equals("0")) {
GBS_MemberList_stBean memBean = new GBS_MemberList_stBean();
memBean.setMemberName(
BaseCommonCheck.convertNullToSpace(rseta.getString("MEMBER_NAME_FIRST"))
+ " "
+ BaseCommonCheck.convertNullToSpace(rseta.getString("MEMBER_NAME_LAST")));
memBean.setDept(rseta.getString("DEPT"));
memBean.setEmail(rseta.getString("E_MAIL"));
memBean.setTelephone(rseta.getString("TELEPHONE"));
listMemberLocal.add(memBean);
}
}
}
//get GBS Members Office data
System.out.println("[INFO] sqlb = " + sqlb.toString());
rsetb = st.executeQuery(sqlb.toString());
String strFlag = "";
int i = 0, j = 0, k = 0;
while (rsetb.next()) {
//add by YM 2004/09/10 start
/*if ((admins.equals("1")
|| (BaseCommonCheck.convertNullToSpace(rsetb.getString("VISIBLE")).equals("Y")
&& !BaseCommonCheck.convertNullToSpace(rsetb.getString("DELETE_FLG")).equals("D")))
|| (loginId.equals(rsetb.getString("USER_ID")))) {*/
if(BaseCommonCheck.convertNullToSpace(rseta.getString("VISIBLE")).equals("Y") &&
!BaseCommonCheck.convertNullToSpace(rseta.getString("DELETE_FLG")).equals("D")){
//add by YM 2004/09/10 end
GBS_MemberList_stBean memBean = new GBS_MemberList_stBean();
String subsidiaryName = BaseCommonCheck.convertNullToSpace(rsetb.getString("SUBSIDIARY_NAME"));
String dept = BaseCommonCheck.convertNullToSpace(rsetb.getString("DEPT"));
String menberNameFirst = BaseCommonCheck.convertNullToSpace(rseta.getString("MEMBER_NAME_FIRST"));
String menberNameLast = BaseCommonCheck.convertNullToSpace(rseta.getString("MEMBER_NAME_LAST"));
if (!subsidiaryName.equals(strFlag)) {
if (i > 0) {
GBS_MemberList_stBean stBean = (GBS_MemberList_stBean) listMemberSubsidiary.get(k);
stBean.setColspan(j);
}
k = i;
j = 1;
strFlag = subsidiaryName;
memBean.setSubsidiaryName(subsidiaryName);
} else {
j++;
memBean.setSubsidiaryName("");
}
memBean.setMemberName(menberNameFirst + " " + menberNameLast);
memBean.setSubsidiaryNameDept(dept);
memBean.setEmail(rsetb.getString("E_MAIL"));
memBean.setTelephone(rsetb.getString("TELEPHONE"));
memBean.setBossName(
BaseCommonCheck.convertNullToSpace(rsetb.getString("BOSS_NAME_FIRST"))
+ " "
+ BaseCommonCheck.convertNullToSpace(rsetb.getString("BOSS_NAME_LAST")));
memBean.setBossEmail(rsetb.getString("BOSS_E_MAIL"));
i++;
listMemberSubsidiary.add(memBean);
}
}
GBS_MemberList_stBean stBean = (GBS_MemberList_stBean) listMemberSubsidiary.get(k);
stBean.setColspan(j);
retdat.put(MENBER_COMMITTEE, listMemberCommittee);
retdat.put(MENBER_SUPPORT, listMemberSupport);
retdat.put(MENBER_OPERATION, listMemberOperation);
retdat.put(MENBER_LOCAL, listMemberLocal);
retdat.put(MEMBER_SUBSIDIARY, listMemberSubsidiary);
} catch (Exception exception) {
System.out.println("[Error Happen!]");
System.out.println("[Start Trace]");
exception.printStackTrace();
System.out.println("[End Trace]");
throw exception;
} finally {
//release db
try {
if (rseta != null) {
rseta.close();
}
if (rsetb != null) {
rsetb.close();
}
if (st != null) {
st.close();
}
if (conn != null) {
conn.close();
}
} catch (SQLException se) {
throw se;
}
}
if (retdat.size() > 0) {
returnValueD.setDataValue(retdat);
} else {
messageList.setMessage("", "", "10000004", Integer.MIN_VALUE);
returnValueD.setBussinessError();
returnValueD.setMessageList(messageList);
}
return returnValueD;
}
public ReturnValue selectByUserIdWithDelete(String UserId) throws Exception {
//Add by Gxk 2004/09/10 Start
UserId = BaseCommonCheck.convertSql(UserId);
//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(" USER_ID , "); //儐乕僓乕ID
sql.append(" DISP_ORDER , "); //昞帵弴彉
sql.append(" PASSWORD , "); //僷僗儚乕僪
sql.append(" MEMBER_NAME_FIRST , "); //儊儞僶乕柤乮First)
sql.append(" MEMBER_NAME_LAST , "); //儊儞僶乕柤(Last)
sql.append(" SUBSIDIARY_CODE , "); //尰朄僐乕僪
sql.append(" DEPT , "); //晹彁
sql.append(" E_MAIL , "); //儊乕儖傾僪儗僗
sql.append(" TELEPHONE , "); //揹榖斣崋
sql.append(" BOSS_NAME_FIRST , "); //忋巌偺柤慜(First)
sql.append(" BOSS_NAME_LAST , "); //忋巌偺柤慜(Last)
sql.append(" BOSS_E_MAIL , "); //忋巌偺儊乕儖傾僪儗僗
sql.append(" MEMBER_KIND , "); //儊儞僶乕庬椶
sql.append(" ADMIN_AUTHORITY , "); //俙倓倣倝値尃尷
sql.append(" DOWNLOAD_OK , "); //僟僂儞儘乕僪壜斲
sql.append(" DELETE_FLG , "); //嶍彍僼儔僌
sql.append(" CREATE_USER , "); //嶌惉儐乕僓乕
sql.append(" CREATE_DATE , "); //嶌惉擔帪
sql.append(" UPDATE_USER , "); //峏怴儐乕僓乕
sql.append(" VISIBLE , ");
sql.append(" UPDATE_DATE "); //峏怴擔帪
sql.append("FROM ");
sql.append(" M_MEMBER ");
sql.append("WHERE");
if (!"".equals(UserId)) {
sql.append(" USER_ID = '" + UserId + "' ");
}
//END EDIT SQL
//END
/////////////////////////////////////////////////////////////////////////////
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
//DEFINE RETURNVALUE
GBS_MMember_stBean out_st = new GBS_MMember_stBean();
int hitCount = 0;
while (rset.next()) {
out_st.setUserId(rset.getString("USER_ID"));
out_st.setDispOrder(rset.getString("DISP_ORDER"));
out_st.setPassword(rset.getString("PASSWORD"));
out_st.setMemberNameFirst(rset.getString("MEMBER_NAME_FIRST"));
out_st.setMemberNameLast(rset.getString("MEMBER_NAME_LAST"));
out_st.setSubsidiaryCode(rset.getString("SUBSIDIARY_CODE"));
out_st.setDept(rset.getString("DEPT"));
out_st.setEmail(rset.getString("E_MAIL"));
out_st.setTelephone(rset.getString("TELEPHONE"));
out_st.setBossNameFirst(rset.getString("BOSS_NAME_FIRST"));
out_st.setBossNameLast(rset.getString("BOSS_NAME_LAST"));
out_st.setBossEMail(rset.getString("BOSS_E_MAIL"));
out_st.setMenberKind(rset.getString("MEMBER_KIND"));
out_st.setAdminAuthority(rset.getString("ADMIN_AUTHORITY"));
out_st.setDownloadOk(rset.getString("DOWNLOAD_OK"));
out_st.setDeleteFlg(BaseCommonCheck.convertNullToSpace(rset.getString("DELETE_FLG")));
out_st.setCreateUser(rset.getString("CREATE_USER"));
out_st.setCreateDate(rset.getString("CREATE_DATE"));
out_st.setUpdateUser(rset.getString("UPDATE_USER"));
out_st.setUpdateDate(rset.getString("UPDATE_DATE"));
out_st.setVisible(rset.getString("VISIBLE"));
hitCount++;
}
if (hitCount == 0) {
//returnValue.setErrorCode("10000005");
messageList.setMessage("UserId", UserId, "10000005", Integer.MIN_VALUE);
} else {
returnValue.setErrorCode("");
returnValue.setDataValue(out_st);
}
//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;
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -