package?MyBook;
import?java.sql.*;
import?java.lang.*;
public?class?Dblink
{
??String?SaPassword;//用戶名和密碼
??Connection?Conn?=?null;
??String?StrURL?=?“jdbc:odbc:“;//連接的數據庫
??String?ConnDriver?=?“sun.jdbc.odbc.JdbcOdbcDriver“;//jdbc.odbc使用的驅動程序
??Statement?Stmt?=?null;//聲明語句對象
??ResultSet?rs?=?null;//返回數據集
??public?void?Dblink（String?saString?passwordString?URL1）
??{
????StrURL?+=?URL1;
????Sa?=?sa;
????Password?=?password;
????try
????{
??????Class.forName（ConnDriver）;//指定使用的驅動程序
????}
????catch（ClassNotFoundException?e）
????{
??????System.err.println（e.getMessage（））;
????}
??}
??public?ResultSet?DbQuery（String?StrSQL）
??{
????try
????{
??????Conn?=?DriverManager.getConnection（StrURLSaPassword）;//連接數據庫
??????Stmt?=?Conn.createStatement（）;//得到Statement對象
??????rs?=?Stmt.executeQuery（StrSQL）;//執行SQL語句
????}
????catch（SQLException?e）
????{
??????System.err.println（e.getMessage（））;
????}
????return?rs;
??}
??public?void?DbExcute（String?StrSQL）
??{
????try
????{
??????Conn?=?DriverManager.getConnection（StrURLSaPassword）;
??????Stmt?=?Conn.createStatement（）;
??????Stmt.executeUpdate（StrSQL）;
????}
????catch（SQLException?e）
????{
??????System.err.println（e.getMessage（））;
????}
??}
}

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

?????目錄??????????0??2002-11-29?10:36??新建文件夾

?????目錄??????????0??2002-11-29?10:00??新建文件夾\MyBook

?????文件???????1853??2002-11-20?10:47??新建文件夾\MyBook\Dblink.class

?????文件???????1305??2002-11-20?10:47??新建文件夾\MyBook\Dblink.java

?????文件???????1303??2002-11-20?10:46??新建文件夾\MyBook\Dblink.java.bak

?????目錄??????????0??2002-11-29?10:28??新建文件夾\MyDatebase

?????文件????1133056??2002-11-29?10:34??新建文件夾\MyDatebase\MyDatebase.db

?????文件??????48128??2002-11-29?10:36??新建文件夾\readme.doc

?????目錄??????????0??2002-11-29?09:59??新建文件夾\SaleBook

?????文件???????1637??2002-11-23?10:48??新建文件夾\SaleBook\botton.html

?????文件???????1643??2002-11-22?16:07??新建文件夾\SaleBook\botton.html.bak

?????文件???????6046??2002-11-28?10:19??新建文件夾\SaleBook\BWSD.jsp

?????文件???????6046??2002-11-28?10:18??新建文件夾\SaleBook\BWSD.jsp.bak

?????文件???????1205??2002-11-27?17:26??新建文件夾\SaleBook\head.html

?????文件???????1224??2002-11-27?17:24??新建文件夾\SaleBook\head.html.bak

?????文件????????384??2002-11-28?11:22??新建文件夾\SaleBook\head.jsp

?????文件????????313??2002-11-23?09:54??新建文件夾\SaleBook\head.jsp.bak

?????文件????????960??2002-11-22?15:19??新建文件夾\SaleBook\head1.html

?????文件????????941??2002-11-22?15:19??新建文件夾\SaleBook\head1.html.bak

?????文件???????1207??2002-11-27?17:24??新建文件夾\SaleBook\headOver.html

?????文件???????1211??2002-11-27?17:23??新建文件夾\SaleBook\headOver.html.bak

?????文件???????1141??2002-11-28?11:18??新建文件夾\SaleBook\headRegist.html

?????文件???????1205??2002-11-28?11:18??新建文件夾\SaleBook\headRegist.html.bak

?????文件???????2362??2002-11-27?17:27??新建文件夾\SaleBook\Login0.jsp

?????文件???????2358??2002-11-27?17:11??新建文件夾\SaleBook\Login0.jsp.bak

?????文件???????3268??2002-11-27?17:27??新建文件夾\SaleBook\Login1.jsp

?????文件???????3264??2002-11-22?15:43??新建文件夾\SaleBook\Login1.jsp.bak

?????文件??????11992??2002-11-28?14:40??新建文件夾\SaleBook\Login2.jsp

?????文件??????11983??2002-11-27?17:27??新建文件夾\SaleBook\Login2.jsp.bak

?????文件???????1108??2002-11-27?17:27??新建文件夾\SaleBook\Login3.jsp

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