try{
String sql = "";
sql = "SELECT content "
+ "FROM t_inf01_additioninfo "
+ "WHERE id = " + String.valueOf(id) ; rs = conn.executeQuery(sql);
if (rs.next()){
Reader clob = rs.getCharacterStream(1);
BufferedReader br = new BufferedReader(clob);
String s = br.readLine();
while (s != null) {
scontent += s;
s = br.readLine();
}
}
} catch (Exception ex) {
ex.printStackTrace();
} finally {
rs.close();
conn.close();
conn=null;
}
String sql = "";
sql = "SELECT content "
+ "FROM t_inf01_additioninfo "
+ "WHERE id = " + String.valueOf(id) ; rs = conn.executeQuery(sql);
if (rs.next()){
Reader clob = rs.getCharacterStream(1);
BufferedReader br = new BufferedReader(clob);
String s = br.readLine();
while (s != null) {
scontent += s;
s = br.readLine();
}
}
} catch (Exception ex) {
ex.printStackTrace();
} finally {
rs.close();
conn.close();
conn=null;
}
解决方案 »
- linux下可以直接使用WIN下的jdbc吗?
- 关于display的结果······························
- 数据库执行完executeUpdate操作以后可以不关闭连接吗?为什么我一关闭连接就报空指针异常呢?
- Session无法失效,就4行文字。
- 大家新年好!请问从数据库取出来的ArrayList集合。。怎么控制其在页面一条一条的显示!
- 谁能提供一个完整的JSP程序
- 在web.xml中配置<servlet>,什么时候该配,什么时候不配。看几天JSP,人都晕了。
- form表单提交给jsp页面,getParameter获取值一直是空
- 请教各位大虾:如何使用前面几个页中得到的select下拉框中的值.
- ?请问servlet中的sevice()主要写什么?为什么有的没sevice(),只有doget()各dopost()呢。初学请指教。谢谢!
- 散千金但求一篇网文,有好兄弟的发邮件给我,急用
- 关于sql server 2000中的datetime数据类型问题
BufferedReader reader = null;
StringBuffer datastr =null;
try {
if (clo != null) {
reader = new BufferedReader(clo.getCharacterStream());
String data = null;
datastr = new StringBuffer();
try { while ( (data = reader.readLine()) != null)
datastr.append(data).append('\r').append('\n');
}
catch (IOException ex) {
System.out.println(ex);
}
finally {
try {
reader.close();
}
catch (IOException ex) {}
}
}
else
return "";
}
catch (SQLException ex) {}
return datastr.toString();
}