我写的 第一
public void del1(int aa)throws DataAccessException {
session=getSession();
String sql = "delete Usertable aa where aa.userid=:userid";
Query q = session.createQuery(sql);
q.setInteger("userid", aa);
int a= q.executeUpdate();
System.out.println(a);
第二种:
public void del11(int aa)throws DataAccessException {
session=getSession();
try {
tx=session.beginTransaction();
Usertable ub1=new Usertable();
ub1.setUserid(aa);
session.delete(ub1);
tx.commit();
} catch (HibernateException e) {
e.printStackTrace();
if(tx!=null)
{
tx.rollback();
}
}
finally{
session.close();
}
}
也没错 就是删除不了数据.为什么 头痛得很啊
public void del1(int aa)throws DataAccessException {
session=getSession();
String sql = "delete Usertable aa where aa.userid=:userid";
Query q = session.createQuery(sql);
q.setInteger("userid", aa);
int a= q.executeUpdate();
System.out.println(a);
第二种:
public void del11(int aa)throws DataAccessException {
session=getSession();
try {
tx=session.beginTransaction();
Usertable ub1=new Usertable();
ub1.setUserid(aa);
session.delete(ub1);
tx.commit();
} catch (HibernateException e) {
e.printStackTrace();
if(tx!=null)
{
tx.rollback();
}
}
finally{
session.close();
}
}
也没错 就是删除不了数据.为什么 头痛得很啊
delete from Usertable aa where aa.userid=:userid";
session=getSession();
String sql = "delete Usertable aa where aa.userid=:userid";
Query q = session.createQuery(sql);
q.setInteger("userid", aa);
int a= q.executeUpdate();
System.out.println(a);
2第二种没有多大问题
有的话加上log4j的JAR 包
还加上一个 properties文件
public void del1(int aa)throws DataAccessException {
session=getSession();
String sql = "delete Usertable aa where aa.userid=:userid";
Query q = session.createQuery(sql);
q.setInteger("userid", aa);
int a= q.executeUpdate();
session.commit();
System.out.println(a); 第二种改成
public void del11(int aa)throws DataAccessException {
session=getSession();
try {
tx=session.beginTransaction();
Usertable ub1=(Usertable )session.get(Usertable.class,aa);
session.delete(ub1);
tx.commit();
} catch (HibernateException e) { e.printStackTrace();
if(tx!=null)
{
tx.rollback();
}
}
finally{ session.close();
}
}
一种改成
public void del1(int aa)throws DataAccessException {
session=getSession();
String sql = "delete Usertable aa where aa.userid=:userid";
Query q = session.createQuery(sql);
q.setInteger("userid", aa);
int a= q.executeUpdate();
session.commit();
System.out.println(a); 第二种改成
public void del11(int aa)throws DataAccessException {
session=getSession();
try {
tx=session.beginTransaction();
Usertable ub1=(Usertable )session.get(Usertable.class,aa);
session.delete(ub1);
tx.commit();
} catch (HibernateException e) { e.printStackTrace();
if(tx!=null)
{
tx.rollback();
}
}
finally{ session.close();
}
}