Question

rs = stmt.executeQuery(sql)出现问题！

public ArrayList<BlogArticle> findBlogArticlesByType(char typeCode) {

ResultSet rs = null;
Statement stmt = null;
ArrayList<BlogArticle> list=new ArrayList<BlogArticle>();
String sql = "select*from sb_blog "
+ "(user_id, blog_title,blog_content,blog_type_id,creat_time,privacy_id)"
+" values ('"
+ null
+ "','"
+ null
+ "','"
+ null
+ "','"
+ typeCode
+ "','"
+ null
+ "','"
+ null
+ "');";
try {
rs = stmt.executeQuery(sql);
ResultSetMetaData rsmd = rs.getMetaData();
int count = rsmd.getColumnCount();
String[] name = new String[count];
for(int j=0;j<count;j++){
name[j] = rsmd.getCatalogName(1+j);
}
while(rs.next()){
Map rsDbo = newHashMap();
for(int k =0;k<name.length;k++){
rsDbo.put(name[k].toUpperCase(), rs.getString(name[k]));
}
list.add((BlogArticle) rsDbo);
}
} catch (SQLException e) {
e.printStackTrace();
}
return list;
}

写了一个方法，寻找博客的种类，在mysql中只定义了两种1或者2，我现在写了sql语句查询，将查询的结果放在arraylist里面，然后放回上一层！
但是，现在是报错在rs = stmt.executeQuery(sql);这一句，请高手帮忙看看！不胜感谢

Answer 1

select*from sb_blog这个*的前后应该加上空格吧……

还有，select * from tableA a where a.id = 'xx' ; select语句应该这么写，values是insert时候用的