Thursday, November 20, 2008

JDBCConnection

/** getJDBCConnection
* @return Connection
**/
public Connection getJDBCConnection() throws Exception{

Connection connection= null;

String driver = dbDriver;
String user = dbId;
String password = dbPasswd;
String url = dbUrl;

Class.forName(driver);
connection = DriverManager.getConnection(url, user, password);

return connection;
}

/////////////////////
#properties file setting
global.database.dbUrl=jdbc:mysql://localhost:3306/aseanreg
global.database.dbId=root
global.database.dbPasswd=password
global.database.dbDriver=com.mysql.jdbc.Driver

No comments: