在MyBatis中,使用insert語句來向數(shù)據(jù)庫中插入數(shù)據(jù)。insert語句的用法如下:
<insert id="insertUser" parameterType="User">
INSERT INTO user (id, name, age) VALUES (#{id}, #{name}, #{age})
</insert>
User user = new User();
user.setId(1);
user.setName("Alice");
user.setAge(25);
SqlSession sqlSession = sqlSessionFactory.openSession();
try {
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
userMapper.insertUser(user);
sqlSession.commit();
} finally {
sqlSession.close();
}
以上示例中,首先創(chuàng)建一個(gè)User對象并設(shè)置屬性,然后通過SqlSession獲取UserMapper實(shí)例,并調(diào)用insertUser方法插入數(shù)據(jù)。最后記得在finally塊中關(guān)閉SqlSession。