extjs很简单的问题

Question

AdminServive.java

[code="java"] NewsDAO dao = new NewsDAO();
JSONObject _str = dao.Query();
response.getWriter().print(_str);
System.out.println(_str);[/code] [color=red]//为什么打印只有一条啊[/color]

NewsDAO.java

[code="java"]public static JSONObject Query(){
String sql = "select t.* from news t ";
JSONObject json = new JSONObject();
try {
Connection conn = DB_connect.createConnection();
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
while(rs.next()){
json.put("title", rs.getString("title"));
json.put("id", rs.getInt("id"));
// System.out.print(json.toStringcolor=red);//有很多条[/color] }
}
catch(Exception e ) {
e.printStackTrace();
}
return json;
}[/code]

Answer 1

[code="java"]
public static JSONArray Query(){

String sql = "select t.* from news t ";

JSONArray jsonArray = new JSONArray();

    try {   
        Connection conn = DB_connect.createConnection();   
        ps = conn.prepareStatement(sql);   
        rs = ps.executeQuery();   
        while(rs.next()){   

JSONObject json = new JSONObject();
json.put("title", rs.getString("title"));

json.put("id", rs.getInt("id"));

jsonArray.put(json);

        }   
    }   
    catch(Exception e ) {   
        e.printStackTrace();   
    }   
    return jsonArray ;   
}

[/code]

这样应该就是多条了
[code="java"]
NewsDAO dao = new NewsDAO();

JSONArray jsonArr= dao.Query();

for(int i=0;i<jsonArr.length();i++){
JSONObject obj= jsonArr.getJSONObject(i);

System.out.println(obj); 

}
[/code]