springboot项目--谷粒商城
[TOC]
第一天 搭建项目
一、项目介绍及基本配置
1.项目介绍
2.安装mysql
安装mysql服务端 参考文档
- 找到mysql的安装目录,cd(注意这里需要是管理员权限)到bin目录下,执行mysqld -install
- 打开mysql服务:管理--服务中找到mysql服务启动
安装mysql客户端
- mysql的Navicat 配置链接属性,用户名密码即可
3.安装jdk8
- java_home
- class_path
- path
4.配置IJ
- 新建project工程,这里的project 类似于ecliipse中的workspace
| project >| moudule
| workspace >| project
- 两项基本配置
---- 由于project相当于工作空间,一个新的工作空间需要配置maven以及jdk版本
- 配置Maven
File->setting->搜索maven(配置setting.xml)
注意:默认的maven是在c盘下的.m2文件夹下,可以通过配置xml来改变需要下载的respository文件夹(默认是被注释的)
~~~xml d:/.m2/respository CN OSChina Central http://maven.aliyun.com/nexus/content/groups/public/ central ~~~ - 配置project_structure
springboot要求jsk8及以上
File->Project Structure->Project SDK
5.Git & GitHub
对一个新的项目(project),此项目由GitHub上创建,然后在IJ上拉下来
File-> new -> project from version controller-> Git
只有是从git上拉取下来的项目,在右键菜单里才有Git选项
- 如图上,先add,然后再commit Directory,如下图
注意:一些本地配置文件不要提交**
- push到GitHub
6.IJ快捷键
- 自动引包: alt+enter
- 接收返回值:ctrl+alt+v 类似于 eclipse中的ctrl+2 ->L
- 复制行:ctrl+d
- 删除行:ctrl+y
- 上/下一个位置 :ctrl+alter+左/右
- 全文搜索:双击shift
- foreach :iter
- 删除一个moudle:右键-->remove Moudle -->delete
- 格式化:ctrl+alt+L
- 拷贝类的namespace:类名右键-->copy Reference
- 自动导包-->setting-->搜索auto--->Auto Import-->Add unambigous imports on the fly
- 关闭autoWird注解检查-->setting-->搜索inspect-->inspections-->右侧搜索-->autowiring-->autowiring for Bean Class 取消勾选
- ctrl+E: 打开历史浏览
- F8 逐步进入,F9跳过断点
- ctrl+alt+v 自动补全返回值
二、test spingboot项目
- 新建一个test Moudule,测试
项目Project右键-->new Moudule-->Spring initializr-->next->
填写项目信息->next->
Depandencies->web->spring Web ->next->finished
由于我们选择的是springboot项目,自动下载项目相关的依赖
pom.xml:
~~~java org.springframework.boot spring-boot-starter-web ~~~
- 新建Controller
~~~ java @Controller public class TestUpload { @ResponseBody @RequestMapping("/test.html") public String testController(){ return "hello"; } } ~~~
- 启动,默认端口8080
- 访问http://localhost:8080/test.html, 返回hello
三、新建user项目
1.新建一个moudle
- 右键 new -->moudle
- 选择dependences(依赖)
web
-->spring web
sql
-->JDBC API
-->Mybatis Framwork
-->MySql Driver
2.项目搭建
~~~properties # 服务端口 server.port=8080 # jdbc spring.datasource.password=123456 spring.datasource.username=root spring.datasource.url=jdbc:mysql://localhost:3306/gmall_study?characterEncoding=UTF-8 # mybtais配置 mybatis.mapper-locations=classpath:mapper/*Mapper.xml mybatis.configuration.map-underscore-to-camel-case=true ~~~
a.表的映射类:bean
由于:mybatis.configuration.map-underscore-to-camel-case=true
不需要@Column(name="create_time")
b.userMapper.xml
~~~xml <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> select * from UmsMember u ~~~
c.备注:IDEA的mysql插件
右侧-->Database-->【+】-->dataSource-->mysql
~~~ java @MapperScan(basePackages = {"com.atguigu.gmalluser.mapper"}) ~~~
~~~ xx ~~~
方案:加serverTimezone=UTC
~~~ properties spring.datasource.url=jdbc:mysql://localhost:3306/gmall_test?characterEncoding=utf8&useSSL=false&serverTimezone=UTC ~~~
- 错误:mapper里写的数据库表名为sql,不是hql
~~~ select * from ums_member ~~~
3.加入通用mapper(tkMapper)
- 引包
~~~ xml tk.mybatis mapper-spring-boot-starter 1.2.3 org.springframework.boot spring-boot-starter-jdbc ~~~
- 修改bean
~~~java @Id @GeneratedValue(strategy = GenerationType.IDENTITY) ~~~
- 修改xxxMapper继承TkMapper
public interface UserMapper extends Mapper<UmsMember>
- 配置启动类扫描器MapperScan,使用通用mapper的tk……..MapperScan
tk.mybatis.spring.annotation.MapperScan
- 启动报错:
~~~java java.lang.RuntimeException: java.lang.reflect.InvocationTargetException at tk.mybatis.spring.mapper.SpringBootBindUtil$SpringBoot2Bind.bind(SpringBootBindUtil.java:129) ~[mapper-spring-boot-autoconfigure-1.2.3.jar:na] ..... ~~~
在application.xml里加入mapper.identity=MYSQL,有可能是高版本的springboot 支持不只一种数据库,这里要指定查看博客
- tkMapper扩展:
~~~ java //1拼装model类 UmsMemberReceiveAddress umsMemberReceiveAddress = new UmsMemberReceiveAddress(); umsMemberReceiveAddress.setMemberId(userId); List umsMemberReceiveAddresses = umsMemberReceiveAddressMapper.select(umsMemberReceiveAddress); //2example Example example = new Example(UmsMemberReceiveAddress.class); example.createCriteria().andEqualTo("memberId",userId); List umsMemberReceiveAddresses = umsMemberReceiveAddressMapper.selectByExample(example); ~~~
7.可以打开log看sql语句打印
~~~ properties logging.level.root =debug ~~~
第二天 修改架构
一、SOA 架构
1.设计原理
a 什么叫前后端分离?
b 抽取gmalll-parent父依赖(maven工程)
- 新建其他项目模块(子项目)的时候,继承自gmalll-parent
- 在gmall-parent中定义好项目的技术框架各种版本
- 如确定springboot的版本
- ==只是对版本进行管理,不会实际引入jar==
- ==//会实际下载jar包==
<?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.21.RELEASE</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<groupId>com.atguigu.gmall</groupId>
<artifactId>gmall-parent</artifactId>
<version>1.0-SNAPSHOT</version>
<packaging>pom</packaging>
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
<java.version>1.8</java.version>
<fastjson.version>1.2.46</fastjson.version>
<dubbo-starter.version>1.0.10</dubbo-starter.version>
<dubbo.version>2.6.0</dubbo.version>
<zkclient.version>0.10</zkclient.version>
<mybatis.version>1.3.1</mybatis.version>
<nekohtml.version>1.9.20</nekohtml.version>
<xml-apis.version>1.4.01</xml-apis.version>
<batik-ext.version>1.9.1</batik-ext.version>
<jsoup.version>1.11.2</jsoup.version>
<httpclient.version>4.5.5</httpclient.version>
<commons-lang3.version>3.7</commons-lang3.version>
<mapper-starter.version>1.2.3</mapper-starter.version>
<jedis.version>2.9.0</jedis.version>
<jest.version>5.3.3</jest.version>
<jna.version>4.5.1</jna.version>
<beanUtils.version>1.9.3</beanUtils.version>
</properties>
<dependencyManagement>
<dependencies>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>fastjson</artifactId>
<version>${fastjson.version}</version>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>dubbo</artifactId>
<version>${dubbo.version}</version>
</dependency>
<dependency>
<groupId>com.101tec</groupId>
<artifactId>zkclient</artifactId>
<version>${zkclient.version}</version>
</dependency>
<dependency>
<groupId>com.gitee.reger</groupId>
<artifactId>spring-boot-starter-dubbo</artifactId>
<version>${dubbo-starter.version}</version>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>${mybatis.version}</version>
</dependency>
<dependency>
<groupId>net.sourceforge.nekohtml</groupId>
<artifactId>nekohtml</artifactId>
<version>${nekohtml.version}</version>
</dependency>
<dependency>
<groupId>xml-apis</groupId>
<artifactId>xml-apis</artifactId>
<version>${xml-apis.version}</version>
</dependency>
<dependency>
<groupId>org.apache.xmlgraphics</groupId>
<artifactId>batik-ext</artifactId>
<version>${batik-ext.version}</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.jsoup/jsoup -->
<dependency>
<groupId>org.jsoup</groupId>
<artifactId>jsoup</artifactId>
<version>${jsoup.version}</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.apache.httpcomponents/httpclient -->
<dependency>
<groupId>org.apache.httpcomponents</groupId>
<artifactId>httpclient</artifactId>
<version>${httpclient.version}</version>
</dependency>
<dependency>
<groupId>org.apache.commons</groupId>
<artifactId>commons-lang3</artifactId>
<version>${commons-lang3.version}</version>
</dependency>
<dependency>
<groupId>tk.mybatis</groupId>
<artifactId>mapper-spring-boot-starter</artifactId>
<version>${mapper-starter.version}</version>
</dependency>
<dependency>
<groupId>redis.clients</groupId>
<artifactId>jedis</artifactId>
<version>${jedis.version}</version>
</dependency>
<!-- https://mvnrepository.com/artifact/io.searchbox/jest -->
<dependency>
<groupId>io.searchbox</groupId>
<artifactId>jest</artifactId>
<version>${jest.version}</version>
</dependency>
<!-- https://mvnrepository.com/artifact/net.java.dev.jna/jna -->
<dependency>
<groupId>net.java.dev.jna</groupId>
<artifactId>jna</artifactId>
<version>${jna.version}</version>
</dependency>
<dependency>
<groupId>commons-beanutils</groupId>
<artifactId>commons-beanutils</artifactId>
<version>${beanUtils.version}</version>
</dependency>
</dependencies>
</dependencyManagement>
</project>
c 抽取util工程
d 基于soa的架构理念,项目分为web前端controller(webUtil)
- Jsp、thymeleaf、cookie工具类
- 加入commonUtil
e 基于soa的架构理念,项目分为web后端service(serviceUtil)
- Mybatis、mysql、redis
- 加入commonUtil
f api工程
g gmall-user-web工程
h gmall-user-service工程