java连接Oracle乱码_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.在进行对单个字段进行转码