Eclipse从0搭建一个springboot

r囧r小猫 2022-02-17 14:27 197阅读 0赞

### 文章目录 ###

*  1. 新建一个maven项目
 *   *  1.1 编写pom.xml文件
 *  2. 编写login登录页面
 *   *  2.1 html代码
     *  2.2. 使用webjars管理静态资源文件(css/js等) - 推荐
     *  2.2. 使用bootstrap(CDN)代替bootstrap.css和js文件
 *  3. 编写一个Controller.java
 *   *  3.1. 写一个LoginController
 *  4. 集成数据库
 *   *  4.1. 集成mybatis
     *   *  4.1.1. 添加相关依赖
         *  4.1.2. 更改application.yml中的配置
         *  4.1.3. 建表
     *  4.2. 用mybatis generator自动生成文件
     *  4.3. 写dao和service,controller,mapper
     *   *  页面userlist.html
     *  在Application.java上加上注解扫描
     *   *  加上分页工具
         *   *  分页-service层
             *  分页-controller层
             *  页面修改
 *  写在最后，推荐参考blog

# 1. 新建一个maven项目 #

## 1.1 编写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.0</modelVersion>
    	<parent>
    		<groupId>org.springframework.boot</groupId>
    		<artifactId>spring-boot-starter-parent</artifactId>
    		<version>1.5.20.RELEASE</version>
    		<relativePath /> 
    	</parent>
    	<groupId>com.extsystem</groupId>
    	<artifactId>ExtSystem</artifactId>
    	<version>0.0.1-SNAPSHOT</version>
    	<name>ExtSystem</name>
    	<description>扩展系统</description>
    
    	<properties>
    		<java.version>1.8</java.version>
    	</properties>
    
    	<dependencies>
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-web</artifactId>
    		</dependency>
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-test</artifactId>
    			<scope>test</scope>
    		</dependency>
    		
    		
    		
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-thymeleaf</artifactId>
    		</dependency>
    
    		
    		
    		
    		
    		
    		
    		
    		
    		
    		
    		
    		
    		
    		
    	</dependencies>
    
    	<build>
    		<plugins>
    			<plugin>
    				<groupId>org.springframework.boot</groupId>
    				<artifactId>spring-boot-maven-plugin</artifactId>
    			</plugin>
    		</plugins>
    	</build>
    
    </project>

# 2. 编写login登录页面 #

## 2.1 html代码 ##

<!DOCTYPE html>
    <html xmlns:th="http://www.thymeleaf.org">
    <head>
    <meta charset="UTF-8" />
    <title>登录</title>
    
    
    
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@3.3.7/dist/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous" />
    
    
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@3.3.7/dist/css/bootstrap-theme.min.css" integrity="sha384-rHyoN1iRsVXV4nD0JutlnGaslCJuC7uwjduW9SVrLvRYooPp2bWYgmgJQIXwl/Sp" crossorigin="anonymous" />
    
    
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@3.3.7/dist/js/bootstrap.min.js" integrity="sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa" crossorigin="anonymous"></script>
    </head>
    <body>
    	<div class="container">
    		<form action="login_in" method="post" class="form-horizontal" role="form">
    			<div class="form-group">
    				<h2 class="col-sm-offset-5 col-sm-4">用户登录</h2>
    			</div>
    			<div class="form-group">
    				<label for="username" class="col-sm-offset-3 col-sm-2 control-label">用户名：</label>
    				<div class="col-sm-3">
    					<input type="text" class="form-control" id="username" name="username" placeholder="请输入用户名" />
    				</div>
    			</div>
    			<div class="form-group">
    				<label for="password" class="col-sm-offset-3 col-sm-2 control-label">密码：</label>
    				<div class="col-sm-3">
    					<input type="text" class="form-control" id="password" name="password" placeholder="请输入密码" />
    				</div>
    			</div>
    			<div class="form-group">
    				<div class="col-sm-offset-5 col-sm-4">
    					<button type="submit" class="btn btn-default">登录</button>
    				</div>
    			</div>
    		</form>
    	</div>
    	
    	
    </body>
    </html>

## 2.2. 使用webjars管理静态资源文件(css/js等) - 推荐 ##

