lab16.java

jdbc 源代码

package com.jdbclab;
import java.sql.*;
import javax.sql.*;
import java.util.*;
import javax.naming.*;

public class Lab16
{
	public static void main(String[] args){
	  Connection con = null;
	  Context ctx = null;
	  DataSource ds = null;
	  try{
		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);
		ds = (DataSource)ctx.lookup("ora20");
		System.out.println("ds -> "+ds);
		con = ds.getConnection();
		System.out.println("con -> "+con);
	  }catch(Exception e){
	    e.printStackTrace();
	  }finally{
	    JdbcUtil.release(con);
		if(ctx!=null){
		  try{
		    ctx.close();
		  }catch(Exception ex){
		    ex.printStackTrace();
		  }
		}
	  }
	}
}