Mybatis的Dao层实现(十一)

CodeWang_NC

已于 2022-10-22 14:02:04 修改

阅读量264

点赞数

分类专栏： mybatis 文章标签： mybatis java log4j

于 2022-10-10 23:04:44 首次发布

本文链接：https://blog.csdn.net/qq_45056135/article/details/127253777

版权

mybatis 专栏收录该内容

17 篇文章 0 订阅

订阅专栏

介绍&步骤

视频教程: https://www.bilibili.com/video/BV1WZ4y1P7Bp?p=163
官方笔记链接：https://pan.baidu.com/s/1dnL5hwOPHPMNgb81yzQIOQ
提取码：2022
目录结构:
在这里插入图片描述

1.准备工作

1.1 导入坐标

<dependencies>
    <!--mybatis 依赖-->
    <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>3.5.5</version>
    </dependency>

    <!--mysql 驱动-->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.46</version>
    </dependency>

    <!--junit 单元测试-->
    <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.13</version>
    </dependency>

    <!-- 添加slf4j日志api -->
    <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>slf4j-api</artifactId>
        <version>1.7.20</version>
    </dependency>
    <!-- 添加logback-classic依赖 -->
    <dependency>
        <groupId>ch.qos.logback</groupId>
        <artifactId>logback-classic</artifactId>
        <version>1.2.3</version>
    </dependency>
    <!-- 添加logback-core依赖 -->
    <dependency>
        <groupId>ch.qos.logback</groupId>
        <artifactId>logback-core</artifactId>
        <version>1.2.3</version>
    </dependency>
</dependencies>

1.2 resource下面的配置文件

1.2.1 log4j.properties配置文件

### direct log messages to stdout ###
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.Target=System.out
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n

### direct messages to file mylog.log ###
log4j.appender.file=org.apache.log4j.FileAppender
log4j.appender.file.File=c:/mylog.log
log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n

### set log levels - for more verbose logging change 'info' to 'debug' ###

log4j.rootLogger=info, stdout

1.2.2 logback.xml文件优化终端显示的效果

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
    <!--
        CONSOLE ：表示当前的日志信息是可以输出到控制台的。
    -->
    <appender name="Console" class="ch.qos.logback.core.ConsoleAppender">
        <encoder>
            <pattern>[%level] %blue(%d{HH:mm:ss.SSS}) %cyan([%thread]) %boldGreen(%logger{15}) - %msg %n</pattern>
        </encoder>
    </appender>

    <logger name="com.itheima" level="DEBUG" additivity="false">
        <appender-ref ref="Console"/>
    </logger>


    <!--

      level:用来设置打印级别，大小写无关：TRACE, DEBUG, INFO, WARN, ERROR, ALL 和 OFF
     ， 默认debug
      <root>可以包含零个或多个<appender-ref>元素，标识这个输出位置将会被本日志级别控制。
      -->
    <root level="DEBUG">
        <appender-ref ref="Console"/>
    </root>
</configuration>

1.2.3 jdbc.properties配置文件

<?xml version="1.0" encoding="UTF-8" ?>
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql:///test?useSSL=false&useServerPrepStmts=true
# useSSL 忽略警告信息， userServer 开启PrepareStatement的预编译功能
jdbc.username=root
jdbc.password=123456
# 初始化连接数量
initialSize=5
# 最大连接数
maxActive=10
# 最大等待时间
maxWait=3000

1.2.4 sqlMapConfig.xml的配置文件

<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>

    <!--加载配置文件-->
    <properties resource="jdbc.properties"></properties>
    
	<!--  定义别名 -->
   <typeAliases>
                <package name="com.itheima.domain"/>
	<!--<typeAlias type="com.itheima.domain.User" alias="User"></typeAlias>-->
    </typeAliases>

    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="${jdbc.driver}"/>
                <property name="url" value="${jdbc.url}"/>
                <property name="username" value="${jdbc.username}"/>
                <property name="password" value="${jdbc.password}"/>
            </dataSource>
        </environment>
    </environments>

    <!--  加载映射文件  -->
    <mappers>
        <!--  配置文件的路径地址 就是Usermapper的地址  这里要用斜杠 不能用点 -->
        <mapper resource="com/itheima/mapper/UserMapper.xml"/>
    </mappers>

</configuration>

1.3 实体类&数据库表(有表就不用创建)

实体类

public class User {
    private int id;
    private String username;
    private String password;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", password='" + password + '\'' +
                '}';
    }
}

数据库表

drop table if exists user;

create table user(
	id int primary key auto_increment,
	username varchar(20),
	password varchar(20)
);

insert into user values (null, "zhangsan", "123");
insert into user values (null, "lisi", "123");
insert into user values (null, "wangwu", "123");
select * from user;

1.4 UserMapper.xml配置文件

UserMapper.xml文件路径要和UserMapper接口路径一致:

com/itheima/mapper/UserMapper.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="com.itheima.mapper.UserMapper">

    <!--  sql语句的抽取  -->
    <sql id="selectUser">select * from user</sql>

    <select id="findAll" resultType="user">
        select * from user;
    </select>

</mapper>

2.传统开发方式

2.1 编写UserMapper接口

public interface UserMapper {
    List<User> findAll() throws IOException;
}

2.2 编写UserDaoImpl实现

public class UserMapperImpl implements UserMapper {
    public List<User> findAll() throws IOException {
        //加载核心配置文件
        InputStream resourceAsStream = Resources.getResourceAsStream("SqlMapConfig.xml");
        //获得sqlSession工厂对象
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
        //获得sqlSession对象
        SqlSession sqlSession = sqlSessionFactory.openSession();
        //执行sql语句   执行参数就是nameSpace.id 如果没有就会报错
        List<User> userList = sqlSession.selectList("userMapper.findAll");
        //打印结果
        System.out.println("userList:" + userList);
        //释放资源
        sqlSession.close();
        return userList;
    }
}

2.3 测试传统方式

这里UserMapper.xml的命名空间为userMapper不然会出错

public class DaoTest {
    @Test
    public void testTraditionDao() throws IOException {
        //创建dao层对象
        UserMapperImpl userMapper = new UserMapperImpl();
        List<User> userList = userMapper.findAll();
        System.out.println(userList);
    }
}

3.代理开发方式

介绍
在这里插入图片描述

3.1 编写UserMapper接口

public interface UserMapper {
    List<User> findAll() throws IOException;

    User findById(int id);
}

3.2 UserMapper.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="com.itheima.dao.UserMapper">

    
    <!--查询操作-->
    <select id="findAll" resultType="user">
        select * from user;
    </select>

    <!--根据id进行查询-->
    <select id="findById" parameterType="int" resultType="user">
        select * from user where id = #{id}
    </select>

</mapper>

3.3 测试代理方法

这里UserMapper.xml的命名空间为com.itheima.mapper.UserMapper不然会出错

@Test
public void testProxyDao() throws IOException {
    InputStream resourceAsStream = Resources.getResourceAsStream("SqlMapConfig.xml");
    SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
    SqlSession sqlSession = sqlSessionFactory.openSession();
    //获得MyBatis框架生成的UserMapper接口的实现类
    UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
    List<User> userList = userMapper.findAll();
    System.out.println(userList);
    sqlSession.close();

}

@Test
public void testById() throws IOException {
    InputStream resourceAsStream = Resources.getResourceAsStream("SqlMapConfig.xml");
    SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
    SqlSession sqlSession = sqlSessionFactory.openSession();
    //获得MyBatis框架生成的UserMapper接口的实现类
    UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
    User user = userMapper.findById(3);
    System.out.println(user);
    sqlSession.close();

}