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:thinlocalhost: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输出一直是乱码,高人指点一下
|