帖子地址是:http://community.csdn.net/Expert/topic/4809/4809371.xml?temp=.4662287public static String getClobString(ResultSet rs, String col) {
try {
Reader reader = rs.getCharacterStream(col);
if (reader == null) {
return null;
}
StringBuffer sb = new StringBuffer();
char[] charbuf = new char[4096];
for (int i = reader.read(charbuf); i > 0; i = reader.read(charbuf)) {
sb.append(charbuf, 0, i);
}
return sb.toString();
} catch (Exception e) {
return "";
}
}ResultSet rs=query.getResult(sql);
while(rs.next()) {
Smemo=rs.getString("BREAK_result");
Smemo= getClobString(rs,Smemo);
}这样调用也不可以 为什么???????
顺序查询sql语句 ,我的是两个表 ,该怎么弄顺序算对呢
sql="SELECT a.BREAKDOWN_ID,a.BREAKDOWN_TIME, b.SITE_NAME, a.INFECTANT_ID, a.BREAKDOWN_TYPE_ID,";
sql=sql+"a.memo FROM BREAKDOWN a LEFT OUTER JOIN T_DIC_SUBSITE b ON a.SITE_ID = b.SITE_ID WHERE (CONVERT(char(10), a.BREAKDOWN_TIME, 120) >= '2005-08-10') AND (CONVERT(char(10), a.BREAKDOWN_TIME, 120) <= '2006-09-17') order by BREAKDOWN_ID desc";
try {
Reader reader = rs.getCharacterStream(col);
if (reader == null) {
return null;
}
StringBuffer sb = new StringBuffer();
char[] charbuf = new char[4096];
for (int i = reader.read(charbuf); i > 0; i = reader.read(charbuf)) {
sb.append(charbuf, 0, i);
}
return sb.toString();
} catch (Exception e) {
return "";
}
}ResultSet rs=query.getResult(sql);
while(rs.next()) {
Smemo=rs.getString("BREAK_result");
Smemo= getClobString(rs,Smemo);
}这样调用也不可以 为什么???????
顺序查询sql语句 ,我的是两个表 ,该怎么弄顺序算对呢
sql="SELECT a.BREAKDOWN_ID,a.BREAKDOWN_TIME, b.SITE_NAME, a.INFECTANT_ID, a.BREAKDOWN_TYPE_ID,";
sql=sql+"a.memo FROM BREAKDOWN a LEFT OUTER JOIN T_DIC_SUBSITE b ON a.SITE_ID = b.SITE_ID WHERE (CONVERT(char(10), a.BREAKDOWN_TIME, 120) >= '2005-08-10') AND (CONVERT(char(10), a.BREAKDOWN_TIME, 120) <= '2006-09-17') order by BREAKDOWN_ID desc";
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货