lab15.java

jdbc 源代码

package com.jdbclab;
import java.sql.*;
import java.util.*;
import javax.naming.*;
import javax.sql.*;
import oracle.jdbc.pool.OracleDataSource;

public class Lab15
{
	public static void main(String[] args){
	  Context ctx = null;
	  try{
	    OracleDataSource ds = new OracleDataSource();
	    ds.setDriverType("thin");
        ds.setServerName("192.168.0.20");
        ds.setNetworkProtocol("tcp");
        ds.setDatabaseName("tarena");
        ds.setPortNumber(1521);
        ds.setUser("openlab");
        ds.setPassword("open123");

	    //1.连接JNDI服务器
	    Hashtable env = new Hashtable();
	    env.put (Context.INITIAL_CONTEXT_FACTORY,
        "com.sun.jndi.fscontext.RefFSContextFactory");
        env.put (Context.PROVIDER_URL, "file:c:/jdbc");
	    ctx = new InitialContext(env);
        //2.将数据源对象存入JNDI服务器
	    ctx.bind("ora20",ds);
	  }catch(Exception e){
	    e.printStackTrace();
	  }finally{
	    if(ctx!=null){
		  try{
		    ctx.close();
		  }catch(Exception ex){
		    ex.printStackTrace();
		  }
		
		}
	  }
	}
}