package?org.easybooks.test.jdbc;
import?java.sql.*;
public?class?SqlSrvDBConn?{
	private?Statement?stmt;
????private?Connection?conn;
????ResultSet?rs;
????//在構造方法中創建數據庫連接
????public?SqlSrvDBConn（）{
????	stmt=null;
????	try{
????		/**加載并注冊?SQLServer?2008?的?JDBC?驅動*/
????		Class.forName（“com.microsoft.sqlserver.jdbc.SQLServerDriver“）;
????		conn=DriverManager.getConnection（“jdbc:sqlserver://localhost:1433;databaseName=TEST““sa““123456“）;
????	}catch（Exception?e）{
????		e.printStackTrace（）;
????	}
????	rs=null;
????}
????//執行查詢類的SQL語句，有返回集
????public?ResultSet?executeQuery（String?sql）
????{
????????try
????????{
????????	stmt=conn.createStatement（ResultSet.TYPE_SCROLL_SENSITIVEResultSet.CONCUR_UPDATABLE）;
????????	rs=stmt.executeQuery（sql）;
????????}catch（SQLException?e）{
????????	System.err.println（“Data.executeQuery:?“?+?e.getMessage（））;
????????}
????????return?rs;
????}
????//關閉對象
????public?void?closeStmt（）
????{
????????try
????????{
????????????stmt.close（）;
????????}catch（SQLException?e）{
????????	System.err.println（“Data.executeQuery:?“?+?e.getMessage（））;
????????}
????}
????public?void?closeConn（）
????{
????????try
????????{
????????????conn.close（）;
????????}catch（SQLException?e）{
????????	System.err.println（“Data.executeQuery:?“?+?e.getMessage（））;
????????}
????}
}

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

?????文件???????1383??2014-08-27?21:35??源程序\網上購書系統\bookstore\.classpath

?????文件????????435??2014-08-27?21:35??源程序\網上購書系統\bookstore\.myhibernatedata

?????文件???????1542??2014-08-27?21:35??源程序\網上購書系統\bookstore\.project

?????文件????????425??2014-08-27?21:35??源程序\網上購書系統\bookstore\.springBeans

?????文件???????1004??2014-08-27?21:35??源程序\網上購書系統\bookstore\WebRoot\addToCart_success.jsp

?????文件???????2385??2014-08-27?21:35??源程序\網上購書系統\bookstore\WebRoot\browseBookPaging.jsp

?????文件???????1014??2014-08-27?21:35??源程序\網上購書系統\bookstore\WebRoot\checkout_success.jsp

?????文件????????609??2014-08-27?21:35??源程序\網上購書系統\bookstore\WebRoot\foot.jsp

?????文件???????1983??2014-08-27?21:35??源程序\網上購書系統\bookstore\WebRoot\head.jsp

?????文件????????940??2014-08-27?21:35??源程序\網上購書系統\bookstore\WebRoot\index.jsp

?????文件???????1236??2014-08-27?21:35??源程序\網上購書系統\bookstore\WebRoot\login.jsp

?????文件????????869??2014-08-27?21:35??源程序\網上購書系統\bookstore\WebRoot\login_success.jsp

?????文件????????704??2014-08-27?21:35??源程序\網上購書系統\bookstore\WebRoot\menu.jsp

?????文件????????828??2014-08-27?21:35??源程序\網上購書系統\bookstore\WebRoot\newBook_success.jsp

?????文件???????2004??2014-08-27?21:35??源程序\網上購書系統\bookstore\WebRoot\register.jsp

?????文件????????837??2014-08-27?21:35??源程序\網上購書系統\bookstore\WebRoot\register_success.jsp

?????文件???????1919??2014-08-27?21:35??源程序\網上購書系統\bookstore\WebRoot\searchBook_result.jsp

?????文件???????2039??2014-08-27?21:35??源程序\網上購書系統\bookstore\WebRoot\showCart.jsp

?????文件????????318??2014-08-27?21:35??源程序\網上購書系統\bookstore\WebRoot\WEB-INF\dwr.xml

?????文件??????75574??2014-08-27?21:35??源程序\網上購書系統\bookstore\WebRoot\WEB-INF\spring-form.tld

?????文件??????17344??2014-08-27?21:35??源程序\網上購書系統\bookstore\WebRoot\WEB-INF\spring.tld

?????文件???????2060??2014-08-27?21:35??源程序\網上購書系統\bookstore\WebRoot\WEB-INF\web.xml

?????文件??????69002??2014-08-27?21:35??源程序\網上購書系統\bookstore\WebRoot\WEB-INF\lib\commons-fileupload-1.3.1.jar

?????文件?????173587??2014-08-27?21:35??源程序\網上購書系統\bookstore\WebRoot\WEB-INF\lib\commons-io-2.2.jar

?????文件?????315805??2014-08-27?21:35??源程序\網上購書系統\bookstore\WebRoot\WEB-INF\lib\commons-lang3-3.1.jar

?????文件??????62050??2014-08-27?21:35??源程序\網上購書系統\bookstore\WebRoot\WEB-INF\lib\commons-logging-1.1.3.jar

?????文件?????503117??2014-08-27?21:35??源程序\網上購書系統\bookstore\WebRoot\WEB-INF\lib\dwr.jar

?????文件?????931168??2014-08-27?21:35??源程序\網上購書系統\bookstore\WebRoot\WEB-INF\lib\freemarker-2.3.19.jar

?????文件?????614203??2014-08-27?21:35??源程序\網上購書系統\bookstore\WebRoot\WEB-INF\lib\javassist-3.11.0.GA.jar

?????文件?????227997??2014-08-27?21:35??源程序\網上購書系統\bookstore\WebRoot\WEB-INF\lib\ognl-3.0.6.jar

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