MyBatis 基于注解的增、删、改、查操作

╰+攻爆jí腚メ 2022-05-14 04:34 173阅读 0赞

### MyBatis 基于注解的增、删、改、查操作 ###

**程序清单：UserMapper.java**

package com.mapper;
    import org.apache.ibatis.annotations.Delete;
    import org.apache.ibatis.annotations.Insert;
    import org.apache.ibatis.annotations.Options;
    import org.apache.ibatis.annotations.Param;
    import org.apache.ibatis.annotations.Select;
    import org.apache.ibatis.annotations.Update;
    import com.po.User;
    public interface UserMapper {
    	@Insert("insert into t_user (name,sex,age) values(#{name},#{sex},#{age})")
    	@Options(useGeneratedKeys=true,keyProperty="id")
    	int addUser(User user);
    	
    	@Select("select * from t_user where id=#{id}")
    	User getUserById(Integer id);
    	
    	@Delete("delete from t_user where id=#{id}")
    	int deleteUser(@Param("id") Integer id);
    	
    	@Update("update t_user set name=#{name},sex=#{sex},age=#{age} where id=#{id}")
    	void updateUser(User user);
    }

**配置mybatis-config.xml**

<mappers>
    		<mapper class="com.mapper.UserMapper" />				
    	</mappers>

**测试@Insert注解**

@Test
    	public void test() throws IOException {
    		session=MySqlSessionFactory.getSqlSession();
    		UserMapper um=session.getMapper(UserMapper.class);
    		User user=new User();
    		user.setName("tom");
    		user.setSex("男");
    		user.setAge(25);
    		um.addUser(user);
    		session.commit();
    		System.out.println("添加用户成功，id为："+user.getId());
    	}

**控制台输出如下：**

![70][]

**测试@Delete注解**

@Test
    	public void test() throws IOException {
    		session=MySqlSessionFactory.getSqlSession();
    		UserMapper um=session.getMapper(UserMapper.class);
    		um.deleteUser(2);
    		session.commit();
    	}

**控制台输出如下：**

![70 1][]

**测试@Update注解**

@Test
    	public void test() throws IOException {
    		session=MySqlSessionFactory.getSqlSession();
    		UserMapper um=session.getMapper(UserMapper.class);
    		User user=um.getUserById(1);
    		user.setName("白雪");
    		user.setAge(18);
    		um.updateUser(user);
    		session.commit();
    	}

**控制台输出如下：**

![70 2][]

**测试@Select注解**

**控制台输出如下：**

![70 3][]

[70]: /images/20220514/59077fd75fc344aba4bd5031aa2e4f5d.png
[70 1]: /images/20220514/cebf342cb7744aef8784f4b046838581.png
[70 2]: /images/20220514/2f1da48462184a44bab79d2d2e51aac7.png
[70 3]: /images/20220514/edb74672aacc4e968a353384395fe461.png