81,091
社区成员
发帖
与我相关
我的任务
分享
String sql="SELECT Sum(merit_inventory_chuhuo.quality) AS xquality, merit_inventory_chuhuo.sku FROM merit_inventory_chuhuo GROUP BY merit_inventory_chuhuo.sku";
db.query(sql);
while(db.rs_next()){
sku=db.rs_getString("sku");
quality=db.rs_getInt("xquality");
out.print(rows+". "+sku+" "+quality+"<br>");
}
//....
ResultSet rs = null;
public ResultSet query(String strSql){
try{
this.rs = stmt.executeQuery(strSql);
return this.rs;
}catch(SQLException e){
return null;
}catch(NullPointerException e){
return null;
}catch(IOException e){
return null;
}
}
public String rs_getString(int column){
try{
return this.rs.getString(column);
}catch(SQLException e){
return e.toString();
}
}
public int rs_getInt(String column){
try{
return this.rs.getInt(column);
}catch(SQLException e){
return -1;
}
}
//....