package?com.util;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.ResultSetmetaData;
import?java.sql.SQLException;
import?java.sql.Statement;
import?java.util.ArrayList;
import?java.util.List;

public?class?BallotUtil?{
????static?Connection?conn?=?null;
????
????//?獲取數據庫連接
????public?static?Connection?getConn（）?{
????????try?{
????????????Class.forName（“net.sourceforge.jtds.jdbc.Driver“）;?//?加載數據庫驅動
????????}?catch?（ClassNotFoundException?e）?{
????????????e.printStackTrace（）;
????????}
????????String?url?=?“jdbc:jtds:sqlserver://localhost:1433;DatabaseName=db_database22“;?//?連接數據庫URL
????????String?userName?=?“sa“;?//?連接數據庫的用戶名
????????String?passWord?=?““;?//?連接數據庫密碼
????????try?{
????????????conn?=?DriverMan

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件?????????289??2015-08-28?13:53??.classpath
?????文件?????????379??2015-08-28?13:53??.project
?????文件?????????629??2015-08-28?13:53??.settings\org.eclipse.jdt.core.prefs
?????文件????????3153??2015-08-28?13:53??bin\com\util\BallotUtil.class
?????文件?????????758??2015-08-28?13:53??bin\com\util\BallotUtilframe$1.class
?????文件?????????725??2015-08-28?13:53??bin\com\util\BallotUtilframe$2.class
?????文件?????????722??2015-08-28?13:53??bin\com\util\BallotUtilframe$3.class
?????文件????????4399??2015-08-28?13:53??bin\com\util\BallotUtilframe.class
?????文件??????294726??2015-08-28?13:53??lib\jtds-1.2.2.jar
?????文件????????2792??2015-08-28?13:53??src\com\util\BallotUtil.java
?????文件????????4760??2015-08-28?13:53??src\com\util\BallotUtilframe.java