一起学习Spring boot 2.1.X | 第五篇：Mybatis Druid 数据库(注解版)

天会晴人会暖

运转展现

正题

Spring boot ：2.１.5RELEASE ；数据库（Mysql、Oracle）；Mybatis；阿里云的毗邻池 : Druid ；
步调

１．POM依靠

1. <!-- MyBatis -->
2. <dependency>
3.     <groupId>org.mybatis.spring.boot</groupId>
4.     <artifactId>mybatis-spring-boot-starter</artifactId>
5.     <version>1.3.2</version>
6. </dependency>
8. <!-- MySQL -->
9. <dependency>
10.     <groupId>mysql</groupId>
11.     <artifactId>mysql-connector-java</artifactId>
12. </dependency>
14. <!-- Oracle -->
15. <!--<dependency>
16.         <groupId>com.oracle</groupId>
17.         <artifactId>ojdbc14</artifactId>
18.         <version>10.2.0.4.0</version>
19. /dependency>-->
21. <!-- Druid -->
22. <dependency>
23.     <groupId>com.alibaba</groupId>
24.     <artifactId>druid</artifactId>
25.     <version>1.1.16</version>
26. </dependency>

复造代码

 
２．application.properties

1. #Mybatis+MySQL+Druid
2. #Mysql时区非常URL后增加serverTimezone=GMT%2B8/毗连池:typr/初初化毗连:initialSize/最年夜闲暇数:maxActive/最小闲暇数:minIdle/获得毗连等候工夫:maxWait/最小等候工夫:minEvictableIdleTimeMillis/封闭后没有主动提交:defaultAutoCommit
3. spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
4. spring.datasource.url=jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&serverTimezone=GMT%2B8&characterEncoding=utf-8&allowMultiQueries=true&useSSL=false
5. #spring.datasource.url=jdbc:oracle:thin:@127.0.0.1:1521:test
6. spring.datasource.username=root
7. spring.datasource.password=root
8. spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver
10. # 初初化巨细，最小，最年夜
11. spring.datasource.initialSize=5
12. spring.datasource.minIdle=5
13. spring.datasource.maxActive=20
14. # 设置获得毗连等候超时的工夫
15. spring.datasource.maxWait=60000
16. # 设置距离多暂才停止一次检测，检测需求封闭的闲暇毗连，单元是毫秒
17. spring.datasource.timeBetweenEvictionRunsMillis=60000
18. # 设置一个毗连正在池中最小保存的工夫，单元是毫秒
19. spring.datasource.minEvictableIdleTimeMillis=300000
20. spring.datasource.validationQuery=SELECT 1 FROM DUAL
21. spring.datasource.testWhileIdle=true
22. spring.datasource.testOnBorrow=false
23. spring.datasource.testOnReturn=false
24. # 翻开PSCache，而且指定每一个毗连上PSCache的巨细
25. spring.datasource.poolPreparedStatements=true
26. spring.datasource.maxPoolPreparedStatementPerConnectionSize=20
27. # 设置监控统计阻拦的filters，来失落后监控界里sql没法统计，&#39;wall&#39;用于防水墙
28. spring.datasource.filters=stat,wall,log4j
29. # 经由过程connectProperties属性去翻开mergeSql功用；缓SQL记载
30. spring.datasource.connectionProperties=druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
31. # 兼并多个DruidDataSource的监控数据
32. #spring.datasource.useGlobalDataSourceStat=true
34. spring.datasource.defaultAutoCommit=false

复造代码

 
3.其他文件天生
User.java

1. public class User {
3.     public Integer uid;
4.     public String uname;
5.     public String upassword;
7.     public Integer getUid() {
8.         return uid;
9.     }
11.     public void setUid(Integer uid) {
12.         this.uid = uid;
13.     }
15.     public String getUanme() {
16.         return uname;
17.     }
19.     public void setUanme(String uanme) {
20.         this.uname = uanme;
21.     }
23.     public String getUpassword() {
24.         return upassword;
25.     }
27.     public void setUpassword(String upassword) {
28.         this.upassword = upassword;
29.     }
31.     @Override
32.     public String toString() {
33.         return "User{" +
34.                 "uid=" + uid +
35.                 ", uname=&#39;" + uname + &#39;\&#39;&#39; +
36.                 ", upassword=&#39;" + upassword + &#39;\&#39;&#39; +
37.                 &#39;}&#39;;
38.     }
39. }

复造代码

UserDao.java

1. import com.spring.boot.bean.User;
2. import org.apache.ibatis.annotations.Select;
3. import org.apache.ibatis.annotations.Update;
5. import java.util.List;
7. @Mapper
8. public interface UserDao {
10.     @Select("select * from user")
11.     public List<User> AllUser();
13.     @Update("<script> " + "update user" +
14.             "<set>"+  "<if test=&#39;uname!=null&#39;>uname=#{uname},</if>"+
15.             "<if test=&#39;upassword!=null&#39;>upassword=#{upassword},</if>"+
16.             "</set>"+ "where uid=#{uid}"+
17.             " </script> ")
18.     public int Update(User user);
20. }

复造代码

UserService.java

1. import com.spring.boot.bean.User;
2. import java.util.List;
4. public interface UserService {
6.     public List<User> AllUser();
8.     public int Update(User user);
10. }

复造代码

 
UserImpl.java
次要是注解成绩Service能够定名，次要依旧看本人的一样平常利用

1. import com.spring.boot.bean.User;
2. import com.spring.boot.dao.UserDao;
3. import com.spring.boot.service.UserService;
4. import org.springframework.beans.factory.annotation.Autowired;
5. import org.springframework.stereotype.Service;
7. import java.util.List;
9. @Service
10. public class UserImpl implements UserService {
12.     @Autowired
13.     private UserDao userDao;
15.     @Override
16.     public List<User> AllUser() {
18.         return userDao.AllUser();
19.     }
21.     @Override
22.     public int Update(User user) {
23.         return userDao.Update(user);
24.     }
25. }

复造代码

UserController.java
 

1. import com.spring.boot.bean.User;
2. import com.spring.boot.service.impl.UserImpl;
3. import org.springframework.beans.factory.annotation.Autowired;
4. import org.springframework.stereotype.Controller;
5. import org.springframework.ui.Model;
6. import org.springframework.web.bind.annotation.RequestMapping;
7. import javax.servlet.http.HttpServletRequest;
9. @RestController
10. public class UserController {
12.     @Autowired
13.     private  HttpServletRequest request;
15.     @Autowired
16.     private UserImpl userimpl;
18.      @RequestMapping("/api/login")
19.     public String Login(User user) {
21.         HttpSession session = request.getSession();
23.         //存进Session
24.         //session.setAttribute("user", user);
25.         //单元为秒，设置为-1时没有再生效
26.         //session.setMaxInactiveInterval(60 * 60 * 24 * 30);
27.         //登记登岸
28.         //request.getSession().removeAttribute("user");
30.         return userimpl.UserAll(user).toString();
31.     }
32. }

复造代码

 
注：userDao报白处理办法

 
注：启动类参加注解@MapperScan("途径)
小编那是Java web项目，@Controller注解是界里、@RestController是写接心

免责声明：假如进犯了您的权益，请联络站少，我们会实时删除侵权内乱容，感谢协作！