long转string mybatis_Spring+Mybatis类型转换的问题，oracle数据库中有一个clob类型，怎样在查询以后转换为String类型？...

展开全部

首先你的思路就错的，不可能转换成string把大对象读进byte[]

public byte[] function(Connection connection,所需参数) throws EMPException{

PreparedStatement ps = null;

ResultSet rs = null;

byte[] data = null;

try {

.....省略

while (rs.next()) {

oracle.sql.CLOB  clob= (oracle.sql.CLOB) rs.getClob("大对象的32313133353236313431303231363533e78988e69d8331333332623330字段名");

InputStream inStream =clob.getBinaryStream();

long nLen = clob.length();

int nSize = (int) nLen;

data = new byte[nSize];

inStream.read(data);

inStream.close();

connection.commit();

}

} catch (SQLException e) {

EMPLog.log(this.getClass().getName(), EMPLog.INFO, 0, e.toString());

} catch (IOException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} finally {

try {

if (rs != null) {

rs.close();

rs = null;

}

if (ps != null) {

ps.close();

ps = null;

}

} catch (SQLException e) {

EMPLog.log(this.getClass().getName(), EMPLog.INFO, 0, e

.toString());

}

}

return data;

}

2.直接在页面上将对象读到页面上

response.setContentType("image/jpg");

response.setHeader("Content-Transfer-Encoding","base64");

ServletOutputStream toClient = response.getOutputStream();

out.clear();

out = pageContext.pushBody();

ByteArrayInputStream in = new ByteArrayInputStream(data);

int len;

byte[] buf = new byte[1024];

while ((len = in.read(buf, 0, 1024)) != -1) {

toClient.write(buf, 0, len);

}

toClient.flush();

toClient.close();

%>