mybatis学生表增删查改
时间: 2023-11-17 12:03:59 浏览: 41
假设我们有一个学生表,包含id、name、age三个字段。以下是mybatis对学生表的增删查改操作的示例:
1. 增加学生
```xml
<insert id="addStudent" parameterType="com.example.Student">
INSERT INTO student (name, age)
VALUES (#{name}, #{age})
</insert>
```
2. 删除学生
```xml
<delete id="deleteStudentById" parameterType="int">
DELETE FROM student WHERE id = #{id}
</delete>
```
3. 查询学生
```xml
<select id="getStudentById" parameterType="int" resultType="com.example.Student">
SELECT * FROM student WHERE id = #{id}
</select>
<select id="getStudentsByName" parameterType="String" resultType="com.example.Student">
SELECT * FROM student WHERE name = #{name}
</select>
<select id="getAllStudents" resultType="com.example.Student">
SELECT * FROM student
</select>
```
4. 更新学生
```xml
<update id="updateStudent" parameterType="com.example.Student">
UPDATE student SET name=#{name}, age=#{age}
WHERE id=#{id}
</update>
```