package?com.jyl.db;
import?java.sql.*;
public?class?DbManager?{
????private?static?final?String?DRIVERNAME?=
????????????“com.microsoft.jdbc.sqlserver.SQLServerDriver“;
????private?static?final?String?URL?=
????????????“jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=education“;
????private?static?final?String?UID?=?“sa“;
????private?static?final?String?PWD?=?““;
????private?Connection?conn?=?null;

????public?DbManager（）?throws?SQLException?ClassNotFoundException?{
????????//在實例化的時候加載
????????this.openConnection（）;
????}
????public?void?openConnection（）?throws?ClassNotFoundException?SQLException?{
????????Class.forName（DRIVERNAME）;
????????this.conn?=?DriverManager.getConnection（URLUIDPWD）?;
????}

????//此方法用于執行sql語句?有反回值
????public?void?executeUpdate（String?strSql）?throws?SQLException?{
?????Statement?stat=conn.createStatement（）;
?????stat.executeUpdate（strSql）;
???}

????public?ResultSet?executeQuery（String?Strsql）?throws?SQLException?{
????????Statement?stat?=?this.conn.createStatement（）;
????????return?stat.executeQuery（Strsql）;
????}



????public?void?closeConnection（）?throws?SQLException?{
????????if?（this.conn?!=?null）?{
????????????if?（!this.conn.isClosed（））?{
????????????????this.conn.close（）;
????????????}

????????}
????}
}

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

?????目錄??????????0??2008-01-27?17:08??我的畢業設計

?????目錄??????????0??2008-01-27?17:08??我的畢業設計\EducationData

?????文件????1310720??2008-01-13?21:49??我的畢業設計\EducationData\education_Data.MDF

?????文件????1048576??2008-01-13?21:49??我的畢業設計\EducationData\education_Log.LDF

?????目錄??????????0??2008-01-27?17:08??我的畢業設計\BY

?????文件????1293604??2007-11-23?16:11??我的畢業設計\BY\ai.exe

?????文件?????363095??2008-01-06?23:23??我的畢業設計\BY\BY.jar

?????文件???????6247??2008-01-13?21:05??我的畢業設計\BY\BY.jpx

?????文件???????6833??2008-01-23?12:48??我的畢業設計\BY\BY.jpx.local

?????文件???????6750??2008-01-23?12:48??我的畢業設計\BY\BY.jpx.local~

?????文件??????12010??2007-11-07?17:00??我的畢業設計\BY\hs_err_pid1260.log

?????文件???????8601??2007-11-07?14:10??我的畢業設計\BY\hs_err_pid1348.log

?????文件??????12393??2007-11-07?14:07??我的畢業設計\BY\hs_err_pid1428.log

?????文件???????8410??2007-11-15?17:55??我的畢業設計\BY\hs_err_pid1660.log

?????文件??????12014??2007-11-07?16:37??我的畢業設計\BY\hs_err_pid1840.log

?????文件???????8681??2007-11-07?14:19??我的畢業設計\BY\hs_err_pid1872.log

?????文件???????8603??2007-11-07?14:13??我的畢業設計\BY\hs_err_pid1908.log

?????文件??????12023??2007-11-07?16:57??我的畢業設計\BY\hs_err_pid1956.log

?????文件??????11334??2007-11-15?16:46??我的畢業設計\BY\hs_err_pid2040.log

?????文件??????14355??2007-11-12?21:32??我的畢業設計\BY\hs_err_pid2076.log

?????文件??????12002??2007-11-19?23:56??我的畢業設計\BY\hs_err_pid2184.log

?????文件??????11995??2007-11-21?20:36??我的畢業設計\BY\hs_err_pid3068.log

?????文件???????8481??2007-11-15?18:01??我的畢業設計\BY\hs_err_pid888.log

?????目錄??????????0??2008-01-27?17:08??我的畢業設計\BY\txt

?????文件??????????1??2008-01-05?17:42??我的畢業設計\BY\txt\beifen.txt

?????文件?????????23??2007-11-15?14:55??我的畢業設計\BY\txt\ShengMing.txt

?????文件????????120??2007-11-27?01:29??我的畢業設計\BY\txt\sos.txt

?????文件???????3401??2008-01-06?23:18??我的畢業設計\BY\txt\日志.txt

?????目錄??????????0??2008-01-27?17:08??我的畢業設計\BY\src

?????目錄??????????0??2008-01-27?17:08??我的畢業設計\BY\src\com

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