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

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

?????文件????????803??2014-06-11?16:20??第1章\jsp_jdbc\.classpath

?????文件???????1333??2014-06-11?16:20??第1章\jsp_jdbc\.project

?????文件????????522??2014-06-11?16:20??第1章\jsp_jdbc\.settings\.jsdtscope

?????文件????????164??2014-06-11?16:20??第1章\jsp_jdbc\.settings\com.genuitec.runtime.libraries.xml

?????文件????????364??2014-06-11?16:20??第1章\jsp_jdbc\.settings\org.eclipse.jdt.core.prefs

?????文件????????483??2014-06-11?16:20??第1章\jsp_jdbc\.settings\org.eclipse.wst.common.component

?????文件????????414??2014-06-11?16:20??第1章\jsp_jdbc\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2014-06-11?16:20??第1章\jsp_jdbc\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2014-06-11?16:20??第1章\jsp_jdbc\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????1387??2014-06-11?16:20??第1章\jsp_jdbc\src\org\easybooks\test\jdbc\SqlSrvDBConn.java

?????文件????????172??2014-06-11?16:20??第1章\jsp_jdbc\WebRoot\error.jsp

?????文件????????572??2014-06-11?16:20??第1章\jsp_jdbc\WebRoot\login.jsp

?????文件????????204??2014-06-11?16:20??第1章\jsp_jdbc\WebRoot\main.jsp

?????文件?????????39??2014-06-11?16:20??第1章\jsp_jdbc\WebRoot\meta-INF\MANIFEST.MF

?????文件???????1487??2014-06-11?16:20??第1章\jsp_jdbc\WebRoot\validate.jsp

?????文件???????2078??2014-06-11?16:20??第1章\jsp_jdbc\WebRoot\WEB-INF\classes\org\easybooks\test\jdbc\SqlSrvDBConn.class

?????文件?????466359??2014-06-11?16:20??第1章\jsp_jdbc\WebRoot\WEB-INF\lib\sqljdbc4.jar

?????文件????????426??2014-06-11?16:20??第1章\jsp_jdbc\WebRoot\WEB-INF\web.xml

?????文件????????803??2014-06-13?16:57??第2章\JSPExample\.classpath

?????文件???????1335??2014-06-13?16:57??第2章\JSPExample\.project

?????文件????????522??2014-06-13?16:57??第2章\JSPExample\.settings\.jsdtscope

?????文件????????164??2014-06-13?16:57??第2章\JSPExample\.settings\com.genuitec.runtime.libraries.xml

?????文件????????364??2014-06-13?16:57??第2章\JSPExample\.settings\org.eclipse.jdt.core.prefs

?????文件????????489??2014-06-13?16:57??第2章\JSPExample\.settings\org.eclipse.wst.common.component

?????文件????????414??2014-06-13?16:57??第2章\JSPExample\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2014-06-13?16:57??第2章\JSPExample\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2014-06-13?16:57??第2章\JSPExample\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????1472??2014-06-13?16:57??第2章\JSPExample\src\org\easybooks\test\jdbc\SqlSrvDBConn.java

?????文件???????1008??2014-06-13?16:57??第2章\JSPExample\src\org\easybooks\test\model\vo\LyTable.java

?????文件????????651??2014-06-13?16:57??第2章\JSPExample\src\org\easybooks\test\model\vo\UserTable.java

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