百思不得其解,请教解决方法
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import = "java.sql.*"%>
<%
String DBDriver = "oracle.jdbc.driver.OracleDriver";
String DBurl = "jdbc:oracle:thin:@127.0.0.1:1521:db";
String user = "system";
String passwd = "manager";
try{
Class.forName(DBDriver);
Connection conn = DriverManager.getConnection(DBurl,user,passwd);
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
String sql = "select OPE_ID,OPE_NAME,OPE_TYPE,OPE_POPEDOM from OPERATOR_CODE";
ResultSet rs = stmt.executeQuery(sql);
//PreparedStatement ps = conn.prepareStatement("select node_name,node_no,father_no,menu_step from sys_stru",ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
//ResultSet rs = ps.executeQuery();
while (rs.next()){
out.println(rs.getString(2)+".");
}
}catch(Exception e){
System.out.println(e.getMessage());
}
%>
指定ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY属性后从ORACLE取出的数据前十条为十六进制,写成BEAN取出的数据也一样,十条后的数据都是正常的。我的环境是oracle 8.1.6 ,jboss 3.2.2