关于SSM框架搭建的过程和遇到的一些坑

最新推荐文章于 2024-06-25 17:39:36 发布

weixin_38728929

最新推荐文章于 2024-06-25 17:39:36 发布

阅读量1k

点赞数 3

分类专栏： SSM框架文章标签： SSM框架框架搭建

本文链接：https://blog.csdn.net/weixin_38728929/article/details/81434085

版权

SSM框架专栏收录该内容

1 篇文章 0 订阅

订阅专栏

前言

这是我第一次搭建SSM框架，参考了一些资料与博客，就简单的实现了MVC层数据到数据库的数据持久化

数据库结构

这里写图片描述

项目目录结构

这里写图片描述

搭建过程

1. 在IDEA创建一个新的Maven项目并选择webapp模板

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>

  <groupId>com</groupId>
  <artifactId>Romantic-Wine-Estate02</artifactId>
  <version>1.0-SNAPSHOT</version>
  <packaging>war</packaging>

  <name>Romantic-Wine-Estate02 Maven Webapp</name>
  <!-- FIXME change it to the project's website -->
  <url>http://www.example.com</url>

  <properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <maven.compiler.source>1.7</maven.compiler.source>
    <maven.compiler.target>1.7</maven.compiler.target>

    <!-- spring版本号 -->
    <spring.version>4.1.4.RELEASE</spring.version>
    <!-- mybatis版本号 -->
    <mybatis.version>3.4.6</mybatis.version>
    <!-- log4j日志文件管理包版本 -->
    <slf4j.version>1.7.25</slf4j.version>
    <log4j.version>1.2.17</log4j.version>

    <!-- jackson包版本 -->
    <jackson.version>2.5.0</jackson.version>
  </properties>
  <dependencies>

    <!-- junit测试包 -->
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.11</version>
      <scope>test</scope>
    </dependency>

    <!-- spring核心包 -->
    <!-- springframe start -->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-core</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <!-- https://mvnrepository.com/artifact/org.springframework/spring-context -->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-context</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <!-- https://mvnrepository.com/artifact/org.springframework/spring-beans -->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-beans</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-web</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-aop</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-oxm</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-tx</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-jdbc</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-webmvc</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-context-support</artifactId>
      <version>${spring.version}</version>
    </dependency>

    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-test</artifactId>
      <version>${spring.version}</version>
    </dependency>
    <!-- springframe end -->

    <!-- mybatis核心包 -->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>${mybatis.version}</version>
    </dependency>

    <!-- mybatis-spring包 -->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis-spring</artifactId>
      <version>1.3.2</version>
    </dependency>

    <!-- mysql驱动包 -->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.38</version>
    </dependency>

    <!-- https://mvnrepository.com/artifact/com.alibaba/druid -->
    <dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>druid</artifactId>
      <version>1.1.10</version>
    </dependency>

    <!-- servlet -->
    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>javax.servlet-api</artifactId>
      <version>3.1.0</version>
      <scope>provided</scope>
    </dependency>

    <!-- https://mvnrepository.com/artifact/javax.servlet.jsp/javax.servlet.jsp-api -->
    <dependency>
      <groupId>javax.servlet.jsp</groupId>
      <artifactId>javax.servlet.jsp-api</artifactId>
      <version>2.2.1</version>
      <scope>provided</scope>
    </dependency>

    <!-- https://mvnrepository.com/artifact/javax.servlet.jsp/jsp-api -->
    <dependency>
      <groupId>javax.servlet.jsp</groupId>
      <artifactId>jsp-api</artifactId>
      <version>2.2</version>
      <scope>provided</scope>
    </dependency>

    <!-- JSTL标签类 -->
    <dependency>
      <groupId>jstl</groupId>
      <artifactId>jstl</artifactId>
      <version>1.2</version>
    </dependency>

    <!-- 映入JSON -->
    <dependency>
      <groupId>org.codehaus.jackson</groupId>
      <artifactId>jackson-mapper-asl</artifactId>
      <version>1.9.13</version>
    </dependency>

    <dependency>
      <groupId>com.fasterxml.jackson.core</groupId>
      <artifactId>jackson-databind</artifactId>
      <version>2.1.0</version>
    </dependency>
    <dependency>
      <groupId>com.fasterxml.jackson.core</groupId>
      <artifactId>jackson-annotations</artifactId>
      <version>2.1.0</version>
    </dependency>

    <!-- 上传组件包 -->
    <dependency>
      <groupId>commons-fileupload</groupId>
      <artifactId>commons-fileupload</artifactId>
      <version>1.3.1</version>
    </dependency>
    <dependency>
      <groupId>commons-io</groupId>
      <artifactId>commons-io</artifactId>
      <version>2.4</version>
    </dependency>
    <dependency>
      <groupId>commons-codec</groupId>
      <artifactId>commons-codec</artifactId>
      <version>1.9</version>
    </dependency>

    <!-- https://mvnrepository.com/artifact/commons-logging/commons-logging -->
    <dependency>
      <groupId>commons-logging</groupId>
      <artifactId>commons-logging</artifactId>
      <version>1.2</version>
    </dependency>

    <!-- 日志文件管理包 -->
    <!-- log start -->
    <dependency>
      <groupId>log4j</groupId>
      <artifactId>log4j</artifactId>
      <version>${log4j.version}</version>
    </dependency>

    <dependency>
      <groupId>org.slf4j</groupId>
      <artifactId>slf4j-api</artifactId>
      <version>${slf4j.version}</version>
    </dependency>

    <dependency>
      <groupId>org.slf4j</groupId>
      <artifactId>slf4j-log4j12</artifactId>
      <version>${slf4j.version}</version>
    </dependency>
    <!-- log end -->

      <!-- 格式化对象，方便输出日志 -->
    <!-- https://mvnrepository.com/artifact/com.alibaba/fastjson -->
    <dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>fastjson</artifactId>
      <version>1.2.47</version>
    </dependency>
  </dependencies>

  <build>
    <finalName>Romantic-Wine-Estate02</finalName>
    <pluginManagement><!-- lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) -->
      <plugins>
        <plugin>
          <artifactId>maven-clean-plugin</artifactId>
          <version>3.0.0</version>
        </plugin>
        <!-- see http://maven.apache.org/ref/current/maven-core/default-bindings.html#Plugin_bindings_for_war_packaging -->
        <plugin>
          <artifactId>maven-resources-plugin</artifactId>
          <version>3.0.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-compiler-plugin</artifactId>
          <version>3.7.0</version>
        </plugin>
        <plugin>
          <artifactId>maven-surefire-plugin</artifactId>
          <version>2.20.1</version>
        </plugin>
        <plugin>
          <artifactId>maven-war-plugin</artifactId>
          <version>3.2.0</version>
        </plugin>
        <plugin>
          <artifactId>maven-install-plugin</artifactId>
          <version>2.5.2</version>
        </plugin>
        <plugin>
          <artifactId>maven-deploy-plugin</artifactId>
          <version>2.8.2</version>
        </plugin>
      </plugins>
    </pluginManagement>
  </build>
