package?com.mingrisoft.dbutils;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.SQLException;

import?org.apache.commons.dbutils.DbUtils;
import?org.apache.commons.dbutils.QueryRunner;

public?class?QueryRunnerTest?{
????//?定義JDBC相關參數
????private?static?String?URL?=?“jdbc:mysql://localhost:3306/db_database18“;
????private?static?String?DRIVER?=?“com.mysql.jdbc.Driver“;
????private?static?String?USERNAME?=?“root“;
????private?static?String?PASSWORD?=?“111“;
????private?static?Connection?conn;
????
????public?static?Connection?getConnection（）?{//?用于獲得數據庫連接的工具方法
????????try?{
????????????DbUtils.loadDriver（DRIVER）;//?加載驅動
????????????conn?=?DriverManager.getConnection（URL?USERNAME?PASSWORD）;//?建立連接
????????}?catch?（SQLException?e）?{
????????????e.printStackTrace（）;
????????}
????????return?conn;
????}
????
????public?static?int?operate（String?sql?object...?params）?{//?用于執行有參數的SQL語句
????????int?result?=?0;
????????QueryRunner?runn

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件?????????375??2010-10-30?14:43??.classpath
?????文件?????????379??2010-09-11?17:01??.project
?????文件????????2063??2013-11-21?08:41??bin\com\mingrisoft\dbutils\QueryRunnerTest.class
?????文件???????41376??2013-11-15?13:52??lib\commons-dbutils-1.3.jar
?????文件??????703265??2013-11-15?13:53??lib\mysql-connector-java-5.1.6-bin.jar
?????文件????????1588??2010-10-30?14:44??src\com\mingrisoft\dbutils\QueryRunnerTest.java