| tSet resultSet){
_connection = connection;
_statement = statement;
_resultSet = resultSet;
}
private Connection getConnection(){
return _connection;
}
private Statement getStatement(){
return _statement;
}
public ResultSet getResultSet(){
return _resultSet;
}
public void close() throws SQLException{
getResultSet().close();
getStatement().close();
getConnection().close();
}
}
揖扮?糞?匯倖全俊勧由方象垂議絹廁窃?
package queen.data;
import java.io.IOException;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.DriverManager;
import java.util.Properties;
/*
* 方象垂恵諒匂
*
* @author Howard Queen
* @version 1.0.1, 2010/10/12
* */
public final class DbExecutor implements IExecutor {
static{
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
private String _connectionString;
private String _userName, _password;
public String getConnectionString() {
return _connectionString;
}
public void setConnectionString(String value) throws Exception {
throw new Exception("萩聞喘揖兆嶷墮圭隈 setConnectionString(String connectionString,
String userName, String password) 譜崔全俊歌方!");
}
public void setConnection(String connectionString, String userName, String password){
_connectionString = connectionString;
_userName = userName;
_password = password;
}
public void setConnectionFromProperties(String fileName, String connectionStringPropertyName,
String userNamePropertyName, String passwordPropertyName) throws IOException{
Properties p = new Properties();
p.load(DbExecutor.class.getResourceAsStream(fileName));
String connectionString = p.getProperty(connectionStringPropertyName);
String userName = p.getProperty(userNamePropertyName);
String password = p.getProperty(passwordPropertyName);
setConnection(connectionString, userName, password);
}
public String getUserName(){
return _userName;
}
public String getPassword(){
return _password;
}
private int _timeout;
public int getTimeout() {
return _timeout;
}
public void setTimeout(int value) {
_timeout = value;
}
public int executeNonQuery(String statement) throws Exception{
Connection con = null;
Statement stm = null;
try{
con = DriverManager.getConnection(getConnectionString(), getUserName(), getPassword());
|