</project>

2. 整合Spring和MyBatis

配置applicationContext-mybatis.xml和jdbc.properties和mybatis-config.xml

applicationContext-mybatis.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:mvc="http://www.springframework.org/schema/mvc"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
                        http://www.springframework.org/schema/beans/spring-beans-3.1.xsd
                        http://www.springframework.org/schema/context
                        http://www.springframework.org/schema/context/spring-context-3.1.xsd
                        http://www.springframework.org/schema/mvc
                        http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">
    <!-- 自动扫描 -->
    <context:component-scan base-package="com.romantic" />
    <!-- 引入配置文件 -->
    <bean id="propertyConfigurer"
          class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="location" value="classpath:jdbc.properties" />
    </bean>

    <!-- 数据源 -->
    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"
          init-method="init" destroy-method="close">
        <!-- 数据库基本信息配置 -->
        <property name = "driverClassName" value = "${driver}" />
        <property name="url" value="${url}" />
        <property name="username" value="${username}" />
        <property name="password" value="${password}" />

        <!-- 初始化连接数量 -->
        <property name="initialSize" value="${initialSize}" />
        <!-- 最小空闲连接数 -->
        <property name="minIdle" value="${minIdle}" />
        <!-- 最大并发连接数 -->
        <property name="maxActive" value="${maxActive}" />
        <!-- 配置获取连接等待超时的时间 -->
        <property name="maxWait" value="${maxWait}" />

        <!-- 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒 -->
        <property name="timeBetweenEvictionRunsMillis" value="${timeBetweenEvictionRunsMillis}" />

        <!-- 配置一个连接在池中最小生存的时间，单位是毫秒 -->
        <property name="minEvictableIdleTimeMillis" value="${minEvictableIdleTimeMillis}" />
        <property name="validationQuery" value="${validationQuery}" />
        <property name="testWhileIdle" value="${testWhileIdle}" />
        <property name="testOnBorrow" value="${testOnBorrow}" />
        <property name="testOnReturn" value="${testOnReturn}" />

        <!-- 配置监控统计拦截的filters -->
        <property name="filters" value="${filters}" />
    </bean>

    <!-- spring和MyBatis完美整合，不需要mybatis的配置映射文件 -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!-- 数据源 -->
        <property name="dataSource" ref="dataSource"/>
        <property name="configLocation" value="classpath:/mybatis-config.xml"/>
        <!-- 自动扫描mapping.xml文件 -->
        <property name="mapperLocations" value="classpath:com/romantic/mapping/*.xml"/>
    </bean>

    <!-- DAO接口所在包名，Spring会自动查找其下的类 -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.romantic.dao" />
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
    </bean>

    <!-- (事务管理)transaction manager, use JtaTransactionManager for global tx -->
    <bean id="transactionManager"
          class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource" />
    </bean>
