mysql读取text 大文本

2025-05-14 05:46:50
推荐回答(2个)
回答(1):

读取mysql数据库文本字段的值方法如下:
public void read() {
try {
//连接数据库
conn = JdbcUtils.getConnection();
//查询resume字段,text格式
String sql = "select resume from testclob where id=1";
pt = conn.prepareStatement(sql);
//执行查询并返回结果
rs = pt.executeQuery();
if (rs.next()) {
// rs.getCharacterStream读取该字段
Reader reader = rs.getCharacterStream("resume");
//定义字符数组来存放读取值
char buffer[] = new char[1024];
while ((reader.read(buffer)) != -1) {
//打印
System.out.println(buffer);
}
reader.close();
}
} catch (Exception e) {
e.printStackTrace();
} finally {
JdbcUtils.release(conn, pt, rs);
}
}

回答(2):

是不是把应该把if改成while啊