从spring boot到spring cloud（三）springmvc+spring+mybatis

墨蓝 2022-11-30 01:33 116阅读 0赞

本章先用非微服务的方式搭建一个本地springmvc+spring+mybatis，然后再分解成微服务。  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3RlcnJ5NzEx_size_16_color_FFFFFF_t_70_pic_center]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3RlcnJ5NzEx_size_16_color_FFFFFF_t_70_pic_center 1]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3RlcnJ5NzEx_size_16_color_FFFFFF_t_70_pic_center 2]  
选择springmvc+mybatis+mysql驱动。

mybatis的建表和生成对象这里就不说了看一查看以前的

[在eclipse中使用MyBatisGenerator生成MyBatis实体类][eclipse_MyBatisGenerator_MyBatis]

![在这里插入图片描述][20201102092249621.png_pic_center]  
生成以后产生相应的目录  
mapping xml存放目录  
entity 数据库bean对象存放目录  
dao dao层存放目录

server:
      port: 8082
     
    spring:
      datasource:
        username: root
        password: ******
        url: jdbc:mysql://139.*.*.*:3306/zskxt?zeroDateTimeBehavior=CONVERT_TO_NULL&serverTimezone=UTC&characterEncoding=utf8
        driver-class-name: com.mysql.cj.jdbc.Driver
        type: com.alibaba.druid.pool.DruidDataSource
        druid:
          # 下面为连接池的补充设置，应用到上面所有数据源中
          # 初始化大小，最小，最大
          initial-size: 5
          min-idle: 5
          max-active: 1000
          # 配置获取连接等待超时的时间
          max-wait: 600000
          # 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒
          time-between-eviction-runs-millis: 60000
          # 配置一个连接在池中最小生存的时间，单位是毫秒
          min-evictable-idle-time-millis: 300000
          validation-query: SELECT 1 FROM DUAL
          test-while-idle: true
          test-on-borrow: false
          test-on-return: false
          # 打开PSCache，并且指定每个连接上PSCache的大小
          pool-prepared-statements: true
          #   配置监控统计拦截的filters，去掉后监控界面sql无法统计，'wall'用于防火墙
          max-pool-prepared-statement-per-connection-size: 20
          filters: stat,wall
          use-global-data-source-stat: true
          # 通过connectProperties属性来打开mergeSql功能；慢SQL记录
          connect-properties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=50000
          validationQuery: SELECT 'x'
                      
    mybatis:
      mapper-locations: classpath:com/zskwebxt/mapping/*.xml
     
    #showSql
    logging:
      level:
        com:
          example:
            mapper : debug

mapper-locations: classpath:com/zskwebxt/mapping/\*.xml 配置成xml存放目录

运行

import org.mybatis.spring.annotation.MapperScan;
    import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.SpringBootApplication;
    import org.springframework.context.annotation.Bean;
    import org.springframework.context.annotation.ComponentScan;
    import org.springframework.scheduling.annotation.EnableAsync;
    import org.springframework.scheduling.concurrent.ThreadPoolTaskExecutor;
    import org.springframework.web.servlet.config.annotation.CorsRegistry;
    import org.springframework.web.servlet.config.annotation.WebMvcConfigurer;
    
    @ComponentScan(basePackages={ "com.zskwebxt.*"})  //spring扫描的控制层
    @SpringBootApplication
    @EnableAsync
    @MapperScan("com.zskwebxt.dao") //dao层存放空间
    public class ZskwebxtApplication implements WebMvcConfigurer{ 
    
    	public static void main(String[] args) { 
    		SpringApplication.run(ZskwebxtApplication.class, args);
    	}
    	
    	//跨域 
    	@Override
        public void addCorsMappings(CorsRegistry registry) { 
            registry.addMapping("/**")
            .allowedOrigins("*")
            .allowedMethods("*") //.allowedMethods("PUT", "DELETE","POST","GET")
            .allowedHeaders("*").maxAge(3600);
        }
    }

控制层代码

@RestController
    @RequestMapping("/getss")
    public class ssController { 
    
    	@Autowired
    	private zsk_book_smMapper zsk_book_smMapper;  //注入dao层对象
    
    	@RequestMapping("/sousuo")  //请求名称
    	@ResponseBody
    	public Returnben sousuo(HttpServletRequest request, HttpSession session,@RequestBody Map<String, Object> json) { 
    		Returnben returnben = new Returnben();
    		String bookname = json.get("bookname").toString();
    		List<zsk_book_sm> m=zsk_book_smMapper.selectbysousuo(bookname);
    		returnben.setObj(m);
    		returnben.setMsg("成功");
    		returnben.setSuccess("0");
    		return returnben;
    	}
    }

ajax请求  
需要引用

以上就是简单的 springmvc+spring+mybatis 有什么问题可以私信，后续建立分布式和集群微服务。

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3RlcnJ5NzEx_size_16_color_FFFFFF_t_70_pic_center]: /images/20221124/1c6d2ec1105846678ca08b5854ada982.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3RlcnJ5NzEx_size_16_color_FFFFFF_t_70_pic_center 1]: /images/20221124/3aeaa358483c47febc0c577a463aea1e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3RlcnJ5NzEx_size_16_color_FFFFFF_t_70_pic_center 2]: /images/20221124/17b9691d034442619315ebe18bbf19ac.png
[eclipse_MyBatisGenerator_MyBatis]: https://blog.csdn.net/terry711/article/details/105385875
[20201102092249621.png_pic_center]: /images/20221124/074536ad1c7c43e9951baf55a320b0f4.png