SSM项目的项目架构

转载

码海无压 2024-09-28 07:26:58

文章标签 SSM项目的项目架构 ssm项目 spring git mysql 文章分类 架构后端开发

搭建项目ssm

1.简介SSM

SSM(Spring+SpringMVC+MyBatis) 框架集由Spring、MyBatis两个开源框架整合而成(SpringMVC是Spring中的部分内容)。常作为数据源较简单的web项目的框架。

Spring　　Spring就像是整个项目中装配bean的大工厂，在配置文件中可以指定使用特定的参数去调用实体类的构造方法来实例化对象。也可以称之为项目中的粘合剂。　　Spring的核心思想是IoC(控制反转)，即不再需要程序员去显式地new一个对象，而是让Spring框架帮你来完成这一切。

SpringMVC　　SpringMVC在项目中拦截用户请求，它的核心Servlet即DispatcherServlet承担中介或是前台这样的职责，将用户请求通过HandlerMapping去匹配Controller，Controller就是具体对应请求所执行的操作。SpringMVC相当于SSH框架中struts。

mybatis　　mybatis是对jdbc的封装，它让数据库底层操作变的透明。mybatis的操作都是围绕一个sqlSessionFactory实例展开的。mybatis通过配置文件关联到各实体类的Mapper文件，Mapper文件中配置了每个类对数据库所需进行的sql语句映射。在每次与数据库交互时，通过sqlSessionFactory拿到一个sqlSession，再执行sql命令。

2.搭建项目

配置环境-->导入mybatis-->编写代码-->测试

搭建ssm项目需要

mybatis
mysql
juit

2.1 File-New-Project

SSM项目的项目架构_mysql

2.2 使用spring initializr 搭建项目

Spring initializr 是Spring 官方提供的一个用来初始化一个Spring boot 项目的工具。

SSM项目的项目架构_mysql_02

2.3.设置Project 名称

SSM项目的项目架构_spring_03

2.4.选择项目中所需要的组件

SSM项目的项目架构_git_04

2.5.保存项目

SSM项目的项目架构_ssm项目_05

2.6.检查下maven地址[File-Setting-Maven]

SSM项目的项目架构_git_06

2.7.构建项目格式

common 放一些公用组件
controller是前端访问使用
dao (Mapper 用于和Mybatis进行交货)
pojo(就是VO)
service(由Controller调用Service，ServiceImpl，Mapper进行执行数据)
mapper(mybatis语句注意存放的是Xml文件sql语句)

SSM项目的项目架构_spring_07

2.8.配置application.yml

spring:
  profiles:

server:
  port: 8100

spring:
  profiles:

server:
  port: 8100

SSM项目的项目架构_spring_08

Tomcat started on port(s): 8100 则启动成功

2.9.配置数据源

这里我们写一个通用的扫描配置数据库

@Configuration
public class DataSourceConfig {

 @Bean(name = "octMybatisDataSource")
 @Qualifier("octMybatisDataSource")
 @ConfigurationProperties(prefix = "spring.datasource")
 public DataSource octMybatisDataSource() {
  DruidDataSource dataSource = new DruidDataSource();
  return dataSource;
 }
}

@Configuration
public class DataSourceConfig {

 @Bean(name = "octMybatisDataSource")
 @Qualifier("octMybatisDataSource")
 @ConfigurationProperties(prefix = "spring.datasource")
 public DataSource octMybatisDataSource() {
  DruidDataSource dataSource = new DruidDataSource();
  return dataSource;
 }
}

2.10.配置mybatis扫描路径

/**
 * Mybatis配置，只读
 */
@Configuration
@EnableTransactionManagement
@MapperScan(basePackages = {"com.groot.springbootmybatis.dao.mapper","com.groot.springbootmybatis.dao.mapper"})
public class MiddleMybatisConfig {

