前言
Spring boot + Mybatis + Thymeleaf + Druid +mySql
JDK版本 ：1.8及以上 （JDK１.８）；
開發工具 ：Intellij IDEA （IDEA２０１８.２）；
服務器 ：Tomcat(務必比JDK版本高，小編不在解釋（Jar包不用配置、War需要配置）) （Tomcat９） ；
JRE包 ：Maven倉庫 （Maven３.６）；
數據庫 ：MySql（MySql５.５） ；
正題
Spring boot ：2.１.１RELEASE ；
Thymeleaf
Mybatis
阿里雲的連接池 : Druid ；
步驟
１．創建Springboot：
２．創建項目文件結構
３.POM依賴
如果使用阿里雲的連接池不選擇JDBC，小編用的阿里雲這裡不選擇
點擊Finish；
注：可能Maven中無Jar包需要從倉庫下載，需要耐心等待（可以去聽首歌）
４.項目結構
５.POM
<project>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>
<parent>
<groupid>org.springframework.boot/<groupid>
<artifactid>spring-boot-starter-parent/<artifactid>
<version>2.1.1.RELEASE/<version>
<relativepath>
/<parent>
<groupid>com.spring/<groupid>
<artifactid>boot/<artifactid>
<version>0.0.1-SNAPSHOT/<version>
<name>boot/<name>
<description>Demo project for Spring Boot/<description>
<properties>
<java.version>1.8/<java.version>
/<properties>
<dependencies>
<dependency>
<groupid>org.springframework.boot/<groupid>
<artifactid>spring-boot-devtools/<artifactid>
<optional>true/<optional>
/<dependency>
<dependency>
<groupid>com.alibaba/<groupid>
<artifactid>druid-spring-boot-starter/<artifactid>
<version>1.1.10/<version>
/<dependency>
<dependency>
<groupid>org.springframework.boot/<groupid>
<artifactid>spring-boot-starter-thymeleaf/<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.2/<version>
/<dependency>
<dependency>
<groupid>mysql/<groupid>
<artifactid>mysql-connector-java/<artifactid>
<scope>runtime/<scope>
/<dependency>
<dependency>
<groupid>org.springframework.boot/<groupid>
<artifactid>spring-boot-starter-test/<artifactid>
<scope>test/<scope>
/<dependency>
/<dependencies>
<build>
<plugins>
<plugin>
<groupid>org.springframework.boot/<groupid>
<artifactid>spring-boot-maven-plugin/<artifactid>
/<plugin>
/<plugins>
/<build>
/<project>
注：IDEA失效解決方法
６.小編使用的application.properties文件，項目啟動識別兩種格式的文件properties和yml文件：
#緩存設置為false, 修改之後馬上生效
spring.thymeleaf.cache=false
spring.thymeleaf.encoding=UTF-8
#spring.thymeleaf.prefix=classpath:/templates/
#spring.thymeleaf.suffix=.html
server.port=8080
server.tomcat.uriEncoding=utf-8
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.url=jdbc:mysql://localhost:3306/web?useUnicode=true&serverTimezone=GMT%2B8&characterEncoding=utf-8&allowMultiQueries=true&useSSL=false
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.druid.driverClassName=com.mysql.cj.jdbc.Driver
#初始化連接
spring.datasource.initialSize=20
#最大空閒數
spring.datasource.maxActive=50
#最小空閒數
spring.datasource.minIdle=10
#獲取連接等待時間
#spring.datasource.druid.max-wait=60000
#最小等待時間
#spring.datasource.minEvictableIdleTimeMillis=3600000
7.其他文件生成
User.java
package com.spring.boot.bean;
public class User {
public Integer uid;
public String uname;
public String upassword;
public Integer getUid() {
return uid;
}
public void setUid(Integer uid) {
this.uid = uid;
}
public String getUanme() {
return uname;
}
public void setUanme(String uanme) {
this.uname = uanme;
}
public String getUpassword() {
return upassword;
}
public void setUpassword(String upassword) {
this.upassword = upassword;
}
@Override
public String toString() {
return "User{" +
"uid=" + uid +
", uname='" + uname + '\'' +
", upassword='" + upassword + '\'' +
'}';
}
}
UserDao.java
package com.spring.boot.dao;
import com.spring.boot.bean.User;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;
import java.util.List;
public interface UserDao {
@Select("select * from user")
public List<user> AllUser();
@Update(" ")
public int Update(User user);
}
/<user>
UserService.java
package com.spring.boot.service;
import com.spring.boot.bean.User;
import java.util.List;
public interface UserService {
public List<user> AllUser();
public int Update(User user);
}
/<user>
UserImpl.java
主要是註解問題Service可以命名，主要還是看自己的日常使用
package com.spring.boot.service.impl;
import com.spring.boot.bean.User;
import com.spring.boot.dao.UserDao;
import com.spring.boot.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
@Service
public class UserImpl implements UserService {
@Autowired
private UserDao userDao;
@Override
public List<user> AllUser() {
return userDao.AllUser();
}
@Override
public int Update(User user) {
return userDao.Update(user);
}
}
/<user>
注：userDao報紅解決方法
UserController.java
package com.spring.boot.controller;
import com.spring.boot.bean.User;
import com.spring.boot.service.impl.UserImpl;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
@Controller
public class UserController {
@Autowired
private UserImpl userimpl;
@RequestMapping("/index")
public String index(Model model, User user){
model.addAttribute("user",userimpl.AllUser());
user.uid = 2;
user.uname = "nan";
user.upassword = "lou";
userimpl.Update(user);
System.out.println("******************"+userimpl.AllUser());
System.out.println("******************"+userimpl.Update(user));
return "index";
}
}
index.html
<title>Title/<title>
Spring boot+Thymeleaf!
8.界面顯示
分享到:
閱讀更多 JAVA架構進階 的文章
