jdbc-oracle-字符集-乱码

本地的数据库是oracle.字符集是WE8ISO8859P1,
提取过来的值是乱码。
实现办法：
插入一条记录:
Connection conn=null;
PreparedStatement pstmt = null;
try {
String strSql="insert into tabA(A,B) values(11&121)";
conn=ds.getConnection();
strSql = new String(strSql.getBytes("GBK"), "ISO-8859-1");
pstmt = conn.prepareStatement(strSql);
pstmt.executeUpdate();
}
catch (Exception e) {
} finally {
rs.close;
pstmt.close;
coon.close;
}

查询一条记录:
Connection conn=null;
PreparedStatement pstmt = null;
ResultSet rs=null;
try {
String sql="select B from tabA where A=1111";
conn=ds.getConnection();
Sql = new String(strSql.getBytes("GBK"), "ISO-8859-1");
pstmt = conn.prepareStatement(sql);
rs=pstmt.executeQuery();
String s;
if (rs.next()){
s=new String(rs.getString(1) .getBytes("ISO-8859-1"), "GBK");
}
catch (Exception e) {

}
finally {
rs.close;
pstmt.close;
coon.close;
}

总结：进行两次转码1.先是对sql语句进行转码；2.在进行对单个字段进行转码

转载于:https://www.cnblogs.com/aidan-1219/p/5915468.html