import java.io.IOException;
import java.io.InputStream;
import java.util.Properties;
import java.sql.DriverManager;
import java.sql.SQLException;
import
com.mysql.jdbc.Connection;
public
class JDBCTools {
public JDBCTools() {
}
public
static
Connection getConnection() throws IOException, SQLException {
Connection
conn = null;
Properties properties = newProperties();
InputStream inStream = JDBCTools.class.getClassLoader()
.getResourceAsStream("jdbc.properties");
properties.load(inStream);
String user = properties.getProperty("user");
String password = properties.getProperty("password");
String driverClass = properties.getProperty("driverClass");
String jdbcUrl = properties.getProperty("jdbcUrl");
conn = (Connection) DriverManager.getConnection(jdbcUrl,user,password);
return
conn;
|