扫描二维码下载沐宇APP

沐宇

微信扫码使用沐宇小程序

沐宇

hibernate鎬庝箞鎵归噺瀵煎叆鏁版嵁

扬州沐宇科技
2024-01-11 16:16:05
hibernate

浣跨敤Hibernate杩涜鎵归噺瀵煎叆鏁版嵁鍙互閫氳繃浠ヤ笅姝ラ鎿嶄綔锛?/p>

  1. 鍒涘缓涓€涓寘鍚瀵煎叆鏁版嵁鐨勯泦鍚堟垨鏁扮粍銆?/li>
  2. 鑾峰彇Hibernate鐨凷ession瀵硅薄銆?/li>
  3. 浣跨敤Session鐨刢reateSQLQuery鏂规硶鍒涘缓涓€涓猄QL鏌ヨ銆?/li>
  4. 浣跨敤SQL鏌ヨ鐨剆etParameters鏂规硶璁剧疆鍙傛暟銆?/li>
  5. 浣跨敤SQL鏌ヨ鐨剆etParameterList鏂规硶灏嗛泦鍚堟垨鏁扮粍浣滀负鍙傛暟浼犻€掋€?/li>
  6. 璋冪敤SQL鏌ヨ鐨別xecuteUpdate鏂规硶鎵ц鎵归噺瀵煎叆鎿嶄綔銆?/li>
  7. 鎻愪氦浜嬪姟骞跺叧闂璖ession銆?/li>

浠ヤ笅鏄竴涓ず渚嬩唬鐮侊細

List<User> userList = // 瑕佸鍏ョ殑鐢ㄦ埛鏁版嵁闆嗗悎

Session session = sessionFactory.openSession();
Transaction transaction = session.beginTransaction();

String sql = "INSERT INTO user (id, name, age) VALUES (:id, :name, :age)";
SQLQuery query = session.createSQLQuery(sql);
query.setParameterList("id", userList.stream().map(User::getId).collect(Collectors.toList()));
query.setParameterList("name", userList.stream().map(User::getName).collect(Collectors.toList()));
query.setParameterList("age", userList.stream().map(User::getAge).collect(Collectors.toList()));

int rowsAffected = query.executeUpdate();

transaction.commit();
session.close();

璇锋敞鎰忥紝涓婅堪绀轰緥鍋囪浣犳湁涓€涓悕涓?quot;User"鐨勫疄浣撶被锛屽叾涓寘鍚?quot;id"銆?quot;name"鍜?quot;age"灞炴€с€備綘闇€瑕佹牴鎹綘鐨勫疄浣撶被鍜屾暟鎹簱琛ㄧ粨鏋勮繘琛岀浉搴旂殑鏇存敼銆?/p>

姝ゅ锛屼綘杩橀渶瑕佹牴鎹綘鐨勫叿浣撶幆澧冮厤缃瓾ibernate鐨凷essionFactory銆?/p>

扫码添加客服微信