?? gbs_mwideuse_db.java
字號:
package DB;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import javax.sql.DataSource;
import COMMON.BaseCommonCheck;
import COMMON.MessageList;
import COMMON.ReturnValue;
import COMMON.SystemConstants;
import DataBean.GBS_MWideUse_stBean;
/**
* public class GBS_MWideUse_DB implements SystemConstants
* created on 07-30-2004
* @author wxf
* @version 1.0
*/
public class GBS_MWideUse_DB implements SystemConstants {
private DataSource datasource = null;
/**
* get datasource from logic
* @param datasource
*/
public GBS_MWideUse_DB(DataSource datasource) {
this.datasource = datasource;
}
public ReturnValue selectByTargetUse(String TargetUse) throws Exception {
//Add by Gxk 2004/09/10 Start
TargetUse = BaseCommonCheck.convertSql(TargetUse);
//Add by Gxk 2004/09/10 End
ReturnValue returnValueD = new ReturnValue();
MessageList messageList = new MessageList();
returnValueD.setMessageList(messageList);
StringBuffer sql = new StringBuffer();
// sql edit *********************************************/
sql.append(" SELECT TARGET_USE, ");
sql.append(" MAIN_KEY, ");
sql.append(" STRING1, ");
sql.append(" STRING2, ");
sql.append(" STRING3, ");
sql.append(" NUMERIC1, ");
sql.append(" NUMERIC2, ");
sql.append(" NUMERIC3, ");
sql.append(" EXPOSITION, ");
sql.append(" CREATE_USER, ");
sql.append(" CREATE_DATE, ");
sql.append(" UPDATE_USER, ");
sql.append(" UPDATE_DATE ");
sql.append(" FROM M_WIDE_USE ");
sql.append(" WHERE TARGET_USE = '" + TargetUse + "' ");
sql.append(" ORDER BY DISP_ORDER, MAIN_KEY ");
//sql edit ********************************************/
System.out.println("[INFO] sql = " + sql.toString());
ResultSet rset = null;
Connection conn = null;
Statement st = null;
try {
conn = this.datasource.getConnection();
st = conn.createStatement();
//System.out.println("[info]GBS_MServiceinfo_DB.getServiceinfoList.sql=" + sql);
rset = st.executeQuery(sql.toString());
ArrayList returnList = new ArrayList();
while (rset.next()) {
GBS_MWideUse_stBean mWideUse_st = new GBS_MWideUse_stBean();
mWideUse_st.setTargetUse(rset.getString("TARGET_USE"));
mWideUse_st.setMainKey(rset.getString("MAIN_KEY"));
mWideUse_st.setString1(rset.getString("STRING1"));
mWideUse_st.setString2(rset.getString("STRING2"));
mWideUse_st.setString3(rset.getString("STRING3"));
mWideUse_st.setNumeric1(rset.getString("NUMERIC1"));
mWideUse_st.setNumeric2(rset.getString("NUMERIC2"));
mWideUse_st.setNumeric3(rset.getString("NUMERIC3"));
mWideUse_st.setExpsition(rset.getString("EXPOSITION"));
mWideUse_st.setCreateUser(rset.getString("CREATE_USER"));
mWideUse_st.setCreateDate(rset.getString("CREATE_DATE"));
mWideUse_st.setUpdateUser(rset.getString("UPDATE_USER"));
mWideUse_st.setUpdateDate(rset.getString("UPDATE_DATE"));
returnList.add(mWideUse_st);
}
if (returnList.size() == 0) {
messageList.setMessage("", "", "10000004", Integer.MIN_VALUE);
returnValueD.setBussinessError();
}
returnValueD.setDataValue(returnList);
} 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 (rset != null) {
rset.close();
}
if (st != null) {
st.close();
}
if (conn != null) {
conn.close();
}
} catch (SQLException se) {
}
}
return returnValueD;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -