?? dataaccess.java
字號:
package com.ascenttech.ebookstore.util;
import java.sql.*;
import java.util.Properties;
import javax.sql.*;
import javax.naming.*;
public class DataAccess {
private static String driver;
private static String url;
private static String user;
private static String pwd;
static{
DatabaseConfigParser databaseConfig=new DatabaseConfigParser();
try {
databaseConfig.parse("database.conf.xml");
Properties dbProps=databaseConfig.getProps();
driver=dbProps.getProperty("driver");
url=dbProps.getProperty("url");
user=dbProps.getProperty("user");
pwd=dbProps.getProperty("password");
} catch (Exception e) {
e.printStackTrace();
}
}
public DataAccess() throws Exception {
}
public static Connection getConnection(){
Connection con=null;
try {
Class.forName(driver);
con = DriverManager.getConnection(url, user, pwd);
}
catch (Exception ex) {
ex.printStackTrace();
}
return con;
}
public static Connection getConnectionByDS(){
Connection con = null;
try{
Context ctx = new InitialContext();
DataSource ds = (DataSource)ctx.lookup("ebsDS");
con = ds.getConnection();
}catch(Exception e){e.printStackTrace();}
return con;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -