ssm框架整合

ssm整合

开发环境ide,mysql数据库,Spring+SpringMVC+Mybatis,tomcat8.5,jdk使用的是1.7版本。

第一步:导入jar包

  • Spring+ SpringMVC + MyBatis + Mybatis-spring整合包
  • AOP联盟+织入 + c3p0 数据库连接池 + MySQL连接驱动 + jstl
链接:https://pan.baidu.com/s/1_tSC... 提取码:dyao

项目结构如下图:
图片描述

第二步:创建springmvc.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:mvc="http://www.springframework.org/schema/mvc"
   xmlns:context="http://www.springframework.org/schema/context"
   xmlns:aop="http://www.springframework.org/schema/aop"
   xmlns:tx="http://www.springframework.org/schema/tx"
   xsi:schemaLocation="http://www.springframework.org/schema/beans
  http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
  http://www.springframework.org/schema/mvc
  http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd
  http://www.springframework.org/schema/context
  http://www.springframework.org/schema/context/spring-context-3.2.xsd
  http://www.springframework.org/schema/aop
  http://www.springframework.org/schema/aop/spring-aop-3.2.xsd
  http://www.springframework.org/schema/tx
  http://www.springframework.org/schema/tx/spring-tx-3.2.xsd">

<!-- 1.配置注解扫描位置 -->
<context:component-scan base-package="com.justin.backoffice.web.controller" />

<!-- 2.配置注解处理映射-->
<bean class="org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping"/>

<!--3.配置适配器-->
<bean class="org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter"/>

<!-- 4.配置springmvc视图解析器 视图解析器解析的视频路径为:前缀 + 后缀 -->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
    <property name="prefix" value="/WEB-INF/views/" />
    <property name="suffix" value=".jsp" />
</bean>

第三步:在web.xml添加springmvc配置

图片描述
<!--配置springmvc-->

<servlet>
    <servlet-name>DispatcherServlet</servlet-name>
    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    <!-- 3.0的springmvc 默认加载WEB-INF下的dispatcher-servlet.xml文件 3.2的springmvc
        加载DispatcherServlet-servlet.xml文件 -->
    <init-param>
        <!-- 修改黑底springmvc加载的配置文件路径 -->
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:springmvc.xml</param-value>
    </init-param>
    <load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
    <servlet-name>DispatcherServlet</servlet-name>
    <url-pattern>*.do</url-pattern>
</servlet-mapping>

第四步:配置Controller

图片描述

图片描述

第五步:通过Mybatis的逆向工程生成JavaBean/Mapper

简单点说,就是通过数据库中的单表,自动生成java代码。
Mybatis官方提供了逆向工程
可以针对单表自动生成mybatis代码(mapper.javamapper.xmlmodel类)
企业开发中,逆向工程是个很常用的工具

下载链接
点此链接进行下载

  • 导入jar包,创建generator配置文件
    在classpath下,创建generator.xml文件:(文件内容可以从逆向工程的jar包中docs目录下的index.html中找到相关代码)
    <?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE generatorConfiguration

    PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
    "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">

<generatorConfiguration>

<context id="mysqlTables" targetRuntime="MyBatis3">
    <!--数据库配置-->
    <jdbcConnection driverClass="com.mysql.jdbc.Driver"
                    connectionURL="jdbc:mysql://localhost:3306/mybatisday1"
                    userId="root"
                    password="justin">
    </jdbcConnection>

    <!-- java类型解析 -->
    <javaTypeResolver >
        <property name="forceBigDecimals" value="false" />
    </javaTypeResolver>

    <!-- 模型生成包名-->
    <javaModelGenerator targetPackage="com.justin.backoffice.model" targetProject=".\src">
        <property name="enableSubPackages" value="true" />
        <property name="trimStrings" value="true" />
    </javaModelGenerator>

    <!-- mybatis的映射.xml-->
    <sqlMapGenerator targetPackage="com.justin.backoffice.mapper"  targetProject=".\src">
        <property name="enableSubPackages" value="true" />
    </sqlMapGenerator>

    <!-- mybatis 的mapper接口生成的包路径-->
    <javaClientGenerator type="XMLMAPPER" targetPackage="com.justin.backoffice.mapper"  targetProject=".\src">
        <property name="enableSubPackages" value="true" />
    </javaClientGenerator>

    <!-- 配置生成表的模型-->
    <table tableName="items"/>
    <table tableName="orderdetail" domainObjectName="OrderDetail"></table>
    <table tableName="orders"></table>
    <table tableName="user"></table>
