Question

java swing 界面模糊查询？为什么表格不显示数据

public Vector<Vector> searchMemInfo_theme(String theme) {
// TODO Auto-generated method stub
Log.log(this, "searchMemInfo_theme");
Connection conn = null;
PreparedStatement stmt = null;
ResultSet rs = null;
Vector v = null;
Vector<Vector> meminfo = new Vector<Vector>();
try {
conn = Dbcp.getConnection();
stmt = conn.prepareStatement(Constants.QUERY_MEMORANDUM_THEME);
stmt.setString(1, "'%"+theme+"%'");
Log.log(this, "'%"+theme+"%'");
rs = stmt.executeQuery();
while(rs.next()){
Log.log(this, "MemDao:");
v = new Vector();
v.add(rs.getInt("M_NUM"));
v.add(rs.getString("M_THEME"));
v.add(rs.getString("M_CONTENT"));
v.add(rs.getString("M_WEEK"));
v.add(rs.getTimestamp("M_TIME"));

meminfo.add(v);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
Dbcp.close(rs,stmt, conn);
Log.log( this, "savememinfo:"+Constants.QUERY_MEMORANDUM_THEME);
}

return meminfo;
}

Answer 1

你这是查询语句啊大哥，我建议你打断点调试啊，就是debug啊

说没有数据显示：这个很多因素可以导致的啊，数据库的因素，查询语句的因素，表格的因素等等啊

你载入数据后，有没有validate这个表格啊