Jdbc连接oracle远程数据库字符集US7ASCII中文乱码解决

#Jdbc连接oracle远程数据库字符集US7ASCII中文乱码解决| 来源: 网络整理| 查看: 265

一、环境描述

数据库：oracle11g 字符集：AMERICAN_AMERICA.US7ASCII 查询字符集sql语句：

select userenv('language') from dual;

JDK1.8 oracle驱动包

com.oracle ojdbc 6 二、问题描述

因为程序代码本身的编码是utf-8，使用jdbc连接查询oracle数据库表数据中文乱码，plsql设置环境变量NLS_LANG=AMERICAN_AMERICA.US7ASCII 是能解决plsql显示正常，但是程序使用jdbc连接数据库还是乱码。

三、解决方案

直接上代码：

package com.joe.jdbc; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.*; /** * @author joe * @Title: ascii字符集 * @Description: * @date 2022/9/3014:37 */ public class Test_ACSII_Oracle { static { try { Class.forName("oracle.jdbc.driver.OracleDriver"); }catch (ClassNotFoundException e) { e.printStackTrace(); } } //定义数据库连接地址 public static final String DBURL = "jdbc:wrap-jdbc:filters=encoding:jdbc:oracle:thin:@//192.168.0.233:1521/helowin"; public static final String DBUSER = "test"; public static final String DBPASS = "123456"; public static void main(String[] agrs) throws Exception{ String sql = "select code,fee_type from t_fee_type"; Properties props = new Properties(); props.setProperty("serverEncoding","ISO-8859-1"); props.setProperty("clientEncoding","GBK"); props.put("user", DBUSER); props.put("password", DBPASS); Connection conn = (Connection) DriverManager.getConnection(DBURL,props); PreparedStatement ps = (PreparedStatement)conn.prepareStatement(sql, ResultSet.TYPE_SCROLL_SENSITIVE); //Statement stmt = conn.createStatement(); //ps.setNString(1,"病程记录"); ResultSet rs = ps.executeQuery(); List mapList = print(rs); for (Map objectMap : mapList) { System.out.println(objectMap); } //关闭资源 if(rs!=null){rs.close();} if(ps!=null){ps.close();} if(conn!=null){conn.close();} } public static List print(ResultSet rs)throws Exception{ int rowCount = 0; long begin = System.currentTimeMillis(); List list = new ArrayList(); while (rs.next()){ rowCount++; Map map = new HashMap(); //获取数据 map.put("code",rs.getString(1)); //map.put("fee_type2",new String(rs.getString("fee_type").getBytes("ISO-8859-1"),"GBK")); map.put("fee_type3",rs.getString(2)); list.add(map); } long end = System.currentTimeMillis(); System.out.println("总共行数："+rowCount); System.out.println("耗时："+ (end-begin)/1000+"秒"); return list; } }

在这里插入图片描述核心改造： 1、配置服务端编码和客户端编码

Properties props = new Properties(); props.setProperty("serverEncoding","ISO-8859-1"); props.setProperty("clientEncoding","GBK");

2、url

jdbc:wrap-jdbc:filters=encoding:

【本文地址】

公司简介

联系我们