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>org.example</groupId>
<artifactId>student-demo</artifactId>
<version>1.0-SNAPSHOT</version>
<dependencies>
<!-- 添加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.38</version>
</dependency>
<!-- 添加druid连接池依赖 -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.1.0</version>
</dependency>
<!-- 添加slf4j日志api -->
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-api</artifactId>
<version>1.7.20</version>
</dependency>
<!-- 添加logback-classic依赖 -->
<dependency>
<groupId>ch.qos.logback</groupId>
<artifactId>logback-classic</artifactId>
<version>1.2.3</version>
</dependency>
<!-- 添加logback-core依赖 -->
<dependency>
<groupId>ch.qos.logback</groupId>
<artifactId>logback-core</artifactId>
<version>1.2.3</version>
</dependency>
<!-- 添加mybatis依赖 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.3</version>
</dependency>
<!-- 添加lomkok 依赖 生成get,set方法 -->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.20</version>
<scope>provided</scope>
</dependency>
<!--分页助手-->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.3.0</version>
</dependency>
</dependencies>
</project>
==================================================================================
jdbc.properties 配置文件
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost/mydatabase1
username=root
password=gwh
==================================================================================
核心配置文件
<?xml version="1.0" encoding="UTF-8" ?>
<!-- MyBatis的DTD约束-->
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<!-- configuration 核心根标签-->
<configuration>
<!-- properties 引入数据库连接的配置文件-->
<properties resource="jdbc.properties"></properties>
<settings>
<!-- 数据库下划线自动映射成Java驼峰
数据库:aaa_bbb
Java:aaaBbb
-->
<setting name="mapUnderscoreToCamelCase" value="true"/>
<!-- typeAliases 起别名-->
<typeAliases>
<!--
typeAlias为全类名起别名的子标签
type:指定全类名
alias:指定别名
package:为指定包名下所有类起别名的子标签。别名就是类名
-->
<typeAlias type="com.itheima.Student" alias="student"/>
<package name="com.itheima"/>
</typeAliases>
<!--分页助手-->
<plugins>
<!-- com.github.pagehelper为PageHelper类所在包名 -->
<plugin interceptor="com.github.pagehelper.PageInterceptor">
<!-- 使用下面的方式配置参数,后面会有所有的参数介绍 -->
<property name="helperDialect" value="mysql"/>
<property name="reasonable" value="true"/>
</plugin>
</plugins>
<!-- environments配置数据库环境,环境可以有多个。default属性指定使用的是哪一个-->
<environments default="mysql">
<!-- environment 配置数据库环境,id属性唯一标识-->
<environment id="mysql">
<!-- transactionManager 事务管理 type 属性,采用JDBC默认的事务-->
<transactionManager type="JDBC"/>
<!-- dataSource 数据源信息 type属性连接池-->
<dataSource type="POOLED">
<!-- property 获取数据库连接的配置信息-->
<property name="driver" value="${driver}"/>
<property name="url" value="${url}"/>
<property name="username" value="${username}"/>
<property name="password" value="${password}"/>
</dataSource>
</environment>
</environments>
<!-- mappers引入映射配置文件-->
<mappers>
<!-- mapper引入指定的映射配置文件 resource属性指定映射配置文件的名称-->
<mapper resource="StudentMapper.xml"/>
</mappers>
</configuration>
======================================================================================
映射 配置文件
<?xml version="1.0" encoding="UTF-8" ?>
<!-- MyBatis的DTD约束-->
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!--
mapper:根核心标签
namespace属性:名称空间
-->
<mapper namespace="com.ithema.mapper.UserMapper2">
<!--
select:查询功能的标签
insert:新增功能标签
update:修改功能标签
delete:删除功能标签
id属性:唯一标识
resultType属性:指定结果映射对象类型
parameterType属性:指定参数映射对象类型
Sql 获取参数 #{属性名}
-->
<select id="selectAll" resultType="com.ithema.pojo.Student1">
select*from tb_student
</select>
</mapper>