jdbc获取clob图片_spring使用JdbcTemplate 读取clob属性字段

public static List queryListBlob(String sql,JdbcTemplate sjt){

List list=null;

list = sjt.query(sql, new RowMapper(){

public Object mapRow(ResultSet rs, int i) throws SQLException {

Map results = new HashMap();//存放对像的hashmap

CLOB clob = null;

String str = "";

try {

T_CASESTUDY bean=new T_CASESTUDY();//表对应的javaBean

clob = (oracle.sql.CLOB) rs.getClob("content");//content字段属性为clob,转成clob对象

str = clobToString(clob);将clob对象转为String

bean.setId(rs.getString("id"));

bean.setName(rs.getString("name"));

bean.setWebsite(rs.getString("website"));

bean.setImgpath(rs.getString("imgpath"));

bean.setContent(str);

bean.setCrdt(rs.getDate("crdt"));

bean.setCrusr(rs.getString("crusr"));

bean.setOrderid(rs.getInt("orderid"));

bean.setState(rs.getString("state"));

results.put(rs.getString("id"),bean);

} catch (Exception e) {

logger.error(e.getMessage());

results.put("content", "");

}

return results;

}

//此方法将clob转为String

public String clobToString(CLOB clob) throws SQLException, IOException {

String reString = "";

if( clob == null || clob.getCharacterOutputStream() == null )

return "";

Reader is = clob.getCharacterStream();// 得到流

BufferedReader br = new BufferedReader(is);

String s = br.readLine();

StringBuffer sb = new StringBuffer();

while (s != null) {// 执行循环将字符串全部取出付值给StringBuffer由StringBuffer转成STRING

sb.append(s);

s = br.readLine();

}

reString = sb.toString();

return reString;

}

});

}

分享到：

2012-09-13 11:35

浏览 7035

评论