【Mybatis】getMapper 实现增删改查

根据用户名模糊查询

(1)定义接口中的方法
(2)语句
(3)配置
(4)通过session.getMapper()返回的对象不是实现类对象
UserDao.java

public interface UserDao {
    public User findById(int id);
    List<User> findByKeyWord(String s);
}

UserDao.xml

<select id="findById" parameterType="int" resultType="com.syy.bean.User">
        select * from user where id=#{id};
</select>
<select id="findByKeyWord" parameterType="string" resultType="com.syy.bean.User">
        select * from  user where username like #{keyword}
</select>

test.java

@Test
    public void test01(){
        SqlSession sqlSession = MySessionUtils.getSession();
        UserDao dao=sqlSession.getMapper(UserDao.class);
        User user= dao.findById(1);
        System.out.println(user);
        sqlSession.close();
    }
    @Test
    public void test02(){
        SqlSession sqlSession = MySessionUtils.getSession();
        UserDao dao=sqlSession.getMapper(UserDao.class);
        List<User> list=dao.findByKeyWord("张%");
        System.out.println(list);
        sqlSession.close();
    }

删除数据

(1)定义接口中的方法
(2)语句
(3)配置
(4)通过session.getMapper()返回的对象不是实现类对象
UserDao.java

public interface UserDao {
    void deleteById(int id);
}

UserDao.xml

<delete id="deleteById" parameterType="int">
            delete  from user where id=#{id};
</delete>

test.java

 @Test
    public void test03(){
        SqlSession sqlSession = MySessionUtils.getSession();
        UserDao dao=sqlSession.getMapper(UserDao.class);
        dao.deleteById(22);
        sqlSession.commit();
        sqlSession.close();
    }

插入数据

(1)定义接口中的方法
(2)语句
(3)配置
(4)通过session.getMapper()返回的对象不是实现类对象
UserDao.java

public interface UserDao {
    void saveUser(User user);
}

UserDao.xml

<insert id="saveUser" parameterType="com.wzx.bean.User">
        insert into user value(null,#{username},#{birthday},#{sex},#{address})
    </insert>

test.java

@Test
    public void test04(){
        SqlSession sqlSession = MySessionUtils.getSession();
        //返回的是实现接口的实现类对象
        UserDao dao = sqlSession.getMapper(UserDao.class);
        User user = new User();
        user.setId(100);
        user.setUsername("赵四");
        user.setAddress("东北");
        user.setBirthday(new Date());
        sqlSession.commit();
        sqlSession.close();
    }

在SqlMapConfig.xm中给类取别名

<typeAliases>
       <package name="com.wzx.bean"/>    
</typeAliases>