    @Bean(name = "middleMybatisSqlSessionFactory")
    public SqlSessionFactory testSqlSessionFactory(@Qualifier("octMybatisDataSource") DataSource dataSource) throws Exception {
        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
        bean.setDataSource(dataSource);
        PathMatchingResourcePatternResolver pathMatchingResourcePatternResolver = new PathMatchingResourcePatternResolver();
        String packageSearchPath = ResourcePatternResolver.CLASSPATH_ALL_URL_PREFIX + "/mapper/*.xml";
        bean.setMapperLocations(pathMatchingResourcePatternResolver.getResources(packageSearchPath));
        return bean.getObject();
    }

    @Bean(name = "middleMybatisSqlSessionTemplate")
    public SqlSessionTemplate testSqlSessionTemplate(@Qualifier("middleMybatisSqlSessionFactory") SqlSessionFactory sqlSessionFactory) throws Exception {
        return new SqlSessionTemplate(sqlSessionFactory);
    }
}

/**
 * Mybatis配置，只读
 */
@Configuration
@EnableTransactionManagement
@MapperScan(basePackages = {"com.groot.springbootmybatis.dao.mapper","com.groot.springbootmybatis.dao.mapper"})
public class MiddleMybatisConfig {

    @Bean(name = "middleMybatisSqlSessionFactory")
    public SqlSessionFactory testSqlSessionFactory(@Qualifier("octMybatisDataSource") DataSource dataSource) throws Exception {
        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
        bean.setDataSource(dataSource);
        PathMatchingResourcePatternResolver pathMatchingResourcePatternResolver = new PathMatchingResourcePatternResolver();
        String packageSearchPath = ResourcePatternResolver.CLASSPATH_ALL_URL_PREFIX + "/mapper/*.xml";
        bean.setMapperLocations(pathMatchingResourcePatternResolver.getResources(packageSearchPath));
        return bean.getObject();
    }

    @Bean(name = "middleMybatisSqlSessionTemplate")
    public SqlSessionTemplate testSqlSessionTemplate(@Qualifier("middleMybatisSqlSessionFactory") SqlSessionFactory sqlSessionFactory) throws Exception {
        return new SqlSessionTemplate(sqlSessionFactory);
    }
}

2.11.在application文件中增加数据库配置

spring:
  datasource:
    url: jdbc:mysql://127.0.0.1:3306/oct?useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT%2B8
    username: root
    password: 1q2w3e
    driver-class-name: com.mysql.cj.jdbc.Driver
    initialSize: 10
    minIdle: 10
    maxActive: 30
    timeBetweenEvictionRunsMillis: 60000
    validationQuery: SELECT 1
    testWhileIdle: true
    testOnBorrow: false
    testOnReturn: false

spring:
  datasource:
    url: jdbc:mysql://127.0.0.1:3306/oct?useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT%2B8
    username: root
    password: 1q2w3e
    driver-class-name: com.mysql.cj.jdbc.Driver
    initialSize: 10
    minIdle: 10
    maxActive: 30
    timeBetweenEvictionRunsMillis: 60000
    validationQuery: SELECT 1
    testWhileIdle: true
    testOnBorrow: false
    testOnReturn: false

2.12.创建VO

public class ExampleDemoVO {

 @JsonFormat(shape = JsonFormat.Shape.STRING, pattern = "yyyy-MM-dd", timezone = "GMT+8")
 private Date bTime;
 @JsonFormat(shape = JsonFormat.Shape.STRING, pattern = "yyyy-MM-dd", timezone = "GMT+8")
 private Date eTime;


 @JsonFormat(shape = JsonFormat.Shape.STRING, pattern = "yyyy-MM-dd ", timezone = "GMT+8")
 private Date createTime;
 @JsonFormat(shape = JsonFormat.Shape.STRING, pattern = "yyyy-MM-dd ", timezone = "GMT+8")
 private Date updateTime;
 private Integer createUser;
 private Integer updateUser;
 private Integer valid;
 private Date rVersion;
 private String deliveryNo;
 private Integer bookingId;
 private Integer taskId;

