hibernate删除操作的sql语句写法

 
第一种：
public void deleteUser(String byemail) {
  Session session = getSession();
  Transaction transaction = null;
  String hql = "delete from Register where email=?
";
  try {
   transaction = session.beginTransaction();
   System.out.println(hql);
   Query q = session.createQuery(hql);
   System.out.println(q);
   q.setParameter(0,byemail);//这里用setParameter
(int position, Object val)
 System.out.println("q+++++++");
   q.executeUpdate();
   System.out.println("update");
   transaction.commit();
   System.out.println("commit");
  } catch (HibernateException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
   if (transaction != null) {
    // 当发生异常时回滚事务，取消数据库操作
    transaction.rollback();
    System.out.println("#######删除发生异常，事务回滚#########");
   }
  } finally {
   session.close();
  }
第二种：
public void deleteUser(String byemail
) {
  Session session = getSession();
  Transaction transaction = null;
  String hql = "delete from Register where email=:byemail
";
  try {
   transaction = session.beginTransaction();
   System.out.println(hql);
   Query q = session.createQuery(hql);
   System.out.println(q);
   q.setParameter("byemail
",byemai
l);
   System.out.println("q+++++++");
   q.executeUpdate();
   System.out.println("update");
   transaction.commi