PHP与ORACLE 连接程序，中文乱码处理，有会的帮忙解决下?

为什么80%的码农都做不了架构师？>>>   

public class testjdbc {

//字符编码转换

private static String myTrans(String str){

String result=null;

        byte temp[];

        try

                {

                        temp=str.getBytes("ISO-8859-1");

                        result=new String(temp,"utf-8");

                }

                catch(java.io.UnsupportedEncodingException e)

                {

                        System.out.println(e.toString());

                }

                return result;

}

public static void main(String[] args) {

String driver = "oracle.jdbc.driver.OracleDriver";

String url = "jdbc:oracle:thin:@192.110.25.2:1521:orcl";

String username = "erp";

String password = "erp";

String sql = "insert into CST_ORDER_SHEET(CST_ORD_ID,STATUS,CREATED,LASTMOD,STORE_ID,CST_ID,CST_NAME,CST_CONTACT,CST_TEL,CST_EMAIL,CST_ADDRESS,ORDER_DATE,ORDER_AMOUNT,ORDER_MODE) values(CSTORDERSHEET_CSTORDID_SEQ.Nextval,'A',to_date ( '2012-09-06' , 'YYYY-MM-DD' ),to_date ( '2012-09-06' , 'YYYY-MM-DD' ),'0','500','雪儿','昆山4S店','15902191377', '289253657@qq.com','花桥镇黎明路88号',to_date ( '2012-09-06' , 'YYYY-MM-DD' ),'1694','2')";

for (int i = 4; i < 100000; i++) {

try {

Class.forName(driver);

// new oracle.jdbc.driver.OracleDriver();

Connection conn = DriverManager.getConnection(url, username,

password);

// Statement stat=conn.createStatement();

PreparedStatement pstmt = conn.prepareStatement(sql);

pstmt.setString(1, "i");

pstmt.setString(2, myTrans("中国"));   //字符编码的转换

pstmt.setString(3, "i");

pstmt.executeUpdate();

pstmt.close();

conn.close();

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

}

}

}

}

转载于:https://my.oschina.net/qgqlyy/blog/77165