Java开发网 - oracle9i乱码问题,oracle817没问题

Java开发网

您没有登录

» Java开发网 » Database/JDBC/SQL/JDO/Hibernate » Oracle

打印话题 寄给朋友 订阅主题

作者

oracle9i乱码问题,oracle817没问题

yl9448

发贴: 3
积分: 0

于 2008-06-11 09:58

ORACLE: ORACLE9.2.0.7
NLS_NCHAR_CHARACTERSET: AL16UTF16
NLS_CHARACTERSET: WE8ISO8859P1

JAVA代码如下:
<%@ page import="java.sql.,java.text.,java.util.*" errorPage="" %>
<%@ page language="java" contentType="text/html;charset=UTF-8"%>
<%
String sDBDriver = "oracle.jdbc.driver.OracleDriver";
String sConnStr = "jdbc:oracle:thin Angry

localhost:1521:oracle";
Connection conn = null;
ResultSet rs = null;
Statement stmt = null;
Class.forName(sDBDriver);
try {
conn = DriverManager.getConnection(sConnStr, "user", "password");
stmt = conn.createStatement();
rs = stmt.executeQuery("select * from table1");
while (rs.next()) {
out.println(":" + "
");
}
conn.close();
}

catch (Exception e){
String err= e.getMessage();
String des = new String(err.getBytes("GBK"),"ISO8859-1");

out.println (e.getMessage () + "\n");
out.println("" +des + "");
out.println("
");
out.println("" +err + "");

}
%>

注:1. table1不存在,主要想输出oracle 错误提示,
2. oracle 817 显示正常

想输出oracle 错误提示,但
des输出一直是乱码,高人指点一下

已读帖子

新的帖子

被删除的帖子