绝对干货,超全的 MyBatis 动态代理原理讲解!( 二 )


schema.sql文件
drop table if exists user; CREATE TABLE user ( id int(11) NOT NULL AUTO_INCREMENT, username varchar(255) DEFAULT NULL, password varchar(255) DEFAULT NULL, PRIMARY KEY (id) ); insert into user(id,username,password) values(1,'xiongxina','123456'); insert into user(id,username,password) values(2,'xiongxinb','123456'); insert into user(id,username,password) values(3,'xiongxinc','123456');
mapper定义
package com.dbutil.mapper; import com.dbutil.entity.UserEntity; import com.dbutil.session.SqlSession; import java.util.List; public interface UserMapper { @SqlSession.QueryList("select * from user") List queryUser(); }
使用:
package com.dbutil; import com.dbutil.entity.UserEntity; import com.dbutil.mapper.UserMapper; import com.dbutil.session.SqlSession; import java.util.List; public class UserService { public static void main(String[] args) throws Exception { UserMapper userMapper = SqlSession.getMapper(UserMapper.class); List userEntities = userMapper.queryUser(); for (UserEntity userEntity : userEntities) { System.out.println(userEntity); } } }

原文链接:https://mp.weixin.qq.com/s/E00PkxeKrY9ZttPWh69t5G




推荐阅读