为什么这个bean返回null
yxqc 2005-03-05 03:06:58 方法如下:
NewsMode 是一个参数类
DBConnection 是一个数据库类
已测式过SQL语句是没有问题的.
可是好像while循环走不进去,里面有个测式的,总是输出null.
不知首为什么?
public Vector findallNews()throws Exception
{
vc = new Vector();
nm = new NewsMode();
sbf = new StringBuffer(" select * from ");
sbf.append(NewsMode.TABLE_NAME);
sbf.append(" where mark = '是' order by Id desc ");
try
{
dbc = new DBConnection();
dbc.getConnection();
rs = dbc.executeQuery(sbf.toString());
System.out.println(sbf.toString());
while(rs.next())
{
nm.setId(rs.getInt("Id"));
System.out.println(rs.getInt(1));//
nm.setNewsName(rs.getString("newsname"));
nm.setNewsTitle(rs.getString("newstitle"));
nm.setNewsContent(rs.getString("newscontent"));
nm.setNewsDatetime(rs.getString("newsdatetime"));
nm.setMark(rs.getString("mark"));
nm.setPoint(rs.getInt("point"));
vc.add(nm);
}
dbc.close();
}
catch(Exception e)
{
System.out.println(e.getMessage());
}
return vc;
}