package?common;

import?java.sql.*;

/**
?*?數據庫操作公共類
?*?@author?TH_0707
?*?@date?2019-4-2
?*/
public?class?DB?{
	private?Connection?conn?=?null;//數據庫連接對象
	private?Statement?stmt?=?null;//發送sql命令的對象
	private?ResultSet?rs?=?null;//查詢結果集
	
	/**
	?*?1、構造的時候加載數據庫驅動程序
	?*/
	public?DB（）{
		String?className?=?“com.mysql.jdbc.Driver“;
		try?{
			Class.forName（className）;
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
	}
	
	/**
	?*?2、連接數據庫
	?*?@return
	?*/
	public?Connection?getConn（）{
		String?url?=?“jdbc:mysql://localhost:3306/testdb?characterEncoding=utf-8“;
		String?user?=?“root“;
		String?pass?=?“root“;
		try?{
			conn?=?DriverManager.getConnection（url?user?pass）;
		}?catch?（SQLException?e）?{
			//

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2019-06-17?14:37??新聞發布系統項目\test03\
?????文件?????????842??2019-04-26?11:25??新聞發布系統項目\test03\.classpath
?????文件?????????906??2019-04-26?11:25??新聞發布系統項目\test03\.project
?????目錄???????????0??2019-06-17?14:37??新聞發布系統項目\test03\.settings\
?????文件?????????567??2019-04-26?11:25??新聞發布系統項目\test03\.settings\.jsdtscope
?????文件?????????364??2019-04-26?11:25??新聞發布系統項目\test03\.settings\org.eclipse.jdt.core.prefs
?????文件?????????470??2019-04-26?11:25??新聞發布系統項目\test03\.settings\org.eclipse.wst.common.component
?????文件?????????345??2019-04-26?11:25??新聞發布系統項目\test03\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2019-04-26?11:25??新聞發布系統項目\test03\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2019-04-26?11:25??新聞發布系統項目\test03\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2019-06-17?14:37??新聞發布系統項目\test03\build\
?????目錄???????????0??2019-06-17?14:37??新聞發布系統項目\test03\build\classes\
?????目錄???????????0??2019-06-17?14:37??新聞發布系統項目\test03\build\classes\common\
?????文件????????2283??2019-04-26?11:37??新聞發布系統項目\test03\build\classes\common\DB.class
?????目錄???????????0??2019-06-17?14:37??新聞發布系統項目\test03\build\classes\news\
?????文件????????2686??2019-06-13?20:07??新聞發布系統項目\test03\build\classes\news\AddNews_Servlet.class
?????文件????????1522??2019-05-14?11:12??新聞發布系統項目\test03\build\classes\news\deleteNews_Servlet.class
?????文件????????1629??2019-04-30?11:07??新聞發布系統項目\test03\build\classes\news\News.class
?????文件????????4913??2019-05-14?10:53??新聞發布系統項目\test03\build\classes\news\NewsDao.class
?????文件????????1874??2019-05-04?22:25??新聞發布系統項目\test03\build\classes\news\QueryNews_Servlet.class
?????文件????????1896??2019-05-14?11:36??新聞發布系統項目\test03\build\classes\news\UpdateNews_Servlet.class
?????文件????????1876??2019-05-10?12:03??新聞發布系統項目\test03\build\classes\news\ViewNews_Servlet.class
?????目錄???????????0??2019-06-17?14:37??新聞發布系統項目\test03\build\classes\test\
?????文件?????????896??2019-04-26?11:28??新聞發布系統項目\test03\build\classes\test\Test_DB.class
?????文件????????1317??2019-05-10?10:41??新聞發布系統項目\test03\build\classes\test\Test_NewsDao.class
?????文件?????????788??2019-04-26?11:28??新聞發布系統項目\test03\build\classes\test\Test_User.class
?????文件?????????389??2019-04-26?11:28??新聞發布系統項目\test03\build\classes\test\Test_UserDao.class
?????目錄???????????0??2019-06-17?14:37??新聞發布系統項目\test03\build\classes\user\
?????文件????????3025??2019-06-02?12:37??新聞發布系統項目\test03\build\classes\user\LoginServlet.class
?????文件????????2650??2019-06-08?13:55??新聞發布系統項目\test03\build\classes\user\UpdatePasswordServlet.class
?????文件????????2069??2019-04-26?11:28??新聞發布系統項目\test03\build\classes\user\User.class
............此處省略588個文件信息