package?common;

import?java.sql.*;

/**
?*?數(shù)據(jù)庫(kù)操作公共類
?*?@author?TH_0707
?*?@date?2019-4-2
?*/
public?class?DB?{
	private?Connection?conn?=?null;//數(shù)據(jù)庫(kù)連接對(duì)象
	private?Statement?stmt?=?null;//發(fā)送sql命令的對(duì)象
	private?ResultSet?rs?=?null;//查詢結(jié)果集
	
	/**
	?*?1、構(gòu)造的時(shí)候加載數(shù)據(jù)庫(kù)驅(qū)動(dòng)程序
	?*/
	public?DB（）{
		String?className?=?“com.mysql.jdbc.Driver“;
		try?{
			Class.forName（className）;
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
	}
	
	/**
	?*?2、連接數(shù)據(jù)庫(kù)
	?*?@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）?{
			//

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