package?com.haiqi.db;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.ResultSetmetaData;
import?java.sql.SQLException;
import?java.util.Iterator;
import?java.util.Map;
import?java.util.Properties;

import?net.sf.json.JSONArray;
import?net.sf.json.JSONobject;

/**
?*?數據庫工具類
?*?
?*?@author?張海洋
?*?
?*/
public?class?DBHelper?{
	/**
	?*?關閉數據庫連接
	?*?
	?*?@param?conn
	?*/
	public?static?Connection?conn;
	public?static?final?String?ACTION_SELECT?=?“SELECT“;
	public?static?final?String?ACTION_UPDATE?=?“UPDATE“;
	public?static?final?String?ACTION_INSERT?=?“INSERT“;
	public?static?final?String?ACTION_DELETE?=?“DELETE“;
	//?這個是數據庫名的常量
	public?static?final?String?DB_URL_EIS?=?“url_TEST“;
	//?public?static?final?String?DB_URL_EIPDB?=?“url_EIPDB“;

	//?這個是定義的數據庫表表名的常量
	public?static?final?String?DB_TABLE_TEST?=?“tb_user“;
	public?static?final?String?TABLE_MEKP_LIBRARY_ITEMS?=?“mekp_LibraryItems“;
	public?static?final?String?TABLE_SYS_FILES?=?“Sys_Files“;
	public?static?final?String?TABLE_DOC_RECEIVE_DOC?=?“Document_ReceiveDoc“;
	public?static?final?String?TABLE_OA_FORM_SENTENCE?=?“OA_FORM_SENTENCE“;
	public?static?final?String?TABLE_OA_FLOW_INST_SENDER?=?“OA_FLOW_INST_SENDER“;
	public?static?final?String?TABLE_OA_FLOW_NOTICE_SENDER?=?“OA_FLOW_NOTICE_SENDER“;
	public?static?final?String?TABLE_FI_ORG_EMP?=?“FI_ORG_EMP“;
	//?public?static?final?String?TABLE_OA_FLOW_INST?=?“OA_FLOW_INST“;//流程表
	//?public?static?final?String?VIEW_VM_USERS_EIS_MSG?=?“VM_Users_EIS_MSG“;
	public?static?final?String?TABLE_MESSAGE_CONTENT?=?“Message_Content“;
	public?static?final?String?TABLE_MESSAGE_SENDLIST?=?“Message_SendList“;

	public?static?final?String?VIEW_V_OA_FLOW_NOTICE_SENDER?=?“V_OA_FLOW_NOTICE_SENDER“;
	public?static?final?String?VIEW_V_OA_FLOW_FORM_PENDING?=?“V_OA_FLOW_FORM_Pending“;

	public?static?final?String?VIEW_VM_MOBILE_MSG?=?“VM_MOBILE_MSG“;
	public?static?final?String?VIEW_VM_MOBILE_USERS?=?“VM_MOBILE_USERS“;
	public?static?final?String?VIEW_VM_MOBILE_FLOW_TODO?=?“VM_MOBILE_FLOW_TODO“;
	public?static?final?String?VIEW_VM_MOBILE_SENTENCE?=?“VM_MOBILE_SENTENCE“;
	public?static?final?String?VIEW_VM_MOBILE_NODE_DEFINE?=?“VM_MOBILE_NODE_DEFINE“;
	public?static?final?String?VIEW_V_FI_ORG_DEPT?=?“V_FI_ORG_DEPT“;

	public?static?final?String?TABLE_OA_FLOW_DEFINE_NODE?=?“OA_FLOW_DEFINE_NODE“;
	public?static?final?String?TABLE_OA_DOC_FILE_INFO?=?“OA_DOC_FILE_INFO“;

	public?static?final?String?TABLE_OA_FLOW_DEFINE?=?“OA_FLOW_DEFINE“;
	public?static?final?String?TABLE_OA_FLOW_DEFINE_SCHEMA?=?“OA_FLOW_DEFINE_SCHEMA“;
	public?static?final?String?TABLE_OA_FLOW_INST?=?“OA_FLOW_INST“;
	public?static?final?String?TABLE_OA_FLOW_INST_NODE?=?“OA_FLOW_INST_NODE“;
	public?static?final?String?TABLE_OA_FLOW_INST_FORM?=?“OA_FLOW_INST_FORM“;
	public?static?final?String?TABLE_OA_FLOW_INST_H?=?“OA_FLOW_INST_H“;
	public?static?final?Str

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????1186??2014-07-01?10:16??仿12306前臺和后臺以及數據庫\HqTicket\.classpath

?????文件???????1333??2014-07-01?10:07??仿12306前臺和后臺以及數據庫\HqTicket\.project

?????文件????????522??2014-07-01?09:38??仿12306前臺和后臺以及數據庫\HqTicket\.settings\.jsdtscope

?????文件????????364??2014-07-01?09:38??仿12306前臺和后臺以及數據庫\HqTicket\.settings\org.eclipse.jdt.core.prefs

?????文件????????485??2014-07-01?09:38??仿12306前臺和后臺以及數據庫\HqTicket\.settings\org.eclipse.wst.common.component

?????文件????????414??2014-07-01?09:38??仿12306前臺和后臺以及數據庫\HqTicket\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2014-07-01?09:38??仿12306前臺和后臺以及數據庫\HqTicket\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2014-07-01?09:38??仿12306前臺和后臺以及數據庫\HqTicket\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件??????10733??2014-07-01?10:00??仿12306前臺和后臺以及數據庫\HqTicket\src\com\haiqi\db\DBHelper.java

?????文件???????1174??2014-07-01?15:30??仿12306前臺和后臺以及數據庫\HqTicket\src\com\haiqi\servlet\DataTicket.java

?????文件???????3270??2014-07-18?09:12??仿12306前臺和后臺以及數據庫\HqTicket\src\com\haiqi\servlet\HqTicket.java

?????文件????????106??2014-06-30?16:10??仿12306前臺和后臺以及數據庫\HqTicket\src\DBConfig.properties

?????文件????????834??2014-07-01?09:38??仿12306前臺和后臺以及數據庫\HqTicket\WebRoot\index.jsp

?????文件?????????39??2014-07-01?09:38??仿12306前臺和后臺以及數據庫\HqTicket\WebRoot\meta-INF\MANIFEST.MF

?????文件????????524??2014-09-12?11:43??仿12306前臺和后臺以及數據庫\HqTicket\WebRoot\WEB-INF\classes\com\haiqi\db\DBHelper$ApprovalTable.class

?????文件????????603??2014-09-12?11:43??仿12306前臺和后臺以及數據庫\HqTicket\WebRoot\WEB-INF\classes\com\haiqi\db\DBHelper$FileTable.class

?????文件??????10500??2014-09-12?11:43??仿12306前臺和后臺以及數據庫\HqTicket\WebRoot\WEB-INF\classes\com\haiqi\db\DBHelper.class

?????文件???????1246??2014-09-12?11:43??仿12306前臺和后臺以及數據庫\HqTicket\WebRoot\WEB-INF\classes\com\haiqi\servlet\DataTicket.class

?????文件???????2425??2014-09-12?11:43??仿12306前臺和后臺以及數據庫\HqTicket\WebRoot\WEB-INF\classes\com\haiqi\servlet\HqTicket.class

?????文件????????106??2014-06-30?16:10??仿12306前臺和后臺以及數據庫\HqTicket\WebRoot\WEB-INF\classes\DBConfig.properties

?????文件?????188671??2014-07-01?10:15??仿12306前臺和后臺以及數據庫\HqTicket\WebRoot\WEB-INF\lib\commons-beanutils-1.7.0.jar

?????文件?????571259??2014-07-01?10:15??仿12306前臺和后臺以及數據庫\HqTicket\WebRoot\WEB-INF\lib\commons-collections-3.2.jar

?????文件?????261809??2014-07-01?10:15??仿12306前臺和后臺以及數據庫\HqTicket\WebRoot\WEB-INF\lib\commons-lang-2.4.jar

?????文件??????52915??2014-07-01?10:15??仿12306前臺和后臺以及數據庫\HqTicket\WebRoot\WEB-INF\lib\commons-logging-1.1.jar

?????文件??????86381??2014-07-01?10:15??仿12306前臺和后臺以及數據庫\HqTicket\WebRoot\WEB-INF\lib\ezmorph-1.0.4.jar

?????文件?????152797??2014-07-01?10:15??仿12306前臺和后臺以及數據庫\HqTicket\WebRoot\WEB-INF\lib\jdom.jar

?????文件?????151839??2014-07-01?10:13??仿12306前臺和后臺以及數據庫\HqTicket\WebRoot\WEB-INF\lib\json-lib-2.3-jdk15.jar

?????文件?????536609??2014-07-01?09:43??仿12306前臺和后臺以及數據庫\HqTicket\WebRoot\WEB-INF\lib\mysql-connector-java-5.0.7-bin.jar

?????文件???????1157??2014-07-01?15:25??仿12306前臺和后臺以及數據庫\HqTicket\WebRoot\WEB-INF\web.xml

?????文件???????8820??2008-01-11?17:23??仿12306前臺和后臺以及數據庫\mysql\columns_priv.frm

............此處省略242個文件信息