1. 导入pom代码Gitee路径:Mini
这里已将源码中的com包放入了maven本地仓库的根路径下。
2. 导入配置文件4.0.0 com.lwl testMini 1.0-SNAPSHOT com.lwl Mini 1.0-SNAPSHOT mysql mysql-connector-java 5.1.6 org.projectlombok lombok 1.18.20
]>
3. 加载配置文件
package com.lwl.test;
import com.lwl.mini.session.SqlSession;
import com.lwl.mini.session.SqlSessionFactory;
import com.lwl.mini.session.SqlSessionFactoryBuilder;
import com.lwl.testMapper.UserMapper;
public class test {
public static void main(String[] args) {
SqlSessionFactory build = new SqlSessionFactoryBuilder().build("miniConfig.xml");
SqlSession sqlSession = build.openSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
}
}
4.编写sql语句以及参数规则
public interface UserMapper {
@Select("select * from user where id = #{testId} and username = #{name}")
User selectOne(@Param("testId") int id, @Param("name") String name);
}
5. 执行
package com.lwl.test;
import com.lwl.mini.session.SqlSession;
import com.lwl.mini.session.SqlSessionFactory;
import com.lwl.mini.session.SqlSessionFactoryBuilder;
import com.lwl.mini.test.User;
import com.lwl.testMapper.UserMapper;
public class test {
public static void main(String[] args) {
SqlSessionFactory build = new SqlSessionFactoryBuilder().build("miniConfig.xml");
SqlSession sqlSession = build.openSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
User user = mapper.selectOne(41, "小刘");
System.out.println("user = " + user);
}
}
6. 后言
Mini架构参考Mybatis,代码自己diy,可以看作是个小型Mybatis。目前初步阶段,仍有许多限制不足。博主创作它也是想验证自己是否真的学会了Mybatis,因为我觉得学会一个东西,不仅局限于如何使用它,更应该扩展到如何制造它,整个过程就像是把电视机拆开之后,自己还能否重新拼凑出一个电视,这是一个有趣的过程。



