【MyBatis字段名属性名不一致的方法1】起别名：emp_name empName

1.测试取名必须加上test

public class SelectMapperTest {}

否则mapper不能调用接口中的方法

2.MyBatis添加功能自增

接口

public interface SQLMapper {
    /*
     动态表名，从指定的表查询用户信息
     List<User> getUserByTableName(@Param("tableName") String tableName);
      */
    void insertUser(User user);
}

映射文件

​​​​​​​<insert id="insertUser" useGeneratedKeys="true" keyProperty="id">
    insert into t_user values(null, #{username},  #{password}, #{age}, #{sex}, #{email})
</insert>

测试

public class SQLMapperTest{

    @Test
    public void testInsertUser(){
        SqlSession sqlSession = SqlSessionUtils.getSqlSession();
        SQLMapper mapper = sqlSession.getMapper(SQLMapper.class);
        User user = new User(null,"zz", "1234", 23, "女", "123456789@qq.com");
        mapper.insertUser(user);
        System.out.println(user);

    }

}

3.自定义映射resultmap

resource创建mapper需要用斜线com/zy/mybatis/mapper/

get/set、有参无参，快捷键： Alt+Enter 、 Alt+Insert 

4.lambda 表达式

java: -source 1.5 中不支持 lambda 表达式
  (请使用 -source 8 或更高版本以启用 lambda 表达式)

public void testGetAllEmp(){
    SqlSession sqlSession = SqlSessionUtils.getSqlSession();
    EmpMapper mapper = sqlSession.getMapper(EmpMapper.class);
    List<Emp> list = mapper.getAllEmp();
    list.forEach(emp -> System.out.println(emp));
  }

错误:java: 错误: 不支持发行版本 5（IDEA新建的maven项目，然后maven配置的Spring，测试一下用bean创建对象）_Casey·Hu的博客-CSDN博客

5.IntelliJ IDEA提示编译失败如下：

Error:java: Compilation failed: internal java compiler error

原因：内部 java 编译错误,一般是编译版本不匹配。

intellij-Error:java: Compilation failed: internal java compiler error

intellij-Error:java: Compilation failed: internal java compiler error_DRPrincess的博客-CSDN博客

6.各种错误

Error querying database.  Cause: java.sql.SQLException: Error setting driver on UnpooledDataSource. Cause: java.lang.ClassNotFoundException: Cannot find class: com.mysql.jdbc.Driver

查询数据库时出错。原因：java.sql.SQLException：在 UnpooledDataSource 上设置驱动程序时出错。原因：java.lang.ClassNotFoundException：找不到类：com.mysql.jdbc.Driver

* ###The error may exist in com/zy/mybatis/mapper/EmpMapper.xml
* ### The error may involve（涉及） com.zy.mybatis.mapper.EmpMapper.getAllEmp
* ### The error occurred while executing a query 执行查询时发生错误
* ### Cause: java.sql.SQLException: Error setting driver on UnpooledDataSource. Cause: java.lang.ClassNotFoundException: Cannot find class: com.mysql.jdbc.Driverjava.sql.SQLException：在 UnpooledDataSource 上设置驱动程序时出错。原因：java.lang.ClassNotFoundException：找不到类：com.mysql.jdbc.Driver

代码

pom..xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>com.zy.mybatis</groupId>
    <artifactId>Mybatis_d3</artifactId>
    <version>1.0-SNAPSHOT</version>
    <packaging>jar</packaging>

    <dependencies>

        <!-- Mybatis核心 -->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.7</version>
        </dependency>

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

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

        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.6</version>
            <scope>test</scope>
        </dependency>

        <!-- log4j日志 -->
        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.17</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.6</version>
            <scope>compile</scope>
        </dependency>

    </dependencies>

</project>

mapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "https://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.zy.mybatis.mapper.EmpMapper">
<!--List<Emp> getAllEmp();-->
    <select id="getAllEmp" resultType="Emp">
        select eid,emp_name empName,age,sex,email from t_emp
    </select>
</mapper>

接口

import com.zy.mybatis.pojo.Emp;

import java.util.List;

/**
 * @Auther:ZLY
 * @Date: 2023/5/11 - 05 - 11 - 19:10
 * @Description:
 * @version:1.0
 */
public interface EmpMapper {

    List<Emp> getAllEmp();
}

测试代码

public class EmpTest {
    @Test
    public void testGetAllEmp(){
        SqlSession sqlSession = SqlSessionUtils.getSqlSession();
        EmpMapper mapper = sqlSession.getMapper(EmpMapper.class);
        List<Emp> list = mapper.getAllEmp();
        list.forEach(emp -> System.out.println(emp));
    }
}