package?dao;

import?java.io.IOException;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?java.util.Properties;
public?class?conDao?{
	
	public?Connection?conn?=?null;?//?聲明Connection對象的實例
	public?Statement?stmt?=?null;?//?聲明Statement對象的實例
	public??ResultSet?rs?=?null;?//?聲明ResultSet對象的實例
	private?static?String?propFileName?=?“connDB.properties“;?//?指定資源文件保存的位置
	private?static?Properties?prop?=?new?Properties（）;?//?創建并實例化Properties對象的實例
	private?static?String?dbClassName?=?“com.mysql.jdbc.Driver“??;//定義保存數據庫驅動的變量
	private?static?String?dbUrl=?“jdbc:mysql://localhost:3306/exam_system“?;
	private?static?String?dbUser?=?“root“;
	private?static?String?dbPwd?=?“123456“;
????public?conDao（）?{
????	
????	
????}
	public?static??Connection?getConnection（）?{
		Connection?conn?=?null;
		try?{
			Class.forName（“com.mysql.jdbc.Driver“）.newInstance（）;
			conn?=?DriverManager.getConnection（“jdbc:mysql://localhost:3306/exam_system“?“root“?“123456“）;
			System.out.println（“suceess!“）;
		}?catch?（Exception?ee）?{
			ee.printStackTrace（）;
		}
		if?（conn?==?null）?{
			System.err
					.println（“警告:?DbConnectionManager.getConnection（）?獲得數據庫鏈接失敗.\r\n\r\n鏈接類型:“
							+?dbClassName
							+?“\r\n鏈接位置:“
							+?dbUrl
							+?“\r\n用戶/密碼“
							+?dbUser?+?“/“?+?dbPwd）;
		}
		return?conn;
	}
	
	/*
	?*?功能：執行查詢語句
	?*/
	public??ResultSet?executeQuery（String?sql）?{
		try?{?//?捕捉異常
			conn?=?getConnection（）;?//?調用getConnection（）方法構造Connection對象的一個實例conn
			stmt?=?conn.createStatement（ResultSet.TYPE_SCROLL_INSENSITIVE
					ResultSet.CONCUR_READ_ONLY）;
			rs?=?stmt.executeQuery（sql）;
		}?catch?（SQLException?ex）?{
			System.err.println（ex.getMessage（））;?//?輸出異常信息
		}
		return?rs;?//?返回結果集對象
	}

	public?static?void?main（String[]?args）?{??
????????getConnection（）;
????????System.out.println（“success“）;

????}??	
}

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

?????文件?????591748??2018-08-13?09:16??docx4j2word\jar包\commons-compress-1.18.jar

?????文件?????214788??2017-10-15?12:00??docx4j2word\jar包\commons-io-2.6.jar

?????文件?????501879??2018-09-19?11:24??docx4j2word\jar包\commons-lang3-3.8.1.jar

?????文件??????61829??2014-07-05?20:11??docx4j2word\jar包\commons-logging-1.2.jar

?????文件????5443920??2018-11-05?16:47??docx4j2word\jar包\docx4j-6.0.1.jar

?????文件????2747878??2018-11-05?17:26??docx4j2word\jar包\guava-27.0-jre.jar

?????文件?????489883??2012-05-06?13:01??docx4j2word\jar包\log4j-1.2.17.jar

?????文件??????41203??2017-03-16?17:18??docx4j2word\jar包\slf4j-api-1.7.25.jar

?????文件??????12244??2017-03-16?17:18??docx4j2word\jar包\slf4j-log4j12-1.7.25.jar

?????文件????3176148??2013-03-24?20:04??docx4j2word\jar包\xalan-2.7.1.jar

?????文件????1367760??2018-11-05?19:34??docx4j2word\jar包\xercesImpl-2.11.0.jar

?????文件?????509244??2011-09-27?22:27??docx4j2word\jar包\xmlgraphics-commons-1.3.jar

?????文件???????1346??2018-11-06?16:20??docx4j2word\test5\.classpath

?????文件????????381??2018-11-05?15:58??docx4j2word\test5\.project

?????文件????????598??2018-11-05?15:58??docx4j2word\test5\.settings\org.eclipse.jdt.core.prefs

?????文件???????2603??2018-11-28?07:59??docx4j2word\test5\bin\dao\conDao.class

?????文件???????1658??2018-11-28?07:59??docx4j2word\test5\bin\dao\question.class

?????文件??????16482??2019-01-18?15:48??docx4j2word\test5\bin\test5\moduldocx4j.class

?????文件???????2056??2019-01-18?15:49??docx4j2word\test5\bin\test5\te.class

?????文件???????2102??2018-11-06?10:55??docx4j2word\test5\src\dao\conDao.java

?????文件???????1074??2018-11-20?15:07??docx4j2word\test5\src\dao\question.java

?????文件??????19669??2019-01-18?15:48??docx4j2word\test5\src\test5\moduldocx4j.java

?????文件???????1460??2019-01-18?15:49??docx4j2word\test5\src\test5\te.java

?????目錄??????????0??2018-11-28?07:59??docx4j2word\test5\bin\dao

?????目錄??????????0??2018-11-28?07:59??docx4j2word\test5\bin\test5

?????目錄??????????0??2018-11-06?10:56??docx4j2word\test5\src\dao

?????目錄??????????0??2018-11-20?16:15??docx4j2word\test5\src\test5

?????目錄??????????0??2018-11-05?15:58??docx4j2word\test5\.settings

?????目錄??????????0??2018-11-28?07:59??docx4j2word\test5\bin

?????目錄??????????0??2018-11-06?10:54??docx4j2word\test5\src

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