Java 备份BLOB类型的数据生成INSERT语句可识别的字符
做数据库备份得时候，备份二进制的数据类型如BLOB类型的数据
public static String hexToString() throws Exception {
try {
? ? ? ? ? ? ? ? ? ? ? ?InputStream in = rs.getBinaryStream(1);
int b;
StringBuffer result =new StringBuffer();
while ((b = in.read()) != -1) {
String hex = Integer.toHexString(b & 0xFF);
if (hex.length() == 1) {
hex = 0 + hex;
}
result.append(hex.toUpperCase());
}
return "0x"+result.toString();
} catch (Exception e) {
throw e;
}
}
?
