MyBatis从入门到放弃

Litch_

已于 2022-08-28 02:56:16 修改

阅读量90

点赞数

文章标签： mybatis

于 2020-11-02 10:07:28 首次发布

本文链接：https://blog.csdn.net/litch_/article/details/109440547

版权

创建一个Maven项目，并且在pom.xml文件中导入Mybatis依赖

<!-- 导入依赖 -->
    <dependencies>
        <!--MyBatis核心依赖-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.6</version>
        </dependency>

        <!--MySql驱动依赖-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.47</version>
        </dependency>

        <!-- 日志依赖：Log4J -->
        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.17</version>
        </dependency>

    </dependencies>

在Resource目录下创建jdbc.properties配置文件

jdbc.url=jdbc:mysql://localhost:3306/数据库名字?useUnicode=true&characterEncoding=utf-8
jdbc.driver=com.mysql.jdbc.Driver
jdbc.username=root
jdbc.password=123456

在Resource目录下创建log4j.properties日志l配置文件

# Global logging configuration
log4j.rootLogger=DEBUG, stdout
# MyBatis logging configuration...
log4j.logger.org.mybatis.example.BlogMapper=TRACE
# Console output...
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

在Resource目录下创建Mybatis的配置文件mybatis-config.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>

    <!-- 导入外部的参数 -->
    <properties resource="jdbc.properties"></properties>
    <environments default="default_config">
        <!-- 数据库相关配置 -->
        <environment id="default_config">
            <!-- 事务控制类型 -->
            <transactionManager type="jdbc"></transactionManager>
            <!-- 数据连接参数  -->
            <dataSource type="org.apache.ibatis.datasource.pooled.PooledDataSourceFactory">
                <property name="driver" value="${jdbc.driver}"/>
                <!-- &转义&amp; -->
                <property name="url" value="${jdbc.url}"/>
                <property name="username" value="${jdbc.username}"/>
                <property name="password" value="${jdbc.password}"/>
            </dataSource>
        </environment>
    </environments>
    </configuration>

创建数据库表

 create table t_user(
   id int primary key auto_increment,
   username varchar(50),
   password varchar(50),
   gender tinyint,
   regist_time datetime
 )default charset =utf8;

定义实体类，属性名字必须与数据库一致（自行添加get、set、toString、有参构造、无参构造方法），idea快捷键alt+insert

import java.util.Date;

public class User {
    private Integer id;
    private String username;
    private String password;
    private Boolean gender;
    private Date registTime;
/*        此处省略get、set、toString、有参构造、无参构造方法            */
}

创建Dao包，定义Dao接口

public interface UserDAO {
    User queryUserById(Integer id);
    }

<?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.hello.dao.UserDAO">
  <resultMap id="user_resultMap" type="User">
        <!-- 定义更复杂的  映射规则 -->
        <id column="id" property="id"></id>
        <result column="username" property="username"></result>
        <result column="password" property="password"></result>
        <result column="gender" property="gender"></result>
        <result column="regist_time" property="registTime"></result>
    </resultMap>
     <!-- 描述方法 -->
    <select id="queryUserById" resultType="User">
        select id,username,password,gender,regist_time as registTime
        from t_user
        where id=#{arg0}
    </select>
    </mapper>

由于java目录下的Mapper文件在运行时不会被加载，所以需要在pom.xml中配置加载路径，复制粘贴在<dependencies>标签下即可。

 <build>
        <!-- 更改maven编译规则 -->
        <resources>
            <resource>
                <!-- 资源目录 -->
                <directory>src/main/java</directory>
                <includes>
                    <include>*.xml</include><!-- 默认（新添加自定义则失效） -->
                    <include>**/*.xml</include><!-- 新添加 */代表1级目录 **/代表多级目录 -->
                </includes>
                <filtering>true</filtering>
            </resource>
        </resources>
    </build>

在mybatis-config.xml配置文件中注册Mapper.xml文件

    <mappers>
        <mapper resource="Mapper.xml"/>
            </mappers>

创建类文件进行测试

InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml");
sqlSessionFactory=new SqlSessionFactoryBuilder().build(inputStream);
sqlSession=sqlSessionFactory.openSession();
UserDao userDao = sqlSession.getMapper(UserDao.class);
System.out.println(userDao.selectUserById(1));