 /**
  * 页面收货方编码
  * */
 private List receiveNos;public List getReceiveNos() {return receiveNos;
 }public void setReceiveNos(List receiveNos) {this.receiveNos = receiveNos;
 }public Date getCreateTime() {return createTime;
 }public void setCreateTime(Date createTime) {this.createTime = createTime;
 }public Date getUpdateTime() {return updateTime;
 }public void setUpdateTime(Date updateTime) {this.updateTime = updateTime;
 }public Integer getCreateUser() {return createUser;
 }public void setCreateUser(Integer createUser) {this.createUser = createUser;
 }public Integer getUpdateUser() {return updateUser;
 }public void setUpdateUser(Integer updateUser) {this.updateUser = updateUser;
 }public Integer getValid() {return valid;
 }public void setValid(Integer valid) {this.valid = valid;
 }public Date getrVersion() {return rVersion;
 }public void setrVersion(Date rVersion) {this.rVersion = rVersion;
 }public String getDeliveryNo() {return deliveryNo;
 }public void setDeliveryNo(String deliveryNo) {this.deliveryNo = deliveryNo;
 }public Integer getBookingId() {return bookingId;
 }public void setBookingId(Integer bookingId) {this.bookingId = bookingId;
 }public Integer getTaskId() {return taskId;
 }public void setTaskId(Integer taskId) {this.taskId = taskId;
 }
}
public class ExampleDemoVO {

 @JsonFormat(shape = JsonFormat.Shape.STRING, pattern = "yyyy-MM-dd", timezone = "GMT+8")
 private Date bTime;
 @JsonFormat(shape = JsonFormat.Shape.STRING, pattern = "yyyy-MM-dd", timezone = "GMT+8")
 private Date eTime;


 @JsonFormat(shape = JsonFormat.Shape.STRING, pattern = "yyyy-MM-dd ", timezone = "GMT+8")
 private Date createTime;
 @JsonFormat(shape = JsonFormat.Shape.STRING, pattern = "yyyy-MM-dd ", timezone = "GMT+8")
 private Date updateTime;
 private Integer createUser;
 private Integer updateUser;
 private Integer valid;
 private Date rVersion;
 private String deliveryNo;
 private Integer bookingId;
 private Integer taskId;

 /**
  * 页面收货方编码
  * */
 private List receiveNos;public List getReceiveNos() {return receiveNos;
 }public void setReceiveNos(List receiveNos) {this.receiveNos = receiveNos;
 }public Date getCreateTime() {return createTime;
 }public void setCreateTime(Date createTime) {this.createTime = createTime;
 }public Date getUpdateTime() {return updateTime;
 }public void setUpdateTime(Date updateTime) {this.updateTime = updateTime;
 }public Integer getCreateUser() {return createUser;
 }public void setCreateUser(Integer createUser) {this.createUser = createUser;
 }public Integer getUpdateUser() {return updateUser;
 }public void setUpdateUser(Integer updateUser) {this.updateUser = updateUser;
 }public Integer getValid() {return valid;
 }public void setValid(Integer valid) {this.valid = valid;
 }public Date getrVersion() {return rVersion;
 }public void setrVersion(Date rVersion) {this.rVersion = rVersion;
 }public String getDeliveryNo() {return deliveryNo;
 }public void setDeliveryNo(String deliveryNo) {this.deliveryNo = deliveryNo;
 }public Integer getBookingId() {return bookingId;
 }public void setBookingId(Integer bookingId) {this.bookingId = bookingId;
 }public Integer getTaskId() {return taskId;
 }public void setTaskId(Integer taskId) {this.taskId = taskId;
 }
}

2.13.创建service

public interface ExampleDemoService {
 List getExampleList();
}

public interface ExampleDemoService {
 List getExampleList();
}

2.14.创建serviceImpl

在接口的实现类中需要增加注解@Service

@Service
public class ExampleDemoServiceImpl implements ExampleDemoService {

 @Autowired
 ExampleMapper exampleMapper;

 @Override
 public List getExampleList() {
  List list= exampleMapper.findExampleList();return list;
 }
}
@Service
public class ExampleDemoServiceImpl implements ExampleDemoService {

 @Autowired
 ExampleMapper exampleMapper;