[SpringBoot项目搭建：使用WebJars统一管理静态资源][SpringBoot_WebJars]

## 2.2. 使用bootstrap(CDN)代替bootstrap.css和js文件 ##

Bootstrap 中文网 为 Bootstrap 专门构建了免费的 CDN 加速服务，访问速度更快、加速效果更明显、没有速度和带宽限制、永久免费。BootCDN 还对大量的前端开源工具库提供了 CDN 加速服务。

<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@3.3.7/dist/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">
    
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@3.3.7/dist/css/bootstrap-theme.min.css" integrity="sha384-rHyoN1iRsVXV4nD0JutlnGaslCJuC7uwjduW9SVrLvRYooPp2bWYgmgJQIXwl/Sp" crossorigin="anonymous">
    
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@3.3.7/dist/js/bootstrap.min.js" integrity="sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa" crossorigin="anonymous"></script>

# 3. 编写一个Controller.java #

## 3.1. 写一个LoginController ##

package com.extSystem.Login;
    import java.util.Map;
    import javax.servlet.http.HttpServletRequest;
    import javax.servlet.http.HttpServletResponse;
    import org.springframework.stereotype.Controller;
    import org.springframework.web.bind.annotation.RequestMapping;
    
    @Controller
    @RequestMapping(value = "/login")
    public class LoginController { 
    
    	@RequestMapping("/normalLogin")
    	public String normalLogin() { 
         // 因为引入thympleaf，所以只需要传入字符串自动到templates找相应页面文件
    		return "login";
    	}
    }

# 4. 集成数据库 #

## 4.1. 集成mybatis ##

### 4.1.1. 添加相关依赖 ###

<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>
            </dependency>
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid</artifactId>
                <version>RELEASE</version>
            </dependency>
    		
            <dependency>
                <groupId>com.github.pagehelper</groupId>
                <artifactId>pagehelper-spring-boot-starter</artifactId>
                <version>1.2.3</version>
            </dependency>

### 4.1.2. 更改application.yml中的配置 ###