</beans>

jdbc.properties

url=jdbc:mysql://localhost:3306/对应的数据库名?useUnicode=true&characterEncoding=utf-8
driver=com.mysql.jdbc.Driver
username=你的数据库用户名
password=你自己的数据库密码
filters=stat
maxActive=20
initialSize=1
maxWait=60000
minIdle=1
maxIdle=15
timeBetweenEvictionRunsMillis=60000
minEvictableIdleTimeMillis=300000
validationQuery=SELECT 'x'
testWhileIdle=true
testOnBorrow=false
testOnReturn=false
maxOpenPreparedStatements=20
removeAbandoned=true
removeAbandonedTimeout=1800
logAbandoned=true

mybatis-config.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration
        PUBLIC "-//ibatis.apache.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <!--配置全局属性-->
    <settings>
        <setting name="logImpl" value="LOG4J" />
        <setting name="cacheEnabled" value="true"/>
        <setting name="lazyLoadingEnabled" value="false"/>
        <setting name="aggressiveLazyLoading" value="true"/>
        <!--<setting name="logImpl" value="STDOUT_LOGGING"/>-->
    </settings>
</configuration>

3. 整合Spring和Spring-MVC

配置applicationContext-mvc.xml和web.xml和log4j.properties（顺带加上log4j，便于我们DEBUG查看程序运行信息，这里不多赘述）
applicationContext-mvc.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:p="http://www.springframework.org/schema/p"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:mvc="http://www.springframework.org/schema/mvc"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
                        http://www.springframework.org/schema/beans/spring-beans-3.1.xsd
                        http://www.springframework.org/schema/context
                        http://www.springframework.org/schema/context/spring-context-3.1.xsd
                        http://www.springframework.org/schema/mvc
                        http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">

    <!-- 自动扫描该包，使SpringMVC认为包下用了@controller注解的类是控制器 -->
    <context:component-scan base-package="com.romantic.controller" />

    <!--避免IE执行AJAX时，返回JSON出现下载文件 -->
    <bean id="mappingJacksonHttpMessageConverter"
          class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter">
        <property name="supportedMediaTypes">
            <list>
                <value>text/html;charset=UTF-8</value>
            </list>
        </property>
    </bean>
    <!-- 启动SpringMVC的注解功能，完成请求和注解POJO的映射 -->
    <bean
            class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter">
        <property name="messageConverters">
            <list>
                <ref bean="mappingJacksonHttpMessageConverter" />  <!-- JSON转换器 -->
            </list>
        </property>
    </bean>

    <!-- 定义跳转的文件的前后缀 ，视图模式配置-->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <!-- 这里的配置我的理解是自动给后面action的方法return的字符串加上前缀和后缀，变成一个 可用的url地址 -->
        <property name="prefix" value="/WEB-INF/" />
        <property name="suffix" value=".jsp" />
    </bean>

    <!-- 处理请求返回json字符串的中文乱码问题 -->
    <mvc:annotation-driven>
        <mvc:message-converters>
            <bean class="org.springframework.http.converter.StringHttpMessageConverter">
                <property name="supportedMediaTypes">
                    <list>
                        <value>application/json;charset=UTF-8</value>
                    </list>
                </property>
            </bean>
        </mvc:message-converters>
    </mvc:annotation-driven>
