dbutil.java

连接oracle数据库的操作方法 tatic String driverName="oracle.jdbc.driver.OracleDriver" static String dbUrl="

package dbproject.model;

import java.io.*;
import java.sql.*;
 import javax.naming.Context;
 import javax.naming.InitialContext;
 import javax.naming.NamingException;
 import javax.sql.DataSource;



/**
 * <strong>DbUtil</strong> is a utility class to create
 * a connection to our sample database.
 */
public class DbUtil {
        static String driverName="oracle.jdbc.driver.OracleDriver";
        static String dbUrl="jdbc:oracle:thin:@10.1.1.44:1521:DBAWEB";
        static String user="DBA_WEB";
        static String password="DBA_WEB";
public DbUtil() {

}

public static Connection connectToDb(String hostName, String databaseName)throws Exception
{
        Context ctx=null;
        DataSource ds=null;
        Statement stmt=null;
        ResultSet rs=null;
        Connection myConn=null;
        try{
        ctx = new InitialContext();
        ds = (javax.sql.DataSource)
        ctx.lookup ("MyJDBCDS");//30DataSourceis jndi name
        }
        catch(Exception e)
        {
        System.out.println("init error"+e);
        }
        try
        {
        myConn = ds.getConnection();
      }
catch(Exception e)
{
System.out.println("init error"+e);
}
finally
{
if(rs !=null)
{
try
{
rs.close();
}
catch(Exception ignore){}
}
if(stmt!=null)
{
try
{
stmt.close();
}
catch(Exception ignore){}
}

}
           return myConn;
}

public static Connection connectToDb(String databaseName)throws Exception{
        return(connectToDb("localhost", databaseName));
}

public static java.sql.Connection connectToDb()throws Exception{
        return(connectToDb("localhost", "DBA_WEB"));
}


}