一 MyBatis框架使用
1.1创建maven项目导入相关依赖
1 导入jar文件,maven
2 处理配置文件
3 开发业务代码
先创建一个空项目,用于存放后面Mybatis相关项目模块
项目名为mybatisAll即可
接下来设置maven为我们自己安装的,不用idea自带的(当然用自带的也行)
在当前项目中创建模块
选择maven项目 next
输入groupid和aitifactid 然后finish
检查项目目前在磁盘上的存放路径 然后next
检查项目目录结构是否有缺失
MyBatis官网说明文档 https://mybatis.org/mybatis-3/zh/index.html
在pom.xml中导入MyBatis相关依赖jar文件
<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>com.msb</groupId> <artifactId>mybatisTest01</artifactId> <version>1.0-SNAPSHOT</version> <packaging>jar</packaging> <dependencies> <!--mysqlConnector--> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.16</version> </dependency> <!--mybatis 核心jar包--> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.5.3</version> </dependency> <!--junit--> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.13.1</version> <scope>test</scope> </dependency> <!--lombok --> <dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> <version>1.18.12</version> <scope>provided</scope> </dependency> </dependencies> </project> |
安装lombok插件后,重启idea
导入lombok依赖后,单独设置启用注解处理
1.2准备数据库,包结构和实体类
实体类Dept
@Data
@AllArgsConstructor
@NoArgsConstructor
public class Dept implements Serializable {
private Integer deptno;
private String dname;
private String loc;
}
resources目录下 创建 com/mapper目录,然后添加DeptMapper.xml映射文件
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="aaa">
<!--public List<Dept> findAll(){ }-->
<select id="findAll" resultType="com.msb.pojo.Dept" >
select * from dept
</select>
</mapper>
resources目录下准备sqlMapConfig.xml 核心配置文件
<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"> <configuration> <environments default="development"> <environment id="development"> <transactionManager type="JDBC"/> <dataSource type="POOLED"> <property name="driver" value="com.mysql.cj.jdbc.Driver"/> <property name="url" value="jdbc:mysql://127.0.0.1:3306/mydb?useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai"/> <property name="username" value="root"/> <property name="password" value="root"/> </dataSource> </environment> </environments> <!--加载mapper映射文件--> <mappers> <mapper resource="com/msb/mapper/DeptMapper.xml"/> </mappers> </configuration> |
1.3 准备Mapper映射文件和核心配置文件
1.4 运行测试
在test目录下开发测试代码并运行
public class Test1 {
private SqlSession sqlSession;
@Before
public void init(){
SqlSessionFactoryBuilder ssfb =new SqlSessionFactoryBuilder();
InputStream resourceAsStream = null;
try {
resourceAsStream = Resources.getResourceAsStream("sqlMapConfig.xml");
} catch (IOException e) {
e.printStackTrace();
}
SqlSessionFactory factory=ssfb.build(resourceAsStream) ;
sqlSession=factory.openSession();
}
@Test
public void testFindAll(){
// 调用SQL语句
List<Dept> list = sqlSession.selectList("findAll");
for (Dept dept : list) {
System.out.println(dept);
}
}
@After
public void release(){
// 关闭SQLSession
sqlSession.close();
}
}
感谢各位观看阅读,如果你也喜欢编程的话,欢迎关注,我将持续更新后续内容。