java jndi oracle_java-jndi(tomcat-oracle)

步骤一、META-INF下添加context.xml

type="javax.sql.DataSource"

maxActive="100" maxIdle="30" maxWait="5000" username="test"

password="test" driverClassName="oracle.jdbc.driver.OracleDriver"

url="jdbc:oracle:thin:@127.0.0.1:1521:orcl" />

步骤二、WEB-INF下web.xml中添加

DB Connection

jdbc/oracle

javax.sql.DataSource

Container

步骤三、在index.jsp

ResultSet rSet=null;

PreparedStatement ps=null;

Connection conn=null;

String sqlString=null;

try {

Context ctx=new InitialContext();

DataSource ds=(DataSource)ctx.lookup("java:comp/env/jdbc/oracle");

conn=ds.getConnection();

sqlString="select a,b from testa";

ps=conn.prepareStatement(sqlString);

rSet=ps.executeQuery();

out.print("

out.print("

");

out.print("

"+" 学号");

out.print("

"+" 姓名");

out.print("

");

while(rSet.next())

{

out.print("

");

out.print("

"+rSet.getString(1)+"");

out.print("

"+rSet.getString(2)+"");

out.print("

") ;

}

out.print("

");

} catch (Exception e) {

e.printStackTrace();

}finally{

ps.close();

rSet.close();

conn.close();

}

%>

步骤四、oracle数据库中建表

create table TESTA (   A VARCHAR2(10),   B VARCHAR2(50) );