SpringBoot入门构建Web应用程序

1.1 技术介绍

Spring Boot 是由 Pivotal 团队提供的全新框架，其设计目的是用来简化新 Spring 应用的初始搭建以及开发过程。

1.2 技术注意点

a.springboot生成环境部署，热部署插件不要使用，去除springs-boot-devtools

b.监控相关的jar包去除，

  1. spring-boot-starter-actuator 的监控
  3. druid 的监控
  5. swagger的接口

c.打包一定要跳过测试test

1.3 技术具体demo文件路径

E:\MyJAVA\SpringMakeup

1.4 demo的UML图

1.5 demo的技术代码实现

pom准备
  1. <dependencies>
  2.         <dependency>
  3.             <groupId>org.springframework.boot</groupId>
  4.             <artifactId>spring-boot-starter-web</artifactId>
  5.         </dependency>
  6.         <!-- mybatis -->
  7.         <dependency>
  8.             <groupId>org.mybatis.spring.boot</groupId>
  9.             <artifactId>mybatis-spring-boot-starter</artifactId>
  10.             <version>2.0.0</version>
  11.         </dependency>
  13.         <!-- mysql -->
  14.         <dependency>
  15.             <groupId>mysql</groupId>
  16.             <artifactId>mysql-connector-java</artifactId>
  17.             <version>5.1.21</version>
  18.         </dependency>
  19.         <dependency>
  20.             <groupId>org.springframework.boot</groupId>
  21.             <artifactId>spring-boot-starter-test</artifactId>
  22.             <scope>test</scope>
  23.         </dependency>
  24.         <dependency>
  25.             <groupId>junit</groupId>
  26.             <artifactId>junit</artifactId>
  27.             <version>4.12</version>
  28.         </dependency>
  30.         <!--热部署 -->
  31.         <dependency>
  32.             <groupId>org.springframework.boot</groupId>
  33.             <artifactId>spring-boot-devtools</artifactId>
  34.             <optional>true</optional>
  35.         </dependency>
  36.         <!-- tomcat的支持. -->
  37.         <dependency>
  38.             <groupId>org.apache.tomcat.embed</groupId>
  39.             <artifactId>tomcat-embed-jasper</artifactId>
  40.         </dependency>
  41.         <!--自动生成bean -->
  42.         <dependency>
  43.             <groupId>org.mybatis.generator</groupId>
  44.             <artifactId>mybatis-generator-core</artifactId>
  45.             <version>1.3.6</version>
  46.         </dependency>
  47.         <!-- 对象转换成json引入如下依赖 -->
  48.         <!-- 文档：https://www.yiibai.com/jackson/jackson_first_application.html#article-start -->
  49.         <dependency>
  50.             <groupId>com.fasterxml.jackson.core</groupId>
  51.             <artifactId>jackson-core</artifactId>
  52.             <version>2.9.5</version>
  53.         </dependency>
  54.         <dependency>
  55.             <groupId>com.fasterxml.jackson.core</groupId>
  56.             <artifactId>jackson-databind</artifactId>
  57.             <version>2.9.5</version>
  58.         </dependency>
  59.         <dependency>
  60.             <groupId>com.fasterxml.jackson.core</groupId>
  61.             <artifactId>jackson-annotations</artifactId>
  62.             <version>2.9.5</version>
  63.         </dependency>
  64.         <dependency>
  65.             <groupId>com.fasterxml.jackson.module</groupId>
  66.             <artifactId>jackson-module-jaxb-annotations</artifactId>
  67.             <version>2.9.5</version>
  68.         </dependency>
  70.     </dependencies>
  72.     <build>
  73.         <plugins>
  74.             <plugin>
  75.                 <groupId>org.springframework.boot</groupId>
  76.                 <artifactId>spring-boot-maven-plugin</artifactId>
  77.             </plugin>
  78.             <plugin>
  79.                 <groupId>org.apache.maven.plugins</groupId>
  80.                 <artifactId>maven-surefire-plugin</artifactId>
  81.                 <configuration>
  82.                     <skip>true</skip>
  83.                 </configuration>
  84.             </plugin>
  85.         </plugins>
  86.     </build>

