springboot+mybaties
2024-10-19 20:26:40
1. 开发工具:Intellij idea2018.3
2. file----->new----->project
3. 选择Spring Initializr,点击next
4. 点击next
5. web中选择web,SQL中选择JAP/MySQL/JDBC,点击next
6. 输入项目名称,选择存储路径,点击finish
7. application.properties配置文件
spring.datasource.url=jdbc:mysql://*********:3306/pmis
spring.datasource.username=root
spring.datasource.password=******
spring.datasource.driverClassName=com.mysql.jdbc.Driver
#页面热加载
spring.thymeleaf.cache=false
server.port=
8. mapper类,需要加注解@Repository
package com.example.mapper; import com.example.model.UserModel;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository; @Repository
public interface UserMapper {
@Select("select * from wx_config where id=#{id}")
UserModel selectById(int id);
}
9. 启动类需要加注解@MapperScan("com.example.mapper"),用来扫描mapper文件,需要注意的是:启动类需要和controller/entity/mapper/service包同级!!!
package com.example; import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication; @MapperScan("com.example.mapper")
@SpringBootApplication
public class DemoApplication { public static void main(String[] args) {
SpringApplication.run(DemoApplication.class, args);
} }
10. 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.</modelVersion>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.0..RELEASE</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<groupId>com.example</groupId>
<artifactId>demo</artifactId>
<version>0.0.-SNAPSHOT</version>
<name>demo</name>
<description>Demo project for Spring Boot</description> <properties>
<project.build.sourceEncoding>UTF-</project.build.sourceEncoding>
<project.reporting.outputEncoding>UTF-</project.reporting.outputEncoding>
<java.version>1.8</java.version>
</properties> <dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency> <dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.</version>
</dependency> <dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.</version>
</dependency> <dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency> <!--<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>-->
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java --> <!--<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.</version>
</dependency>--> </dependencies> <build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
</build> </project>
可能不太完善,后期再改
最新文章
- js下的面向对象
- 【C++实现python字符串函数库】一:分割函数:split、rsplit
- 网易大手笔领投美国VR触觉公司AxonVR
- HDU 5673 Robot ——(卡特兰数)
- linux基本命令--学习记录
- UVa11526 H(n)
- (转)ecshop刷新页面出现power by ecshop和链接的解决办法
- WCF—Binding
- 动态创建ImageView
- es6基础知识
- PowerBI分析Exchange服務器IIS運行日誌
- Centos7 编译安装 Nginx PHP Mariadb Memcache扩展 ZendOpcache扩展 (实测 笔记 Centos 7.0 + Mariadb 10.1.9 + Nginx 1.9.9 + PHP 5.5.30)
- 数位dp 模板
- centos6.9 忘记密码解决方法
- Redis高可用详解:持久化技术及方案选择
- 转 [PHP] - 性能加速 - 开启Opcache
- Oozie 生成JMS消息并向 JMS Provider发送消息过程分析
- C# .Net 多进程同步 通信 共享内存 内存映射文件 Memory Mapped
- 赋值操作符、复制构造函数、析构函数、static成员练习
- 设计模式之开放-封闭原则(引申出Objective-C中继承、Category、Protocol三者的区别,这点面试常问)