tion e) {
e.printStackTrace();
}
DBUtil.close(connection, null, preparedStatement, null);
return commentList;
} （4）使用Statement操作数据库： public List getArticleMessage() {
Connection connection = DBUtil.getConn();
String sql = "select * from article";// 编写sql语句，第一个字段不需要插入，是自动增加的
Statement statement = null;
List articleList = new ArrayList();
try {
statement = connection.createStatement();
ResultSet rs = statement.executeQuery(sql);
//判断是否为空
if (rs.next()) {
while (rs.next()) {//将信息迭代到list中
Article article = new Article();
article.setTitle(rs.getString("title"));
article.setContext(rs.getString("context"));
article.setArticleTime(rs.getString("articletime"));
article.setUserid(rs.getInt("userid"));
article.setArticleid(rs.getInt("articleid"));
articleList.add(article);
}
} else {
return null;
}
} catch (SQLException e) {
e.printStackTrace();
}
DBUtil.close(connection, statement, null, null);
return articleList;
}
|