首頁猿問以下是部分代碼,請高手幫忙看看問題...

以下是部分代碼,請高手幫忙看看問題出在哪里？

C

SMILET 2023-03-17 17:13:59

public List<Category> getCategoryList() throws SQLException {Connection conn = null;PreparedStatement ps = null;ResultSet rs = null;try {conn = DbUtil.getConnection();String sql = "select * from category";ps = conn.prepareStatement(sql);rs = ps.executeQuery(sql);List<Category> categoryList = new ArrayList<Category>();Category c = new Category();while (rs.next()) {c.setcId(rs.getInt("cId"));System.out.println("ci Dao===="+rs.getInt("cId"));c.setName(rs.getString("name"));c.setDescribes(rs.getString("describes"));c.setContentTime(rs.getString("contentTime"));categoryList.add(c);}System.out.println("categoryList.get(0).getCid()=="+categoryList.get(0).getcId());//輸出3System.out.println("categoryList.get(1).getCid()=="+categoryList.get(1).getcId());//輸出3 和上面的一樣 ???????return categoryList;} finally {DbUtil.close(rs, ps);}}

查看完整描述

2 回答

慕婉清6462132

TA貢獻1804條經驗獲得超2個贊

把Category c = new Category();寫到循環(huán)里面去就好了！
while (rs.next()) {
Category c = new Category();

c.setcId(rs.getInt("cId"));
System.out.println("ci Dao===="+rs.getInt("cId"));
c.setName(rs.getString("name"));
c.setDescribes(rs.getString("describes"));
c.setContentTime(rs.getString("contentTime"));
categoryList.add(c);
}