</beans>

web.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE web-app PUBLIC
 "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
 "http://java.sun.com/dtd/web-app_2_3.dtd" >

<web-app xmlns="http://java.sun.com/xml/ns/javaee"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://java.sun.com/xml/ns/javaee
        http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
         version="3.0">
    <display-name>Archetype Created Web Application</display-name>
    <display-name>web-ssm</display-name>

    <!--Spring和mybatis的配置文件-->
    <context-param>
      <param-name>contextConfigLocation</param-name>
      <param-value>classpath:applicationContext-mybatis.xml</param-value>
    </context-param>

    <!--Log4j配置-->
    <context-param>
        <param-name>log4jConfigLocation</param-name>
        <param-value>classpath:log4j.properties</param-value>
    </context-param>
    <context-param>
        <param-name>log4jRefreshInterval</param-name>
        <param-value>60000</param-value>
    </context-param>
    <listener>
        <listener-class>org.springframework.web.util.Log4jConfigListener</listener-class>
    </listener>

    <!-- 编码过滤器 -->
    <filter>
      <filter-name>encodingFilter</filter-name>
      <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
      <init-param>
        <param-name>encoding</param-name>
        <param-value>UTF-8</param-value>
      </init-param>
    </filter>
    <filter-mapping>
      <filter-name>encodingFilter</filter-name>
      <url-pattern>/*</url-pattern>
    </filter-mapping>

    <!-- spring监听器 -->
    <listener>
      <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>

    <!-- 防止spring内存溢出监听器，比如quartz -->
    <listener>
      <listener-class>org.springframework.web.util.IntrospectorCleanupListener</listener-class>
    </listener>

    <!-- Spring MVC 核心配置开始 -->
    <servlet>
        <servlet-name>mvc-dispatcher</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <!-- 可以通过contextConfigLocation来自定义SpringMVC配置文件的位置，如不指定，则默认在WEB-INF目录下，名称为[<servlet-name>]-servlet.xml，
             此时文件名必须为[<servlet-name>]-servlet.xml，否则会出错-->
        <!--以下init-param是自定义SpringMVC的配置文件的位置 -->
        <init-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath:applicationContext-mvc.xml</param-value>
        </init-param>
        <load-on-startup>1</load-on-startup>
        <async-supported>true</async-supported>
    </servlet>

    <!-- 拦截设置 -->
    <servlet-mapping>
        <servlet-name>mvc-dispatcher</servlet-name>
        <!-- 此处可以可以配置成*.do，对应struts的后缀习惯 -->
        <url-pattern>/</url-pattern>
    </servlet-mapping>
    <!-- Spring MVC 核心配置结束 -->

    <welcome-file-list>
      <welcome-file>/index.jsp</welcome-file>
    </welcome-file-list>

    <!-- session配置 -->
    <session-config>
      <session-timeout>15</session-timeout>
    </session-config>
</web-app>

log4j.properties

### set log levels ###  
log4j.rootLogger = DEBUG , console , debug , error  

### console ###  
log4j.appender.console = org.apache.log4j.ConsoleAppender  
log4j.appender.console.Target = System.out  
log4j.appender.console.layout = org.apache.log4j.PatternLayout  
log4j.appender.console.layout.ConversionPattern = %-d{yyyy-MM-dd HH\:mm\:ss} [%p]-[%c] %m%n  

### log file ###  
log4j.appender.debug = org.apache.log4j.DailyRollingFileAppender  
log4j.appender.debug.File = ../logs/springmvc-demo.log  
log4j.appender.debug.Append = true  
log4j.appender.debug.Threshold = INFO  
log4j.appender.debug.layout = org.apache.log4j.PatternLayout  
log4j.appender.debug.layout.ConversionPattern = %-d{yyyy-MM-dd HH\:mm\:ss} [%p]-[%c] %m%n  

### exception ###  
log4j.appender.error = org.apache.log4j.DailyRollingFileAppender  
log4j.appender.error.File = redcms.log  
log4j.appender.error.Append = true  
log4j.appender.error.Threshold = ERROR  
log4j.appender.error.layout = org.apache.log4j.PatternLayout  
log4j.appender.error.layout.ConversionPattern = %-d{yyyy-MM-dd HH\:mm\:ss} [%p]-[%c] %m%n

到这里SSM框架环境的基本配置就算完成了，可以先跑出一个helloword检验一下
这里写图片描述

4. 创建pojo类（包含get和set方法）

tbOrder.java

package com.romantic.pojo;

import org.springframework.stereotype.Component;

/**
 * 用户订单表实体类
 */
