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;
	}
}