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（）;
		}?
	}

}

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

?????文件????????168??2006-03-21?15:14??329t\ASP300使用注意.url

?????文件????????176??2006-04-11?10:21??329t\ASP300工具條.url

?????文件????????832??2009-04-30?23:13??329t\schooljw\.classpath

?????文件????????291??2009-05-01?10:47??329t\schooljw\.mymetadata

?????文件???????1224??2009-05-01?10:47??329t\schooljw\.project

?????文件?????????79??2008-09-10?13:53??329t\schooljw\CodeFans.net.url

?????文件????????895??2007-05-12?17:23??329t\schooljw\src\com\sevenEleven\Beans\CadminBean.java

?????文件???????9680??2007-05-12?17:23??329t\schooljw\src\com\sevenEleven\Beans\CbestPageBean.java

?????文件???????1510??2007-05-13?14:45??329t\schooljw\src\com\sevenEleven\Beans\CchooseTestBean.java

?????文件????????560??2007-05-12?17:23??329t\schooljw\src\com\sevenEleven\Beans\CclassBean.java

?????文件????????401??2007-05-12?17:23??329t\schooljw\src\com\sevenEleven\Beans\Clesson1Bean.java

?????文件????????392??2007-05-12?17:23??329t\schooljw\src\com\sevenEleven\Beans\Clesson2Bean.java

?????文件???????1527??2007-05-12?17:23??329t\schooljw\src\com\sevenEleven\Beans\CstudentBean.java

?????文件???????1159??2007-05-12?17:23??329t\schooljw\src\com\sevenEleven\Beans\CteacherBean.java

?????文件????????754??2007-05-12?17:23??329t\schooljw\src\com\sevenEleven\Beans\CtextTestBean.java

?????文件?????????79??2008-09-10?13:53??329t\schooljw\src\com\sevenEleven\CodeFans.net.url

?????文件???????2045??2007-05-12?17:23??329t\schooljw\src\com\sevenEleven\javaBean\admin_test\Cautomakescheme.java

?????文件???????4020??2007-05-12?17:23??329t\schooljw\src\com\sevenEleven\javaBean\admin_test\CgetCurrentTimeFromTimeClassBegin.java

?????文件??????10319??2007-05-13?19:49??329t\schooljw\src\com\sevenEleven\javaBean\admin_test\CmakeTeacherAndCourseTogether.java

?????文件????????587??2007-05-12?17:23??329t\schooljw\src\com\sevenEleven\javaBean\admin_test\CteacherAndLesson1ForClass.java

?????文件???????1335??2007-05-12?17:23??329t\schooljw\src\com\sevenEleven\javaBean\admin_test\CTimeClassUnit.java

?????文件???????5502??2009-05-01?12:27??329t\schooljw\src\com\sevenEleven\javaBean\CcheckUser.java

?????文件???????2185??2009-05-01?10:31??329t\schooljw\src\com\sevenEleven\javaBean\CConnectMSSQL.java

?????文件???????2680??2007-05-12?17:23??329t\schooljw\src\com\sevenEleven\javaBean\CdataFormat.java

?????文件???????3281??2009-05-01?00:37??329t\schooljw\src\com\sevenEleven\javaBean\CDBConnection.java

?????文件???????3120??2009-05-01?10:34??329t\schooljw\src\com\sevenEleven\javaBean\CDBOracle.java

?????文件???????1754??2007-05-13?09:34??329t\schooljw\src\com\sevenEleven\javaBean\CMethod.java

?????文件????????252??2007-05-12?17:23??329t\schooljw\src\com\sevenEleven\javaBean\Count.java

?????文件???????2141??2007-05-13?18:56??329t\schooljw\src\com\sevenEleven\javaBean\CreateTime.java

?????文件???????3835??2007-05-12?17:23??329t\schooljw\src\com\sevenEleven\javaBean\CseparateTime.java

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