package?test2;

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“）;

????}??	
}

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

?????文件????????982??2018-10-27?10:04??freemarker2word\JavaToWord?-?副本\.classpath

?????文件????????386??2018-10-17?09:00??freemarker2word\JavaToWord?-?副本\.project

?????文件???????7872??2018-10-17?09:33??freemarker2word\JavaToWord?-?副本\.settings\org.eclipse.jdt.core.prefs

?????文件???????2607??2018-11-28?07:57??freemarker2word\JavaToWord?-?副本\bin\test2\conDao.class

?????文件???????1662??2018-11-28?07:57??freemarker2word\JavaToWord?-?副本\bin\test2\question.class

?????文件??????10164??2019-01-18?15:23??freemarker2word\JavaToWord?-?副本\bin\test2\WordTest.class

?????文件???????7915??2019-01-18?15:23??freemarker2word\JavaToWord?-?副本\bin\test2\WordTest1.class

?????文件????????112??2018-10-26?15:52??freemarker2word\JavaToWord?-?副本\connDB.properties

?????文件????1007505??2018-10-26?16:59??freemarker2word\JavaToWord?-?副本\mysql-connector-java-5.1.47-bin.jar

?????文件???????2100??2018-10-26?21:21??freemarker2word\JavaToWord?-?副本\src\test2\conDao.java

?????文件???????1071??2018-10-26?17:21??freemarker2word\JavaToWord?-?副本\src\test2\question.java

?????文件??????10765??2019-01-18?15:23??freemarker2word\JavaToWord?-?副本\src\test2\WordTest.java

?????文件???????7487??2019-01-18?15:23??freemarker2word\JavaToWord?-?副本\src\test2\WordTest1.java

?????文件???????2025??2018-03-31?05:10??freemarker2word\所需jar包\apache-freemarker-2.3.28-bin\apache-freemarker-2.3.28-bin\documentation\index.html

?????文件??????81921??2018-03-31?05:10??freemarker2word\所需jar包\apache-freemarker-2.3.28-bin\apache-freemarker-2.3.28-bin\documentation\_html\alphaidx.html

?????文件??????42701??2018-03-31?05:10??freemarker2word\所需jar包\apache-freemarker-2.3.28-bin\apache-freemarker-2.3.28-bin\documentation\_html\api\allclasses-frame.html

?????文件??????37281??2018-03-31?05:10??freemarker2word\所需jar包\apache-freemarker-2.3.28-bin\apache-freemarker-2.3.28-bin\documentation\_html\api\allclasses-noframe.html

?????文件?????193579??2018-03-31?05:10??freemarker2word\所需jar包\apache-freemarker-2.3.28-bin\apache-freemarker-2.3.28-bin\documentation\_html\api\constant-values.html

?????文件??????51845??2018-03-31?05:10??freemarker2word\所需jar包\apache-freemarker-2.3.28-bin\apache-freemarker-2.3.28-bin\documentation\_html\api\deprecated-list.html

?????文件??????10180??2018-03-31?05:10??freemarker2word\所需jar包\apache-freemarker-2.3.28-bin\apache-freemarker-2.3.28-bin\documentation\_html\api\freemarker\cache\AndMatcher.html

?????文件??????28518??2018-03-31?05:10??freemarker2word\所需jar包\apache-freemarker-2.3.28-bin\apache-freemarker-2.3.28-bin\documentation\_html\api\freemarker\cache\ByteArrayTemplateLoader.html

?????文件??????10679??2018-03-31?05:10??freemarker2word\所需jar包\apache-freemarker-2.3.28-bin\apache-freemarker-2.3.28-bin\documentation\_html\api\freemarker\cache\CacheStorage.html

?????文件???????9739??2018-03-31?05:10??freemarker2word\所需jar包\apache-freemarker-2.3.28-bin\apache-freemarker-2.3.28-bin\documentation\_html\api\freemarker\cache\CacheStorageWithGetSize.html

?????文件???????4404??2018-03-31?05:10??freemarker2word\所需jar包\apache-freemarker-2.3.28-bin\apache-freemarker-2.3.28-bin\documentation\_html\api\freemarker\cache\class-use\AndMatcher.html

?????文件???????4547??2018-03-31?05:10??freemarker2word\所需jar包\apache-freemarker-2.3.28-bin\apache-freemarker-2.3.28-bin\documentation\_html\api\freemarker\cache\class-use\ByteArrayTemplateLoader.html

?????文件??????19312??2018-03-31?05:10??freemarker2word\所需jar包\apache-freemarker-2.3.28-bin\apache-freemarker-2.3.28-bin\documentation\_html\api\freemarker\cache\class-use\CacheStorage.html

?????文件???????7841??2018-03-31?05:10??freemarker2word\所需jar包\apache-freemarker-2.3.28-bin\apache-freemarker-2.3.28-bin\documentation\_html\api\freemarker\cache\class-use\CacheStorageWithGetSize.html

?????文件???????4503??2018-03-31?05:10??freemarker2word\所需jar包\apache-freemarker-2.3.28-bin\apache-freemarker-2.3.28-bin\documentation\_html\api\freemarker\cache\class-use\ClassTemplateLoader.html

?????文件???????7459??2018-03-31?05:10??freemarker2word\所需jar包\apache-freemarker-2.3.28-bin\apache-freemarker-2.3.28-bin\documentation\_html\api\freemarker\cache\class-use\ConcurrentCacheStorage.html

?????文件???????4723??2018-03-31?05:10??freemarker2word\所需jar包\apache-freemarker-2.3.28-bin\apache-freemarker-2.3.28-bin\documentation\_html\api\freemarker\cache\class-use\ConditionalTemplateConfigurationFactory.html

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