扫描二维码下载沐宇APP

沐宇

微信扫码使用沐宇小程序

沐宇

hibernate鎬庝箞鍚屾椂鍒犻櫎澶氭潯鏁版嵁

扬州沐宇科技
2024-01-26 15:06:27
hibernate

鍦℉ibernate涓紝鍙互浣跨敤HQL锛圚ibernate Query Language锛夋垨鑰匔riteria API鏉ュ垹闄ゅ鏉℃暟鎹€?/p>

  1. 浣跨敤HQL锛?棣栧厛锛屽垱寤轰竴涓狧QL鏌ヨ锛屾寚瀹氳鍒犻櫎鐨勫疄浣撶被鍜屽垹闄ゆ潯浠躲€傜劧鍚庯紝浣跨敤Hibernate鐨?code>createQuery()鏂规硶鍒涘缓鏌ヨ瀵硅薄锛屽苟灏咹QL璇彞浼犻€掔粰璇ユ柟娉曘€傛渶鍚庯紝鎵ц鍒犻櫎鎿嶄綔锛岄€氳繃璋冪敤鏌ヨ瀵硅薄鐨?code>executeUpdate()鏂规硶銆?/p>

    String hql = "delete from EntityClass where condition = :value";
    Query query = session.createQuery(hql);
    query.setParameter("value", condition);
    int result = query.executeUpdate();
    
  2. 浣跨敤Criteria API锛?浣跨敤Criteria API杩涜澶氭潯鏁版嵁鍒犻櫎鏃讹紝闇€瑕佸垱寤轰竴涓狢riteria鏌ヨ瀵硅薄锛屽苟浣跨敤add()鏂规硶鎸囧畾鍒犻櫎鏉′欢銆傜劧鍚庯紝閫氳繃璋冪敤delete()鏂规硶鎵ц鍒犻櫎鎿嶄綔銆?/p>

    CriteriaBuilder builder = session.getCriteriaBuilder();
    CriteriaDelete<EntityClass> delete = builder.createCriteriaDelete(EntityClass.class);
    Root<EntityClass> root = delete.from(EntityClass.class);
    delete.where(builder.equal(root.get("condition"), value));
    int result = session.createQuery(delete).executeUpdate();
    

浠ヤ笂绀轰緥涓殑EntityClass鏄鍒犻櫎鐨勫疄浣撶被锛?code>condition鏄垹闄ょ殑鏉′欢瀛楁锛?code>value鏄潯浠剁殑鍊笺€?/p>

鏃犺鏄娇鐢℉QL杩樻槸Criteria API锛屾渶鍚庨兘闇€瑕佽皟鐢?code>executeUpdate()鏂规硶鏉ユ墽琛屽垹闄ゆ搷浣滐紝骞惰繑鍥炲彈褰卞搷鐨勮褰曟暟銆?/p>

扫码添加客服微信