JSP读oracle字符数据

Question

java.sql.SQLException: 无法转换为内部表示
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:285)
at oracle.sql.CHAR.longValue(CHAR.java:375)
at oracle.sql.CHAR.intValue(CHAR.java:354)我的代码是这样的，……
<%@ page contentType="text/html;charset=gb2312"%>
<%request.setCharacterEncoding("gb2312");%>
<%@ page language="java" import="java.sql.*"%>
<jsp:useBean  id="sqlbean" scope="page" class="police.DBConnection"/>
<%
/******************************************
**             数据的读取                **
******************************************/
String sql,Str;int dalei=0;
sql="select * from fxq";
ResultSet rs1=sqlbean.executeQuery1(sql);
while(rs1.next()){
//daleiname=rs1.getString("name");
//dalei=rs1.getInt("id");
out.print(new String(rs1.getString(0)));
dalei++;
}
%>

Answer 1

用sys在oracle执行
update props$ set value$='SIMPLIFIED CHINESE_CHINA.ZHS16GBK
' where name='NLS_CHARACTERSET';out.print(new String(rs1.getString(0).getBytes("GBK"), "GB2312"));
如果没有执行上面的语句改变oracle的字符集就用以下语句，读数据
out.print(new String(rs1.getString(0).getBytes("GBK"), "ISO8859_1"));