package?db;
import?java.sql.*;

public?class??db{
String?sDBDriver?=?“sun.jdbc.odbc.JdbcOdbcDriver“;
String?sConnStr?=?“jdbc:odbc:class“;
Connection?conn?=?null;
ResultSet?rs?=?null;

public?db（）?{
try?{
Class.forName（sDBDriver）;?
}
catch（java.lang.ClassNotFoundException?e）?{
System.err.println（“bbsreg（）:?“?+?e.getMessage（））;
}
}

public?ResultSet?execute（String?sql）?{
rs?=?null;
try?{
conn?=?DriverManager.getConnection（sConnStr）;?
Statement?stmt?=?conn.createStatement（ResultSet.TYPE_SCROLL_INSENSITIVEResultSet.CONCUR_READ_ONLY）;
rs?=?stmt.executeQuery（sql）;
}?
catch（SQLException?ex）?{?
System.err.println（“aq.executeQuery:?“?+?ex.getMessage（））;
System.err.println（“aq.executeQuerystrSQL:?“?+?sql）;
}
return?rs;
}

public?String?makepage（ResultSet?testrsString?urlint?pageint?pagesize）?{
int?allpage=0;
String?str=““;??
try?{
testrs.last（）;
allpage=testrs.getRow（）;
if?（allpage>0）?
{?testrs.absolute（（page-1）?*?pagesize?+1）;
allpage=（allpage+pagesize-1）?/?pagesize;?
str?+=?“第?“+page+“?頁??共?“+allpage?+?“?頁“;??
if（page>1）???
str+=“?第一頁?“;???
else??
str+=“?第一頁?“;??
if（page>1）???
str+=“?上一頁?“;???
else??
str+=“?上一頁?“;??
if（page?str+=“?下一頁?“;???
else???
str+=“?下一頁?“;??
if（page?str+=“?最后頁?“;???
else??
str+=“?最后頁?“;???
}
else?
str=“zero“;
}?
catch（Exception?ex）?{?
System.err.println（“aq.executeQuery:?“?+?ex.getMessage（））;
System.err.println（“aq.executeQuerystrSQL:?“?+?allpage）;
}?
return?str;
}
public?void?Update（String?sql）?{
try?{
conn?=?DriverManager.getConnection（sConnStr）;?
Statement?stmt?=?conn.createStatement（）;
stmt.executeUpdate（sql）;
}?
catch（SQLException?ex）?{?
System.err.println（“aq.executeUpdate:?“?+?ex.getMessage（））;
System.err.println（“aq.executeUpadatestrSQL:?“?+?sql）;
}
}

public?void?close（）?{
try?{
conn.close（）;?
}?
catch（SQLException?ex）?{?
System.err.println（“aq.executeUpdate:?“?+?ex.getMessage（））;
}
}
}

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

?????文件??????10495??2001-12-10?22:16??班級通訊錄\change.jsp

?????文件???????1410??2001-12-11?09:45??班級通訊錄\changeok.jsp

?????文件?????192512??2007-12-13?22:10??班級通訊錄\data-base\man.mdb

????..AD...?????????0??2007-12-13?22:10??班級通訊錄\data-base

?????文件?????????95??2000-09-19?19:48??班級通訊錄\images\71_left.gif

?????文件?????????99??2000-09-19?19:48??班級通訊錄\images\71_middle.gif

?????文件?????????94??2000-09-19?19:48??班級通訊錄\images\71_right.gif

?????文件???????1409??2000-09-19?19:48??班級通訊錄\images\bar1.gif

?????文件???????1780??2000-09-19?19:48??班級通訊錄\images\l3.gif

?????文件????????486??2000-09-19?19:48??班級通訊錄\images\more1.gif

????..A.SH.??????8192??2007-12-13?22:10??班級通訊錄\images\Thumbs.db

????..AD...?????????0??2007-12-13?22:10??班級通訊錄\images

?????文件????????284??2001-12-10?16:01??班級通訊錄\in.jsp

?????文件???????6296??2001-12-10?17:32??班級通訊錄\index.htm

?????文件???????6854??2001-12-11?15:09??班級通訊錄\index.jsp

?????文件???????1180??2001-11-30?20:36??班級通訊錄\index2.jsp

?????文件???????2763??2001-11-28?20:44??班級通訊錄\index3.jsp

?????文件???????9914??2001-12-19?16:48??班級通訊錄\reg.htm

?????文件???????1826??2001-12-19?17:34??班級通訊錄\save.jsp

?????文件???????7227??2001-12-11?11:15??班級通訊錄\search.jsp

?????文件???????2975??2001-12-11?11:09??班級通訊錄\WEB-INF\classes\db\db.class

????..AD...?????????0??2007-12-13?22:10??班級通訊錄\WEB-INF\classes\db

?????文件???????2128??2001-12-11?11:09??班級通訊錄\WEB-INF\classes\db.java

?????文件???????1157??2001-11-29?11:07??班級通訊錄\WEB-INF\classes\db2.java

?????文件????????499??2001-12-05?19:04??班級通訊錄\WEB-INF\classes\org\jetic\web\notepad\DBConnect.class

?????文件???????3180??2001-12-05?19:04??班級通訊錄\WEB-INF\classes\org\jetic\web\notepad\Forward.class

?????文件????????111??2001-12-05?19:04??班級通訊錄\WEB-INF\classes\org\jetic\web\notepad\k666說明1.txt

?????文件???????2168??2001-12-05?19:04??班級通訊錄\WEB-INF\classes\org\jetic\web\notepad\NewPad.class

?????文件???????2994??2001-12-05?19:04??班級通訊錄\WEB-INF\classes\org\jetic\web\notepad\NewReply.class

?????文件???????2331??2001-12-05?19:04??班級通訊錄\WEB-INF\classes\org\jetic\web\notepad\Sendmail.class

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