Mybatis入门案例(mybatis学习DAY1)

最新推荐文章于 2024-05-18 16:03:12 发布

lucien1029

最新推荐文章于 2024-05-18 16:03:12 发布

阅读量184

点赞数

文章标签： mybatis 学习 java

本文链接：https://blog.csdn.net/shine3316/article/details/125749391

版权

Mybatis入门案例

搭建MyBatis环境，使用Mybatis进行简单增删改查

导入依赖pom.xml

<dependencies>
        <!--导入MySQL的驱动包-->
        <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.6</version>
        </dependency>

        <!--junit-->
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
            <scope>test</scope>
        </dependency>

        <!--log4j-->
        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.17</version>
        </dependency>


        <!-- https://mvnrepository.com/artifact/org.projectlombok/lombok -->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.12</version>
            <scope>provided</scope>
        </dependency>
    </dependencies>

连接数据库四要素 jdbc.properties

jdbc_username=root
jdbc_password=root
jdbc_url=jdbc:mysql://127.0.0.1:3306/mydb?useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true
jdbc_driver=com.mysql.cj.jdbc.Driver

数据库文件 sql

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for department
-- ----------------------------
DROP TABLE IF EXISTS `department`;
CREATE TABLE `department`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of department
-- ----------------------------
INSERT INTO `department` VALUES (1, '教学部');
INSERT INTO `department` VALUES (2, '教务部');
INSERT INTO `department` VALUES (3, '运营部');
INSERT INTO `department` VALUES (4, '咨询部');
INSERT INTO `department` VALUES (5, '就业部');

-- ----------------------------
-- Table structure for employee
-- ----------------------------
DROP TABLE IF EXISTS `employee`;
CREATE TABLE `employee`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `last_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `gender` int(1) NULL DEFAULT NULL,
  `email` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `salary` double(11, 2) NOT NULL,
  `dept_id` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `dept_id`(`dept_id`) USING BTREE,
  CONSTRAINT `employee_ibfk_1` FOREIGN KEY (`dept_id`) REFERENCES `department` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 55 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of employee
-- ----------------------------
INSERT INTO `employee` VALUES (1, 'Mark', 1, 'Mark@atguigu.com', 30000.00, 1);
INSERT INTO `employee` VALUES (2, 'Mayun', 0, 'mayun@alibaba.com', 20000.00, 2);
INSERT INTO `employee` VALUES (3, 'Mahuateng', 1, 'mahuateng@qq.com', 10000.00, 3);
INSERT INTO `employee` VALUES (4, '按住啦baby', 0, 'baby@atguigu.cn', 20000.00, 1);
INSERT INTO `employee` VALUES (5, '安其拉Baby', 1, 'angel@atguigu.cn', 10000.00, 3);

SET FOREIGN_KEY_CHECKS = 1;

日志文件 log4j.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/">
    <appender name="STDOUT" class="org.apache.log4j.ConsoleAppender">
        <param name="Encoding" value="UTF-8" />
        <layout class="org.apache.log4j.PatternLayout">
            <param name="ConversionPattern" value="%-5p %d{MM-dd HH:mm:ss,SSS} %m  (%F:%L) \n" />
        </layout>
    </appender>
    <logger name="java.sql">
        <level value="debug" />
    </logger>
    <logger name="org.apache.ibatis">
        <level value="info" />
    </logger>
    <root>
        <level value="debug" />
        <appender-ref ref="STDOUT" />
    </root>
</log4j:configuration>

Mybatis核心配置文件 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>

    <!--引入外部属性文件-->
    <properties resource="jdbc.properties">
        <!--<property name="JDBC_username" value="root"/>
        <property name="JDBC_password" value="root"/>-->
    </properties>

    <!--开启命名的驼峰转换-->
    <settings>
        <setting name="mapUnderscoreToCamelCase" value="true"/>
    </settings>

    <!--为实体类起别名-->
    <typeAliases>
        <!--<typeAlias type="com.atguigu.pojo.Employee" alias="emp"></typeAlias>-->
        <!--
        通过包扫描一次性为包下所有的实体类起别名
        自动别名规则 类的简单类名的首字母小写  com.atguigu.pojo.Employee >>>> employee

        -->
        <package name="com.atguigu.pojo"/>
    </typeAliases>
    <!--配置环境-->
    <environments default="development">
        <!--配置默认的数据源环境  mysql-->
        <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>


        <!--配置默认的数据源环境  oracle   sql server-->
        <!--<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>

    <!--设置数据库厂商标识-->
    <!--<databaseIdProvider type="DB_VENDOR">
        <property name="MySQL" value="mysql"/>
        <property name="Oracle" value="oracle"/>
    </databaseIdProvider>-->


    <!--加载mapper映射文件


    方式1 resource 写mapper映射文件的目录结构的路径
    方式2 class 加载mapper映射文件
         class里面写的是接口的全限定名
         通过全限定名去找对应的映射文件
    方式3 通过包扫描.一次性加载所有mapper映射文件
    -->

    <mappers>
        <!--<mapper resource="com/atguigu/dao/EmployeeMapper.xml"></mapper>-->
        <!--<mapper class="com.atguigu.dao.EmployeeMapper"/>-->
        <package name="com.atguigu.dao"/>
    </mappers>
</configuration>

pojo层的实体类 Employee.java

package com.atguigu.pojo;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import org.apache.ibatis.type.Alias;

@AllArgsConstructor
@NoArgsConstructor
@Data
public class Employee {
    private Integer id;
    private String lastName;
    private String email;
    private Double salary;
    private Integer deptId;
}

dao层的Mapper类 EmployeeMapper.java

package com.atguigu.dao;

import com.atguigu.pojo.Employee;
import java.util.List;

public interface EmployeeMapper {
    List<Employee> findAll();
}

sql 映射文件 EmployeeMapper.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接口代理模式下的几个相同
1 接口的名字和对应的mapper.xml映射文件名必须一致
2 mapper映射文件中的namespace必须是接口的全路径名
3 mapper.xml映射文件和编译之后的接口字节码必须在同一个目录下(目前来看)
4 mapper.xml中,SQL语句的id 必须是对应抽象方法的方法名

-->


<mapper namespace="com.atguigu.dao.EmployeeMapper">
    <!--配置SQL语句,代表对List<Employee> findAll();的实现
    resultType用来指定返回值类型
        其实是用来指明结果集使用什么类来进行映射封装
    -->
    <!--msyql 执行该语句-->
    <select id="findAll" resultMap="findResultMap">
        select * from employee;
    </select>

    <!--增加-->
    <insert id="addEmp">
        insert into employee values
        (DEFAULT ,'按住啦baby','zhaosi@yuzhibo.com','1002.34',1);
    </insert>

    <!--修改-->
    <update id="updateEmp">
        update employee
        set last_name ='旋涡刘能',email= '刘能@旋涡.com',salary =1234.456,dept_id = 2
        where id = 5;
    </update>

    <!--删除-->
    <delete id="delEmp">
        delete from employee
        where id = 2;
    </delete>


    <!--oracle 执行该语句-->
    <!--databaseId="mysql"-->
    <!--<select id="findAll" resultType="employee" >
        select * from employee
    </select>-->

</mapper>

测试类 TestEmployeeDao.java

package com.atguigu;

import com.atguigu.mapper.EmployeeMapper;
import com.atguigu.pojo.Employee;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Before;
import org.junit.Test;

import javax.annotation.Resource;
import java.io.IOException;
import java.io.InputStream;
import java.util.List;

public class TestEmployee {

    private SqlSession sqlSession;

    @Before
    public void init() throws IOException {
        //sqlSession共产的构建对象    专门用于生产工厂
        SqlSessionFactoryBuilder ssfb = new SqlSessionFactoryBuilder();
        //读取核心配置文件 通过Resources对象获取字节码根路径下的mybatis核心配置文件
        InputStream resources = Resources.getResourceAsStream("sqlMapConfig.xml");
        //构建工厂 SQL会话对象工厂 专门用于生产SQLSession对象
        SqlSessionFactory sqlSessionFactory = ssfb.build(resources);
        //获取sqlSession对象，用于执行SQL语句
        sqlSession = sqlSessionFactory.openSession(true);//给true自动提交事务
    }

    @Test
    public void testSelect(){
//        List<Employee> employees = sqlSession.selectList("com.atguigu.mapper.EmployeeMapper.findAll");
        EmployeeMapper employeeMapper = sqlSession.getMapper(EmployeeMapper.class);
        //查
//        List<Employee> employees = employeeMapper.findAll();
        //增
        employeeMapper.addEmp();

        //删除
        employeeMapper.delEmp();

        //修改
        employeeMapper.updateEmp();

        //查
        List<Employee> employees = employeeMapper.findAll();
        for (Employee employee : employees) {
            System.out.println(employee);
        }

        //关闭流
        sqlSession.close();
    }
}

lucien1029

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
打赏
0
评论
Mybatis入门案例(mybatis学习DAY1)

搭建MyBatis环境，使用Mybatis进行简单增删改查数据库文件 sql日志文件 log4j.xmlMybatis核心配置文件 sqlMapConfig.xmlpojo层的实体类 Employee.javadao层的Mapper类 EmployeeMapper.javasql 映射文件 EmployeeMapper.xml测试类 TestEmployeeDao.java...
复制链接

扫一扫