package?db;

import?java.sql.*;
import?java.util.Vector;
import?javax.swing.JOptionPane;

/**
?*?數據庫相關操作實現類
?*?@author?紫翡魚
?*/
public?class?DBOperation?{

????//?聲明靜態的JDBC連接數據庫操作對象
????private?static?DBPool?dbc?=?new?DBPool（）;
????
????//?聲明數據庫操作對象
????private?static?Connection?conn?=?null;
????private?static?Statement?stmt?=?null;
????private?static?ResultSet?rs?=?null;

????/**
?????*?從數據庫中查詢所有記錄
?????*?@param?sql?查詢語句
?????*?@return?record?二維數組
?????*/
????public?static?object[][]?getRecordFromDB（String?sql）?{
????????//?聲明
????????object[][]?record?=?null;
????????Vectorject[]>?v?=?new?Vectorject[]>（）;
????????
????????//?保存結果集的列數和行數
????????int?col?=?0;
????????int?row?=?0;

????????try?{
????????????//?與數據庫建立連接
????????????conn?=?dbc.getConnection（）;

????????????//?建立Statement對象
????????????stmt?=?conn.createStatement（）;

????????????//?執行SQL語句
????????????rs?=?stmt.executeQuery（sql）;
????????????
????????????//?從ResultSet對象的元數據中的獲得列數信息
			col?=?rs.getmetaData（）.getColumnCount（）;

????????????//?遍歷結果集中的記錄
			while?（rs.next（））?{
				object[]?vx?=?new?object[col];
				for?（int?c?=?0;?c?					//?據字段索引獲取該字段的內容（索引從1開始）
					vx[c]?=?rs.getobject（c?+?1）;
				}
				v.add（vx）;
			}

????????????//?獲得結果集中的記錄數
			row?=?v.size（）;

			//?初始化二維數組的大小
			record?=?new?object[row][col];

			//?轉化為二維數組
			record?=?v.toArray（record）;

????????}?catch?（SQLException?ex）?{
????????????JOptionPane.showMessageDialog（null?“對不起，SQL查詢出現異常，請稍后再試！“?“SQL查詢出錯“?JOptionPane.WARNING_MESSAGE）;
????????}?finally?{
????????????//?關閉，釋放資源
????????????try?{
????????????????if?（rs?!=?null）?{
????????????????????rs.close（）;
????????????????}
????????????????if?（stmt?!=?null）?{
????????????????????stmt.close（）;
????????????????}
????????????????if?（conn?!=?null）?{
????????????????????conn.close（）;
????????????????}
????????????}?catch?（SQLException?ex）?{
????????????????JOptionPane.showMessageDialog（null?“對不起，關閉相關資源出現異常，請稍后再試！“?“關閉相關資源出錯“?JOptionPane.WARNING_MESSAGE）;
????????????}
????????}

????????return?record;
????}


????/**
?????*?更新數據庫中的記錄
?????*?@@param?sql?增加語句
?????*?@return?true?or?false
?????*/
????public?static?int?updateRecordToDB（String?sql）?{
????????//?聲明操作影響到的記錄數
????????int?count?=?0;

????????try?{
????????????//?與數據庫建立連接
????????????conn?=?dbc.getConnection（）;

????????????//?建立Statement對象
????????????stmt?=?conn.createStatement（）;

????????????//?執行SQL語句
????????????count?=?stmt.executeUpdate（sql）;
????????????
?????????}?catch?（SQLException?ex）?{
????????????JOptionPane.showMessageDialog（null?“對不起，SQL執行出現異常，請稍后再試！“?“SQL查詢出錯“?JOptionPane.WARNING_MESSAGE）;
?????????}?finally?{
????????????//?關閉，釋放資源
????????????try?{
????????????????if?（stmt?!=?null）?{
????????????????????stmt.close（）;
????????????????}
????????????????if?（conn?!=?null）?{
????????????????????conn.close（）;
????????????????}
????????????}?catch?（SQLEx

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

?????文件????????340??2009-07-28?17:39??web_vote\.classpath

?????文件????????572??2009-07-28?17:35??web_vote\.project

?????文件????????360??2009-07-28?17:35??web_vote\.settings\.jsdtscope

?????文件?????????49??2009-07-28?17:35??web_vote\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2009-07-28?17:35??web_vote\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????1086??2009-07-30?17:19??web_vote\delete.jsp

?????文件???????1854??2008-11-01?16:49??web_vote\images\background.jpg

?????文件??????23975??2009-07-16?17:10??web_vote\images\login.jpg

?????文件???????9903??2008-07-28?16:41??web_vote\images\online_vote.gif

?????文件?????????65??2008-07-28?16:41??web_vote\images\progress.gif

?????文件???????3227??2009-08-01?15:35??web_vote\login.jsp

?????文件???????3965??2009-08-02?13:00??web_vote\manage.jsp

?????文件???????2381??2009-08-02?13:02??web_vote\result.jsp

?????文件???????3505??2009-08-05?16:29??web_vote\src\db\DBOperation.java

?????文件????????938??2009-08-05?14:48??web_vote\src\db\DBPool.java

?????文件???????2355??2009-08-02?12:56??web_vote\src\servlet\ChangeVote.java

?????文件???????1559??2009-07-29?19:35??web_vote\src\servlet\LoginHandleServlet.java

?????文件???????1468??2009-08-02?23:00??web_vote\src\servlet\VoteHandleServlet.java

?????文件???????3050??2009-08-02?12:58??web_vote\vote.jsp

?????文件???????3097??2009-08-05?16:29??web_vote\WEB-INF\classes\db\DBOperation.class

?????文件???????1185??2009-08-05?14:48??web_vote\WEB-INF\classes\db\DBPool.class

?????文件???????3248??2009-08-02?22:58??web_vote\WEB-INF\classes\servlet\ChangeVote.class

?????文件???????2537??2009-07-30?09:02??web_vote\WEB-INF\classes\servlet\LoginHandleServlet.class

?????文件???????2751??2009-08-02?23:00??web_vote\WEB-INF\classes\servlet\VoteHandleServlet.class

?????文件???????1374??2009-07-30?13:07??web_vote\WEB-INF\web.xml

?????目錄??????????0??2010-01-01?13:56??web_vote\WEB-INF\classes\db

?????目錄??????????0??2010-01-01?13:56??web_vote\WEB-INF\classes\servlet

?????目錄??????????0??2010-01-01?13:56??web_vote\src\db

?????目錄??????????0??2010-01-01?13:56??web_vote\src\servlet

?????目錄??????????0??2010-01-01?13:56??web_vote\WEB-INF\classes

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