1,237
社区成员
发帖
与我相关
我的任务
分享weblogic6.1+oracle9i下写了一个简单的javabean(编译通过),但是运行时出现异常！！希望高手帮忙看以下，指点一二。
bean:
package com;
import javax.naming.*;
import java.sql.*;
import javax.sql.*;
import java.util.*;
public class TestOracle{
Context ctx;
DataSource ds;
Connection conn;
Statement st;
ResultSet rs;
public int id;
public String sql,name,addr;
public Connection getConn() throws Exception{
ctx = new InitialContext();
ds = (DataSource)ctx.lookup("oraclejndi");
conn = ds.getConnection();
return conn;
}
public Vector getRecords() throws Exception{
Vector v=new Vector();
sql="select id,name,addr from system.person";
st=getConn().createStatement();
rs=st.executeQuery(sql);
while(rs.next()){
TestOracle to=new TestOracle();
to.id=rs.getInt("id");
to.name=rs.getString("name");
to.addr=rs.getString("addr");
v.add(to);
}
rs.close();
st.close();
System.out.println("size="+v.size());
return v;
}
}
jsp:
<%@ page import="java.util.*,com.*" %>
<html>
<body>
<%
TestOracle to =new TestOracle();
Vector vt =to.getRecords();
Enumeration e =vt.elements();
while(e.hasMoreElements()){
TestOracle oe=(TestOracle)e.nextElement();
out.print(oe.id+" ");
out.print(oe.name+" ");
out.print(oe.addr);
out.print("<br>");
}
%>
</body>
</html>
package com;
import javax.naming.*;
import java.sql.*;
import javax.sql.*;
import java.util.*;
public class TestOracle{
Context ctx;
DataSource ds;
Connection conn;
Statement st;
ResultSet rs;
public int id;
public String sql,name,addr;
public Connection getConn() throws Exception{
ctx = new InitialContext();
ds = (DataSource)ctx.lookup("oraclejndi");
conn = ds.getConnection();
return conn;
}
public Vector getRecords() throws Exception{
Vector v=new Vector();
sql="select id,name,addr from system.person";
st=getConn().createStatement();
rs=st.executeQuery(sql);
while(rs.next()){
TestOracle to=new TestOracle();
to.id=rs.getInt("id");
to.name=rs.getString("name");
to.addr=rs.getString("addr");
v.add(to);
}
rs.close();
st.close();
System.out.println("size="+v.size());
return v;
}
}
jsp:
<%@ page import="java.util.*,com.*" %>
<html>
<body>
<%
TestOracle to =new TestOracle();
Vector vt =to.getRecords();
Enumeration e =vt.elements();
while(e.hasMoreElements()){
TestOracle oe=(TestOracle)e.nextElement();
out.print(oe.id+" ");
out.print(oe.name+" ");
out.print(oe.addr);
out.print("<br>");
}
%>
</body>
</html>
...全文
请发表友善的回复…
发表回复
