ssm三大框架整合基本配置

maven目录结构

数据库脚本mysql

create database maven;

use maven

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------

-- Table structure for `items`

-- ----------------------------

DROP TABLE IF EXISTS `items`;

CREATE TABLE `items` (

  `id` int(10) NOT NULL auto_increment,

  `name` varchar(20) default NULL,

  `price` float(10,0) default NULL,

  `pic` varchar(40) default NULL,

  `createtime` datetime default NULL,

  `detail` varchar(200) default NULL,

  PRIMARY KEY  (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- ----------------------------

-- Records of items

-- ----------------------------

INSERT INTO `items` VALUES ('', '小宝', '', null, '2018-03-13 09:29:30', '带我走上人生巅峰');

INSERT INTO `items` VALUES ('', '张三', null, null, '2018-03-28 10:05:52', '插入测试');

INSERT INTO `items` VALUES ('', '李四', '', null, '2018-03-07 10:08:04', '插入测试');

INSERT INTO `items` VALUES ('', '王五', null, null, null, null);

INSERT INTO `items` VALUES ('', '呵呵', null, null, null, null);

pom.xml坐标

<!-- 统一管理jar包版本 -->

  <properties>

    <spring.version>5.0.2.RELEASE</spring.version>

    <slf4j.version>1.6.6</slf4j.version>

    <log4j.version>1.2.12</log4j.version>

    <shiro.version>1.2.3</shiro.version>

    <mysql.version>5.1.6</mysql.version>

    <mybatis.version>3.4.5</mybatis.version>

    <spring.security.version>5.0.1.RELEASE</spring.security.version>

  </properties>

  <!-- 锁定jar包版本 -->

  <dependencyManagement>

    <dependencies>

      <dependency>

        <groupId>org.springframework</groupId>

        <artifactId>spring-context</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-webmvc</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-test</artifactId>

        <version>${spring.version}</version>

      </dependency>

      <dependency>

        <groupId>org.mybatis</groupId>

        <artifactId>mybatis</artifactId>

        <version>${mybatis.version}</version>

      </dependency>

    </dependencies>

  </dependencyManagement>

  <!-- 项目依赖jar包 -->

  <dependencies>

    <!-- spring -->

    <dependency>

      <groupId>org.aspectj</groupId>

      <artifactId>aspectjweaver</artifactId>

      <version>1.6.8</version>

    </dependency>

    <dependency>

      <groupId>org.springframework</groupId>

      <artifactId>spring-aop</artifactId>

      <version>${spring.version}</version>

    </dependency>

    <dependency>

      <groupId>org.springframework</groupId>

      <artifactId>spring-context</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-web</artifactId>

      <version>${spring.version}</version>

    </dependency>

    <dependency>

      <groupId>org.springframework</groupId>

      <artifactId>spring-orm</artifactId>

      <version>${spring.version}</version>

    </dependency>

    <dependency>

      <groupId>org.springframework</groupId>

      <artifactId>spring-beans</artifactId>

      <version>${spring.version}</version>

    </dependency>

    <dependency>

      <groupId>org.springframework</groupId>

      <artifactId>spring-core</artifactId>

      <version>${spring.version}</version>

    </dependency>

    <dependency>

      <groupId>org.springframework</groupId>

      <artifactId>spring-test</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-tx</artifactId>

      <version>${spring.version}</version>

    </dependency>

    <dependency>

      <groupId>junit</groupId>

      <artifactId>junit</artifactId>

      <version>4.12</version>

      <scope>test</scope>

    </dependency>

    <dependency>

      <groupId>mysql</groupId>

      <artifactId>mysql-connector-java</artifactId>

      <version>${mysql.version}</version>

    </dependency>

    <dependency>

      <groupId>javax.servlet</groupId>

      <artifactId>javax.servlet-api</artifactId>

      <version>3.1.0</version>

      <scope>provided</scope>

    </dependency>

    <dependency>

      <groupId>javax.servlet.jsp</groupId>

      <artifactId>jsp-api</artifactId>

      <version>2.0</version>

      <scope>provided</scope>

    </dependency>

    <dependency>

      <groupId>jstl</groupId>

      <artifactId>jstl</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 -->

    <dependency>

      <groupId>org.mybatis</groupId>

      <artifactId>mybatis</artifactId>

      <version>${mybatis.version}</version>

    </dependency>

    <dependency>

      <groupId>org.mybatis</groupId>

      <artifactId>mybatis-spring</artifactId>

      <version>1.3.0</version>

    </dependency>

    <dependency>

      <groupId>c3p0</groupId>

      <artifactId>c3p0</artifactId>

      <version>0.9.1.2</version>

      <type>jar</type>

      <scope>compile</scope>

    </dependency>

    <dependency>

      <groupId>com.github.pagehelper</groupId>

      <artifactId>pagehelper</artifactId>

      <version>5.1.2</version>

    </dependency>

    <dependency>

      <groupId>org.springframework.security</groupId>

      <artifactId>spring-security-web</artifactId>

      <version>${spring.security.version}</version>

    </dependency>

    <dependency>

      <groupId>org.springframework.security</groupId>

      <artifactId>spring-security-config</artifactId>

      <version>${spring.security.version}</version>

    </dependency>

    <dependency>

      <groupId>org.springframework.security</groupId>

      <artifactId>spring-security-core</artifactId>

      <version>${spring.security.version}</version>

    </dependency>

    <dependency>

      <groupId>org.springframework.security</groupId>

      <artifactId>spring-security-taglibs</artifactId>

      <version>${spring.security.version}</version>

    </dependency>

    <dependency>

      <groupId>com.alibaba</groupId>

      <artifactId>druid</artifactId>

      <version>1.0.9</version>

    </dependency>

  </dependencies>

  <!-- 添加tomcat7插件 -->

  <build>

    <plugins>

      <plugin>

        <groupId>org.apache.tomcat.maven</groupId>

        <artifactId>tomcat7-maven-plugin</artifactId>

        <version>2.2</version>

      </plugin>

    </plugins>

  </build>

实体类Items

public class Items {

    private Integer id;

    private String name;

    private Float price;

    private String pic;

    private Date createtime;

    private String detail;

    public Integer getId() {

        return id;

    }

    public void setId(Integer id) {

        this.id = id;

    }

    public String getName() {

        return name;

    }

    public void setName(String name) {

        this.name = name;

    }

    public Float getPrice() {

        return price;

    }

    public void setPrice(Float price) {

        this.price = price;

    }

    public String getPic() {

        return pic;

    }

    public void setPic(String pic) {

        this.pic = pic;

    }

    public Date getCreatetime() {

        return createtime;

    }

    public void setCreatetime(Date createtime) {

        this.createtime = createtime;

    }

    public String getDetail() {

        return detail;

    }

    public void setDetail(String detail) {

        this.detail = detail;

    }

}

mapper层,ItemsMapper

public interface ItemsMapper {

    Items findDetail(Integer id);

}

mapper配置文件,ItemsMapper.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.maven.mapper.ItemsMapper">

    <select id="findDetail" parameterType="integer" resultType="com.maven.domain.Items">

        select * from items where id = #{id}

    </select>

</mapper>

jdbc.properties

jdbc.driver=com.mysql.jdbc.Driver

jdbc.url=jdbc:mysql:///maven

jdbc.username=root

jdbc.password=root

mybatis和spring配置文件在一起

<?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"

       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/aop

                http://www.springframework.org/schema/aop/spring-aop.xsd

                http://www.springframework.org/schema/tx

                http://www.springframework.org/schema/tx/spring-tx.xsd

                http://www.springframework.org/schema/mvc

                http://www.springframework.org/schema/mvc/spring-mvc.xsd">

    <!--mybatis配置开始-->

    <!--加载properties文件-->

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

    <!--配置连接池-->

    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">

        <property name="driverClassName" value="${jdbc.driver}"/>

        <property name="url" value="${jdbc.url}"/>

        <property name="username" value="${jdbc.username}"/>

        <property name="password" value="${jdbc.password}"/>

    </bean>

    <!--配置连接工厂-->

    <bean id="sqlSessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">

        <property name="dataSource" ref="dataSource"/>

        <!--为mapper起别名-->

        <property name="typeAliasesPackage" value="com.maven.domain"/>

    </bean>

    <!--扫描接口包,生成包下接口的所有代理对象,并且放入spring容器中-->

    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">

        <property name="basePackage" value="com.maven.mapper"/>

    </bean>

    <!--mybatis配置结束-->

    <!--spring配置文件开始-->

    <!--配置组件扫描-->

    <context:component-scan base-package="com.maven.service"/>

    <!--配置事务管理器,AOP面向切面编程, 切面=切入点+通知-->

    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">

        <!--事务的控制,也需要数据源的注入-->

        <property name="dataSource" ref="dataSource"/>

    </bean>

    <!--配置事务通知-->

    <tx:advice id="advice">

        <tx:attributes>

            <tx:method name="save*" propagation="REQUIRED"/>

            <tx:method name="update*" propagation="REQUIRED"/>

            <tx:method name="delete*" propagation="REQUIRED"/>

            <tx:method name="find*" read-only="true"/>

            <tx:method name="*" propagation="REQUIRED"/>

        </tx:attributes>

    </tx:advice>

    <!--配置切入点-->

    <aop:config>

        <aop:pointcut id="pointcut" expression="execution(* com.maven.service.impl.*.*(..))"/>

        <aop:advisor advice-ref="advice" pointcut-ref="pointcut"/>

    </aop:config>

    <!--spring配置文件结束-->

</beans>

log4j

# Set root category priority to INFO and its only appender to CONSOLE.

#log4j.rootCategory=INFO, CONSOLE            debug   info   warn error fatal

log4j.rootCategory=debug, CONSOLE, LOGFILE

# Set the enterprise logger category to FATAL and its only appender to CONSOLE.

log4j.logger.org.apache.axis.enterprise=FATAL, CONSOLE

# CONSOLE is set to be a ConsoleAppender using a PatternLayout.

log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender

log4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayout

log4j.appender.CONSOLE.layout.ConversionPattern=%d{ISO8601} %-6r [%15.15t] %-5p %30.30c %x - %m\n

# LOGFILE is set to be a File appender using a PatternLayout.

log4j.appender.LOGFILE=org.apache.log4j.FileAppender

log4j.appender.LOGFILE.File=d:\axis.log

log4j.appender.LOGFILE.Append=true

log4j.appender.LOGFILE.layout=org.apache.log4j.PatternLayout

log4j.appender.LOGFILE.layout.ConversionPattern=%d{ISO8601} %-6r [%15.15t] %-5p %30.30c %x - %m\n

service接口

public interface ItemsService {

    Items findDetail(Integer id);

}

service实现类

@Service

public class ItemsServiceImpl implements ItemsService {

    @Autowired

    private ItemsMapper itemsMapper;

    public Items findDetail(Integer id) {

        Items items = itemsMapper.findDetail(id);

        return items;

    }

}

  • service层的配置文件就是applicationContext.xml

  • controller层　　

@Controller

@RequestMapping("/items")

public class ItemsController {

    @Autowired

    private ItemsService itemsService;

    @RequestMapping("/findDetail")

    public String findDetail(Model model){

        Items items = itemsService.findDetail(1);

        model.addAttribute("item",items);

        return "itemDetail";

    }

}

controller层的spring-mvc配置文件

<?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"

       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/aop

                http://www.springframework.org/schema/aop/spring-aop.xsd

                http://www.springframework.org/schema/tx

                http://www.springframework.org/schema/tx/spring-tx.xsd

                http://www.springframework.org/schema/mvc

                http://www.springframework.org/schema/mvc/spring-mvc.xsd">

    <!--配置组件扫描-->

    <context:component-scan base-package="com.maven.controller"/>

    <!--配置处理器,映射器-->

    <mvc:annotation-driven/>

    <!--配置视图解析器-->

    <bean id="internalResourceViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">

        <property name="prefix" value="/WEB-INF/pages/"/>

        <property name="suffix" value=".jsp"/>

    </bean>

    <!--释放静态资源-->

    <mvc:default-servlet-handler/>

</beans>

jsp页面

<%@ page language="java" contentType="text/html; charset=UTF-8"

    pageEncoding="UTF-8"%>

<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>

<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt"  prefix="fmt"%>    

<!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>

    <form>

        <table width="100%" border=1>

            <tr>

                <td>商品名称</td>

                <td> ${item.name } </td>

            </tr>

            <tr>

                <td>商品价格</td>

                <td> ${item.price } </td>

            </tr>

            <tr>

                <td>生成日期</td>

                <td> <fmt:formatDate value="${item.createtime}" pattern="yyyy-MM-dd HH:mm:ss"/> </td>

            </tr>

            <tr>

                <td>商品简介</td>

                <td>${item.detail} </td>

            </tr>

        </table>

    </form>

</body>

</html>

web.xml配置文件

<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>

  <!--配置编码过滤器-->

  <filter>

    <filter-name>encoding</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>encoding</filter-name>

    <url-pattern>/*</url-pattern>

  </filter-mapping>

  <!--配置spring核心文件监听器-->

  <listener>

    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>

  </listener>

  <!--重新制定配置文件的路径-->

  <context-param>

    <param-name>contextConfigLocation</param-name>

    <param-value>classpath:applicationContext.xml</param-value>

  </context-param>

  <!--springMvc的核心servlet-->

  <servlet>

    <servlet-name>springMvc</servlet-name>

    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>

    <init-param>

      <param-name>contextConfigLocation</param-name>

      <param-value>classpath:spring-mvc.xml</param-value>

    </init-param>

    <load-on-startup>1</load-on-startup>

  </servlet>

  <servlet-mapping>

    <servlet-name>springMvc</servlet-name>

    <url-pattern>/</url-pattern>

  </servlet-mapping>

</web-app>

测试文件

public class MybatisTest {

    @Test   //测试mybatis的环境是否正确

    public void myBatisTest(){

        ApplicationContext app = new ClassPathXmlApplicationContext("applicationContext.xml");

        ItemsMapper itemsMapper = app.getBean(ItemsMapper.class);

        Items items = itemsMapper.findDetail(1);

        System.out.println(items.getName());

    }

}
public class SpringTest {

    @Test

    public void springTest(){

        ApplicationContext app = new ClassPathXmlApplicationContext("applicationContext.xml");

        ItemsService itemsService = app.getBean(ItemsService.class);

        Items items = itemsService.findDetail(1);

        System.out.println(items.getName());

    }

}

最新文章

  1. 如何在select下拉列表中添加复选框?
  2. 10分钟制作UWP汉堡菜单
  3. [转载] poll()函数
  4. 关闭程序 提示 C#
  5. fragment的入门DEMO
  6. FLASH图片上传功能—从百度编辑器UEditor里面提取出来
  7. 【LeetCode题意分析&amp;解答】42. Trapping Rain Water
  8. 在VS中配置并测试opencv
  9. [UWP小白日记-2]SQLite数据库DOME
  10. [MyBatis]mapperLocations属性通配符的使用
  11. 【Mybatis】 JdbcType 与 JavaType对应关系
  12. [Swift]LeetCode75. 颜色分类 | Sort Colors
  13. 发布网站配置IIS（把网上找到的解决方法综合了一下）
  14. java httpclient post xml demo
  15. 实验一：C++简单程序设计
  16. vsto-Word相关操作
  17. frame嵌套页面元素的定位
  18. 如何在 CentOS 7 中安装、配置和安全加固 FTP 服务
  19. 【黑金ZYNQ7000系列原创视频教程】02.视频接口&mdash;&mdash;hdmi编码输出实验
  20. HRBUST1311 火影忍者之～忍者村 2017-03-06 16:06 106人阅读 评论(0) 收藏

热门文章

  1. Mybatis精讲(一)---环境配置及架构梳理
  2. 自动任务调度 - Timer
  3. C#索引器与数组的区别
  4. nyoj 82-迷宫寻宝（一） (多重BFS)
  5. .NET Core 获取数据库上下文实例的方法和配置连接字符串
  6. ES6入门十二：Module（模块化）
  7. Python 函数知识点整理
  8. 你必须知道的容器日志 (2) 开源日志管理方案 ELK
  9. 官网例子，mt-field password获取不到
  10. 源码包的安装、rsync同步、inotify监测