package?com.database;

import?com.mysql.jdbc.Connection;
import?com.mysql.jdbc.Statement;
import?com.valuebean.UserSingle;
import?com.valuebean.voteSingle;

import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.ArrayList;

public?class?DB?{
	private?String?className;
	private?String?url;
	private?String?username;
	private?String?password;
	private?Connection?con;
	private?Statement?st;
	private?ResultSet?res;
	public?DB（）?{
		className=“com.mysql.jdbc.Driver“;
		url=“jdbc:mysql://localhost:3306/votedb“;
		username?=?“root“;
		password?=?“3.14159“;
	}
	public?void?loadDriver（）?{
		try?{
			Class.forName（className）;
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			System.out.println（“加載數據庫驅動失??！“）;
			e.printStackTrace（）;
		}
	}
	public?void?getConnection（）?{
		loadDriver（）;
		try?{
			con?=?（Connection）?DriverManager.getConnection（url?username?password）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			System.out.println（“連接數據庫失??！“）;
			e.printStackTrace（）;
		}
	}
	public?void?getStatement（）?{
		getConnection（）;
		try?{
			st?=?（Statement）?con.createStatement（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			System.out.println（“獲取statement對象失敗“）;
			e.printStackTrace（）;
		}
	}
	public?void?getResultSet（String?sql）?{
		if（sql?!=?null?&&?!sql.equals（““））?{
			getStatement（）;
			try?{
				res?=?st.executeQuery（sql）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				System.out.println（“查詢數據庫失敗！“）;
				e.printStackTrace（）;
			}
		}
	}
	public?void?closed（）?{
		try?{
			if（res?!=?null）?{
				res.close（）;
			}
			if（con?!=?null）?{
				con.close（）;
			}
			if（st?!=?null）?{
				st.close（）;
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			System.out.println（“關閉數據庫失敗！“）;
			e.printStackTrace（）;
		}
	}
	public?int?update（String?sql）?{
		int?i?=?-1;
		if（sql?!=?null?&&?!sql.equals（““））?{
			getStatement（）;
			try?{
				i?=?st.executeUpdate（sql）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				System.out.println（“數據庫更新失??！“）;
				e.printStackTrace（）;
			}finally?{
				closed（）;
			}
		}
		return?i;
	}
	public?ArrayList?getVotes（）{
		String?sql?=?“select?*?from?vote“;
		getResultSet（sql）;
		ArrayList?votes?=?new?ArrayList（）;
		try?{
			while（res.next（））?{
				voteSingle?v?=?new?voteSingle（）;
				v.setId（res.getString（1））;
				v.settitle（res.getString（2））;
				v.setNum（res.getString（3））;
				votes.add（v）;
			}
			res.close（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?votes;
	}
	public?ArrayList?getUsers（）{
		String?sql?=?“select?*?from?users“;
		getResultSet（sql）;
		ArrayList?users?=?new?ArrayList（）;
		try?{
			wh

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-04-17?17:11??VoteDemo\
?????文件?????????840??2018-04-17?22:01??VoteDemo\.classpath
?????文件?????????908??2018-04-17?17:10??VoteDemo\.project
?????目錄???????????0??2018-04-17?17:10??VoteDemo\.settings\
?????文件?????????567??2018-04-17?17:10??VoteDemo\.settings\.jsdtscope
?????文件?????????364??2018-04-17?17:10??VoteDemo\.settings\org.eclipse.jdt.core.prefs
?????文件?????????476??2018-04-17?17:10??VoteDemo\.settings\org.eclipse.wst.common.component
?????文件?????????305??2018-04-17?17:10??VoteDemo\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2018-04-17?17:10??VoteDemo\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2018-04-17?17:10??VoteDemo\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2018-04-17?17:10??VoteDemo\build\
?????目錄???????????0??2018-04-17?22:01??VoteDemo\build\classes\
?????目錄???????????0??2018-04-17?22:01??VoteDemo\build\classes\com\
?????目錄???????????0??2018-04-17?22:01??VoteDemo\build\classes\com\database\
?????文件????????5385??2018-04-18?10:42??VoteDemo\build\classes\com\database\DB.class
?????目錄???????????0??2018-04-17?22:01??VoteDemo\build\classes\com\toolbean\
?????文件????????1579??2018-04-18?00:03??VoteDemo\build\classes\com\toolbean\MyTool.class
?????目錄???????????0??2018-04-17?22:01??VoteDemo\build\classes\com\valuebean\
?????文件?????????914??2018-04-17?22:01??VoteDemo\build\classes\com\valuebean\UserSingle.class
?????文件?????????891??2018-04-17?22:01??VoteDemo\build\classes\com\valuebean\voteSingle.class
?????目錄???????????0??2018-04-17?17:11??VoteDemo\Sql\
?????文件?????????464??2018-04-18?01:00??VoteDemo\Sql\init.sql
?????目錄???????????0??2018-04-17?19:30??VoteDemo\src\
?????目錄???????????0??2018-04-17?19:30??VoteDemo\src\com\
?????目錄???????????0??2018-04-17?17:46??VoteDemo\src\com\database\
?????文件????????4469??2018-04-18?10:42??VoteDemo\src\com\database\DB.java
?????目錄???????????0??2018-04-17?19:30??VoteDemo\src\com\toolbean\
?????文件?????????873??2018-04-18?00:03??VoteDemo\src\com\toolbean\MyTool.java
?????目錄???????????0??2018-04-17?17:44??VoteDemo\src\com\valuebean\
?????文件?????????449??2018-04-17?17:43??VoteDemo\src\com\valuebean\UserSingle.java
?????文件?????????441??2018-04-17?17:45??VoteDemo\src\com\valuebean\voteSingle.java
............此處省略13個文件信息