整合Mybatis

@一只牛码

已于 2022-02-05 11:43:21 修改

阅读量671

点赞数

文章标签： mysql postman 蓝桥杯

于 2022-02-05 11:16:50 首次发布

本文链接：https://blog.csdn.net/m0_58963550/article/details/122788633

版权

第一步：导包

  <dependencies>
<!--mysql依赖 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.26</version>
        </dependency>
<!-- junit测试依赖-->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.13.2</version>
            <scope>test</scope>
        </dependency>
<!-- mybatis依赖 -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.7</version>
        </dependency>
<!--lombok依赖-->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.22</version>
        </dependency>
    </dependencies>

第二步：编写Mybatis工具类、实体类、接口

Mybatis工具类,获取SqlSession数据库操作对象

public class MybatisUtils {

    private static SqlSessionFactory sqlSessionFactory;

    static {
        try {
            //核心配置文件
            String resource="mybatis-config.xml";
            //读取
            InputStream in = Resources.getResourceAsStream(resource);
            //创建工厂实例
            sqlSessionFactory =new SqlSessionFactoryBuilder().build(in);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
    //获取sqlsession对象
    public static SqlSession getSqlSession(){
        return sqlSessionFactory.openSession(true);//true设置自动提交事务
    }
}

实体类

@Data
@NoArgsConstructor
@AllArgsConstructor
@ToString
public class User {
    private Integer id;
    private String uName;
    private Integer uAge;
    private String uGender;
    private String uPwd;
}

接口

public interface UserMapper {
    //获取所有的用户对象
    public List<User> getListUser();
    //通过id查询一个用户对象
    public User getUser(int id);
    //增加一个用户
    public int addUser(User user);
    //删除一个用户
    public int delUser(int id);
    //修改一个用户
    public int upDateUser(User user);
    //分页查询
    public List<User> getUserByLimit(Map<String,Integer> map);

}

第三步：配置*Mapper.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">
<!--namespace=命名空间，相当于实现某个接口-->
<mapper namespace="com.wwm.dao.UserMapper">
    <resultMap id="myDate" type="user">
        <id column="id" property="id"/>
        <result column="username" property="uName"/>
        <result column="userage" property="uAge"/>
        <result column="gender" property="uGender" />
        <result column="userPwd" property="uPwd"/>
    </resultMap>
<!--    <select id="getListUser" resultType="user">-->
<!--        select id id, username uName, userage uAge, gender uGender, userPwd uPwd from mybatis.user-->
<!--    </select>-->
    <select id="getListUser" resultMap="myDate">
        select * from mybatis.user
    </select>
    <select id="getUser" resultMap="myDate">
        select id , username , userage , gender , userPwd  from mybatis.user
        where id=#{id}
    </select>
    <insert id="addUser" useGeneratedKeys="true" keyProperty="id">
        insert into mybatis.user values (#{id},#{uName},#{uAge},#{uGender},#{uPwd})
    </insert>
    <delete id="delUser">
        delete from mybatis.user where id=#{id}
    </delete>
    <update id="upDateUser" >
        update mybatis.user set
        username=#{uName},
        userage=#{uAge},
        gender=#{uGender},
        userPwd=#{uPwd}
        where id=#{id}
    </update>
    <select id="getUserByLimit" parameterType="map" resultMap="myDate">
        select * from mybatis.user limit #{start},#{end}
    </select>
</mapper>

第四步：配置Mybtis核心配置文件

mybtis-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="db.properties">
<!--        <property name="username" value="root"/>-->
<!--        <property name="password" value="www123"/>-->
    </properties>

    <settings>
        <!-- 配置日志-->
        <setting name="logImpl" value="LOG4J"/>
        <!--显式开启二级缓存-->
        <setting name="cacheEnabled" value="true"/>
   </settings>-->

<!-- 给实体类取别名-->
    <typeAliases>
        <typeAlias type="com.wwm.pojo.User" alias="user"/>
<!--        <package name="com.wwm.pojo"/>-->
    </typeAliases>
<!--配置数据源-->
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="${driver}"/>
                <property name="url" value="${url}"/>
                <property name="username" value="${username}"/>
                <property name="password" value="${password}"/>
            </dataSource>
        </environment>
    </environments>
<!--每个xml文件都需要在核心配置文件里注册-->
    <mappers>
        <mapper resource="mappers/UserMapper.xml"/>
    </mappers>
</configuration>

数据源配置文件 db.properties

driver=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://localhost:3306/mybatis?useSSL=true&useUnicode=true&charterEncoding=utf-8
username=root
password=www123

第五步：测试

public class UserDaoTest {
    static Logger logger = Logger.getLogger(UserDaoTest.class);
    @Test
    public void test(){
        logger.info("log4j:单个查询开始。。。");
        //获取SqlSession对象
        SqlSession sqlSession = MybatisUtils.getSqlSession();
        //获取对应接口的对象
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        //通过接口对象执行自定义sql语句
        User user =mapper.getUser(1);
        System.out.println(user);
        //关闭sqlsesion对象
        sqlSession.close();
    }
}

注：配置log4j日志，需要导入依赖，以及日志输出配置文件（log4j.properties）

 <!-- https://mvnrepository.com/artifact/log4j/log4j -->
        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.17</version>
        </dependency>

#将等级为DEBUG的日志信息输出到console和file这两个目的地，console和file的定义在下面的代码
log4j.rootLogger=DEBUG,console,file

#控制台输出的相关设置
log4j.appender.console = org.apache.log4j.ConsoleAppender
log4j.appender.console.Target = System.out
log4j.appender.console.Threshold=DEBUG
log4j.appender.console.layout = org.apache.log4j.PatternLayout
log4j.appender.console.layout.ConversionPattern=【%c】-%m%n

#文件输出的相关设置
log4j.appender.file = org.apache.log4j.RollingFileAppender
log4j.appender.file.File=./log/kuang.log
log4j.appender.file.MaxFileSize=10mb
log4j.appender.file.Threshold=DEBUG
log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=【%p】【%d{yy-MM-dd}】【%c】%m%n

#日志输出级别
log4j.logger.org.mybatis=DEBUG
log4j.logger.java.sql=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.ResultSet=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG

**Mybtis使用注解开发（不需要配置*Mapper.xml文件）**

直接在接口使用注解写sql语句

public interface userDao {//使用注解开发
    //使用注解开发数据库字段和实体类的属性名建议保持一致
    @Select("select * from mybatis.user")
    List<User> getUsers();

    @Select("select * from mybatis.user where id=#{id}")
    User getUserById(@Param("id") Integer id);

    @Update("update mybatis.user set username=#{username},userage=#{userage}," +
            "gender=#{gender},userPwd=#{userPwd} where id=#{id}")
    int upDateUser(User user);

    @Insert("insert into mybatis.user values(#{id},#{username},#{userage}," +
            "#{gender},#{userPwd})")
    int addUser(User user);

    @Delete("delete from mybatis.user where id=#{id}")
    int delUser(int id);
}

<?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="db.properties">
<!--        <property name="username" value="root"/>-->
<!--        <property name="password" value="www123"/>-->
    </properties>

<!-- 配置日志-->
    <settings>
        <setting name="logImpl" value="STDOUT_LOGGING"/>
    </settings>

<!-- 给实体类取别名-->
    <typeAliases>
        <typeAlias type="com.wwm.pojo.User" alias="user"/>
<!--        <package name="com.wwm.pojo"/>-->
    </typeAliases>

    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="${driver}"/>
                <property name="url" value="${url}"/>
                <property name="username" value="${username}"/>
                <property name="password" value="${password}"/>
            </dataSource>
        </environment>
    </environments>
<!-- 要在mybatis核心文件里注册接口-->
    <mappers>
        <mapper class="com.wwm.dao.userDao"/>
    </mappers>
</configuration>