Rick's: MySQL 的JDBC 驅動程式

2009年6月22日星期一

使用MySQL的JDBC 驅動程式建立和資料庫的連線

瑞克提到...: package home.shitRick;

import java.io.FileInputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;

public class SimpleDBSource implements DBSource {
private Properties props;
private String url;
private String user;
private String passwd;

public SimpleDBSource() {
this("jdbc.properties");
}
public SimpleDBSource(String configFile) throws IOException,ClassNotFoundException {
props = new Properties();
props.load(new FileInputStream(configFile));
url = props.getProperty("home.shitRick.url");
user = props.getProperty("home.shitRick.user");
passwd = props.getProperty("home.shitRick.passwd");

Class.forname {
props.getProperty("home.shitRick.driver");
}
}
public Connection getConnection() throws SQLException {
return DriverManager.getConnection(url, user, passwd);
}
public void closeConnection(Connection conn) throws SQLException {
conn.close();
}; 2009年6月22日上午11:22