目录
先放一下文件的位置给你们看一下,这是我跟着学mybatis时建的一部分内容,我懒得再新建一个,凑合看吧,很多东西我这一节里不会写。
一、首先在数据库中新建user表
具体内容是啥你们自己看着来
二、创建一个工程
1、文件——新建——模块
2、点下一个
3、输入内容
4、 模块名可以更改,内容根和模块文件位置你可以放到你想放到的地方,这样我们的模块就完成了。
三、在pom.xml中添加依赖
复制就完事
<dependencies>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.20</version>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.3</version>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.16.18</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>dev.tuxjsql</groupId>
<artifactId>hikaricp-cp</artifactId>
<version>2.1</version>
</dependency>
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.12</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-nop</artifactId>
<version>1.7.30</version>
</dependency>
<dependency>
<groupId>org.apache.logging.log4j</groupId>
<artifactId>log4j-to-slf4j</artifactId>
<version>2.13.3</version>
</dependency>
<dependency>
<groupId>net.sf.ehcache</groupId>
<artifactId>ehcache</artifactId>
<version>2.10.3</version>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<version>3.8.1</version>
<configuration>
<target>1.8</target>
<source>1.8</source>
<encoding>utf-8</encoding>
</configuration>
</plugin>
</plugins>
<resources>
<resource>
<directory>src/main/java</directory>
<includes>
<include>**/*.properties</include>
<include>**/*.xml</include>
</includes>
<filtering>false</filtering>
</resource>
<resource>
<directory>src/main/resources</directory>
<includes> <include>**/*.properties</include>
<include>**/*.xml</include>
</includes>
<filtering>false</filtering>
</resource>
</resources>
</build>
五、编写mybatis核心配置文件
1、在resources下面新建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>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="cn.itnanls.datasource.HikariDataSource">
<property name="driverClassName" value="${driver}"/>
<property name="jdbcUrl" value="${url}" />
<property name="username" value="${username}"/>
<property name="password" value="${password}"/>
</dataSource>
</environment>
</environments>
</configuration>
2、在resources下面新建db.properties
driver=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://localhost:3306/ssm? useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=Asia/Shanghai
username=root
password=123456
3、新建数据源,在java下新建cn.itnanls.datasource.HikariDataSource
public class HikariDataSource implements DataSourceFactory {
private Properties properties;
@Override
public void setProperties(Properties properties) {
this.properties = properties;
}
@Override
public DataSource getDataSource() {
HikariConfig hikariConfig = new HikariConfig(properties);
return new com.zaxxer.hikari.HikariDataSource(hikariConfig);
}
}
六、编写实体类
我用了lombok插件,你们可以在文件——设置——插件里面下载,有了这个插件就不用再写getter,setter和构造参数了,只需要写上几个注解
这个还要引入依赖的,但我前面给的依赖里有,就可以忽略掉
Data表示getter和setter AllArgsConstructor表示含有左右参数的构造函数 NoArgsConstructor表示空造
@Data
@AllArgsConstructor
@NoArgsConstructor
public class User implements Serializable {
private Integer id;
private String username;
private String password;
}
如此,我们的环境就搭建成功了。
下接:
Mybatis的增删改查https://blog.csdn.net/wenqi1/article/details/120944084