mysql 字符串存为blob

string存储为blob

引用：http://stackoverflow.com/questions/17400497/how-to-convert-blob-to-string-and-string-to-blob-in-java

PreparedStatement ps1 = conn.prepareStatement("update t1 set a2=? where id=1");
Blob blob = conn.createBlob();
blob.setBytes(1, str.getBytes());
ps1.setBlob(1, blob);
ps1.executeUpdate();

blob读取转码

String sqlString = "select CAST(" +  clobFieldName + " AS CHAR(10000) CHARACTER SET utf8) from " + tableName+" where " + pkName +" ='" + pkValue + "'";
ps = conn.prepareStatement(sqlString);
rs = ps.executeQuery();

blob流读取

String sqlString = "select " +  clobFieldName + " from " + tableName+" where " + pkName +" ='" + pkValue + "'";
ps = conn.prepareStatement(sqlString);
rs = ps.executeQuery();

Blob b = (Blob)rs.getBlob(1);
<span style="white-space:pre">				</span>
InputStream is = b.getBinaryStream();
ByteArrayInputStream bais = (ByteArrayInputStream)is;
byte[] byte_data = new byte[bais.available()]; //bais.available()返回此输入流的字节数


bais.read(byte_data, 0,byte_data.length);//将输入流中的内容读到指定的数组
String s;
try {
s = new String(byte_data,"utf-8");
} catch (UnsupportedEncodingException e) {
<span style="white-space:pre">	</span>// TODO Auto-generated catch block
<span style="white-space:pre">	</span>e.printStackTrace();
} //再转为String，并使用指定的编码方式