vue编写
  1. <!DOCTYPE html>
  2. <html lang="en" xmlns:v-bind="http://www.w3.org/1999/xhtml" xmlns:v-on="http://www.w3.org/1999/xhtml">
  3. <head>
  4.     <meta charset="UTF-8">
  5.     <title>vue增删改查</title>
  6. </head>
  7. <body>
  8.     <div id="app1">
  9.         <table border="1" cellpadding="0" cellspacing="0">
  10.             <tr>
  11.                 <td colspan="2" align="center">学生基本信息</td>
  12.             </tr>
  13.             <tr>
  14.                 <td>姓名</td>
  15.                 <td>
  16.                     <input v-model="name" style="width:150px" />
  17.                 </td>
  18.             </tr>
  19.             <tr>
  20.                 <td>性别</td>
  21.                 <td>
  22.                     <input type="radio" id="boy" value="男" v-model="sex">
  23.                     <label for="boy">男</label>
  24.                     <input type="radio" id="girl" value="女" v-model="sex">
  25.                     <label for="girl">女</label>
  26.                 </td>
  27.             </tr>
  28.             <tr>
  29.                 <td>年龄</td>
  30.                 <td>
  31.                     <select v-model="age">
  32.                         <option v-for="option in options" v-bind:value="option.value"
  33.                                 :disabled="option.value==0?true:false" :class="{statusbtn:option.value==0}">
  34.                             {{ option.text }}
  35.                         </option>
  36.                     </select>
  37.                 </td>
  38.             </tr>
  39.             <tr>
  40.                 <td>成绩</td>
  41.                 <td>
  42.                     <input v-model.number="score" placeholder="请输入成绩"  style="width:150px"/>
  43.                 </td>
  44.             </tr>
  45.             <tr>
  46.                 <td>兴趣</td>
  47.                 <td>
  48.                     <span v-for="(studentHobby,index) in studentHobbys" >
  49.                         <input type="checkbox" name="interests" v-bind:value="index+1" v-model="checkData">
  50.                         <label>{{ studentHobby.hobby }}</label>
  51.                     </span>
  52.                 </td>
  53.             </tr>
  54.             <tr>
  55.                 <td colspan="2" align="center">
  56.                     <input type="submit" :value="form" @click="submission" v-if="isAdd"/>
  57.                     <input type="submit" :value="form" @click="update" v-else="!isAdd"/>
  58.                     <input type="submit" id="reset" value="重置" v-on:click="resets"/>
  59.                 </td>
  60.             </tr>
  61.         </table>
  64.         <br /><br /><br /><br />
  65.         <table border="1" cellspacing="0" cellpadding="0" id="listTable">
  66.         <tr>
  67.             <td>选中</td>
  68.             <td>姓名</td>
  69.             <td>性别</td>
  70.             <td>年龄</td>
  71.             <td>成绩</td>
  72.             <td>兴趣</td>
  73.             <td>操作</td>
  74.         </tr>
  75.         <tr>
  76.             <td>
  77.                 <label>全选</label>
  78.                 <input type="checkbox" name="item" v-model='checked' v-on:click='checkedAll'/>
  79.             </td>
  80.             <td  colspan="6" align="center">
  81.                 <input type="button" value="选中删除" @click="delRow"/>
  82.             </td>
  83.         </tr>
  84.         <tr v-for="(items,index) in student">
  85.             <td><input type="checkbox" name="item" v-model="checkList" :value="items.id"/>{{1 + index}}</td>
  86.             <td>{{items.name}}</td>
  87.             <td>{{items.sex}}</td>
  88.             <td>{{items.age}}</td>
  89.             <td>{{ items.score }}</td>
  90.             <td><span v-for="item in items.hobby">{{item.hobby}} </span></td>
  91.             <td>
  92.                 <input type="button" value="删除" @click="del(items.id)"/>
  93.                 <input type="button" name="update" value="修改" @click="modify(items)" />
  94.             </td>
  95.         </tr>
  96.         </table>
  97.     </div>
  98.     <style>
  99.         .statusbtn {
  100.             color: #d6caca;
  101.             cursor: not-allowed; /*这个在button上面才管用,是一个禁用的小标识*/
  102.         }
  103.     </style>
  105.     <script src="https://cdn.jsdelivr.net/npm/vue/dist/vue.js"></script>
  106.     <script src="https://cdn.jsdelivr.net/npm/axios@0.12.0/dist/axios.min.js"></script>
  107.     <script src="https://cdn.bootcss.com/qs/6.6.0/qs.min.js"></script>
  109.     <script>
  110.         var app1=new Vue({
  111.             el:'#app1',
  112.             data:{
  113.                 options: [
  114.                     { text: '请选择', value: '0' },
  115.                     { text: '16', value: '16' },
  116.                     { text: '17', value: '17' },
  117.                     { text: '18', value: '18' },
  118.                     { text: '19', value: '19' },
  119.                     { text: '20', value: '20' },
  120.                     { text: '21', value: '21' },
  121.                     { text: '22', value: '22' },
  122.                     { text: '23', value: '23' },
  123.                 ],
  124.                 id:'',
  125.                 name:'',
  126.                 age:'0',
  127.                 sex:'男',
  128.                 score:'',
  129.                 studentHobbys:[],
  130.                 student:[],
  131.                 form:'提交',
  132.                 isAdd: true,
  133.                 checkData: [],//后台请求的数据
  134.                 checked:false,//全选框
  135.                 checkList: []
  136.             },
  137.             watch: { // 监视双向绑定的数据数组
  138.                 'checkList': {
  139.                     handler(val, oldVal){ // 数据数组有变化将触发此函数
  140.                         if (val.length === this.student.length) {
  141.                             this.checked = true;
  142.                         } else {
  143.                             this.checked = false;
  144.                         }
  145.                     },
  146.                     deep: true // 深度监视
  147.                 }
  148.             },
  149.             created: function (){
  150.                 this.getStudent();
  151.                 this.getHobbysAll();
  152.             },
  153.             methods: {
  154.                 getHobbysAll: function(){
  155.                     axios.get('http://localhost:8080/getHobbys')
  156.                         .then(function (response) {
  157.                             var arr = response.data;
  158.                             app1.studentHobbys = arr;
  159.                         })
  160.                         .catch(function (error) {
  162.                         })
  163.                 },
  164.                 getStudent:function () {
  165.                     axios.post('http://localhost:8080/getAll').
  166.                     then(function (response){
  167.                         var arr=response.data;
  168.                         app1.student=arr;
  169.                     }) .catch(function (error) {
  171.                     })
  172.                 },
  173.                 submission:function () {
  174.                     // console.log("选中："+this.checkData);
  175.                     //获取兴趣
  176.                     var selectedValue=this.checkData;
  177.                     axios.get('http://localhost:8080/addStudent?name='+this.name+'&sex='+this.sex+'&age='+
  178.                        this.age+'&score='+this.score+'&hobbys='+selectedValue)
  179.                         .then(function (response) {
  180.                             //更新
  181.                             app1.getStudent();
  182.                             //重置
  183.                             app1.resets();
  184.                         }).catch(function (error) {
  186.                         })
  187.                 },
  188.                 del:function (e) {
  189.                     // console.log(e);
  190.                     axios.get('http://localhost:8080/deleteStudent?studentId='+e)
  191.                         .then(function (response) {
  192.                             app1.getStudent();
  193.                         }).catch(function (error) {
  195.                     })
  196.                 },
  197.                 //选中删除
  198.                 delRow:function(){
  199.                     for(var i=0;i<this.checkList.length;i++){
  200.                         axios.get('http://localhost:8080/deleteStudent?studentId='+this.checkList[i])
  201.                             .then(function (response) {
  202.                                 app1.getStudent();
  203.                             }).catch(function (error) {
  205.                         })
  206.                     }
  207.                 },
  208.                 //修改回显
  209.                 modify:function (items) {
  210.                     //重置
  211.                     app1.resets();
  212.                     //更新按钮
  213.                     app1.form='更新';
  214.                     //回显
  215.                     this.id=items.id;
  216.                     this.name=items.name;
  217.                     this.sex=items.sex;
  218.                     this.age=items.age;
  219.                     this.score=items.score;
  220.                     var arr=[];
  221.                     for(var i=0;i<items.hobby.length;i++){
  222.                         arr.push(items.hobby[i].id);
  223.                     }
  224.                     this.checkData=arr;
  225.                     this.isAdd=false;
  226.                 },
  227.                 update:function(items){
  228.                     axios.get('http://localhost:8080/updateStudent?id='+this.id+'&name='+this.name+'&sex='+this.sex+'&age='+
  229.                         this.age+'&score='+this.score+'&hobbys='+this.checkData)
  230.                         .then(function (response) {
  231.                             app1.getStudent();
  232.                             app1.resets();
  233.                         }).catch(function (error) {
  235.                     })
  236.                 },
  237.                 resets:function () {
  238.                     this.name='',
  239.                     this.sex='男',
  240.                     this.age='0',
  241.                     this.score=''
  242.                     this.checkData=[],
  243.                     this.form='提交',
  244.                     this.isAdd=true
  245.                 },
  246.                 checkedAll: function(){
  247.                     //全选和反选
  248.                     var _this = this;
  249.             // .log(_this.checked+"---"+_this.checkList+"----"+_this.student)
  250.                     this.$nextTick(function() {
  251.                         if(!_this.checked){
  252.                             _this.checkList = _this.student.map(function(json,index){
  253.                                 // console.log(json.id+","+index)
  254.                                 return json.id;
  255.                             })
  256.                         }else {
  257.                             _this.checkList = []
  258.                         }
  259.                     });
  260.                 },
  261.             }
  262.         });
  263.     </script>
  264. </body>
  265. </html>

