public boolean deletePost(int postId){
Connection conn = null;
PreparedStatement ps = null;
String sql = null;
try {
conn = DbUtil.getConn();
sql = "delete from post where postId=? ";
ps = conn.prepareStatement(sql);
ps.setInt(1, postId);
ps.executeUpdate();
System.out.println("帖子删除成功!");
} catch (SQLException e) {
e.printStackTrace();
return false;
}finally{
DbUtil.closeConn(conn, ps, null);
}
return true;
Connection conn = null;
PreparedStatement ps = null;
String sql = null;
try {
conn = DbUtil.getConn();
sql = "delete from post where postId=? ";
ps = conn.prepareStatement(sql);
ps.setInt(1, postId);
ps.executeUpdate();
System.out.println("帖子删除成功!");
} catch (SQLException e) {
e.printStackTrace();
return false;
}finally{
DbUtil.closeConn(conn, ps, null);
}
return true;
}
ps = conn.prepareStatement(sql);
ps = conn.prepareCall(sql);
prepareStatement :创建一个 PreparedStatement
对象来将参数化的 SQL 语句发送到数据库
prepareCall:创建一个 CallableStatement
对象来调用数据库存储过程
prepareStatement :创建一个 PreparedStatement
对象来将参数化的 SQL 语句发送到数据库
prepareCall:创建一个 CallableStatement
对象来调用数据库存储过程
prepareStatement :创建一个 PreparedStatement
对象来将参数化的 SQL 语句发送到数据库