hibernate鎬庝箞鎵归噺瀵煎叆鏁版嵁
浣跨敤Hibernate杩涜鎵归噺瀵煎叆鏁版嵁鍙互閫氳繃浠ヤ笅姝ラ鎿嶄綔锛?/p>
- 鍒涘缓涓€涓寘鍚瀵煎叆鏁版嵁鐨勯泦鍚堟垨鏁扮粍銆?/li>
- 鑾峰彇Hibernate鐨凷ession瀵硅薄銆?/li>
- 浣跨敤Session鐨刢reateSQLQuery鏂规硶鍒涘缓涓€涓猄QL鏌ヨ銆?/li>
- 浣跨敤SQL鏌ヨ鐨剆etParameters鏂规硶璁剧疆鍙傛暟銆?/li>
- 浣跨敤SQL鏌ヨ鐨剆etParameterList鏂规硶灏嗛泦鍚堟垨鏁扮粍浣滀负鍙傛暟浼犻€掋€?/li>
- 璋冪敤SQL鏌ヨ鐨別xecuteUpdate鏂规硶鎵ц鎵归噺瀵煎叆鎿嶄綔銆?/li>
- 鎻愪氦浜嬪姟骞跺叧闂璖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>
相关问答