@Component
public class tbOrder {
    private String orderNum;
    private String sellerId;
    private String userId;
    private String buyerNick;

    public String getOrderNum() {
        return orderNum;
    }
    public void setOrderNum(String orderNum) {
        this.orderNum = orderNum;
    }
    public String getSellerId() {
        return sellerId;
    }
    public void setSellerId(String sellerId) {
        this.sellerId = sellerId;
    }
    public String getUserId() {
        return userId;
    }
    public void setUserId(String userId) {
        this.userId = userId;
    }
    public String getBuyerNick() {
        return buyerNick;
    }
    public void setBuyerNick(String buyerNick) {
        this.buyerNick = buyerNick;
    }
}

5. 创建dao层接口

OrderMapper.java

package com.romantic.dao;

import com.romantic.pojo.tbOrder;

/**
 * 订单表dao层接口
 */
public interface OrderMapper {

    tbOrder selectByUserId(String userId);

    Integer deleteByOrderNum(String orderNum);

    Integer updateByOrderNum(tbOrder order);

    Integer insertOrder(tbOrder order);
}

6. 创建MyBatis的XML映射文件

OrderMapper.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" >

<mapper namespace="com.romantic.dao.OrderMapper" >
    <resultMap id="BaseResultMap" type="com.romantic.pojo.tbOrder" >
        <id column="user_id" property="userId" jdbcType="VARCHAR" />
        <result column="seller_id" property="sellerId" jdbcType="VARCHAR" />
        <result column="order_num" property="orderNum" jdbcType="VARCHAR" />
        <result column="buyer_nick" property="buyerNick" jdbcType="VARCHAR" />
    </resultMap>

    <sql id="Base_Column_List" >
      user_id, seller_id, order_num, buyer_nick
    </sql>

    <!--通过user_id查询订单表数据-->
    <select id="selectByUserId" resultMap="BaseResultMap" parameterType="java.lang.String" >
        select
        <include refid="Base_Column_List" />
        from tb_order
        where user_id = #{user_id,jdbcType=VARCHAR}
    </select>

    <!--通过order_num删除订单表的数据-->
    <delete id="deleteByOrderNum" parameterType="java.lang.String" >
    delete from tb_order
    where order_num = #{order_num,jdbcType=VARCHAR}
    </delete>

    <!--根据订单编号更新订单表数据-->
    <update id="updateByOrderNum" parameterType="com.romantic.pojo.tbOrder" >
    update tb_order
    set seller_id = #{sellerId,jdbcType=VARCHAR},
    user_id = #{userId,jdbcType=VARCHAR},
    buyer_nick = #{buyerNick,jdbcType=VARCHAR}
    where order_num = #{orderNum,jdbcType=VARCHAR}
    </update>

    <!--向订单表插入一条数据-->
    <insert id="insertOrder" parameterType="com.romantic.pojo.tbOrder" >
    insert into tb_order(order_num, seller_id, user_id, buyer_nick)
    values (#{orderNum,jdbcType=VARCHAR}, #{sellerId,jdbcType=VARCHAR}, #{userId,jdbcType=VARCHAR}, #{buyerNick,jdbcType=VARCHAR}
      )
    </insert>
