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;
        }
       
    }
}