?? db.java
字號:
package library;
import java.sql.DriverManager;
import javax.sql.DataSource;
import java.sql.Connection;
import javax.naming.*;
import java.sql.SQLException;
public class DB {
//InitialContext ctx;
//DataSource ds;
Connection conn;
String DBDRIVER = "oracle.jdbc.driver.OracleDriver";
String DBURL = "jdbc:oracle:thin:@localhost:1521:library";
String DBUSER = "scott";
String DBPASSWORD = "anna";
public DB() {
}
public Connection getConnection(){
try{
// InitialContext ctx = new InitialContext();
// DataSource ds = (DataSource)ctx.lookup("jdbc/DBConnCoreDS");
// conn = ds.getConnection();
// InitialContext ic = new InitialContext();
// DataSource ds = (DataSource)ic.lookup("jdbc/DBConnectionCoreDS");
Class.forName(DBDRIVER);
conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);
return conn;
}catch(Exception e){
System.out.println("DB:getConnection:"+e.getMessage());
return null;
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -