<dependencies>
    <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>3.5.10</version>
    </dependency>
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.38</version>
    </dependency>
    <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.13.2</version>
        <scope>test</scope>
    </dependency>
    <dependency>
        <groupId>org.projectLombok</groupId>
        <artifactId>lombok</artifactId>
        <version>1.18.26</version>
    </dependency>
</dependencies>

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/hqyj03?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimeZone=Asia/Shanghai
password=yjg
username=root

<setting name="mapUnderscoreToCamelCase" value="true"/> 

<setting name="logImpl" value="STDOUT_LOGGING"/> 

<!--設置映射類型別名-->
    <typeAliases>
       <!--設置pojo包下的類型別名-->
        <package name="com.yjg.mybatis.pojo"/>
    </typeAliases>

<?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配置內容時，有順序限制-->
<configuration>
      <!--讀取jdbc.properties配置文件-->
 <properties resource="jdbc.properties"></properties>
<settings>
    <!--配置sql日志打印-->
    <setting name="logImpl" value="STDOUT_LOGGING"/>
    <!--下劃線駝峰映射stu_name映射stuName-->
    <setting name="mapUnderscoreToCamelCase" value="true"/>
</settings>
    <!--設置映射類型別名-->
    <typeAliases>
       <!--設置pojo包下的類型別名-->
        <package name="com.yjg.mybatis.pojo"/>
    </typeAliases>
    <!--mybatis環(huán)境，default屬性指定一個環(huán)境-->
    <environments default="development">
        <!--id屬性自定義的環(huán)境唯一標識符-->
        <environment id="development">
            <!--指定使用jdbc事務管理-->
            <transactionManager type="JDBC"/>
            <!--使用mybatis內部帶連接池功能的數據源-->
            <dataSource type="POOLED">
                <!--獲取配置驅動-->
                <property name="driver" value="${driver}"/>
                <!--獲取配置url-->
                <property name="url" value="${url}"/>
                <!--獲取配置賬號-->
                <property name="username" value="${username}"/>
                <!--獲取配置密碼-->
                <property name="password" value="${password}"/>
            </dataSource>
        </environment>
    </environments>
    <!--映射器，映射器的 XML 映射文件包含了 SQL 代碼和映射定義信息-->
    <mappers>
        <mapper resource="com/yjg/mybatis/mapper/StudentMapper.xml"/>
    </mappers>
</configuration>

CREATE TABLE `student` (
  `stu_id` int(11) NOT NULL AUTO_INCREMENT,
  `stu_name` varchar(255) DEFAULT NULL,
  `stu_age` varchar(255) DEFAULT NULL,
  `stu_salary` decimal(10,2) DEFAULT NULL,
  `stu_birth` date DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  PRIMARY KEY (`stu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

import lombok.Data;
import java.util.Date;
@Data
//@Alias 注解是 MyBatis 提供的一個注解，用于為類或接口指定一個別名。
//@Alias("s")
public class Student {
    private Integer stuId;
    private String  stuName;
    private Integer stuAge;
    private Double  stuSalary;
    private Date  stuBirth;
    private Date createTime;
}

public interface StudentMapper {
    //插入用戶
    int insertStudent();
    //查詢全部類型
    List<Student> queryStudent();
    //通過id查詢學生,傳遞單個參數
    Student queryStudentById(Integer id);
   /*
   通過名字和age進行查詢
     1.方法中的參數會將存儲到map集合中，key值設置為arg0 , arg1.....或者設置為param1, param2. ...
     2.sql語句中是通過#{map的key值}來獲取到參數值,例如#{arg0}
     3.可以通過@Param注解更改參數在map中的key
     @Param("name")可以修改名稱
   */
    Student queryStudentByNameAndAge(@Param("name") String name,@Param("age") int age);
}

<?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.yjg.mybatis.mapper.StudentMapper">
    <insert id="insertStudent">
        insert into student values(null, 'zhangsan',18,' 200','2020-01-01 ' , now())
    </insert>
    <select id="queryStudent" parameterType="integer" resultType="Student">
              select * from student;
    </select>
      <!--拿到方法的形參，單個參數，#{id}-->
    <select id="queryStudentById" resultType="Student">
          select * from student where stu_id=#{id}
    </select>
     <!--拿到參數的值，多個參數的時候-->
    <select id="queryStudentByNameAndAge" resultType="student">
          select * from student where stu_name=#{name} and stu_age=#{age};
    </select>
</mapper>

public class Test1 {
    SqlSession sqlSession;
    @Before
    public void test1() throws Exception{
        InputStream inputStream = Resources.getResourceAsStream("mybatis.xml");
        SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
        SqlSessionFactory build = builder.build(inputStream);
       sqlSession = build.openSession(true);
    }
     //    添加數據
    @Test
    public void test2(){
        StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
        int i = mapper.insertStudent();
        System.out.println(i);
    }
     //    查詢所有學生
    @Test
    public void test3(){
        StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
        List<Student> students = mapper.queryStudent();
        students.forEach(System.out::println);
    }
    //    根據id查詢
    @Test
    public void test4(){
        StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
        Student student = mapper.queryStudentById(2);
        System.out.println(student);
    }
    //    根據多個參數查詢
    @Test
    public void test5(){
        StudentMapper mapper = sqlSession.getMapper(StudentMapper.class);
        Student student = mapper.queryStudentByNameAndAge("kun", 18);
        System.out.println(student);
    }
}