打印查询到的mysql_怎么把在mySql查询到的信息打印出来？

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

//查询所有商品

public List findAllCommodity(){

Commodity commodity=new Commodity();

Connection conn=DBConnection.getConnection(); //获得连接对象

String querySQL="select * from shop";

PreparedStatement ps=null; //声明预处理对象

ResultSet rs=null;

List list=new ArrayList();

try {

ps=conn.prepareStatement(querySQL); //获得预处理对象并赋值

rs=ps.executeQuery(querySQL);

while(rs.next()){

commodity.setId(rs.getInt("id"));

commodity.setName(rs.getString("name"));

commodity.setPrice(rs.getDouble("price"));

commodity.setAigo(rs.getDouble("aigo"));

list.add(commodity);

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}finally{

DBConnection.close(ps); //关闭预处理对象

DBConnection.close(conn); //关闭连接对象

DBConnection.close(rs); //关闭结果集

}

return list;

}