如题,我想把查询一列的结果放到一个String中,该怎么做呢?
我不会用Vector,HashMap,Hashtable这些了, 请给出详细代码嘛,谢谢 .
PreparedStatement stat =con.prepareStatement("select cStudentNo from BasicInfo ");
ResultSet rs=stat.executeQuery();
我不会用Vector,HashMap,Hashtable这些了, 请给出详细代码嘛,谢谢 .
PreparedStatement stat =con.prepareStatement("select cStudentNo from BasicInfo ");
ResultSet rs=stat.executeQuery();
用JAVA语言做了.
while(rs.next())
{
strResult = strResult+":"+rs.getString("cStudentNo");
}然後用一個數組
String str[] = strResult.split(":");
不过我还没有弄出来了.,,什么错误:
Column not found
java.lang.NullPointerException
at demo.Operate.jbInit(Operate.java:127)
at demo.Operate.<init>(Operate.java:70)
at demo.Operate.main(Operate.java:294)
不过我把
strResult = strResult+ ": "+rs.getString( "cStudentNo ");
注释掉,又能显示该列的值,这是怎么回事了?
是要先取出值,
但是这样做不太好做样了.
有没有其它的方法了.
您们看嘛是不是了?
strResult = strResult+ ": "+rs.getString( "cStudentNo "); 太粗心了.哎! 谢谢二楼您了.