MyBatis 鏄竴涓寔涔呭眰妗嗘灦锛屾彁渚涗簡涓€绉嶅皢 SQL 鏌ヨ璇彞涓?Java 瀵硅薄鏄犲皠鐨勬柟寮忥紝閫氳繃 XML 鏂囦欢鎴栨敞瑙ｇ殑鏂瑰紡鏉ラ厤缃?SQL 璇彞銆備笅闈㈡槸浣跨敤 MyBatis 杩涜澧炲垹鏀规煡鏂规硶鐨勭ず渚嬶細

1. 澧炲姞鏁版嵁锛?/li>

// 浣跨敤 SQLSessionFactoryBuilder 鍒涘缓 SQLSessionFactory
SQLSessionFactory factory = new SQLSessionFactoryBuilder().build(inputStream);

// 鑾峰彇 SQLSession
SQLSession session = factory.openSession();

// 鍒涘缓涓€涓疄浣撳璞?/span>
User user = new User();
user.setId(1);
user.setName("Alice");
user.setAge(20);

// 璋冪敤 SQLSession 鐨?insert 鏂规硶鎻掑叆鏁版嵁
session.insert("insertUser", user);

// 鎻愪氦浜嬪姟
session.commit();

// 鍏抽棴 SQLSession
session.close();

2. 鍒犻櫎鏁版嵁锛?/li>

// 鑾峰彇 SQLSession
SQLSession session = factory.openSession();

// 璋冪敤 SQLSession 鐨?delete 鏂规硶鍒犻櫎鏁版嵁
session.delete("deleteUser", 1);

// 鎻愪氦浜嬪姟
session.commit();

// 鍏抽棴 SQLSession
session.close();

3. 鏇存柊鏁版嵁锛?/li>

// 鑾峰彇 SQLSession
SQLSession session = factory.openSession();

// 鍒涘缓涓€涓疄浣撳璞?/span>
User user = new User();
user.setId(1);
user.setName("Bob");
user.setAge(25);

// 璋冪敤 SQLSession 鐨?update 鏂规硶鏇存柊鏁版嵁
session.update("updateUser", user);

// 鎻愪氦浜嬪姟
session.commit();

// 鍏抽棴 SQLSession
session.close();

4. 鏌ヨ鏁版嵁锛?/li>

// 鑾峰彇 SQLSession
SQLSession session = factory.openSession();

// 璋冪敤 SQLSession 鐨?selectOne 鏂规硶鏌ヨ鍗曟潯鏁版嵁
User user = session.selectOne("getUserById", 1);
System.out.println(user);

// 璋冪敤 SQLSession 鐨?selectList 鏂规硶鏌ヨ澶氭潯鏁版嵁
List<User> userList = session.selectList("getAllUsers");
for (User u : userList) {
    System.out.println(u);
}

// 鍏抽棴 SQLSession
session.close();

浠ヤ笂浠ｇ爜绀轰緥婕旂ず浜嗗浣曚娇鐢?MyBatis 杩涜澧炲垹鏀规煡鎿嶄綔锛岄渶瑕佸湪 XML 鏂囦欢涓厤缃搴旂殑 SQL 璇彞锛屽苟灏?SQLSessionFactory 瀹炰緥鍖栧悗鍗冲彲浣跨敤 SQLSession 鏉ユ墽琛岀浉搴旂殑鎿嶄綔銆?/p>