JAVA MyBatis入门学习过程记录
作者:wangweizu99 时间:2022-04-23 13:49:24
一、Mybatis
1、mybatis-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>
<!-- 外部引入db-->
<properties resource="db.properties"/>
<settings>
<!-- 配置日志文件-->
<!-- <setting name="logImpl" value="STDOUT_LOGGING"/>-->
<setting name="logImpl" value="log4j"/>
<!-- 开启A_NAME==>aName-->
<setting name="mapUnderscoreToCamelCase" valie="true"
</settings>
<!-- 减少类型-->
<typeAliases> <typeAlias type="com.wang.pojo.User" alias="User"/>
</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>
<mappers>
<mapper resource="com/wang/dao/UserMapper.xml"/>
</mappers>
</configuration>
2、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">
<mapper namespace="com.wang.dao.UserDao">
<select id="getUserList" resultType="User">
select * from mybatis.user
</select>
</mapper>
3、db.properties
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/mybatis
username=root
password=123456
4、MybatisUtils工具类
package com.wang.utils;
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 java.io.IOException;
import java.io.InputStream;
public class MybatisUtils {
private static SqlSessionFactory sqlSessionFactory;
static {
InputStream inputStream = null;
try {
String resource = "mybatis-config.xml";
inputStream = Resources.getResourceAsStream(resource);
sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
} catch (IOException e) {
e.printStackTrace();
}
}
public static SqlSession getsqlsession() {
return sqlSessionFactory.openSession();
}
}
5、多对一AND多对一:
在Mapper.xml中配置
association 对象 多对一
collection 集合 一对多
从用参数解释:
javaType java类型
ofType 泛型约束类型
6、使用注解开发
可在接口中使用注解进行开发,省去Mapper.xml
@Select("select * from mybatis.User")
List<User> getUserList();
在mybatis-config.xml中配置
<mappers>
<mapper class="com.wang.Dao.UserMapper"
</mappers>
7、自定义缓存:ehcache
8、mybatis 其他工具
mybatis Hepler:https://pagehelper.github.io/
二、MAVEN资源导出错误解决
<build>
<resources>
<resource>
<directory>src/main/resources</directory>
<includes>
<include>**/*.properties</include>
<include>**/*.xml</include>
</includes>
<filtering>true</filtering>
</resource>
<resource>
<directory>src/main/java</directory>
<includes>
<include>**/*.properties</include>
<include>**/*.xml</include>
</includes>
<filtering>true</filtering>
</resource>
</resources>
</build>
三、常用依赖导入
<!--导入依赖-->
<dependencies>
<!-- mysql-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.49</version>
</dependency>
<!-- mybatis-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.2</version>
</dependency>
<!-- junit-->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.13</version>
</dependency>
<!-- lombok-->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.20</version>
</dependency>
<!-- servlet and jsp-->
<dependency>
<groupId>org.mortbay.jetty</groupId>
<artifactId>servlet-api-2.5</artifactId>
<version>6.1.7</version>
</dependency>
<dependency>
<groupId>javax.servlet.jsp</groupId>
<artifactId>jsp-api</artifactId>
<version>2.1</version>
</dependency>
<!-- standard-->
<dependency>
<groupId>org.apache.karaf.assemblies.features</groupId>
<artifactId>standard</artifactId>
<version>2.4.4</version>
</dependency>
<dependency>
<groupId>taglibs</groupId>
<artifactId>standard</artifactId>
<version>1.1.2</version>
</dependency>
<!-- jstl-->
<dependency>
<groupId>javax.servlet.jsp.jstl</groupId>
<artifactId>jstl-api</artifactId>
<version>1.2</version>
</dependency>
<dependency>
<groupId>org.glassfish.web</groupId>
<artifactId>jstl-impl</artifactId>
<version>1.2</version>
</dependency>
<!-- fastjson-->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>fastjson</artifactId>
<version>1.2.76</version>
</dependency>
<!--Log4j-->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
</dependencies>
四、LOG4J
1、log4j.properties 配置文件
<!--导入依赖-->
<dependencies>
<!-- mysql-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.49</version>
</dependency>
<!-- mybatis-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.2</version>
</dependency>
<!-- junit-->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.13</version>
</dependency>
<!-- lombok-->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.20</version>
</dependency>
<!-- servlet and jsp-->
<dependency>
<groupId>org.mortbay.jetty</groupId>
<artifactId>servlet-api-2.5</artifactId>
<version>6.1.7</version>
</dependency>
<dependency>
<groupId>javax.servlet.jsp</groupId>
<artifactId>jsp-api</artifactId>
<version>2.1</version>
</dependency>
<!-- standard-->
<dependency>
<groupId>org.apache.karaf.assemblies.features</groupId>
<artifactId>standard</artifactId>
<version>2.4.4</version>
</dependency>
<dependency>
<groupId>taglibs</groupId>
<artifactId>standard</artifactId>
<version>1.1.2</version>
</dependency>
<!-- jstl-->
<dependency>
<groupId>javax.servlet.jsp.jstl</groupId>
<artifactId>jstl-api</artifactId>
<version>1.2</version>
</dependency>
<dependency>
<groupId>org.glassfish.web</groupId>
<artifactId>jstl-impl</artifactId>
<version>1.2</version>
</dependency>
<!-- fastjson-->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>fastjson</artifactId>
<version>1.2.76</version>
</dependency>
<!--Log4j-->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
</dependencies>
2、log4j 在mybatis-config.xml的配置
<settings>
<setting name="logImpl" value="LOG4J"/>
</settings>
3、使用场景
在具体类中引入
Logger logger = Logger.getLogger(UserDaoTest.class);
logger.error();
logger.debug();
好用的插件:
1、lombok
常用注解:
@Data 自动生成geter seter
@AllArgsConstructor 生成有参构造函数
@NoArgsConstructor 生成无参构造函数
=“logImpl” value=“LOG4J”/>
## 3、使用场景
- 在具体类中引入
```java
Logger logger = Logger.getLogger(UserDaoTest.class);
logger.error();
logger.debug();
常用注解:
@Data 自动生成geter seter
@AllArgsConstructor 生成有参构造函数
@NoArgsConstructor 生成无参构造函数
来源:https://blog.csdn.net/weixin_50738670/article/details/117933388
标签:JAVA,MyBatis,入门
![](/images/zang.png)
![](/images/jiucuo.png)
猜你喜欢
Java二维数组简单定义与使用方法示例
2022-01-28 08:31:37
Java LinkedHashMap深入分析源码
2022-07-31 03:05:43
![](https://img.aspxhome.com/file/2023/2/62092_0s.png)
feign GET请求不支持对象传参的坑及解决
2023-07-29 18:10:25
elasticsearch索引index之engine读写控制结构实现
2021-12-22 00:08:07
![](https://img.aspxhome.com/file/2023/9/61299_0s.jpg)
Java实现去除文档阴影的示例代码
2023-08-31 11:45:48
![](https://img.aspxhome.com/file/2023/5/58415_0s.png)
java web监听器统计在线用户及人数
2023-12-14 14:42:52
![](https://img.aspxhome.com/file/2023/2/62842_0s.jpg)
Android 无障碍全局悬浮窗实现示例
2023-07-30 08:50:01
android TextView中识别多个url并分别点击跳转方法详解
2023-06-21 04:42:32
SpringMVC底层执行流程及原理解析
2022-11-19 03:34:56
![](https://img.aspxhome.com/file/2023/5/62355_0s.png)
你知道在Java中Integer和int的这些区别吗?
2023-09-04 02:50:18
![](https://img.aspxhome.com/file/2023/3/58173_0s.png)
Android中实现根据资源名获取资源ID
2023-06-20 04:18:30
Java安全之Tomcat6 Filter内存马问题
2022-11-20 07:29:23
![](https://img.aspxhome.com/file/2023/7/61027_0s.jpg)
java 引用传递的三种类型小结
2023-09-03 03:59:47
![](https://img.aspxhome.com/file/2023/0/60560_0s.png)
Spring Boot启动过程(四)之Spring Boot内嵌Tomcat启动
2023-09-21 00:16:18
![](https://img.aspxhome.com/file/2023/7/58577_0s.png)
解析Android 8.1平台SystemUI 导航栏加载流程
2023-06-23 15:21:21
java判断http地址是否连通(示例代码)
2023-08-05 03:24:05
JAVA JNI函数的注册过程详细介绍
2023-02-07 18:41:17
springmvc不进入Controller导致404的问题
2023-03-18 01:29:20
![](https://img.aspxhome.com/file/2023/2/62102_0s.png)
浅谈Java中Collections.sort对List排序的两种方法
2021-11-18 11:20:22
Maven实战之搭建Maven私服和镜像的方法(图文)
2023-11-27 22:27:06
![](https://img.aspxhome.com/file/2023/9/60249_0s.png)