 @Override
 public List getExampleList() {
  List list= exampleMapper.findExampleList();return list;
 }
}

2.15.创建Mapper

@Mapper
public interface ExampleMapper {
 List findExampleList();
}


@Mapper
public interface ExampleMapper {
 List findExampleList();
}

2.16.创建controler

@RestController
@RequestMapping(value = {"/springboot"})
public class MybatisController {

 @Autowired
 ExampleDemoService service;
 @GetMapping("/mybatis")
 public void hello() {
 List list= service.getExampleList();
  System.out.println("获取到的数据为:"+list.size());
 }
}
@RestController
@RequestMapping(value = {"/springboot"})
public class MybatisController {

 @Autowired
 ExampleDemoService service;
 @GetMapping("/mybatis")
 public void hello() {
 List list= service.getExampleList();
  System.out.println("获取到的数据为:"+list.size());
 }
}

2.17.访问地址如下

访问地址

2.18.将代码打包

由于集成了maven所以可以直接使用maven打成jar包

2.19.运行Jar包

上一步已经可以看到文件路径

再该路径执行cmd 然后 **java -jar spring-boot-mybatis-0.0.1-SNAPSHOT.jar **

SSM项目的项目架构_ssm项目_09

A10

2.20.将项目上传到gitee

20.1 修改.gitignore文件

/target/
!.mvn/wrapper/maven-wrapper.jar

### STS ###
.apt_generated
.classpath
.factorypath
.project
.settings
.springBeans
.sts4-cache


### IntelliJ IDEA ###
.idea
.idea/
/.idea/
.mvn
*.iws
*.iml
*.ipr
mvnw.cmd
mvnw
/.mvn


### NetBeans ###
/nbproject/private/
/build/
/nbbuild/
/dist/
/nbdist/
/.nb-gradle/
/.idea
/.git

/target/
!.mvn/wrapper/maven-wrapper.jar

### STS ###
.apt_generated
.classpath
.factorypath
.project
.settings
.springBeans
.sts4-cache


### IntelliJ IDEA ###
.idea
.idea/
/.idea/
.mvn
*.iws
*.iml
*.ipr
mvnw.cmd
mvnw
/.mvn


### NetBeans ###
/nbproject/private/
/build/
/nbbuild/
/dist/
/nbdist/
/.nb-gradle/
/.idea
/.git

20.2 初始化文件

$ git add . #将当前目录所有文件添加到git暂存区
$ git commit -m "my first commit" #提交并备注提交信息
$ git remote add origin https://gitee.com/用户个性地址/HelloGitee.git
$ git push origin master #将本地提交推送到远程仓库

$ git add . #将当前目录所有文件添加到git暂存区
$ git commit -m "my first commit" #提交并备注提交信息
$ git remote add origin https://gitee.com/用户个性地址/HelloGitee.git
$ git push origin master #将本地提交推送到远程仓库

20.2 项目地址

https://gitee.com/VincentBlog/spring-boot-mybatis.git

3.问题总结

1.The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary

Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.

问题原因：升级后的mysql驱动类，Driver位置由com.mysql.jdbc.Driver 变为com.mysql.cj.jdbc.Driver 解决方案：将数据配置文件里spring.datasource.driver-class-name=com.mysql.jdbc.Driver修改为如下 spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

2.Invalid bound statement (not found): com.groot.springbootmybatis.dao.mapper.ExampleMapper.findExampleList

2.1 找不到mapper的路径，检查mapper的路径和是否有问题

<mapper namespace="com.groot.springbootmybatis.dao.mapper.ExampleMapper">
mapper>

<mapper namespace="com.groot.springbootmybatis.dao.mapper.ExampleMapper">
mapper>

3.解决idea新建maven项目时一直loading问题

打开：Setting---->Build Tools → Maven → Importing,

set VM options for importer to -Xmx1024m 中数字改成1024

本文章为转载内容，我们尊重原作者对文章享有的著作权。如有内容错误或侵权问题，欢迎原作者联系我们进行内容更正或删除文章。