为什么在java中将数据库里面的数据这样封装到一个集合里面,集合里面的元素都是数据库最后一行的数据呢?菜鸟求大神指点迷津(集合的元素是dao对象)publicListsubjectList(...
为什么在java中将数据库里面的数据这样封装到一个集合里面,集合里面的元素都是数据库最后一行的数据呢?菜鸟求大神指点迷津(集合的元素是dao对象 )
public List subjectList() {
Subject subject = new Subject();
List subjectList = new ArrayList();
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
try {
// 建立连接;
conn = JdbcUtilsSingle.getInstance().getConnection();
// 声明语句;
String sql = "select * from subjects ";
ps = conn.prepareStatement(sql);
// 执行语句;
rs = ps.executeQuery();
while (rs.next()) {
subject.setSubjectID(rs.getString("subjectID"));
subject.setSubjectTitle(rs.getString("subjectTitle"));
subject.setSubjectOptionA(rs.getString("subjectOptionA"));
subject.setSubjectOptionB(rs.getString("subjectOptionB"));
subject.setSubjectOptionC(rs.getString("subjectOptionC"));
subject.setSubjectOptionD(rs.getString("subjectOptionD"));
subject.setSubjectAnswer(rs.getString("subjectAnswer"));
subject.setSubjectParse(rs.getString("subjectParse"));
subjectList.add(subject);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
throw new RuntimeException("数据库异常!可能是读出异常!");
} finally {
JdbcUtilsSingle.getInstance().free(conn, ps, rs);
}
return subjectList;
}
展开