application.properties配置文件
  1. # 热部署
  2. # 热部署生效
  3. spring.devtools.restart.enabled=true 
  4. # 设置重启目录
  5. spring.devtools.restart.additional-paths=src/main/java 
  7. #mybatis
  8. #mybatis-config.xml xml格式的mybatis配置
  9. #mybatis.configLocation=classpath:mybatis-config.xml
  10. # mybatis的SQL映射路径
  11. #mybatis.mapper-locaitons= classpath*:com/example/mapper/*.xml
  12. mybatis.mapper-locations=classpath:mappers/*.xml
  13. # 扫描package包
  14. mybatis.type-aliases-package=org.lanqiao.model
  15. # 开启驼峰命名转换:Table{create_time} -> Entity{createTime}
  16. mybatis.configuration.mapUnderscoreToCamelCase=true
  17. # 允许返回多个结果集
  18. mybatis.configuration.multipleResultSetsEnabled=true
  19. # 设置自增主键
  20. mybatis.configuration.useGeneratedKeys=true
  21. # 打印sql日志
  22. #mybatis.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl
  23. # 延迟加载总开关
  24. mybatis.configuration.lazyLoadingEnabled=false
  25. # 禁止积极主动的加载
  26. mybatis.configuration.aggressiveLazyLoading=false
  28. spring.datasource.url=jdbc:mysql://localhost:3306/sys?useUnicode=true&characterEncoding=utf8&useSSL=false
  29. spring.datasource.username=root
  30. spring.datasource.password=123
  31. spring.datasource.driver-class-name=com.mysql.jdbc.Driver
  32. spring.datasource.max-idle=10
  33. spring.datasource.max-wait=10000
  34. spring.datasource.min-idle=5
  35. spring.datasource.initial-size=5
  37. spring.mvc.view.prefix=classpath:/static/
  38. spring.mvc.view.suffix=.html
  39. spring.mvc.static-path-pattern=/**

mapper生成接口和xml
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <!DOCTYPE generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
  3.         "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
  4. <!-- 配置生成器 -->
  5. <generatorConfiguration>
  7.     <context id="testTables" targetRuntime="MyBatis3" defaultModelType="flat">
  9.         <property name="beginningDelimiter" value="`"/>
  10.         <property name="endingDelimiter" value="`"/>
  12.         <property name="javaFileEncoding" value="UTF-8"/>
  14.         <!-- 生成注释配置 -->
  15.         <commentGenerator>
  16.             <!-- 是否去除自动生成的注释 true：是 ： false:否 -->
  17.             <property name="suppressAllComments" value="true"/>
  18.             <property name="javaFileEncoding" value="UTF8"/>
  19.             <!--生成的注释包含时间戳(避免重复提交SVN,设为true)-->
  20.             <property name="suppressDate" value="true"/>
  21.         </commentGenerator>
  22.         <!--数据库连接的信息：驱动类、连接地址、用户名、密码 -->
  23.         <!--
  24.         <jdbcConnection driverClass="oracle.jdbc.driver.OracleDriver"
  25.             connectionURL="jdbc:oracle:thin:@150.16.17.22:1521/wsbs" userId="hr"
  26.             password="hr123">
  27.         </jdbcConnection>-->
  28.         <jdbcConnection driverClass="com.mysql.jdbc.Driver"
  29.                         connectionURL="jdbc:mysql://localhost:3306/sys?useUnicode=true&amp;characterEncoding=utf8&amp;useSSL=false"
  30.                         userId="root"
  31.                         password="123">
  32.         </jdbcConnection>
  34.         <!-- 默认false，把JDBC DECIMAL 和 NUMERIC 类型解析为 Integer，为 true时把JDBC DECIMAL 和
  35.             NUMERIC 类型解析为java.math.BigDecimal -->
  36.         <javaTypeResolver>
  37.             <property name="forceBigDecimals" value="false"/>
  38.         </javaTypeResolver>
  40.         <!-- targetProject:生成PO类的位置 -->
  41.         <javaModelGenerator targetPackage="org.lanqiao.model"
  42.                             targetProject="E:/MyJAVA/SpringMakeup/src/main/java">
  43.             <!-- enableSubPackages:是否让schema作为包的后缀 -->
  44.             <property name="enableSubPackages" value="false"/>
  45.             <!-- 从数据库返回的值被清理前后的空格 -->
  46.             <property name="trimStrings" value="true"/>
  47.         </javaModelGenerator>
  48.         <!-- targetProject:mapper.xml映射文件生成的位置 -->
  49.         <sqlMapGenerator targetPackage="mappers"
  50.                          targetProject="E:/MyJAVA/SpringMakeup/src/main/resources">
  51.             <!-- enableSubPackages:是否让schema作为包的后缀 -->
  52.             <property name="enableSubPackages" value="false"/>
  53.         </sqlMapGenerator>
  54.         <!-- targetPackage：mapper.java接口生成的位置 -->
  55.         <javaClientGenerator type="XMLMAPPER"
  56.                              targetPackage="org.lanqiao.mapper"
  57.                              targetProject="E:/MyJAVA/SpringMakeup/src/main/java">
  58.             <!-- enableSubPackages:是否让schema作为包的后缀 -->
  59.             <property name="enableSubPackages" value="false"/>
  60.         </javaClientGenerator>
  63.         <!-- 指定数据库表 -->
  64.         <!--  enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false"
  65.         enableSelectByExample="false" selectByExampleQueryId="false"-->
  66.         <!--不生成example-->
  67.         <!--<table tableName="items"></table> -->
  68.         <table tableName="student" mapperName="StudentMapper" domainObjectName="Student"
  69.                enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false"
  70.                enableSelectByExample="false" selectByExampleQueryId="false">
  71.             <!--下划线转驼峰命名-->
  72.             <property name="useActualColumnNames" value="false"/>
  73.             <!--指定自动生成主键的属性-->
  74.             <generatedKey column="id" sqlStatement="MySql" identity="true"></generatedKey>
  75.             <!--元素从将某些属性默认计算的值更改为指定的值。-->
  76.             <!--<columnOverride  column="message_content" javaType="List&lt;Teacher&gt;"></columnOverride >-->
  77.             <!--忽略字段-->
  78.             <!--<ignoreColumn column="file_id"></ignoreColumn>-->
  79.             <!--<ignoreColumn column="lyric_id"></ignoreColumn>-->
  80.         </table>
  83.     </context>
  84. </generatorConfiguration>

读取生成文件的xml
  1. package org.lanqiao.test;
  3. import org.mybatis.generator.api.MyBatisGenerator;
  4. import org.mybatis.generator.config.Configuration;
  5. import org.mybatis.generator.config.xml.ConfigurationParser;
  6. import org.mybatis.generator.internal.DefaultShellCallback;
  8. import java.io.File;
  9. import java.util.ArrayList;
  10. import java.util.List;
  12. /**
  13.  * @ClassName TestGenerator
  14.  * @Description TODO
  15.  * @Author lisonglin
  16.  * @Date 2018/12/5 17:00
  17.  * @Version 1.0
  18.  */
  19. public class TestGenerator {
  21.     /***
  22.      * 功能描述:
  23.      *  调用generatorConfig.xml
  24.      * @param: []
  25.      * @return: void
  26.      * @auther: 李松林
  27.      * @date: 2018/12/8 19:50
  28.      */
  29.     public void generator(){
  30.         List<String> warnings=new ArrayList<String>();
  31.         //更新数据库时，请修改项目的xml配置绝对路径
  32.         File file=new File("E:\\MyJAVA\\SpringMakeup\\src\\main\\conf\\generatorConfig.xml");
  33.         ConfigurationParser cp = new ConfigurationParser(warnings);
  34.         Configuration config = null;
  35.         try {
  36.             config = cp.parseConfiguration(file);
  37.             DefaultShellCallback shellCallback = new DefaultShellCallback(true);
  38.             MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, shellCallback, warnings);
  39.             myBatisGenerator.generate(null);
  40.             System.out.println(warnings);
  41.         } catch (Exception e) {
  42.             e.printStackTrace();
  43.         }
  44.     }
  46.     /**
  47.      *
  48.      * @param args
  49.      * @throws Exception
  50.      */
  51.     public static void main(String[] args) throws Exception {
  53.         try {
  54.             TestGenerator generatorSqlmap = new TestGenerator();
  55.             generatorSqlmap.generator();
  56.         } catch (Exception e) {
  57.             e.printStackTrace();
  58.         }
  59.     }
  61. }

