mybatis的环境搭建

àì夳堔傛蜴生んèń 2022-12-31 02:25 300阅读 0赞

map.xml``文件的约束

  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!DOCTYPE mapper
  3. PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  4. "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

核心配置文件的约束

  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!DOCTYPE configuration
  3. PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  4. "http://mybatis.org/dtd/mybatis-3-config.dtd">

第一步:创建maven工程并且在pro.xml中导入相关的依赖包

  1. <dependencies>
  2. <!--导入mybatis依赖包-->
  3. <dependency>
  4. <groupId>org.mybatis</groupId>
  5. <artifactId>mybatis</artifactId>
  6. <version>3.5.2</version>
  7. </dependency>
  8. <!--导入junit测试依赖包-->
  9. <dependency>
  10. <groupId>junit</groupId>
  11. <artifactId>junit</artifactId>
  12. <version>4.12</version>
  13. <scope>test</scope>
  14. </dependency>
  15. <!--导入mysql驱动依赖包-->
  16. <dependency>
  17. <groupId>mysql</groupId>
  18. <artifactId>mysql-connector-java</artifactId>
  19. <version>8.0.18</version>
  20. </dependency>
  21. </dependencies>

第二步:创建实体类,和接口

  1. package com.zhu.dao;
  2. import com.zhu.pojo.User;
  3. import java.util.List;
  4. public interface IUserDao {
  5. List<User> selectAllUser();
  6. }
  7. package com.zhu.pojo;
  8. public class User {
  9. private int id;
  10. private String name;
  11. private String pwd;
  12. public User(){
  13. }
  14. public User(int id,String name,String pwd){
  15. }
  16. public int getId() {
  17. return id;
  18. }
  19. public void setId(int id) {
  20. this.id = id;
  21. }
  22. public String getName() {
  23. return name;
  24. }
  25. public void setName(String name) {
  26. this.name = name;
  27. }
  28. public String getPwd() {
  29. return pwd;
  30. }
  31. public void setPwd(String pwd) {
  32. this.pwd = pwd;
  33. }
  34. @Override
  35. public String toString() {
  36. return "User{" +
  37. "id=" + id +
  38. ", name='" + name + '\'' +
  39. ", pwd='" + pwd + '\'' +
  40. '}';
  41. }
  42. }

第三步:为接口配置对应的配置文件

  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!DOCTYPE mapper
  3. PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  4. "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  5. <!--绑定一个对应的Dao或Mapper接口-->
  6. <mapper namespace="com.zhu.dao.IUserDao">
  7. <!--id得对应相应的方法名,resultType对应返回类型的全限定名称-->
  8. <select id="selectAllUser" resultType="com.zhu.pojo.User">
  9. select * from mybatis.user
  10. </select>
  11. </mapper>

第四步:创建一个生成SqlSession对象的工具类

  1. package com.zhu.utils;
  2. import org.apache.ibatis.io.Resources;
  3. import org.apache.ibatis.session.SqlSession;
  4. import org.apache.ibatis.session.SqlSessionFactory;
  5. import org.apache.ibatis.session.SqlSessionFactoryBuilder;
  6. import java.io.IOException;
  7. import java.io.InputStream;
  8. public class MybatisUtils {
  9. private static SqlSessionFactory sqlSessionFactory;
  10. static {
  11. try {
  12. //创建SqlSessionFactory对象
  13. String resource = "mybatis-config.xml";
  14. InputStream inputStream = Resources.getResourceAsStream(resource);
  15. sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
  16. } catch (IOException e) {
  17. e.printStackTrace();
  18. }
  19. }
  20. public static SqlSession getSqlSession(){
  21. //通过SqlSessionFactory来创建SqlSession对象
  22. SqlSession sqlSession = sqlSessionFactory.openSession();
  23. return sqlSession;
  24. }
  25. }

第五步:配置核心文件

1.配置连接数据库的相关信息
2.每一个接口相应的配置文件都得在核心配置文件中通过注册

  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!DOCTYPE configuration
  3. PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  4. "http://mybatis.org/dtd/mybatis-3-config.dtd">
  5. <configuration>
  6. <environments default="development">
  7. <environment id="development">
  8. <transactionManager type="JDBC"/>
  9. <dataSource type="POOLED">
  10. <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
  11. <property name="url" value="jdbc:mysql://localhost:3306"/>
  12. <property name="username" value="root"/>
  13. <property name="password" value="zhuminghua"/>
  14. </dataSource>
  15. </environment>
  16. </environments>
  17. <mappers>
  18. <!--注册相应接口的配置文件-->
  19. <mapper resource="com/zhu/dao/IUserDao.xml"/>
  20. </mappers>
  21. </configuration>

没有在核心配置文件中注册相应接口的配置文件会报以下错误

watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTcyMzAwMw_size_16_color_FFFFFF_t_70_pic_center

由于maven的约定大于配置,我们可能遇到配置文件无法导出或者生效的问题。解决方案:在pom.xml文件中加入build配置

  1. <build>
  2. <resources>
  3. <resource>
  4. <directory>src/main/java</directory>
  5. <includes>
  6. <include>**/*.properties</include>
  7. <include>**/*.xml</include>
  8. </includes>
  9. <filtering>true</filtering>
  10. </resource>
  11. <resource>
  12. <directory>src/main/resources</directory>
  13. <includes>
  14. <include>**/*.properties</include>
  15. <include>**/*.xml</include>
  16. </includes>
  17. <filtering>true</filtering>
  18. </resource>
  19. </resources>
  20. </build>

没配置build可能出现一下异常:

在这里插入图片描述

发表评论

表情:
评论列表 (有 0 条评论,300人围观)

还没有评论,来说两句吧...

相关阅读

    相关 MyBatis工作环境

    0x00:开发步骤 MyBatis 工作环境开发步骤为:创建工程、引入依赖 jar 包、搭建日志输出环境、配置数据库连接池、创建持久层 Java 对象、编写 Mapper