spring:
      application:
        name: myspringboot
      output:
        ansi:
          enabled: always
      profiles:
        active: dev
      thymeleaf:
        encoding: UTF-8
        prefix: classpath:/templates/
    
    server:
      tomcat:
        uri-encoding: UTF-8
        max-connections: 500
        min-spare-threads: 25
        max-threads: 300
        accept-count: 200
      port: 8080
    mybatis:
      type-aliases-package: com.zb.mapper
      mapper-locations: classpath:mapping/*.xml
    
    pagehelper:
      helper-dialect: mysql
      reasonable: true
      support-methods-arguments: true
      params: count=countSql
    logging:
      level:
        com.zb.mapper: debug
    
    ---
    
    #开发配置
    spring:
      profiles: dev
      datasource:
        url: jdbc:mysql://localhost:3306/zb_db?useUnicode=true&characterEncoding=utf8&autoReconnect=true&failOverReadOnly=false&useSSL=false
        username: root
        password: 123456
        driver-class-name: com.mysql.jdbc.Driver
        type: com.alibaba.druid.pool.DruidDataSource
        filters: stat
        maxActive: 20
        initialSize: 1
        maxWait: 60000
        minIdle: 1
        timeBetweenEvictionRunsMillis: 60000
        minEvictableIdleTimeMillis: 300000
        validationQuery: select 'x'
        testWhileIdle: true
        testOnBorrow: false
        testOnReturn: false
        poolPreparedStatements: true
        maxOpenPreparedStatements: 20

### 4.1.3. 建表 ###

CREATE TABLE `user` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `username` varchar(255) DEFAULT NULL,
      `password` varchar(255) DEFAULT NULL,
      `mobile` varchar(255) DEFAULT NULL,
      `email` varchar(255) DEFAULT NULL,
      `sex` varchar(255) DEFAULT NULL,
      `nickname` varchar(255) DEFAULT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
    
    insert into `user`(id, username, password, mobile, email,sex, nickname) VALUES(1, 'admin', '123456', '13918891675','mmc@163.com', '男', '管理员');
    insert into `user`(id, username, password, mobile, email,sex, nickname) VALUES(2, 'lisi2', '123456', '13918891675','mmc@163.com', 'm', 'lisi1');
    insert into `user`(id, username, password, mobile, email,sex, nickname) VALUES(3, 'lisi3', '123456', '13918891675','mmc@163.com', 'm', 'lisi1');
    insert into `user`(id, username, password, mobile, email,sex, nickname) VALUES(4, 'lisi4', '123456', '13918891675','mmc@163.com', 'm', 'lisi1');
    insert into `user`(id, username, password, mobile, email,sex, nickname) VALUES(5, 'lisi5', '123456', '13918891675','mmc@163.com', 'm', 'lisi1');
    insert into `user`(id, username, password, mobile, email,sex, nickname) VALUES(6, 'lisi6', '123456', '13918891675','mmc@163.com', 'm', 'lisi1');
    insert into `user`(id, username, password, mobile, email,sex, nickname) VALUES(7, 'lisi7', '123456', '13918891675','mmc@163.com', 'm', 'lisi1');
    insert into `user`(id, username, password, mobile, email,sex, nickname) VALUES(8, 'lisi8', '123456', '13918891675','mmc@163.com', 'm', 'lisi1');
    insert into `user`(id, username, password, mobile, email,sex, nickname) VALUES(9, 'lisi9', '123456', '13918891675','mmc@163.com', 'm', 'lisi1');
    insert into `user`(id, username, password, mobile, email,sex, nickname) VALUES(10, 'lisi10', '123456', '13918891675','mmc@163.com', 'm', 'lisi1');
    insert into `user`(id, username, password, mobile, email,sex, nickname) VALUES(11, 'lisi11', '123456', '13918891675','mmc@163.com', 'm', 'lisi1');
    insert into `user`(id, username, password, mobile, email,sex, nickname) VALUES(12, 'lisi12', '123456', '13918891675','mmc@163.com', 'm', 'lisi1');
    insert into `user`(id, username, password, mobile, email,sex, nickname) VALUES(13, 'lisi13', '123456', '13918891675','mmc@163.com', 'm', 'lisi1');
    insert into `user`(id, username, password, mobile, email,sex, nickname) VALUES(14, 'lisi14', '123456', '13918891675','mmc@163.com', 'm', 'lisi1');

## 4.2. 用mybatis generator自动生成文件 ##

参考我的另一篇blog,[Springboot项目搭建：整合Mybatis-generator][Springboot_Mybatis-generator]

## 4.3. 写dao和service,controller,mapper ##

mapper增加了几个方法

@Select("Select * from user")
    List<User> selectAll();
    
    @Select("Select * from user where username = #{username} and password = #{password}")
    User selectByUsernamePass(@Param("username") String username, @Param("password") String password);
    
    @Select("Select * from user where username = #{username}")
    User selectByUsername(@Param("username") String username);

dao和service都是正常调用，下面是controller

package com.zb.controller;
    import com.github.pagehelper.PageInfo;
    import com.zb.model.User;
    import com.zb.service.UserService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Controller;
    import org.springframework.ui.Model;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.RequestMethod;
    import org.springframework.web.bind.annotation.ResponseBody;
    
    @Controller
    public class UserController { 
        @Autowired
        private UserService userService;
    
        @RequestMapping("/user")
        @ResponseBody
        public User getUserById(int id){ 
            User user = userService.selectByPrimaryKey(id);
            return user;
        }
    
        @RequestMapping("/userlist")
        public String getUserList(Model model, PageInfo pageInfo){ 
            int pageNum  = (pageInfo.getPageNum() == 0)? 1 : pageInfo.getPageNum();
            int pageSize  = (pageInfo.getPageSize() == 0)? 10 : pageInfo.getPageSize();
            PageInfo<User> result = userService.selectAll(pageNum, pageSize);
            model.addAttribute("users", result.getList());
            model.addAttribute("pageInfo", result);
            return "userlist";
        }
    
        @RequestMapping("/userdelete")
        public String userdelete(int id){ 
            userService.deleteByPrimaryKey(id);
            return "redirect:/userlist";
        }
    
        @RequestMapping("/useredit")
        public String useredit(int id, Model model){ 
            User user = userService.selectByPrimaryKey(id);
            model.addAttribute("user", user);
            return "useredit";
        }
    
        @RequestMapping(value = "/userupdateoradd", method = RequestMethod.POST)
        public String userUpdateOrAdd(User user){ 
            if(user.getId() == 0){ 
                userService.insertSelective(user);
            } else { 
                userService.updateByPrimaryKeySelective(user);
            }
            return "redirect:/userlist";
        }
    }

### 页面userlist.html ###

<!DOCTYPE html>
    <html xmlns:th="http://www.thymeleaf.org">
    <head>
        <meta charset="UTF-8" />
        <title>用户管理</title>
        <link href="/css/bootstrap.min.css" rel="stylesheet">
    </head>
    <body>
    <div class="container">
        <div>
            <nav class="navbar navbar-default" role="navigation">
                <div class="container-fluid">
                    <div>
                        <ul class="nav navbar-nav" >
                            <li><a href="/userlist">用户管理</a></li>
                            <li><a href="#">书籍管理</a></li>
                        </ul>
                    </div>
                </div>
            </nav>
        </div>
    
        <div>
            <h2>用户管理</h2>
            <table width="100%" border="0" cellpadding="0" cellspacing="0" class="table_list">
                <thead>
                <tr>
                    <th width="20%">编号</th>
                    <th width="20%">用户名</th>
                    <th width="20%">电子邮箱</th>
                    <th width="20%">手机</th>
                    <th width="20%">操作</th>
                </tr>
                </thead>
                <tbody>
                <tr th:each="user:${users}">
                    <td height="40px"><a th:text="${user.id}" data-toggle="modal" data-target="#myModal" onclick="values(this)"></a></td>
                    <td th:text="${user.username}"></td>
                    <td th:text="${user.email}"></td>
                    <td th:text="${user.mobile}"></td>
                    <td><a href="#" class="delete_a" th:value="${user.id}">删除</a></td>
                </tr>
                </tbody>
            </table>
        </div>
    </div>
    <script src="/js/jquery-2.2.1.min.js"></script>
    <script src="/js/bootstrap.min.js"></script>
    </body>
    </html>

## 在Application.java上加上注解扫描 ##

@ComponentScan(basePackages = { "com.zb"})
    @MapperScan("com.zb.mapper")

### 加上分页工具 ###

#### 分页-service层 ####

@Override
    public PageInfo<User> selectAll(int pageNum, int pageSize) {
        PageHelper.startPage(pageNum, pageSize);
        List<User> users = userDao.selectAll();
        PageInfo<User> pageInfo = new PageInfo<>(users);
        return pageInfo;
    }

#### 分页-controller层 ####

public String getUserList(Model model, PageInfo pageInfo){ 
            int pageNum  = (pageInfo.getPageNum() == 0)? 1 : pageInfo.getPageNum();
            int pageSize  = (pageInfo.getPageSize() == 0)? 10 : pageInfo.getPageSize();
            PageInfo<User> result = userService.selectAll(pageNum, pageSize);
            model.addAttribute("users", result.getList());
            model.addAttribute("pageInfo", result);
            return "userlist";
        }

#### 页面修改 ####

此时目录  
此时重启，输入 [http://localhost:8080/userlist][http_localhost_8080_userlist]  
就会看到user列表，也可以分页。

--------------------

# 写在最后，推荐参考blog #

*  参考文章
    
     *  [https://www.cnblogs.com/zhangbin1989/p/9473292.html(推荐)][https_www.cnblogs.com_zhangbin1989_p_9473292.html]
     *  [https://www.cnblogs.com/chendeming/p/8443257.html][https_www.cnblogs.com_chendeming_p_8443257.html]
 *  SpringBoot布道系列 | 目录汇总 | 2019持续更新ing
    
     *  [https://www.jianshu.com/p/964370d9374e][https_www.jianshu.com_p_964370d9374e]
 *  比较好的springboot项目
    
     *  [https://github.com/Foreveriss/SpringBoot/blob/master/microboot-activemq/src/main/java/cn/mldn/microboot/dao/IDeptDAO.java][https_github.com_Foreveriss_SpringBoot_blob_master_microboot-activemq_src_main_java_cn_mldn_microboot_dao_IDeptDAO.java]
     *  [https://github.com/xiaojiang1230/demo2/blob/4b87e5506edd69f19979a18d9a2597b99701f99f/src/main/java/com/example/demo/Demo2Application.java][https_github.com_xiaojiang1230_demo2_blob_4b87e5506edd69f19979a18d9a2597b99701f99f_src_main_java_com_example_demo_Demo2Application.java]
     *  [https://github.com/Foreveriss/SpringBoot/blob/0e66e801f4191e016f653602d3ef1184baa50adc/microboot-activemq/src/main/java/cn/mldn/microboot/service/IDeptService.java][https_github.com_Foreveriss_SpringBoot_blob_0e66e801f4191e016f653602d3ef1184baa50adc_microboot-activemq_src_main_java_cn_mldn_microboot_service_IDeptService.java]
 *  springboot 整合mybatis实现动态sql
    
     *  [http://blog.csdn.net/zhugeyangyang1994/article/details/52045924][http_blog.csdn.net_zhugeyangyang1994_article_details_52045924]
 *  springboot 整合log4j
    
     *  [https://blog.csdn.net/caideb/article/details/81163183][https_blog.csdn.net_caideb_article_details_81163183]
     *  [https://blog.csdn.net/loongshawn/article/details/50951329][https_blog.csdn.net_loongshawn_article_details_50951329]
     *  [https://blog.csdn.net/caoshangfeidie000/article/details/82731715][https_blog.csdn.net_caoshangfeidie000_article_details_82731715]
 *  关于spring boot自动注入出现Consider defining a bean of type ‘xxx’ in your configuration问题解决方案
    
     *  [https://blog.csdn.net/a532672728/article/details/77702772/][https_blog.csdn.net_a532672728_article_details_77702772]

[SpringBoot_WebJars]: https://blog.csdn.net/java_18945106612/article/details/89510423
[Springboot_Mybatis-generator]: https://blog.csdn.net/java_18945106612/article/details/89517488
[http_localhost_8080_userlist]: http://localhost:8080/userlist
[https_www.cnblogs.com_zhangbin1989_p_9473292.html]: https://www.cnblogs.com/zhangbin1989/p/9473292.html%28%E6%8E%A8%E8%8D%90%29
[https_www.cnblogs.com_chendeming_p_8443257.html]: https://www.cnblogs.com/chendeming/p/8443257.html
[https_www.jianshu.com_p_964370d9374e]: https://www.jianshu.com/p/964370d9374e
[https_github.com_Foreveriss_SpringBoot_blob_master_microboot-activemq_src_main_java_cn_mldn_microboot_dao_IDeptDAO.java]: https://github.com/Foreveriss/SpringBoot/blob/master/microboot-activemq/src/main/java/cn/mldn/microboot/dao/IDeptDAO.java
[https_github.com_xiaojiang1230_demo2_blob_4b87e5506edd69f19979a18d9a2597b99701f99f_src_main_java_com_example_demo_Demo2Application.java]: https://github.com/xiaojiang1230/demo2/blob/4b87e5506edd69f19979a18d9a2597b99701f99f/src/main/java/com/example/demo/Demo2Application.java
[https_github.com_Foreveriss_SpringBoot_blob_0e66e801f4191e016f653602d3ef1184baa50adc_microboot-activemq_src_main_java_cn_mldn_microboot_service_IDeptService.java]: https://github.com/Foreveriss/SpringBoot/blob/0e66e801f4191e016f653602d3ef1184baa50adc/microboot-activemq/src/main/java/cn/mldn/microboot/service/IDeptService.java
[http_blog.csdn.net_zhugeyangyang1994_article_details_52045924]: http://blog.csdn.net/zhugeyangyang1994/article/details/52045924
[https_blog.csdn.net_caideb_article_details_81163183]: https://blog.csdn.net/caideb/article/details/81163183
[https_blog.csdn.net_loongshawn_article_details_50951329]: https://blog.csdn.net/loongshawn/article/details/50951329
[https_blog.csdn.net_caoshangfeidie000_article_details_82731715]: https://blog.csdn.net/caoshangfeidie000/article/details/82731715
[https_blog.csdn.net_a532672728_article_details_77702772]: https://blog.csdn.net/a532672728/article/details/77702772/