要的不是这个,是一整个案例的源代码
时间: 2024-03-20 08:39:09 浏览: 10
好的,以下是一个简单的MyBatis增删改查案例的源代码:
1. 创建表
```
CREATE TABLE user (
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(20),
age INT
);
```
2. 创建Java实体类
```
public class User {
private int id;
private String name;
private int age;
// getters and setters
}
```
3. 创建Mapper接口
```
public interface UserMapper {
void addUser(User user);
void updateUser(User user);
void deleteUserById(int id);
User getUserById(int id);
}
```
4. 创建Mapper XML文件
```
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.example.mapper.UserMapper">
<insert id="addUser" parameterType="com.example.entity.User">
INSERT INTO user (name, age) VALUES (#{name}, #{age})
</insert>
<update id="updateUser" parameterType="com.example.entity.User">
UPDATE user SET name = #{name}, age = #{age} WHERE id = #{id}
</update>
<delete id="deleteUserById" parameterType="int">
DELETE FROM user WHERE id = #{id}
</delete>
<select id="getUserById" parameterType="int" resultType="com.example.entity.User">
SELECT * FROM user WHERE id = #{id}
</select>
</mapper>
```
5. 创建MyBatis配置文件
```
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/test"/>
<property name="username" value="root"/>
<property name="password" value="123456"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="com/example/mapper/UserMapper.xml"/>
</mappers>
</configuration>
```
6. 创建测试类
```
public class MybatisTest {
public static void main(String[] args) {
// 加载MyBatis配置文件
String resource = "mybatis-config.xml";
InputStream inputStream = MybatisTest.class.getClassLoader().getResourceAsStream(resource);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
// 获取SqlSession
SqlSession sqlSession = sqlSessionFactory.openSession();
// 获取Mapper接口的代理对象
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
// 插入数据
User user = new User();
user.setName("张三");
user.setAge(18);
userMapper.addUser(user);
// 更新数据
User user2 = new User();
user2.setId(1);
user2.setName("李四");
user2.setAge(20);
userMapper.updateUser(user2);
// 删除数据
userMapper.deleteUserById(1);
// 查询数据
User user3 = userMapper.getUserById(2);
System.out.println(user3.getName() + " " + user3.getAge());
// 提交事务
sqlSession.commit();
// 关闭资源
sqlSession.close();
}
}
```
以上就是一个简单的MyBatis增删改查案例的源代码,你可以根据自己的需要进行修改和调整。