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數(shù)據(jù)庫(kù)*/
		//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（）;
		}?
	}

}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件????????549??2012-03-21?22:54??school\.classpath

?????文件????????291??2012-03-21?21:08??school\.mymetadata

?????文件???????1412??2012-03-21?21:08??school\.project

?????文件????????500??2012-03-21?21:08??school\.settings\.jsdtscope

?????文件?????????49??2012-03-21?21:08??school\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2012-03-21?21:08??school\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件????????895??2012-03-21?21:08??school\src\com\sevenEleven\Beans\CadminBean.java

?????文件???????9680??2012-03-21?21:08??school\src\com\sevenEleven\Beans\CbestPageBean.java

?????文件???????1510??2012-03-21?21:08??school\src\com\sevenEleven\Beans\CchooseTestBean.java

?????文件????????560??2012-03-21?21:08??school\src\com\sevenEleven\Beans\CclassBean.java

?????文件????????401??2012-03-21?21:08??school\src\com\sevenEleven\Beans\Clesson1Bean.java

?????文件????????392??2012-03-21?21:08??school\src\com\sevenEleven\Beans\Clesson2Bean.java

?????文件???????1527??2012-03-21?21:08??school\src\com\sevenEleven\Beans\CstudentBean.java

?????文件???????1159??2012-03-21?21:08??school\src\com\sevenEleven\Beans\CteacherBean.java

?????文件????????754??2012-03-21?21:08??school\src\com\sevenEleven\Beans\CtextTestBean.java

?????文件???????2045??2012-03-21?21:08??school\src\com\sevenEleven\javaBean\admin_test\Cautomakescheme.java

?????文件???????4020??2012-03-21?21:08??school\src\com\sevenEleven\javaBean\admin_test\CgetCurrentTimeFromTimeClassBegin.java

?????文件??????10319??2012-03-21?21:08??school\src\com\sevenEleven\javaBean\admin_test\CmakeTeacherAndCourseTogether.java

?????文件????????587??2012-03-21?21:08??school\src\com\sevenEleven\javaBean\admin_test\CteacherAndLesson1ForClass.java

?????文件???????1335??2012-03-21?21:08??school\src\com\sevenEleven\javaBean\admin_test\CTimeClassUnit.java

?????文件???????5547??2012-03-21?22:50??school\src\com\sevenEleven\javaBean\CcheckUser.java

?????文件???????2176??2012-03-22?08:44??school\src\com\sevenEleven\javaBean\CConnectMSSQL.java

?????文件???????2680??2012-03-21?21:08??school\src\com\sevenEleven\javaBean\CdataFormat.java

?????文件???????3297??2012-03-21?22:53??school\src\com\sevenEleven\javaBean\CDBConnection.java

?????文件???????3120??2012-03-21?21:08??school\src\com\sevenEleven\javaBean\CDBOracle.java

?????文件???????1754??2012-03-21?21:08??school\src\com\sevenEleven\javaBean\CMethod.java

?????文件????????252??2012-03-21?21:08??school\src\com\sevenEleven\javaBean\Count.java

?????文件???????2141??2012-03-21?21:08??school\src\com\sevenEleven\javaBean\CreateTime.java

?????文件???????3835??2012-03-21?21:08??school\src\com\sevenEleven\javaBean\CseparateTime.java

?????文件????????485??2012-03-21?21:08??school\src\com\sevenEleven\javaBean\CTimeAndString.java

............此處省略449個(gè)文件信息