</context>

</generatorConfiguration>

  • 使用java类来执行逆向工程

public class Main {

public static void main(String[] args) throws Exception {
    List<String> warnings = new ArrayList<String>();
    boolean overwrite = true;
    File configFile = new File("src/generator.xml");
    ConfigurationParser cp = new ConfigurationParser(warnings);
    Configuration config = cp.parseConfiguration(configFile);
    DefaultShellCallback callback = new DefaultShellCallback(overwrite);
    MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config,
            callback, warnings);
    myBatisGenerator.generate(null);
}

}

  • 把生成的代码拷贝到项目中
    我是把生成的po类复制到我com.justin.backoffice中的mapper和model中

第六步:修改ItemsMapper.java和ItemsMapper.xml

图片描述
图片描述

第七步:定义Service层接口并实现

图片描述
图片描述

第八步:配置SqlMappingConfig.xml,我这里给它命名为mybatis.xml,放在config资源路径下

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration

    PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
    "http://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>

<!-- 别名配置 -->
<typeAliases>
    <!-- 批量配置别名:指定批量定义别名的类包,别名为类名(首字母大小写都可)-->
    <package name="com.justin.backoffice.model"/>
</typeAliases>
<mappers>
    <!-- 批量加载映射文件 -->
    <package name="com.justin.backoffice.mapper"/>
</mappers>

</configuration>

第九步:创建Spring的applicationContext.xml

  • 配置数据源和mybatis的session工厂

<?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:context="http://www.springframework.org/schema/context"
   xmlns:aop="http://www.springframework.org/schema/aop"
   xmlns:tx="http://www.springframework.org/schema/tx"
   xsi:schemaLocation="http://www.springframework.org/schema/beans
    http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
    http://www.springframework.org/schema/context
    http://www.springframework.org/schema/context/spring-context-3.2.xsd
    http://www.springframework.org/schema/aop
    http://www.springframework.org/schema/aop/spring-aop-3.2.xsd
    http://www.springframework.org/schema/tx
    http://www.springframework.org/schema/tx/spring-tx-3.2.xsd">

</beans>

第十步:配置c3p0数据源和mybatis的会话工厂

<!--1.加载db.properties-->

<context:property-placeholder location="classpath:db.properties"/>

<!--2.配置c3p0数据源-->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
    <property name="driverClass" value="${jdbc.driver}"/>
    <property name="jdbcUrl" value="${jdbc.url}"/>
    <property name="user" value="${jdbc.username}"/>
    <property name="password" value="${jdbc.password}"/>
    <property name="maxPoolSize" value="30"/>
    <property name="minPoolSize" value="2"/>
</bean>

<!--3.配置sessionFactory-->
<bean class="org.mybatis.spring.SqlSessionFactoryBean" id="sqlSessionFactoryBean">
    <property name="dataSource" ref="dataSource"/>
    <!-- 指定配置文件位置 -->
    <property name="configLocation" value="classpath:mybatis.xml"/>
</bean>

<!--4.自动生成dao,mapper-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    <property name="basePackage" value="com.justin.backoffice.mapper"/>
    <property name="sqlSessionFactoryBeanName" value="sqlSessionFactoryBean"/>
</bean>
  • db.properties文件内容,同样是存放在config资源路径下

图片描述

第十一步:web.xml中配置spring容器

<!-- 配置spring -->
<context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>classpath:applicationContext.xml</param-value>
</context-param>
<listener>
    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>

第十二步:在applicationContext.xml中添加bean的注解装配

<!--配置扫描注解-->
<context:component-scan base-package="com.justin.backoffice"/>   

第十三步:ItemsService

图片描述

第十四步:ItemsController

图片描述

第十五步:事务配置(在applicationContext.xml中)

<!-- 5.配置事务管理器 -->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    <property name="dataSource" ref="dataSource"/>
</bean>
<!-- 6.开启事务注解-->
<tx:annotation-driven></tx:annotation-driven>

第十六步:添加一个保存方法测试事务

service:
public void saveOrUpdate(Items items) {

    itemsMapper.insert(items);
}

controller:
@RequestMapping("save")

