package?com.bwm.db;

import?java.sql.*;
public?class?Conn?{
????private?static?Connection?con;
????private?Statement?stmt;
????private?ResultSet?rs;
????private?static?final?String?drivername?=
????????“com.microsoft.jdbc.sqlserver.SQLServerDriver“;
????private?static?final?String?url?=?“jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=talentTable;user=sa;password=sa;“;
????
????//創建連接對象
????public?static?synchronized?Connection?getCon（）?throws?Exception?{
????????try?{
????????????Class.forName（drivername）;//反射機制
????????????con?=?DriverManager.getConnection（url）;
????????????return?con;
????????}?catch?（SQLException?e）?{
????????????System.err.println（e.getMessage（））;
????????????throw?e;
????????}
????}
????
????
????public?Statement?getStmtread（）?{
????????try?{
????????????con?=?getCon（）;//獲取數據庫連接
???????????//statement:?數據庫結果集的數據表，通過執行查詢數據庫的語句生成
????????????stmt?=?con.createStatement（ResultSet.TYPE_SCROLL_INSENSITIVE//設置為可滾動的，CONCUR_READ_ONLY常量指示不可以更新的?ResultSet?對象的并發模式
???????????????????????????????????????ResultSet.CONCUR_READ_ONLY）;
????????????return?stmt;
????????}?catch?（Exception?e）?{
????????????System.err.println（e.getMessage（））;
????????????e.printStackTrace（）;
????????}
????????return?null;
????}

????//獲取結果集
????public?ResultSet?getRs（String?sql）?{
????????try?{
????????????stmt?=?getStmtread（）;
????????????rs?=?stmt.executeQuery（sql）;//執行查詢數據庫的語句
????????????return?rs;
????????}?catch?（Exception?e）?{
????????????System.err.println（e.getMessage（））;
????????????e.printStackTrace（）;
????????}
????????return?null;
????}

????public?Statement?getStmt（）?{
????????try?{
????????????con?=?getCon（）;
????????????stmt?=?con.createStatement（）;//Statement?對象執行不帶參數的?SQL?語句
????????????return?stmt;
????????}?catch?（Exception?e）?{
????????????System.err.println（e.getMessage（））;
????????????e.printStackTrace（）;
????????}
????????return?null;
????}


????public?synchronized?void?close（）?{
????????try?{
????????????if?（rs?!=?null）?{
????????????????rs.close（）;
????????????????rs?=?null;
????????????}
????????}?catch?（Exception?e）?{
????????????System.err.println（e.getMessage（））;
????????????e.printStackTrace（）;
????????}
????????try?{
????????????if?（stmt?!=?null）?{
????????????????stmt.close（）;
????????????????stmt?=?null;
????????????}
????????}?catch?（Exception?e）?{
????????????System.err.println（e.getMessage（））;
????????????e.printStackTrace（）;
????????}
????????try?{
????????????if?（con?!=?null）?{
????????????????con.close（）;
????????????????con?=?null;
????????????}
????????}?catch?（Exception?e）?{
????????????System.err.println（e.getMessage（））;
????????????e.printStackTrace（）;
????????}
????}
}

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

?????文件???????1175??2010-05-24?18:09??TradZhaopinProject\.classpath

?????文件????????346??2010-05-26?19:18??TradZhaopinProject\.mymetadata

?????文件???????1242??2010-05-24?18:34??TradZhaopinProject\.project

?????文件???????1040??2010-05-24?18:35??TradZhaopinProject\.settings\com.genuitec.eclipse.j2eedt.core.prefs

?????文件???????2841??2010-05-18?23:53??TradZhaopinProject\src\com\bwm\db\Conn.java

?????文件???????2492??2010-05-10?21:04??TradZhaopinProject\src\com\bwm\db\Data.java

?????文件???????1144??2010-04-15?00:41??TradZhaopinProject\src\com\bwm\page\Show.java

?????文件???????1281??2010-05-10?21:04??TradZhaopinProject\src\com\bwm\string\Str.java

?????文件????????656??2010-05-10?21:04??TradZhaopinProject\src\com\bwm\time\Time.java

?????文件???????1471??2010-04-15?00:41??TradZhaopinProject\src\job\Cjob.java

?????文件???????1474??2010-04-15?00:41??TradZhaopinProject\src\job\Company.java

?????文件???????1471??2010-04-15?00:41??TradZhaopinProject\src\job\Sjob.java

?????文件???????2016??2010-04-15?00:41??TradZhaopinProject\src\job\Student.java

?????文件???????6074??2010-05-19?13:25??TradZhaopinProject\WebRoot\3761653_141325057886_1.jpg

?????文件????????702??2010-05-28?18:40??TradZhaopinProject\WebRoot\admin\admin.jsp

?????文件???????2090??2010-05-28?18:42??TradZhaopinProject\WebRoot\admin\aflink.jsp

?????文件???????1950??2010-05-28?18:41??TradZhaopinProject\WebRoot\admin\cjob.jsp

?????文件???????1887??2010-05-28?16:36??TradZhaopinProject\WebRoot\admin\company.jsp

?????文件????????450??2010-04-15?00:41??TradZhaopinProject\WebRoot\admin\dcjob.jsp

?????文件????????453??2010-04-15?00:41??TradZhaopinProject\WebRoot\admin\dcompany.jsp

?????文件????????445??2010-04-15?00:41??TradZhaopinProject\WebRoot\admin\dflink.jsp

?????文件????????450??2010-04-15?00:41??TradZhaopinProject\WebRoot\admin\dsjob.jsp

?????文件????????453??2010-04-15?00:41??TradZhaopinProject\WebRoot\admin\dstudent.jsp

?????文件???????2199??2010-05-28?18:42??TradZhaopinProject\WebRoot\admin\flink.jsp

?????文件????????164??2010-04-15?00:41??TradZhaopinProject\WebRoot\admin\include.jsp

?????文件???????1223??2010-04-15?00:41??TradZhaopinProject\WebRoot\admin\index\index.htm

?????文件???????2366??2010-05-28?19:51??TradZhaopinProject\WebRoot\admin\index.htm

?????文件????????565??2010-05-28?18:00??TradZhaopinProject\WebRoot\admin\login.htm

?????文件????????811??2010-04-15?00:41??TradZhaopinProject\WebRoot\admin\login.jsp

?????文件????????773??2010-04-15?00:41??TradZhaopinProject\WebRoot\admin\mflink.jsp

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