/**
?*?對數據庫操作的類
?*?對數據庫的操作，就是crud
?*?調用存儲過程
?*/
package?com.db;

import?java.sql.*;

/**
?*?@author?江西聯微軟件有限公司
?*/
public?class?SqlHelper?{
	//?定義需要的對象
	Connection?ct?=?null;
	PreparedStatement?ps?=?null;
	ResultSet?rs?=?null;

	//?連接數據庫需要的字符串
	String?driver?=?“com.mysql.jdbc.Driver“;
	String?url?=?“jdbc:mysql://127.0.0.1/test?useUnicode=true&characterEncoding=utf-8“;
	String?user?=?“root“;
	String?passwd?=?“wo.hN33“;

	//?構造函數，初始化
	public?SqlHelper（）?{
		try?{
			//?加載驅動
			Class.forName（driver）;
			//?得到連接
			ct?=?DriverManager.getConnection（url?user?passwd）;
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
			System.out.println（“驅動沒有加載成功原因是沒有導入驅動！請檢查“）;
		}?catch?（NullPointerException?e）?{
			//?TODO?Auto-generated?catch?bloc
			e.printStackTrace（）;
			System.out.println（“數據庫服務沒有開啟，請打開數據庫服務，再重試“）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?bloc
			e.printStackTrace（）;
		}?
	}
	
	//?關閉資源的方法
	public?void?close（）?

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-07-07?16:55??AXiaoShouManager?3\
?????目錄???????????0??2017-07-01?11:26??AXiaoShouManager?3\AXiaoShouManager\
?????文件?????????303??2017-06-30?10:27??AXiaoShouManager?3\AXiaoShouManager\.classpath
?????文件?????????391??2017-07-03?16:09??AXiaoShouManager?3\AXiaoShouManager\.project
?????目錄???????????0??2017-07-09?18:31??AXiaoShouManager?3\AXiaoShouManager\.settings\
?????文件?????????235??2017-07-09?18:33??AXiaoShouManager?3\AXiaoShouManager\.settings\org.eclipse.core.resources.prefs
?????目錄???????????0??2018-10-22?22:18??AXiaoShouManager?3\AXiaoShouManager\bin\
?????目錄???????????0??2018-10-22?22:18??AXiaoShouManager?3\AXiaoShouManager\bin\com\
?????目錄???????????0??2018-10-22?22:18??AXiaoShouManager?3\AXiaoShouManager\bin\com\db\
?????文件????????2969??2018-10-22?22:18??AXiaoShouManager?3\AXiaoShouManager\bin\com\db\SqlHelper.class
?????目錄???????????0??2018-10-22?22:18??AXiaoShouManager?3\AXiaoShouManager\bin\com\view\
?????文件????????1131??2018-10-22?22:18??AXiaoShouManager?3\AXiaoShouManager\bin\com\view\AddEmployeeView$1.class
?????文件????????1029??2018-10-22?22:18??AXiaoShouManager?3\AXiaoShouManager\bin\com\view\AddEmployeeView$A.class
?????文件????????4740??2018-10-22?22:18??AXiaoShouManager?3\AXiaoShouManager\bin\com\view\AddEmployeeView.class
?????文件????????1138??2018-10-22?22:18??AXiaoShouManager?3\AXiaoShouManager\bin\com\view\AddMarketMessage$1.class
?????文件????????1036??2018-10-22?22:18??AXiaoShouManager?3\AXiaoShouManager\bin\com\view\AddMarketMessage$A.class
?????文件????????4347??2018-10-22?22:18??AXiaoShouManager?3\AXiaoShouManager\bin\com\view\AddMarketMessage.class
?????文件????????1131??2018-10-22?22:18??AXiaoShouManager?3\AXiaoShouManager\bin\com\view\AddMedicineView$1.class
?????文件????????1029??2018-10-22?22:18??AXiaoShouManager?3\AXiaoShouManager\bin\com\view\AddMedicineView$A.class
?????文件????????4184??2018-10-22?22:18??AXiaoShouManager?3\AXiaoShouManager\bin\com\view\AddMedicineView.class
?????文件????????1058??2018-10-22?22:18??AXiaoShouManager?3\AXiaoShouManager\bin\com\view\EmployeeManagerView$1.class
?????文件????????1059??2018-10-22?22:18??AXiaoShouManager?3\AXiaoShouManager\bin\com\view\EmployeeManagerView$2.class
?????文件????????1058??2018-10-22?22:18??AXiaoShouManager?3\AXiaoShouManager\bin\com\view\EmployeeManagerView$3.class
?????文件?????????794??2018-10-22?22:18??AXiaoShouManager?3\AXiaoShouManager\bin\com\view\EmployeeManagerView$4.class
?????文件?????????725??2018-10-22?22:18??AXiaoShouManager?3\AXiaoShouManager\bin\com\view\EmployeeManagerView$5.class
?????文件????????1468??2018-10-22?22:18??AXiaoShouManager?3\AXiaoShouManager\bin\com\view\EmployeeManagerView$6.class
?????文件?????????726??2018-10-22?22:18??AXiaoShouManager?3\AXiaoShouManager\bin\com\view\EmployeeManagerView$7.class
?????文件????????1421??2018-10-22?22:18??AXiaoShouManager?3\AXiaoShouManager\bin\com\view\EmployeeManagerView$PageClick.class
?????文件???????10011??2018-10-22?22:18??AXiaoShouManager?3\AXiaoShouManager\bin\com\view\EmployeeManagerView.class
?????文件????????1014??2018-10-22?22:18??AXiaoShouManager?3\AXiaoShouManager\bin\com\view\LoginView$1.class
?????文件????????1014??2018-10-22?22:18??AXiaoShouManager?3\AXiaoShouManager\bin\com\view\LoginView$2.class
............此處省略75個文件信息