</mapper>

7. 编写Service层

OrderService.java接口

package com.romantic.service;

import com.romantic.pojo.tbOrder;
import org.springframework.stereotype.Service;

/**
 * Service层接口
 */
@Service("orderService")
public interface OrderService {
    //根据用户id查询订单表数据
    public tbOrder gettbOrder(String userId);
    //根据订单编号删除订单表数据
    public Integer deleteOrder(String orderNum);
    //根据订单编号更新订单表数据
    public Integer updateByOrderNum(tbOrder tbOrder);
    //向订单表插入一条数据
    public Integer insertOrder(tbOrder tbOrder);
}

OrderServiceImp.java实现Service层的接口

package com.romantic.service.imp;

import com.romantic.dao.OrderMapper;
import com.romantic.pojo.tbOrder;
import com.romantic.service.OrderService;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;

/**
 * Service接口的实现类，在这里调用dao层接口
 */
@Service("orderService")
public class OrderServiceImp implements OrderService {
    @Resource
    private OrderMapper orderMapper;

    //根据用户id查询订单表数据
    public tbOrder gettbOrder(String userId){
        System.out.println("Service::gettbOrder::"+userId);
        tbOrder a=this.orderMapper.selectByUserId(userId);
        if(a!=null){
            return a;
        }
        return null;
    }

    //根据订单编号删除订单表数据
    public Integer deleteOrder(String orderNum) {
        System.out.println("Service::deleteOrder::"+orderNum);
        Integer b = this.orderMapper.deleteByOrderNum(orderNum);

        return b;
    }

    //根据订单编号更新订单表数据
    @Override
    public Integer updateByOrderNum(tbOrder tbOrder) {
        System.out.println("Service::updateByOrderNum::"+tbOrder);
        Integer c = this.orderMapper.updateByOrderNum(tbOrder);
        return c;
    }

    //向订单表插入一条数据
    @Override
    public Integer insertOrder(tbOrder tbOrder) {
        System.out.println("Service::insertOrder::"+tbOrder);
        Integer d = this.orderMapper.insertOrder(tbOrder);
        return d;
    }
}

8. 创建Controller层

OrderController.java

package com.romantic.controller;

import com.romantic.pojo.tbOrder;
import com.romantic.service.OrderService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.*;

import javax.annotation.Resource;

/**
 * mvc层，与前端交互
 */
@Controller
public class OrderController {
    @Resource
    OrderService orderService;
    @Autowired
    tbOrder tbOrder;
    //根据用户id查询订单表数据
  @RequestMapping(value = "/selectOrder/{userId}",method = RequestMethod.GET)
    @ResponseBody
    public tbOrder getOrder(@PathVariable("userId") String userId){
        System.out.println("Controller::::"+userId);
        return orderService.gettbOrder(userId);
    }

