/********************************************************************
???????????????????????*?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（）;}??
}??

}

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

?????文件???????1510??2007-04-17?05:01??javaweb\CodePub.Com說明.txt

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

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

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

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

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

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

?????文件???????2601??2007-05-10?20:38??javaweb\WEB-INF\classes\wm\servlet\sendMess.class

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

????..A.SH.?????59904??2002-12-05?11:24??javaweb\images\Thumbs.db

?????文件??????31605??2007-01-10?01:38??javaweb\WEB-INF\lib\commons-logging.jar

?????文件??????16630??2006-08-24?03:14??javaweb\WEB-INF\lib\jstl.jar

?????文件?????236956??2004-05-28?06:49??javaweb\WEB-INF\lib\mysql-connector-java-3.0.14-production-bin.jar

?????文件?????440767??2007-01-10?01:38??javaweb\WEB-INF\lib\proxool-0.9.0RC3.jar

?????文件?????315295??2006-08-24?03:14??javaweb\WEB-INF\lib\standard.jar

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

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

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

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

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

?????文件???????2337??2007-05-10?20:46??javaweb\WEB-INF\classes\wm\servlet\sendMess.java

?????文件???????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

?????文件???????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

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

?????文件???????2810??2007-05-16?20:58??javaweb\wm.sql

?????文件??????15999??2006-08-24?03:14??javaweb\WEB-INF\tld\c.tld

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