修改前:
List list=new ArrayList<>();
Connection conn=null;
Statement st=null;
ResultSet rs=null;
Book book=new Book();//这里只实例化了一个对象
conn=dbutils.getConnection();
String sql="select distinct(name),author,description,image from book";
st=conn.createStatement();
rs=st.executeQuery(sql);
while(rs.next()) {
//给一个引用对象不停的复制属性
book.setName(rs.getString("name"));
book.setAuthor(rs.getString("author"));
book.setImage(rs.getString("image"));
book.setDescription(rs.getString("description"));
//book永远是一个,属性是最后一个都是相同的
list.add(book);
}
修改后:
List list=new ArrayList<>();
Connection conn=null;
Statement st=null;
ResultSet rs=null;
conn=dbutils.getConnection();
String sql="select distinct(name),author,description,image from book";
st=conn.createStatement();
rs=st.executeQuery(sql);
while(rs.next()) {
Book book=new Book();
book.setName(rs.getString("name"));
book.setAuthor(rs.getString("author"));
book.setImage(rs.getString("image"));
book.setDescription(rs.getString("description"));
list.add(book);
}