怎么在文本区域显示多条数据,语言:java,数据库:mysql
答案:1 悬赏:70 手机版
解决时间 2021-03-21 20:24
- 提问者网友:我是女神我骄傲
- 2021-03-21 14:23
怎么在文本区域显示多条数据,语言:java,数据库:mysql
最佳答案
- 五星知识达人网友:洒脱疯子
- 2021-03-21 15:16
public List getAllMsgList() {
List msgList = new ArrayList();
DBConnection db = new DBConnection();
Connection conn = db.getConn();
String sql = "select * from msg";
try {
Statement pstmt = conn.createStatement();
ResultSet rs = pstmt.executeQuery(sql);
while (rs.next()) {
int id = rs.getInt(1);
String content = rs.getString(2);
String author = rs.getString(3);
String publishiTime = rs.getString(4);
Msg msg = new Msg(id, content, author, publishiTime);
msgList.add(msg);
}
rs.close();
pstmt.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
return msgList;
List msgList = new ArrayList();
DBConnection db = new DBConnection();
Connection conn = db.getConn();
String sql = "select * from msg";
try {
Statement pstmt = conn.createStatement();
ResultSet rs = pstmt.executeQuery(sql);
while (rs.next()) {
int id = rs.getInt(1);
String content = rs.getString(2);
String author = rs.getString(3);
String publishiTime = rs.getString(4);
Msg msg = new Msg(id, content, author, publishiTime);
msgList.add(msg);
}
rs.close();
pstmt.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
return msgList;
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