public String save(){
    //创建商品
    Items items = new Items();
    items.setName("iphonexs");
    items.setPrice(8000.00f);
    items.setCreatetime(new Date());
    items.setDetail("666真好看");
    //保存数据
    itemsService.saveOrUpdate(items);
    return "items/list";
}  
接下来对items这个表数据进行增删改查

显示商品数据

图片描述
package com.justin.backoffice.web.controller;
图片描述
views/items/list.jsp
图片描述

删除商品

service:
public void deleteById(Integer id) {

    itemsMapper.deleteByPrimaryKey(id);
}

controller:
@RequestMapping("delete")

public String delete(Integer id,Model model){
    itemsService.deleteById(id);
    return "forward:list.do";
}

显示编辑商品页面

图片描述
controller:
@RequestMapping("edit")

public String edit(Integer id,Model model){
    System.out.println("id:"+id);
    //通过id找到商品
    Items items = itemsService.findById(id);
    if (items!=null){
        model.addAttribute("items",items);
    }
    return "items/edit";
}

views/items/edit.jsp:
<form id="itemsForm" action="${pageContext.request.contextPath}/items/update.do" method="post">

<table border="1">
    <tr>
        <td>名称</td>
        <td>
            <input type="text" name="name" value="${items.name}"></td>
        <input type="hidden" name="id" value="${items.id}"></td>
    </tr>
    <tr>
        <td>价格</td>
        <td><input type="text" name="price" value="${items.price}"></td>
    </tr>
    <tr>
        <td>描述</td>
        <td><textarea cols="20" rows="5" name="detail">${items.detail}</textarea> </td>
    </tr>
    <tr>
        <td>图片</td>
        <td>
            <img id="pic" src="${items.pic}" width="100px" height="100px">
            <input type="file" name="itemspic1" onchange="submitImage();">
            <input id="hiddenPic" type="hidden" name="pic" value="${items.pic}">
        </td>
    </tr>
    <tr>
        <td colspan="2">
            <input type="submit" value="更新">
        </td>
    </tr>
</table>

</form>

更新商品

需要在页面中隐藏一input标签存id
图片描述
乱码,在web.xml中配置
<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>

controller:
@RequestMapping("update")

public String update(Items items){
    System.out.println(items);
    //设置时间
    items.setCreatetime(new Date());
    itemsService.saveOrUpdate(items);
    return "forward:list.do";
} 

service需要更改一下逻辑:
public void saveOrUpdate(Items items) {

    if (items.getId() == null){
        itemsMapper.insert(items);
    }else{
        itemsMapper.updateByPrimaryKeySelective(items);
    }
}

文件上传

图片描述

  • springmvc.xml配置支持文件上传

    <bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">

       <property name="maxUploadSize" value="20480000"/>

    </bean>

  • views/items/edit.jsp

图片描述
图片描述

后台

package com.justin.backoffice.web.controller;

@Controller
@RequestMapping("upload")
public class UploadController {

/**
 * 商品图片的上传
 */
@RequestMapping("itemspic")
public void itemspic(HttpServletRequest request, HttpServletResponse response) throws Exception {
    //System.out.println(itemspic1);

    System.out.println(request);
    MultipartHttpServletRequest  mutliRequest = (MultipartHttpServletRequest) request;
    //1.获取图片数据
    MultipartFile mfile = mutliRequest.getFile("itemspic1");

    //2.把图片保存在某个路径
    //2.1文件保存的文件夹路径
    String uploadFolder = request.getServletContext().getRealPath("/upload");
    System.out.println("uploadFolder:" + uploadFolder);
    File uploadFolderFile = new File(uploadFolder);
    if(!uploadFolderFile.exists()){
        uploadFolderFile.mkdirs();
    }

    //2.2.文件
    String suffix = mfile.getOriginalFilename().split("\\.")[1];
    String fileName = UUID.randomUUID().toString().replace("-","") + "." + suffix;
    String totalPath = uploadFolder + "\\" + fileName;
    System.out.println("totalpath:" + totalPath);
    FileCopyUtils.copy(mfile.getInputStream(),new FileOutputStream(new File(totalPath)));

    //返回数据给客户端
    String imgURL = "http://localhost:8080/ssm/upload/" + fileName;
    String responseJson = "{\"imgUrl\":\"" + imgURL  + "\"}";
    response.setHeader("content-type","text/json;charset=utf-8");
    response.getWriter().write(responseJson);

}

}
文件上传成功啦,如图:
图片描述

评论

暂无评论