/********************************************************************
???????????????????????*?Date:2007-04-03?*
???????????????????????*?File:DB.java????*
???????????????????????*?Author:jezz?????*
*********************************************************************/
package?wm.bean;

import?java.sql.*;
import?javax.naming.*;
import?javax.sql.DataSource;
//一個用于查找數據源的工具類。
public?class?DB?{
private?Connection?con=null;
private?Statement?stmt=null;
ResultSet?rs=null;

public??ResultSet?executeQuery（String?sql）?throws?Exception
{
//rs=null;
try
{???
?Class.forName（“org.logicalcobwebs.proxool.ProxoolDriver“）;
?con?=?DriverManager.getConnection（“proxool.xml-test“）;
?stmt=con.createStatement（ResultSet.TYPE_SCROLL_SENSITIVEResultSet.CONCUR_UPDATABLE）;???
?rs=stmt.executeQuery?（sql）;

}
catch（SQLException?e）{throw?e;}
//catch（NamingException?e）{throw?e;}

return?rs;
}


????//執行InsertUpdate語句??
public?void?executeUpdate（String?sql）?throws?Exception
{
//stmt?=?null;??
//rs=null;??
try
{??
??Class.forName（“org.logicalcobwebs.proxool.ProxoolDriver“）;
??con?=?DriverManager.getConnection（“proxool.xml-test“）;//讀取配置文件
??stmt=con.createStatement（ResultSet.TYPE_SCROLL_SENSITIVEResultSet.CONCUR_UPDATABLE）;???
??stmt.executeUpdate（sql）;
?
}
catch（SQLException?ex）?
{
System.err.println（“執行SQL語句出錯:?“?+?ex.getMessage（））;??
}
}


//?關閉stmt和關閉連接
public?void?all_close（）??
{??
try{
	if（con!=null）
?????con.close（）;
??//if（stmt!=null）
?????//stmt.close（）;
??if（rs!=null）
?????rs.close（）;
}??
catch（SQLException?e）{e.printStackTrace（）;}??
}??

}

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

?????文件???????2066??2007-03-07?08:34??javaweb\china-code.net.txt

?????文件???????2995??2007-03-24?22:12??javaweb\code.jsp

?????文件???????1075??2007-04-18?16:40??javaweb\common.jsp

?????文件????????853??2007-04-15?01:23??javaweb\del.jsp

?????文件???????2066??2007-03-07?08:34??javaweb\images\china-code.net.txt

?????文件???????2918??2006-01-16?18:38??javaweb\images\header-bg.png

?????文件???????1974??2006-01-16?18:38??javaweb\images\logo.gif

?????文件???????3810??2007-05-15?19:00??javaweb\images\web.css

?????文件??????13457??2007-03-07?08:49??javaweb\images\說明.html

?????文件???????3369??2007-05-16?20:50??javaweb\index.jsp

?????文件???????1592??2007-04-14?19:53??javaweb\login.jsp

?????文件???????2364??2007-05-10?15:42??javaweb\new.jsp

?????文件???????1313??2007-05-16?21:56??javaweb\readme.txt

?????文件???????2378??2007-05-10?21:26??javaweb\reply.jsp

?????文件???????2066??2007-03-07?08:34??javaweb\WEB-INF\china-code.net.txt

?????文件???????2066??2007-03-07?08:34??javaweb\WEB-INF\classes\china-code.net.txt

?????文件???????2066??2007-03-07?08:34??javaweb\WEB-INF\classes\wm\bean\china-code.net.txt

?????文件???????1708??2007-05-10?15:14??javaweb\WEB-INF\classes\wm\bean\DB.class

?????文件???????1653??2007-05-10?15:13??javaweb\WEB-INF\classes\wm\bean\DB.java

?????文件???????2938??2007-05-12?23:52??javaweb\WEB-INF\classes\wm\bean\messFun.class

?????文件???????3570??2007-05-12?23:52??javaweb\WEB-INF\classes\wm\bean\messFun.java

?????文件???????3212??2007-05-16?20:03??javaweb\WEB-INF\classes\wm\bean\page.class

?????文件???????3300??2007-05-16?20:03??javaweb\WEB-INF\classes\wm\bean\page.java

?????文件??????13457??2007-03-07?08:49??javaweb\WEB-INF\classes\wm\bean\說明.html

?????文件???????2066??2007-03-07?08:34??javaweb\WEB-INF\classes\wm\china-code.net.txt

?????文件???????2271??2007-05-10?20:58??javaweb\WEB-INF\classes\wm\servlet\checkin_admin.class

?????文件???????2081??2007-05-10?21:15??javaweb\WEB-INF\classes\wm\servlet\checkin_admin.java

?????文件???????2066??2007-03-07?08:34??javaweb\WEB-INF\classes\wm\servlet\china-code.net.txt

?????文件???????1805??2007-05-10?21:44??javaweb\WEB-INF\classes\wm\servlet\post.class

?????文件???????1758??2007-05-10?21:41??javaweb\WEB-INF\classes\wm\servlet\post.java

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