className="oracle.jdbc.driver.OracleDriver";

uid="scott";

pwd="tiger";

url="jdbc:oracle:thin:@localhost:1521:ora92";

Class.forName(classname);

Connection conn=DriverManager.getConnection(url,uid,pwd);

//context是一组名称到对象的绑定组成

Hashtable env=new Hashtable ();

Context ctx=(Context)new InitialContext.lookup("env");// 获得数据源所在的上下文点的对象

DataSource ds=(DataSource)ctx.lookup(jndi);//找到数据源

Connection conn=ds.getConnection();//

StateMent stat=conn.createStatement();

ResultSet rs=stat.executeQuery(sql);//执行数据的查询语句(select);

stat.executeUpdate(sql);//执行数据的更新语句(inset into ,delete ,update ,drop)

stat.close();

PreparedStatement ps=conn.prepareStatement(sql);

ps.setInt(1,001);

ps.setString(2,"zhangmanli");

ps.executeQuery();

int count=ps.executeUpdate();

javax.naming.*;

sm=conn.createStatement(sql);

sm.executeUpdate();

sm.close();

import java.sql.*;

import javax.sql.DataSource;

import javax.naming.Context;

import javax.naming.InitialContext;

import java.util.Hashtable;

import java.util.Properties;

import java.io.*;

public class BasicExample{

    {

    public static void main(String args[]){

    Connection conn=null;

    try{

    Properties prop =new Properties();

    prop.load(new FileInputStream("simple.properties"));

    Hashtable env =new Hashtable();

    env.put(Context.INITIAL_CONTEXT_FACTORY,prop.getProperty("INITIAL_CONTEXT_FACTORY"));

    env.put(Context.PROVIDER_URL,prop.getProperty("PROVIDER_URL"));

    InitialContext ctx=new InitialContext(env);

    DataSource ds=(DataSource)ctx.lookup("Book");

    Conn=ds.getConnection();

    Statement stat=conn.createStatement();;

    ResultSet rs=stmt.executeQuery(sql);

    while(rs.next()){

    int id=Integer.parseInt(rs.getString("userId"));

    String userName=rs.getString ("username");

    }

    }catch(SQLException e){

    e.printStackTrace();

    }finally{

    try{

    if(conn!=null){

    conn.close();

    }

    }catch(SQLException e){

    e.printStackTrace();

    }

}

}

};