“`
#### 3.創(chuàng)建實體類和接口
創(chuàng)建一個實體類 `User` 和 `UserMapper` 接口，用于表示數(shù)據(jù)表中的記錄和操作。
“`java
// User.java
public class User {
private int id;
private String name;
private String password;
// getter 和 setter
}
// UserMapper.java
public interface UserMapper {
List getAll();
User getById(int id);
int insert(User user);
int update(User user);
int delete(int id);
}
“`
#### 4.編寫映射文件
接下來，我們需要編寫 `UserMapper.xml` 文件，用于配置 SQL 映射。
“`xml
id, name, password
SELECT
FROM user
SELECT
FROM user
WHERE id = #{id}
INSERT INTO userAPP開發(fā) (name, password) VALUES (#{name}, #{password})
UPDATE user SET name = #{name}, password = #{password} WHERE id = #{id}
DELETE FROM user WHERE id = #{id}
“`
#### 5.注冊映射文件和測試
在 `mybatis-config.xml` 文件的 “ 標簽中注冊映射文件。
“`xml
“`
編寫測試類，進行 CRUD 操作。
“`java
public class MybatisTest {
private static SqlSessionFactory sqlSessionFactory;
@BeforeClass
public static void setUp() throws IOException {
String resource = “mybatis-config.xml”;
InputStream inputStream = Resources.getResourceAsStream(resource);
sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
}
@Test
public void testCRUD() {
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
// 插入數(shù)據(jù)
User user = new User();
user.setName(“Tom”);
user.setPassword(“password”);
userMapper.insert(user);
sqlSession.commit();
// 查詢數(shù)據(jù)
List users = userMapper.getAll();
System.out.println(“查詢所有用戶：” + users);
user = userMapper.getById(1);
System.out.println(“查詢id為1的
