增、删、改、查-蒲公英云

增、删、改、查

た入场券 2022-09-25 00:29 136阅读 0赞

public int doAdd(Reply reply) {
String sql = “insert into reply values(null,?,?,?,?,?,?)”;
return this.getJdbc().executeUpdate(
sql,
new String[] { reply.getTitle(), reply.getContent(),
reply.getPublishtime().toString(),
reply.getModifytime().toString(),
reply.getTopicid() + “”, reply.getUid() + “” });

}

-———————————————————————————————————————————————-

public int doDelete(String replyid) {
String sql = “delete from reply where replyid=” + replyid;
return this.getJdbc().executeUpdate(sql, null);
}

-—————————————————————————————————————————————————

public List findAll(){
List list=new ArrayList();
//创建sql语句
String sql=”select * from board”;
//执行查询
ResultSet rs=this.getJdbc().executeQuery(sql, null);
//遍历
try {
while(rs.next()){
Board board=new Board();
board.setBoardid(rs.getInt(“boardid”));
board.setBoardname(rs.getString(“boardname”));
list.add(board);
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
this.closeResource();
}
return list;
}

-————————————————————————————————————————————————-

public int doUpdate(Reply reply) {

String sql = “update reply set title = ?, content = ?, modifytime = ? where replyid = ?”;

return this.getJdbc().executeUpdate(sql, new String[] { reply.getTitle(), reply.getContent(),
reply.getModifytime().toString(), reply.getReplyid() + “” });
}