package?com;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;

public?class?TestCon?{

	/**
	?*?@param?args
	?*?@throws?ClassNotFoundException?
	?*?@throws?IllegalAccessException?
	?*?@throws?InstantiationException?
	?*/
	public?static?void?main（String[]?args）?throws?InstantiationException?IllegalAccessException?ClassNotFoundException?{
		//?TODO?Auto-generated?method?stub
		/*由于我的電腦安裝sqlserver后沒有開放1433端口，故改用odbc方式連接sqlserver數據庫*/
		//Class.forName（“com.microsoft.jdbc.sqlserver.SQLServerDriver“）.newInstance（）;
		Class.forName（“sun.jdbc.odbc.JdbcOdbcDriver“）.newInstance（）;
		//String?url=“jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=school“;?
		String?url?=?“jdbc:odbc:school“;
		//String?user=“sa“;?
		//String?password=“sa“;?
		try?{
			?//Connection?conn=?DriverManager.getConnection（urluserpassword）;
			Connection?conn?=?DriverManager.getConnection（url）;
			Statement?stmt?=?conn.createStatement（ResultSet.TYPE_SCROLL_SENSITIVE
					ResultSet.CONCUR_READ_ONLY）;

				ResultSet	rs?=?stmt.executeQuery（“select?*?from?administrator“）;
				while（rs.next（））{
					System.out.println（rs.getobject（1））;
					System.out.println（rs.getobject（2））;
					System.out.println（rs.getobject（3））;
				}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}?
	}

}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-04-09?20:35??[淇℃伅鍔炲叕]瀛︽牎鏁欏姟綆＄悊緋葷粺（jsp+servlet+javabean）_school\
?????文件????????6148??2018-06-26?14:57??[淇℃伅鍔炲叕]瀛︽牎鏁欏姟綆＄悊緋葷粺（jsp+servlet+javabean）_school\.DS_Store
?????目錄???????????0??2018-06-26?14:57??__MACOSX\
?????目錄???????????0??2018-06-26?14:57??__MACOSX\[淇℃伅鍔炲叕]瀛︽牎鏁欏姟綆＄悊緋葷粺（jsp+servlet+javabean）_school\
?????文件?????????120??2018-06-26?14:57??__MACOSX\[淇℃伅鍔炲叕]瀛︽牎鏁欏姟綆＄悊緋葷粺（jsp+servlet+javabean）_school\._.DS_Store
?????目錄???????????0??2018-04-09?20:36??[淇℃伅鍔炲叕]瀛︽牎鏁欏姟綆＄悊緋葷粺（jsp+servlet+javabean）_school\school\
?????文件?????????832??2009-04-30?23:13??[淇℃伅鍔炲叕]瀛︽牎鏁欏姟綆＄悊緋葷粺（jsp+servlet+javabean）_school\school\.classpath
?????文件????????6148??2018-04-09?20:36??[淇℃伅鍔炲叕]瀛︽牎鏁欏姟綆＄悊緋葷粺（jsp+servlet+javabean）_school\school\.DS_Store
?????目錄???????????0??2018-06-26?14:57??__MACOSX\[淇℃伅鍔炲叕]瀛︽牎鏁欏姟綆＄悊緋葷粺（jsp+servlet+javabean）_school\school\
?????文件?????????120??2018-04-09?20:36??__MACOSX\[淇℃伅鍔炲叕]瀛︽牎鏁欏姟綆＄悊緋葷粺（jsp+servlet+javabean）_school\school\._.DS_Store
?????目錄???????????0??2009-04-30?23:08??[淇℃伅鍔炲叕]瀛︽牎鏁欏姟綆＄悊緋葷粺（jsp+servlet+javabean）_school\school\.myeclipse\
?????文件?????????291??2009-05-01?10:47??[淇℃伅鍔炲叕]瀛︽牎鏁欏姟綆＄悊緋葷粺（jsp+servlet+javabean）_school\school\.mymetadata
?????文件????????1224??2009-05-01?10:47??[淇℃伅鍔炲叕]瀛︽牎鏁欏姟綆＄悊緋葷粺（jsp+servlet+javabean）_school\school\.project
?????目錄???????????0??2018-04-09?20:36??[淇℃伅鍔炲叕]瀛︽牎鏁欏姟綆＄悊緋葷粺（jsp+servlet+javabean）_school\school\src\
?????文件????????6148??2018-04-09?20:36??[淇℃伅鍔炲叕]瀛︽牎鏁欏姟綆＄悊緋葷粺（jsp+servlet+javabean）_school\school\src\.DS_Store
?????目錄???????????0??2018-06-26?14:57??__MACOSX\[淇℃伅鍔炲叕]瀛︽牎鏁欏姟綆＄悊緋葷粺（jsp+servlet+javabean）_school\school\src\
?????文件?????????120??2018-04-09?20:36??__MACOSX\[淇℃伅鍔炲叕]瀛︽牎鏁欏姟綆＄悊緋葷粺（jsp+servlet+javabean）_school\school\src\._.DS_Store
?????目錄???????????0??2018-04-09?20:36??[淇℃伅鍔炲叕]瀛︽牎鏁欏姟綆＄悊緋葷粺（jsp+servlet+javabean）_school\school\src\com\
?????文件????????6148??2018-04-09?20:36??[淇℃伅鍔炲叕]瀛︽牎鏁欏姟綆＄悊緋葷粺（jsp+servlet+javabean）_school\school\src\com\.DS_Store
?????目錄???????????0??2018-06-26?14:57??__MACOSX\[淇℃伅鍔炲叕]瀛︽牎鏁欏姟綆＄悊緋葷粺（jsp+servlet+javabean）_school\school\src\com\
?????文件?????????120??2018-04-09?20:36??__MACOSX\[淇℃伅鍔炲叕]瀛︽牎鏁欏姟綆＄悊緋葷粺（jsp+servlet+javabean）_school\school\src\com\._.DS_Store
?????目錄???????????0??2018-04-09?20:36??[淇℃伅鍔炲叕]瀛︽牎鏁欏姟綆＄悊緋葷粺（jsp+servlet+javabean）_school\school\src\com\sevenEleven\
?????文件????????6148??2018-04-09?20:36??[淇℃伅鍔炲叕]瀛︽牎鏁欏姟綆＄悊緋葷粺（jsp+servlet+javabean）_school\school\src\com\sevenEleven\.DS_Store
?????目錄???????????0??2018-06-26?14:57??__MACOSX\[淇℃伅鍔炲叕]瀛︽牎鏁欏姟綆＄悊緋葷粺（jsp+servlet+javabean）_school\school\src\com\sevenEleven\
?????文件?????????120??2018-04-09?20:36??__MACOSX\[淇℃伅鍔炲叕]瀛︽牎鏁欏姟綆＄悊緋葷粺（jsp+servlet+javabean）_school\school\src\com\sevenEleven\._.DS_Store
?????目錄???????????0??2009-04-30?23:10??[淇℃伅鍔炲叕]瀛︽牎鏁欏姟綆＄悊緋葷粺（jsp+servlet+javabean）_school\school\src\com\sevenEleven\Beans\
?????文件?????????895??2007-05-12?17:23??[淇℃伅鍔炲叕]瀛︽牎鏁欏姟綆＄悊緋葷粺（jsp+servlet+javabean）_school\school\src\com\sevenEleven\Beans\CadminBean.java
?????文件????????9680??2007-05-12?17:23??[淇℃伅鍔炲叕]瀛︽牎鏁欏姟綆＄悊緋葷粺（jsp+servlet+javabean）_school\school\src\com\sevenEleven\Beans\CbestPageBean.java
?????文件????????1510??2007-05-13?14:45??[淇℃伅鍔炲叕]瀛︽牎鏁欏姟綆＄悊緋葷粺（jsp+servlet+javabean）_school\school\src\com\sevenEleven\Beans\CchooseTestBean.java
?????文件?????????560??2007-05-12?17:23??[淇℃伅鍔炲叕]瀛︽牎鏁欏姟綆＄悊緋葷粺（jsp+servlet+javabean）_school\school\src\com\sevenEleven\Beans\CclassBean.java
?????文件?????????401??2007-05-12?17:23??[淇℃伅鍔炲叕]瀛︽牎鏁欏姟綆＄悊緋葷粺（jsp+servlet+javabean）_school\school\src\com\sevenEleven\Beans\Clesson1Bean.java
............此處省略463個文件信息