基于SSM架构的CRM系统(一):spring+springmvc+mybatis集成

最新推荐文章于 2023-03-18 08:45:00 发布

置顶 qq_33526760

最新推荐文章于 2023-03-18 08:45:00 发布

阅读量514

点赞数 1

分类专栏： ssm spring springmvc mybatis crm 框架业务文章标签： SSM spring springmvc mybatis crm

本文链接：https://blog.csdn.net/qq_33526760/article/details/94441168

版权

ssm 同时被 3 个专栏收录

4 篇文章 0 订阅

订阅专栏

springmvc

4 篇文章 0 订阅

订阅专栏

crm

4 篇文章 0 订阅

订阅专栏

首先创建一个动态web项目:

然后右键点击webapp文件夹复制项目路径,在tomcat的server.xml里进行配置项目

webapp下面新建index.jsp

然后

开始集成spring+springmvc:
首先导入21个包:

applicationContext.xml:

<!-- 组件扫描-- >
<context:component-scan base-package="com.xxx.ssme" />
<import resource="classpath:applicationContext-mvc.xml" />
</beans>

applicationContext-mvc.xml:

<mvc:default-servlet-handler />

<bean
       class="org.springframework.web.servlet.view.InternalResourceViewResolver">
       
       <property name="prefix" value="/WEB-INF/views/" />
       
       <property name="suffix" value=".jsp" />
   </bean>

web.xml:

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
   xmlns="http://xmlns.jcp.org/xml/ns/javaee"
   xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"
   id="WebApp_ID" version="3.1">
   <display-name>ssme</display-name>
   <welcome-file-list>
       <welcome-file>index.html</welcome-file>
       <welcome-file>index.htm</welcome-file>
       <welcome-file>index.jsp</welcome-file>
       <welcome-file>default.html</welcome-file>
       <welcome-file>default.htm</welcome-file>
       <welcome-file>default.jsp</welcome-file>
   </welcome-file-list>
   
   <filter>
       <filter-name>characterEncoding</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>
       <init-param>
           <param-name>forceEncoding</param-name>
           <param-value>true</param-value>
       </init-param>
   </filter>
   <filter-mapping>
       <filter-name>characterEncoding</filter-name>
       <url-pattern>/*</url-pattern>
   </filter-mapping>
   
   <servlet>
       <servlet-name>springmvc</servlet-name>
       <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
       <load-on-startup>1</load-on-startup>
       <init-param>
           <param-name>contextConfigLocation</param-name>
           <param-value>classpath*:applicationContext.xml</param-value>
       </init-param>
   </servlet>

   <servlet-mapping>
       <servlet-name>springmvc</servlet-name>
       <url-pattern>/</url-pattern>
   </servlet-mapping>
</web-app>

启动项目,能正常启动,这里spring+springmvc就集成好了

然后

集成MyBatis环境:

导入相关的9个jar包(核心包,依赖包,数据库连接包):

框架集成核心

如果你的项目中，用到了Spring框架，那么其他框架主要就是和Spring集成！！

和Spring集成的顺序

1.把当前框架的核心类，交给Spring管理

2.如果框架有事务，那么事务也要统一交给Spring管理

Spring配置文件

applicationContext.xml:

<context:property-placeholder location="classpath:jdbc.properties" />
   
   
   <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
       destroy-method="close">
       
       
       
       <property name="driverClassName" value="${jdbc.driverClassName}" />
       <property name="url" value="${jdbc.url}" />
       <property name="username" value="${jdbc.username}" />
       <property name="password" value="${jdbc.password}" />
       
       <property name="maxActive" value="150" />
       
       <property name="minIdle" value="5" />
       
       <property name="maxIdle" value="20" />
       
       <property name="initialSize" value="30" />
       
       <property name="logAbandoned" value="true" />
       
       <property name="removeAbandoned" value="true" />
       
       <property name="removeAbandonedTimeout" value="10" />
       
       <property name="maxWait" value="1000" />
       
       <property name="timeBetweenEvictionRunsMillis" value="10000" />
       
       <property name="numTestsPerEvictionRun" value="10" />
       
       <property name="minEvictableIdleTimeMillis" value="10000" />
       <property name="validationQuery" value="SELECT NOW() FROM DUAL" />
   </bean>

<!-- SSJ集成时候需要entityManagerFactory

SSM集成时候需要sqlSessionFactory

集成jpa的时候需要一个EntityManagerFactory对象 ->

需要一个FactoryBean来完成功能需要用到SqlSessionFactoryBean

-->
   <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
       
       <property name="dataSource" ref="dataSource" />
       
       <property name="mapperLocations" value="classpath:cn/xxx/ssme/mapper/*Mapper.xml" />
       
       
       
       
       
       
       
       
   </bean>

<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
       <property name="basePackage" value="cn.xxx.ssme.mapper" />
   </bean>

<import resource="classpath:plugins/applicationContext-mvc.xml" />

</beans>

(除了一劳永逸的办法,还有一个办法是Mapperj接口一个一个地配,不采用这种方式:

</bean>

........

</bean>)

jdbc.properties:

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql:///ssme
jdbc.username=root
jdbc.password=admin

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: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.xsd
   http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
   http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc.xsd
">

   
   
   <mvc:default-servlet-handler />
   
   <mvc:annotation-driven />

   
   <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
       <property name="prefix" value="/WEB-INF/views/" /> 
       <property name="suffix" value=".jsp" /> 
   </bean>

   
   <bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
       
       <property name="maxUploadSize">
           
           <value>#{1024*1024*5}</value>
       </property>
   </bean>

</beans>

这里spring+springmvc+mybatis就集成完成了

接下来进行测试:

1.新建数据库ssme,新建表t_user,插入两条数据:

2.写controller层,service层,mapper层(及配置文件)进行测试,(注意:我测试为了方便没用使用service层):

package cn.xxx.ssme.controller;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;

import cn.xxx.ssme.mapper.UserMapper;

UserController :

@Controller
public class UserController {

   @Autowired
   private UserMapper userMapper;

   @RequestMapping("/user/list")
   public String list(Model model){
       System.out.println("9999************");
       model.addAttribute("user", userMapper.getOne(1L));
       model.addAttribute("users", userMapper.getAll());

       return "list";
   }
}

UserMapper :

package cn.xxx.ssme.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Select;

import cn.xxx.ssme.domain.User;

public interface UserMapper {
   @Select("select * from t_user")//这种注解方式不用写sql到xml,不建议这样使用
   List<User> getAll();

   User getOne(Long id);
}

UserMapper.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="cn.xxx.ssme.mapper.UserMapper">

   <select id="getOne" parameterType="long" resultType="cn.xxx.ssme.domain.User">
       select *
       from t_user where id = #{id}
   </select>

</mapper>

list.jsp:

<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
${user}</br>
${users}
</body>
</html>