对 DB2 V9 中 XML 类型的编码处理(dW)

                
String url = "jdbc:db2://localhost:50000/testdb";
Connection con;
PreparedStatement stmt;
ResultSet rs;

try 
{                                                                        
	// Load the IBM DB2 Driver for JDBC and SQLJ
	Class.forName("com.ibm.db2.jcc.DB2Driver");                             

	// Create the connection using the IBM DB2 Driver for JDBC and SQLJ
	con = DriverManager.getConnection (url, 
                                "db2admin","db2admin");                                
	con.setAutoCommit(true);

	// Create the Statement
	stmt = con.prepareStatement("insert into T1 values(?)");

	//insert a xml data, readfile from a.xml with UTF-8 encoding
	String xml = readfile("c:/temp/a.xml");
	stmt.setString(1, xml);
	stmt.executeUpdate();

	//insert a xml data, readfile from b.xml with GBK encoding	
	stmt = con.prepareStatement("insert into T1 values(?)");
	xml = readfile("c:/temp/tmp/b.xml");
	stmt.setString(1, xml);
	stmt.executeUpdate();
	
	// Close the Statement
	stmt.close();
	con.close();                                                             
}
catch (Exception e){
	e.printStackTrace();
}
      

                
<?xml version="1.0" encoding="UTF-8"?>
<node>
你好
</node>
      

                
<?xml version="1.0" encoding="GBK"?>
<node>
你好
</node>
      

                
File file = new File("c:/temp/tmp/c.xml");
int size = (int)file.length();
FileInputStream fis = new FileInputStream(file);
byte[] buff = new byte[size];
int readed = 0;
while (readed < size)
	readed += fis.read(buff, readed, size-readed);
stmt.setBytes(1, buff);
stmt.executeUpdate();
      

                
<?xml version="1.0" encoding="GBK"?>
<node>
你好
</node>
      

                
<?xml version="1.0" encoding="GBK"?>
<node>
浣犲ソ
</node>
      

                
<node>
你好
</node>
      

                    
<?xml version="1.0" encoding="GBK"?>
<node>
你好
</node>