数据库查询 第一个字段有值 其他字段为空

Question

ResultSet rs=null;
String username=null;
String password="";
String u_mail="";
String u_sex=null;
String u_qq=null;
String u_question=null;
String u_answer=null;
String u_truename=null;
SqlManager sm=SqlManager.createInstance();
sm.connectDB();
String str="select * from users where u_answer='kaka'";
rs=sm.executeQuery(str);
try{
while(rs.next()){
username=rs.getString("username");
password=rs.getString("u_password");
u_mail=rs.getString("u_mail");
u_sex=rs.getString("u_sex");
u_qq=rs.getString("u_qq");
u_question=rs.getString("u_question");
u_answer=rs.getString("u_answer");
u_truename=rs.getString("u_truename");
}
}catch(SQLException ex){
System.out.println(ex);
}

                           sm.closeDB();
                           
                           System.out.println(username);
System.out.println(password);
System.out.println(u_mail);
System.out.println(u_sex);
System.out.println(u_qq);
                            System.out.println(u_question);
                            System.out.println(u_answer);
                            System.out.println(u_truename);数据库连接成功 打印完以后 只有username有值 其他字段都没有值 请各位帮帮忙！！！！！

Answer 1

两种可能
一、取得的数据就是只有username有值，其他字段都没有值
二、"u_password"、"u_mail"……与数据库字段名不匹配

Answer 2

 nvl(username,null)用这种nvl函数试试

Answer 3

根据lZ的代码。。 是不是u_mail等跟你查询的数据库字段不一样啊。
  或者是你所查询的记录除了username外其他的就是空值？

Answer 4

ResultSet rs=null; 
String username=null; 
String password=""; 
String u_mail=""; 
String u_sex=null; 
String u_qq=null; 
String u_question=null; 
String u_answer=null; 
String u_truename=null; 
SqlManager sm=SqlManager.createInstance(); 
sm.connectDB(); 
String str="select * from users where u_answer='kaka'"; 
rs=sm.executeQuery(str); 
try{ 
while(rs.next()){ 
username=rs.getString(1); 
password=rs.getString(2); 
u_mail=rs.getString(3); 
u_sex=rs.getString(4); 
u_qq=rs.getString(5); 
u_question=rs.getString(6); 
u_answer=rs.getString(7); 
u_truename=rs.getString(8); 
} 
}catch(SQLException ex){ 
System.out.println(ex); 
}                           sm.closeDB(); 
                          
                          System.out.println(username); 
System.out.println(password); 
System.out.println(u_mail); 
System.out.println(u_sex); 
System.out.println(u_qq); 
                            System.out.println(u_question); 
                            System.out.println(u_answer); 
                            System.out.println(u_truename);