Topic: 用ResultSet抓数据库字段如果字段为空！how

  Print this page
1.用ResultSet抓数据库字段如果字段为空！how Copy to clipboard
Posted by: czgdjzy
Posted on: 2004-09-06 14:46

用ResultSet抓数据库字段－－rs.getString("TERMID").trim()
如果字段为空！如何处理
检查ResultSet没有相关方法和属性啊～

如果不处理显示:
java.lang.NullPointerException
at org.apache.jsp.server_jsp._jspService(server_jsp.java:71)
2.Re:用ResultSet抓数据库字段如果字段为空！how [Re: czgdjzy] Copy to clipboard
Posted by: nothing
Posted on: 2004-09-06 14:52

What are you talking about?
3.Re:用ResultSet抓数据库字段如果字段为空！how [Re: czgdjzy] Copy to clipboard
Posted by: yang325
Posted on: 2004-09-07 13:39

null不能用TRIM()这个方法
你可以这样写String s=rs.getString("TERMID")==null?"":rs.getString("TERMID").trim();
4.Re:用ResultSet抓数据库字段如果字段为空！how [Re: czgdjzy] Copy to clipboard
Posted by: lnsylt
Posted on: 2004-09-09 17:33

同意！
String s=rs.getString("TERMID").trim();
if(s==null)
{
return true;
}
else
{
return false;
}
5.lnsylt [Re: czgdjzy] Copy to clipboard
Posted by: sunzy19810705
Posted on: 2004-09-16 09:29

大哥写得有问题应该是这样的：
String s=rs.getString("TERMID");
publis String chek(String s)
{
if(s==null)
{
return "";
}
else
{
return s.trim();
}
}

倘若你一开始就用String s=rs.getString("TERMID").trim();
的话，那么还是会报错的
6.Re:用ResultSet抓数据库字段如果字段为空！how [Re: czgdjzy] Copy to clipboard
Posted by: shanghuaqi888
Posted on: 2004-09-16 18:59

谢谢 各位大哥 帮助我了
7.Re:用ResultSet抓数据库字段如果字段为空！how [Re: czgdjzy] Copy to clipboard
Posted by: remanwang
Posted on: 2004-09-23 10:24

还是不能完全解决问题，如果是int就不能这么写

   Powered by Jute Powerful Forum® Version Jute 1.5.6 Ent
Copyright © 2002-2021 Cjsdn Team. All Righits Reserved. 闽ICP备05005120号-1
客服电话 18559299278    客服信箱 714923@qq.com    客服QQ 714923