因为msgout是一TextArea
很明显应该是
msgout.setText(rs.getString(1));
所以应是:public void display( ResultSet rs ) {
try{
rs.next();
if(!rs.getString(1).equals("")){
msgout.setText(rs.getString(1));
}
else
msgout.setText("\nNo record found\n");
}catch(SQLException sqlex){
msgout.setText("\nNot found \n");
}
}
很明显应该是
msgout.setText(rs.getString(1));
所以应是:public void display( ResultSet rs ) {
try{
rs.next();
if(!rs.getString(1).equals("")){
msgout.setText(rs.getString(1));
}
else
msgout.setText("\nNo record found\n");
}catch(SQLException sqlex){
msgout.setText("\nNot found \n");
}
}
public void display( ResultSet rs ) {
try{
if (rs.next()){
System.out.println("haha");
if(rs.getObject(1)!=null){
System.out.println("hehe");
String str=rs.getString(1);
System.out.println("str="+str);
msgout.append(str);
}
}
else
msgout.append("\nNo record found\n");
}
catch(SQLException sqlex){
msgout.append("\nNot found \n");
}
}
我调试后却发现haha能显示,hehe不能,这说明rs.getObject(1)=null?
我的rs来自于:ResultSet rs = statement.executeQuery(query);
而我的query是可以在TextArea中显示的啊?!这该怎么办了?