我有两个表 一个主贴表 一个跟帖表
主贴表的ID 对应该贴表的topicid
如何构建sql进行批量删除主贴的ID表并批量删除跟帖表下相对应的字段
我是分两步做的 当页面传回帖相对应的值时
实现批量删除如下
Session session = null;
Transaction tx = null;
try {
session = openSession();
tx = session.beginTransaction();
Connection con = session.connection();
String sql = "delete from lybbs_postreply where id in(0";
for (int i = 0; i < ids.length; i++) {
sql += "," + ids[i];
}
sql += ")";
PreparedStatement ps = con.prepareStatement(sql);
ps.execute();
tx.commit();
主贴删除请教大家 !!!谢谢
主贴表的ID 对应该贴表的topicid
如何构建sql进行批量删除主贴的ID表并批量删除跟帖表下相对应的字段
我是分两步做的 当页面传回帖相对应的值时
实现批量删除如下
Session session = null;
Transaction tx = null;
try {
session = openSession();
tx = session.beginTransaction();
Connection con = session.connection();
String sql = "delete from lybbs_postreply where id in(0";
for (int i = 0; i < ids.length; i++) {
sql += "," + ids[i];
}
sql += ")";
PreparedStatement ps = con.prepareStatement(sql);
ps.execute();
tx.commit();
主贴删除请教大家 !!!谢谢
String sql1 = "delete from 主帖表 where id in (0";
String sql = "delete from lybbs_postreply where topicId in(0"; String str = "";
for (int i = 0; i < ids.length; i++) {
str += "," + ids[i];
}
str += ")"; //删除跟帖表 sql=sql+str;
sql1=sql1+str; Session session = null;
Transaction tx = null;
Connection con = null;
PreparedStatement ps = null;
try
{
session = openSession();
con = session.connection(); tx = session.beginTransaction();
ps = con.prepareStatement(sql1); //先删除跟帖
ps.execute(); ps = con.prepareStatement(sql);//再删主帖
ps.execute();
tx.commit();
}
catch (Exception ex)
{
e.printStackTrace();
}finally{
ps.close();
con.close();
session.close();
tx = null; }
str += "," + ids[i];
}
这个获得的是主贴表的ID