student的增删改查xml
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  3. <mapper namespace="org.lanqiao.mapper.StudentMapper">
  4.   <resultMap id="BaseResultMap" type="org.lanqiao.model.Student">
  5.     <id column="id"  property="id" />
  6.     <result column="name" jdbcType="VARCHAR" property="name" />
  7.     <result column="sex" jdbcType="VARCHAR" property="sex" />
  8.     <result column="age"  property="age" />
  9.     <result column="score" jdbcType="DOUBLE" property="score" />
  10.   </resultMap>
  11.   <sql id="Base_Column_List">
  12.     id, name, sex, age, score
  13.   </sql>
  14.   <sql id="Base_All">
  15.     select s.id sid,s.`name`,s.sex,s.age,s.score,h.id,h.hobby
  16.     from student s
  17.     join stu_hobby sh
  18.     on s.id=sh.id
  19.     join hobbys h
  20.     on sh.hobby=h.id
  21.   </sql>
  23.   <select id="getAll" resultMap="getStudentAll">
  24.     <include refid="Base_All"></include>
  25.   </select>
  27.   <resultMap id="getStudentAll" type="Student">
  28.     <id column="sid" property="id"></id>
  29.     <result column="name" property="name"></result>
  30.     <result column="sex" property="sex"></result>
  31.     <result column="age" property="age"></result>
  32.     <result column="score" property="score"></result>
  33.     <collection property="hobby" ofType="Hobbys">
  34.       <id column="id" property="id"></id>
  35.       <result column="hobby" property="hobby"></result>
  36.     </collection>
  37.   </resultMap>
  39.   <select id="selectByPrimaryKey" parameterType="java.lang.Integer" resultMap="BaseResultMap">
  40.     select
  41.     <include refid="Base_Column_List" />
  42.     from student
  43.     where id = #{id,jdbcType=INTEGER}
  44.   </select>
  45.   <delete id="deleteByPrimaryKey" parameterType="java.lang.Integer">
  46.     delete from student
  47.     where id = #{id,jdbcType=INTEGER}
  48.   </delete>
  49.   <insert id="insert" parameterType="org.lanqiao.model.Student">
  50.     <selectKey keyProperty="id" order="AFTER" resultType="java.lang.Integer">
  51.       SELECT LAST_INSERT_ID()
  52.     </selectKey>
  53.     insert into student (name, sex, age,
  54.       score)
  55.     values (#{name,jdbcType=VARCHAR}, #{sex,jdbcType=VARCHAR}, #{age,jdbcType=INTEGER},
  56.       #{score,jdbcType=DOUBLE})
  57.   </insert>
  60.   <insert id="insertSelective" parameterType="org.lanqiao.model.Student">
  61.     <selectKey keyProperty="id" order="AFTER" resultType="java.lang.Integer">
  62.       SELECT LAST_INSERT_ID()
  63.     </selectKey>
  64.     insert into student
  65.     <trim prefix="(" suffix=")" suffixOverrides=",">
  66.       <if test="name != null">
  67.         name,
  68.       </if>
  69.       <if test="sex != null">
  70.         sex,
  71.       </if>
  72.       <if test="age != null">
  73.         age,
  74.       </if>
  75.       <if test="score != null">
  76.         score,
  77.       </if>
  78.     </trim>
  79.     <trim prefix="values (" suffix=")" suffixOverrides=",">
  80.       <if test="name != null">
  81.         #{name,jdbcType=VARCHAR},
  82.       </if>
  83.       <if test="sex != null">
  84.         #{sex,jdbcType=VARCHAR},
  85.       </if>
  86.       <if test="age != null">
  87.         #{age,jdbcType=INTEGER},
  88.       </if>
  89.       <if test="score != null">
  90.         #{score,jdbcType=DOUBLE},
  91.       </if>
  92.     </trim>
  93.   </insert>
  95.   <update id="updateByPrimaryKeySelective" parameterType="org.lanqiao.model.Student">
  96.     update student
  97.     <set>
  98.       <if test="name != null">
  99.         name = #{name,jdbcType=VARCHAR},
  100.       </if>
  101.       <if test="sex != null">
  102.         sex = #{sex,jdbcType=VARCHAR},
  103.       </if>
  104.       <if test="age != null">
  105.         age = #{age,jdbcType=INTEGER},
  106.       </if>
  107.       <if test="score != null">
  108.         score = #{score,jdbcType=DOUBLE},
  109.       </if>
  110.     </set>
  111.     where id = #{id,jdbcType=INTEGER}
  112.   </update>
  114.   <update id="updateByPrimaryKey" parameterType="org.lanqiao.model.Student">
  115.     update student
  116.     set name = #{name,jdbcType=VARCHAR},
  117.       sex = #{sex,jdbcType=VARCHAR},
  118.       age = #{age,jdbcType=INTEGER},
  119.       score = #{score,jdbcType=DOUBLE}
  120.     where id = #{id,jdbcType=INTEGER}
  121.   </update>
  122. </mapper>

自己写个兴趣和学生中间表sql
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  3. <mapper namespace="org.lanqiao.mapper.HobbysMapper">
  4.   <select id="getHobbys" resultType="Hobbys">
  5.     select * from hobbys where id = #{id,jdbcType=INTEGER}
  6.   </select>
  8.   <select id="getHobbis" resultType="Hobbys">
  9.     select * from hobbys where id=#{id,jdbcType=INTEGER}
  10.   </select>
  12. </mapper>
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  3. <mapper namespace="org.lanqiao.mapper.StudentHobbysMapper">
  5.     <insert id="insertStudentHobby">
  6.         insert into stu_hobby (id,hobby) values (#{studentId},#{hobbyId})
  7.     </insert>
  9.     <delete id="deleteHobbyIdToStudent">
  10.         delete from stu_hobby where id=#{studentId}
  11.     </delete>
  13. </mapper>

model编写
  1. package org.lanqiao.model;
  3. import java.io.Serializable;
  5. public class Hobbys implements Serializable {
  6.     /**
  7.      * 
  8.      */
  9.     private static final long serialVersionUID = 1L;
  11.     private Integer id;
  13.     /** 兴趣 */
  14.     private String hobby;
  16.     public Integer getId() {
  17.         return id;
  18.     }
  20.     public void setId(Integer id) {
  21.         this.id = id;
  22.     }
  24.     public String getHobby() {
  25.         return hobby;
  26.     }
  28.     public void setHobby(String hobby) {
  29.         this.hobby = hobby == null ? null : hobby.trim();
  30.     }
  32.     @Override
  33.     public String toString() {
  34.         return "Hobbys [id=" + id + ", hobby=" + hobby + "]";
  35.     }
  38. }
  1. package org.lanqiao.model;
  3. import javax.validation.constraints.NotNull;
  4. import java.io.Serializable;
  5. import java.util.List;
  7. public class Student implements Serializable {
  8.     private Integer id;
  10.     @NotNull(message = "姓名不能为空")
  11.     private String name;
  13.     private String sex;
  15.     private Integer age;
  17.     private Double score;
  19.     private List<Hobbys> hobby;
  21.     public Integer getId() {
  22.         return id;
  23.     }
  25.     public void setId(Integer id) {
  26.         this.id = id;
  27.     }
  29.     public String getName() {
  30.         return name;
  31.     }
  33.     public void setName(String name) {
  34.         this.name = name == null ? null : name.trim();
  35.     }
  37.     public String getSex() {
  38.         return sex;
  39.     }
  41.     public void setSex(String sex) {
  42.         this.sex = sex == null ? null : sex.trim();
  43.     }
  45.     public Integer getAge() {
  46.         return age;
  47.     }
  49.     public void setAge(Integer age) {
  50.         this.age = age;
  51.     }
  53.     public Double getScore() {
  54.         return score;
  55.     }
  57.     public void setScore(Double score) {
  58.         this.score = score;
  59.     }
  61.     public List<Hobbys> getHobby() {
  62.         return hobby;
  63.     }
  65.     public void setHobby(List<Hobbys> hobby) {
  66.         this.hobby = hobby;
  67.     }
  69.     @Override
  70.     public String toString() {
  71.         return "Student{" +
  72.                 "id=" + id +
  73.                 ", name='" + name + '\'' +
  74.                 ", sex='" + sex + '\'' +
  75.                 ", age=" + age +
  76.                 ", score=" + score +
  77.                 ", hobby=" + hobby +
  78.                 '}';
  79.     }
  81.     public Student(Integer id, @NotNull(message = "姓名不能为空") String name, List<Hobbys> hobby) {
  82.         super();
  83.         this.id = id;
  84.         this.name = name;
  85.         this.hobby = hobby;
  86.     }
  87. }
  1. package org.lanqiao.model;
  3. /**
  4.  * @ClassName ResponseCode
  5.  * @Description TODO
  6.  * @Author lisonglin
  7.  * @Date 2019/3/31 11:32
  8.  * @Version 1.0
  9.  */
  10. public class ResponseCode {
  11.     private int errcode;
  12.     private String errmsg;
  13.     private Object data;
  15.     public int getErrcode() {
  16.         return errcode;
  17.     }
  19.     public void setErrcode(int errcode) {
  20.         this.errcode = errcode;
  21.     }
  23.     public String getErrmsg() {
  24.         return errmsg;
  25.     }
  27.     public void setErrmsg(String errmsg) {
  28.         this.errmsg = errmsg;
  29.     }
  31.     public Object getData() {
  32.         return data;
  33.     }
  35.     public void setData(Object data) {
  36.         this.data = data;
  37.     }
  39.     public ResponseCode(int errcode, String errmsg, Object data) {
  40.         this.errcode = errcode;
  41.         this.errmsg = errmsg;
  42.         this.data = data;
  43.     }
  45.     public ResponseCode(int errcode, String errmsg) {
  46.         this.errcode = errcode;
  47.         this.errmsg = errmsg;
  48.     }
  50.     public ResponseCode() {
  51.     }
  53.     public ResponseCode(Object data) {
  54.         this.data = data;
  55.     }
  57.     public ResponseCode(int errcode) {
  58.         this.errcode = errcode;
  59.     }
  61.     public static ResponseCode OK(Object data) {
  62.         return new ResponseCode(0, "ok", data);
  63.     }
  65. }

mapper接口生成
  1. package org.lanqiao.mapper;
  3. import org.lanqiao.model.Student;
  4. import org.springframework.stereotype.Component;
  6. import java.util.List;
  8. @Component
  9. public interface StudentMapper {
  11.     List<Student> getAll();
  13.     int deleteByPrimaryKey(Integer id);
  15.     int insert(Student record);
  17.     int insertSelective(Student record);
  19.     Student selectByPrimaryKey(Integer id);
  21.     int updateByPrimaryKeySelective(Student record);
  23.     int updateByPrimaryKey(Student record);
  24. }
  1. package org.lanqiao.mapper;
  3. import org.lanqiao.model.Hobbys;
  4. import org.springframework.stereotype.Component;
  6. import java.util.List;
  8. @Component
  9. public interface HobbysMapper {
  11.     Hobbys getHobbys(Hobbys hobbys );
  13. //    Hobbys getHobbis(Hobbys hobbys );
  14. }
  1. package org.lanqiao.mapper;
  3. import org.apache.ibatis.annotations.Param;
  4. import org.lanqiao.model.Hobbys;
  5. import org.springframework.stereotype.Component;
  7. /**
  8.  * @ClassName StudentHobbysMapper
  9.  * @Description TODO
  10.  * @Author lisonglin
  11.  * @Date 2019/3/30 11:41
  12.  * @Version 1.0
  13.  */
  14. @Component
  15. public interface StudentHobbysMapper {
  17.     void insertStudentHobby(@Param("studentId")Integer studentId,@Param("hobbyId") String hobbyId);
  19.     void deleteHobbyIdToStudent(@Param("studentId") Integer id);
  20. }

dao层编写
  1. @Repository
  2. public class HobbysDao{
  4.     @Autowired
  5.     HobbysMapper hobbysMapper;
  7.     public Hobbys getHobbys(Hobbys hobbys) {
  8.         return hobbysMapper.getHobbys(hobbys);
  9.     }
  11. }
  1. @Repository
  2. public class StudentDao {
  4.     @Autowired
  5.     StudentMapper studentMapper;
  6.     @Autowired
  7.     StudentHobbysMapper studentHobbysMapper;
  9.     public int deleteByPrimaryKey(Integer id){
  10.         studentMapper.deleteByPrimaryKey(id);
  11.         studentHobbysMapper.deleteHobbyIdToStudent(id);
  12.         return 1;
  13.     };
  15.     public int insertStudent(Student student, String hobbys){
  16.         studentMapper.insert(student);
  17.         String regex = ",";
  18.         String[] arr = hobbys.split(regex);
  19.         for(int i=0;i<arr.length;i++){
  20.             studentHobbysMapper.insertStudentHobby(student.getId(),arr[i]);
  21.         }
  22.         return 1;
  23.     };
  25.     public int insertSelective(Student record){
  26.         return studentMapper.insertSelective(record);
  27.     };
  29.     public Student selectByPrimaryKey(Integer id){
  30.         return studentMapper.selectByPrimaryKey(id);
  31.     };
  33.     public int updateByPrimaryKeySelective(Student record){
  34.         return studentMapper.updateByPrimaryKeySelective(record);
  35.     };
  37.     public int updateByPrimaryKey(Student student, String hobbys){
  38.         studentMapper.updateByPrimaryKey(student);
  39.         studentHobbysMapper.deleteHobbyIdToStudent(student.getId());
  40.         String regex = ",";
  41.         String[] arr = hobbys.split(regex);
  42.         for(int i=0;i<arr.length;i++){
  43.             studentHobbysMapper.insertStudentHobby(student.getId(),arr[i]);
  44.         }
  45.         return 1;
  46.     };
  48.     public List<Student> getAll() {
  49.         return studentMapper.getAll();
  50.     }
  52. }

service层编写
  1. @Service
  2. public class HobbysService {
  3.     @Autowired
  4.     HobbysDao hobbysDao;
  6.     public Hobbys getHobbys(Hobbys hobbys){
  7.         return hobbysDao.getHobbys(hobbys);
  8.     }
  10. }
  1. @Service
  2. public class StudentService{
  4.     @Autowired
  5.     StudentDao studentDao;
  7.     public List<Student> getAll() {
  8.         return studentDao.getAll();
  9.     }
  11.     @Transactional(isolation = Isolation.READ_COMMITTED, readOnly = false, rollbackFor = Exception.class)
  12.     public int deleteByPrimaryKey(Integer id){
  13.         return studentDao.deleteByPrimaryKey(id);
  14.     }
  16.     @Transactional(isolation = Isolation.READ_COMMITTED, readOnly = false, rollbackFor = Exception.class)
  17.     public int insert(Student record,String hobbys){
  18.         return studentDao.insertStudent(record,hobbys);
  19.     }
  21.     public int insertSelective(Student record){
  22.         return studentDao.insertSelective(record);
  23.     }
  25.     public Student selectByPrimaryKey(Integer id){
  26.         return studentDao.selectByPrimaryKey(id);
  27.     }
  29.     @Transactional(isolation = Isolation.READ_COMMITTED, readOnly = false, rollbackFor = Exception.class)
  30.     public int updateByPrimaryKeySelective(Student record){
  31.         return studentDao.updateByPrimaryKeySelective(record);
  32.     }
  34.     @Transactional(isolation = Isolation.READ_COMMITTED, readOnly = false, rollbackFor = Exception.class)
  35.     public int updateByPrimaryKey(Student record, String hobbys){
  36.         return studentDao.updateByPrimaryKey(record,hobbys);
  37.     }
  39. }

controller层编写
  1. @Controller
  2. public class MainController {
  4.     @Autowired
  5.     StudentService studentService;
  6.     @Autowired
  7.     HobbysService hobbysService;
  9.     @ResponseBody
  10.     @RequestMapping("/getAll")
  11.     public List<Student> getStudent(){
  12.         List<Student> students = studentService.getAll();
  13.         System.out.println(students);
  14.         return students;
  15.     }
  17.     @ResponseBody
  18.     @RequestMapping(value ="/addStudent")
  19.     public ResponseCode addStudent(@Valid Student student, String hobbys){
  20.         System.out.println(student.toString());
  21.         System.out.println("兴趣是："+hobbys);
  22.         int insert = studentService.insert(student,hobbys);
  23.         return new ResponseCode(insert);
  24.     }
  26.     @ResponseBody
  27.     @RequestMapping(value ="/updateStudent")
  28.     public ResponseCode updateStudent(@Valid Student student,String hobbys){
  29.         System.out.println(student+"兴趣："+hobbys);
  30.         int i = studentService.updateByPrimaryKey(student, hobbys);
  31.         return new ResponseCode(i);
  32.     }
  34.     @ResponseBody
  35.     @RequestMapping(value ="/deleteStudent")
  36.     public ResponseCode deleteStudent(Integer studentId){
  37.         int i = studentService.deleteByPrimaryKey(studentId);
  38.         return new ResponseCode(i);
  39.     }
  41.     @ResponseBody
  42.     @RequestMapping("/getHobbys")
  43.     public List<Hobbys> getHobbys(){
  44.         return hobbysService.getHobbys();
  45.     }
  47.     @RequestMapping("/hello")
  48.     public String hello(){
  49.         return "hello";
  50.     }
  52. }

config层编写

解决跨域请求配置
  1. @Configuration
  2. public class AccessConfig extends WebMvcConfigurationSupport {
  4.     @Override
  5.     public void addCorsMappings(CorsRegistry registry) {
  6.         registry.addMapping("/**")
  7.                 .allowedOrigins("*")
  8.                 .allowedHeaders("*")
  9.                 .allowCredentials(true)
  10.                 .allowedMethods("GET", "POST", "DELETE", "PUT")
  11.                 .maxAge(3600);
  12.     }
  14. }

扫描mapper接口
  1. @Configuration
  2. public class MapperScannerConfig {
  4.     @Bean
  5.     public MapperScannerConfigurer mapperScannerConfigurer() {
  6.         MapperScannerConfigurer mapperScannerConfigurer = new MapperScannerConfigurer();
  7.         //指定xml配置文件的路径
  8.         mapperScannerConfigurer.setBasePackage("org.lanqiao.mapper");
  9.         return mapperScannerConfigurer;
  10.     }
  12. }

1.6 对应博客地址

https://blog.csdn.net/qq_41520636/article/details/88929298

1.7 启动环境

  • JDK1.8
  • IDEA
  • WINDOWS10
  • MAVEN

启动main方法

  1. @SpringBootApplication
  2. @EnableTransactionManagement
  3. @ComponentScan(basePackages = "org.lanqiao.*")
  4. public class DemoApplication {
  6.     public static void main(String[] args) {
  7.         SpringApplication.run(DemoApplication.class, args);
  8.     }
  10. }