    //根据订单编号删除订单表数据
  @RequestMapping(value = "/deleteOrder/{orderNum}",method = RequestMethod.GET)
    @ResponseBody
    public Integer deleteOrder(@PathVariable("orderNum") String orderNum) {
        System.out.println("Controller::::"+orderNum);
        return orderService.deleteOrder(orderNum);
    }

    //根据订单编号更新订单表数据
  @RequestMapping(value = "/updateOrder",method = RequestMethod.GET)
    @ResponseBody
    public Integer updateByOrderNum(@RequestParam(value = "userId") String userId,
                                    @RequestParam(value = "sellerId") String sellerId,
                                    @RequestParam(value = "orderNum") String orderNum,
                                    @RequestParam(value = "buyerNick") String buyerNick
    ) {
        tbOrder.setUserId(userId);
        tbOrder.setSellerId(sellerId);
        tbOrder.setOrderNum(orderNum);
        tbOrder.setBuyerNick(buyerNick);

        System.out.println("Controller::::"+"userId:"+tbOrder.getUserId()+
                "\nsellerId:"+tbOrder.getSellerId()+"\norderNum:"+
                tbOrder.getOrderNum()+"\nbuyerNick"+tbOrder.getBuyerNick());

        return orderService.updateByOrderNum(tbOrder);
    }

    @RequestMapping(value = "/insertOrder",method = RequestMethod.GET)
    @ResponseBody
    public Integer insertOrder(@RequestParam(value = "userId") String userId,
                               @RequestParam(value = "sellerId") String sellerId,
                               @RequestParam(value = "orderNum") String orderNum,
                               @RequestParam(value = "buyerNick") String buyerNick
    ) {
        tbOrder.setUserId(userId);
        tbOrder.setSellerId(sellerId);
        tbOrder.setOrderNum(orderNum);
        tbOrder.setBuyerNick(buyerNick);

        System.out.println("Controller::::"+"userId:"+tbOrder.getUserId()+
                "\nsellerId:"+tbOrder.getSellerId()+"\norderNum:"+
                tbOrder.getOrderNum()+"\nbuyerNick"+tbOrder.getBuyerNick());
        return orderService.insertOrder(tbOrder);
    }
}

遇到的坑

Mapper.xml文件里SQL语句写错
Mapper.xml中namespace与dao层接口名不同

<mapper namespace="com.romantic.dao.OrderMapper" >

dao层接口

public interface OrderMapper {

    tbOrder selectByUserId(String userId);

    Integer deleteByOrderNum(String orderNum);

    Integer updateByOrderNum(tbOrder order);

    Integer insertOrder(tbOrder order);
}

dao层接口函数返回值与SQL语句结果返回值不匹配
Controller层GET和POST传参方式混淆
Controller层忘记加 @ResponseBody 造成返回的 json 字符串乱码
处理请求后返回的 json 字符串中，中文出现乱码
解决办法：在applicationContext-mvc.xml中加入这段代码解决乱码问题

<mvc:annotation-driven>
    <mvc:message-converters>
        <bean class="org.springframework.http.converter.StringHttpMessageConverter">
            <property name="supportedMediaTypes">
                <list>
                    <value>application/json;charset=UTF-8</value>
                </list>
            </property>
        </bean>
    </mvc:message-converters>
</mvc:annotation-driven>

Spring版本问题
pojo类多写了有参的构造方法，但是Spring自动注入使用的是无参构造，造成Bean注入失败

weixin_38728929

关注

3
点赞
踩
2

收藏

觉得还不错? 一键收藏
1
评论
关于SSM框架搭建的过程和遇到的一些坑

前言这是我第一次搭建SSM框架，参考了一些资料与博客，就简单的实现了MVC层数据到数据库的数据持久化数据库结构项目目录结构搭建过程1. 在IDEA创建一个新的Maven项目并选择webapp模板pom.xml文件的配置（这里各位可以根据自己项目的需求导入相应的依赖）&amp;lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?&amp;gt;&am
复制链接

扫一扫