搭建springmvc+spring+mybatis+IntelliJ IDEA例子

来源:互联网 发布:nginx squid 缓存 编辑:程序博客网 时间:2024/05/16 18:29

首先先看下目录结构:


1.先建好一个大概的项目:

选完后直接next



直接next

直接finish,大概的项目就出来了,接下来就是一些配置文件

2.通过maven导包:

<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/maven-v4_0_0.xsd">    <modelVersion>4.0.0</modelVersion>    <groupId>ssm</groupId>    <artifactId>ssm</artifactId>    <packaging>war</packaging>    <version>1.0-SNAPSHOT</version>    <name>ssm Maven Webapp</name>    <url>http://maven.apache.org</url>    <build>        <plugins>            <plugin>                <groupId>org.mortbay.jetty</groupId>                <artifactId>maven-jetty-plugin</artifactId>                <version>6.1.7</version>                <configuration>                    <connectors>                        <connector implementation="org.mortbay.jetty.nio.SelectChannelConnector">                            <port>8888</port>                            <maxIdleTime>30000</maxIdleTime>                        </connector>                    </connectors>                    <webAppSourceDirectory>${project.build.directory}/${pom.artifactId}-${pom.version}                    </webAppSourceDirectory>                    <contextPath>/</contextPath>                </configuration>            </plugin>        </plugins>    </build>    <properties>        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>        <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>        <!-- spring版本号 -->        <spring.version>4.2.5.RELEASE</spring.version>        <!-- mybatis版本号 -->        <mybatis.version>3.2.8</mybatis.version>        <!-- mysql驱动版本号 -->        <mysql-driver.version>5.1.29</mysql-driver.version>        <!-- log4j日志包版本号 -->        <slf4j.version>1.7.18</slf4j.version>        <log4j.version>1.2.17</log4j.version>    </properties>    <dependencies>        <!-- 添加jstl依赖 -->        <dependency>            <groupId>jstl</groupId>            <artifactId>jstl</artifactId>            <version>1.2</version>        </dependency>        <dependency>            <groupId>javax</groupId>            <artifactId>javaee-api</artifactId>            <version>7.0</version>        </dependency>        <!-- 添加junit4依赖 -->        <dependency>            <groupId>junit</groupId>            <artifactId>junit</artifactId>            <version>4.11</version>            <!-- 指定范围,在测试时才会加载 -->            <scope>test</scope>        </dependency>        <!-- 添加spring核心依赖 -->        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-core</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-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</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-aop</artifactId>            <version>${spring.version}</version>        </dependency>        <dependency>            <groupId>org.springframework</groupId>            <artifactId>spring-test</artifactId>            <version>${spring.version}</version>        </dependency>        <!-- 添加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.2.2</version>        </dependency>        <!-- 添加mysql驱动依赖 -->        <dependency>            <groupId>mysql</groupId>            <artifactId>mysql-connector-java</artifactId>            <version>${mysql-driver.version}</version>        </dependency>        <!-- 添加数据库连接池依赖 -->        <dependency>            <groupId>commons-dbcp</groupId>            <artifactId>commons-dbcp</artifactId>            <version>1.2.2</version>        </dependency>        <!-- 添加fastjson -->        <dependency>            <groupId>com.alibaba</groupId>            <artifactId>fastjson</artifactId>            <version>1.1.41</version>        </dependency>        <!-- 添加日志相关jar包 -->        <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 -->        <!-- 映入JSON -->        <dependency>            <groupId>org.codehaus.jackson</groupId>            <artifactId>jackson-mapper-asl</artifactId>            <version>1.9.13</version>        </dependency>        <!-- https://mvnrepository.com/artifact/com.fasterxml.jackson.core/jackson-core -->        <dependency>            <groupId>com.fasterxml.jackson.core</groupId>            <artifactId>jackson-core</artifactId>            <version>2.8.0</version>        </dependency>        <!-- https://mvnrepository.com/artifact/com.fasterxml.jackson.core/jackson-databind -->        <dependency>            <groupId>com.fasterxml.jackson.core</groupId>            <artifactId>jackson-databind</artifactId>            <version>2.8.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>    </dependencies></project>

3.配置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:mvc="http://www.springframework.org/schema/mvc"       xsi:schemaLocation="http://www.springframework.org/schema/beans                        http://www.springframework.org/schema/beans/spring-beans-4.0.xsd                        http://www.springframework.org/schema/context                        http://www.springframework.org/schema/context/spring-context-4.0.xsd                        http://www.springframework.org/schema/mvc                        http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">    <!-- 配置自动扫描的包 -->    <context:component-scan base-package="com.great" use-default-filters="false">        <context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/>        <context:include-filter type="annotation" expression="org.springframework.web.bind.annotation.ControllerAdvice"/>    </context:component-scan>    <!-- 自动扫描  @Controller-->    <!--<context:component-scan base-package="com.great.controller"/>-->    <!-- 配置视图解析器 -->    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">        <property name="prefix" value="/WEB-INF/views/"/>        <property name="suffix" value=".jsp"/>    </bean>    <!--访问静态资源 例如 http://localhost:8080/views/index.html-->    <mvc:resources mapping="/views/**" location="/WEB-INF/views/" />    <!--配置默认页-->    <mvc:view-controller path="/" view-name="index"/>    <!-- 添加后可以显示welcome-file界面 -->    <mvc:default-servlet-handler/>    <!-- 启动注解 -->    <mvc:annotation-driven />    <!-- 启动SpringMVC的注解功能,完成请求和注解POJO的映射 -->    <bean class="org.springframework.web.servlet.view.ContentNegotiatingViewResolver">        <property name="order" value="1"/>        <property name="defaultViews">            <list>                <!-- JSON View -->                <bean class="org.springframework.web.servlet.view.json.MappingJackson2JsonView">                </bean>            </list>        </property>    </bean>    <!--避免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>    <!-- 配置 MultipartResolver 文件上传-->    <bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">        <property name="defaultEncoding" value="UTF-8"/>        <property name="maxUploadSize" value="1024000000"/>    </bean>    <!-- SpringMVC在超出上传文件限制时,会抛出org.springframework.web.multipart.MaxUploadSizeExceededException -->    <!-- 该异常是SpringMVC在检查上传的文件信息时抛出来的,而且此时还没有进入到Controller方法中 -->    <bean id="exceptionResolver" class="org.springframework.web.servlet.handler.SimpleMappingExceptionResolver">        <property name="exceptionMappings">            <props>                <!-- 遇到MaxUploadSizeExceededException异常时,自动跳转到/WEB-INF/jsp/error_fileupload.jsp页面 -->                <prop key="org.springframework.web.multipart.MaxUploadSizeExceededException">error_fileupload</prop>            </props>        </property>    </bean></beans>

4.先配置jdbc.propertes数据库连接信息

driverClasss=com.mysql.jdbc.DriverjdbcUrl=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNullusername=rootpassword=root#初始化连接大小initialSize=0#连接池最大数量maxActive=20#连接池最大空闲maxIdle=20#连接池最小空闲minIdle=1#连接最大等待时间maxWait=60000

5.配置spring和mybatis的联系,spring-mabatis:

<?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:tx="http://www.springframework.org/schema/tx"       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/tx                        http://www.springframework.org/schema/tx/spring-tx.xsd">    <!-- 自动扫描 -->    <context:component-scan base-package="com.great"/>    <!-- 第一种方式:加载一个properties文件 -->    <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">        <property name="location" value="classpath:jdbc.properties"/>    </bean>    <!-- 配置数据源 -->    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"          destroy-method="close">        <property name="driverClassName" value="${driverClasss}"/>        <property name="url" value="${jdbcUrl}"/>        <property name="username" value="${username}"/>        <property name="password" value="${password}"/>        <!-- 初始化连接大小 -->        <property name="initialSize" value="${initialSize}"/>        <!-- 连接池最大数量 -->        <property name="maxActive" value="${maxActive}"/>        <!-- 连接池最大空闲 -->        <property name="maxIdle" value="${maxIdle}"/>        <!-- 连接池最小空闲 -->        <property name="minIdle" value="${minIdle}"/>        <!-- 获取连接最大等待时间 -->        <property name="maxWait" value="${maxWait}"/>    </bean>    <!-- mybatis和spring完美整合,不需要mybatis的配置映射文件 -->    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">        <property name="dataSource" ref="dataSource"/>        <!-- 自动扫描mapping.xml文件 -->        <property name="mapperLocations" value="classpath:mapping/*.xml"/>    </bean>    <!-- DAO接口所在包名,Spring会自动查找其下的类 -->    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">        <property name="basePackage" value="com.great.mapper"/>        <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>    <!-- (事务管理)transaction manager, use JtaTransactionManager for global tx -->    <tx:annotation-driven transaction-manager="transactionManager"/></beans>

6.还有一个日志属性log4j.properties:

log4j.rootLogger=INFO,Console,File#控制台日志log4j.appender.Console=org.apache.log4j.ConsoleAppenderlog4j.appender.Console.Target=System.outlog4j.appender.Console.layout=org.apache.log4j.PatternLayoutlog4j.appender.Console.layout.ConversionPattern=[%p][%t][%d{yyyy-MM-dd HH\:mm\:ss}][%C] - %m%n#普通文件日志log4j.appender.File=org.apache.log4j.RollingFileAppenderlog4j.appender.File.File=logs/ssm.loglog4j.appender.File.MaxFileSize=10MB#输出日志,如果换成DEBUG表示输出DEBUG以上级别日志log4j.appender.File.Threshold=ALLlog4j.appender.File.layout=org.apache.log4j.PatternLayoutlog4j.appender.File.layout.ConversionPattern=[%p][%t][%d{yyyy-MM-dd HH\:mm\:ss}][%C] - %m%n

7.现在就是写一个测试类了

model

package com.great.model;/** * 部门表实体类 */public class Dept {    //部门编号 主键    private String id;    //部门编码    private String code;    //部门名称    private String name;    public String getId() {        return id;    }    public void setId(String id) {        this.id = id;    }    public String getCode() {        return code;    }    public void setCode(String code) {        this.code = code;    }    public String getName() {        return name;    }    public void setName(String name) {        this.name = name;    }}

mapping映射:dept.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.great.mapper.DeptMapper">    <resultMap id="deptMap" type="com.great.model.Dept">        <id property="id" column="id" />        <result property="name" column="name"/>    </resultMap>    <select id="selectAllDept" resultType="com.great.model.Dept">         SELECT * FROM dept    </select>    <insert id="createDept" parameterType="com.great.model.Dept">        INSERT INTO dept VALUES (#{id},#{name},#{code})    </insert>    <update id="updateDept" parameterType="java.util.Map">        UPDATE dept SET name = #{name} WHERE id=#{id}    </update>    <select id="selectDept" resultType="com.great.model.Dept" parameterType="java.lang.String">        SELECT * FROM dept WHERE id=#{id}    </select></mapper>

DeptMapper.java

package com.great.mapper;import com.great.model.Dept;import org.springframework.stereotype.Repository;import java.util.List;import java.util.Map;@Repositorypublic interface DeptMapper {    List<Dept> selectAllDept();    void createDept(Dept dept);    void updateDept(Map<String,String> map);    Dept selectDept(String id);}

DeptService.java

package com.great.service;import com.great.model.Dept;import java.util.List;import java.util.Map;public interface DeptService {    public List<Dept> selectAllDept();    public void createDept(Dept dept);    public void updateDept(Map<String,String> map);    public Dept selectDept(String id);}

DeptServiceImp.java

package com.great.service.imp;import com.great.mapper.DeptMapper;import com.great.model.Dept;import com.great.service.DeptService;import org.springframework.stereotype.Service;import javax.annotation.Resource;import java.util.List;import java.util.Map;@Servicepublic class DeptServiceImp implements DeptService {    @Resource    private DeptMapper deptMapper;    public List<Dept> selectAllDept() {        return deptMapper.selectAllDept();    }    public void createDept(Dept dept) {        deptMapper.createDept(dept);    }    public void updateDept(Map<String, String> map) {        deptMapper.updateDept(map);    }    public Dept selectDept(String id) {        return deptMapper.selectDept(id);    }}

DeptController.java,使用的是假数据

package com.great.controller;import com.great.model.Dept;import com.great.service.imp.DeptServiceImp;import org.springframework.stereotype.Controller;import org.springframework.web.bind.annotation.PathVariable;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.RequestMethod;import org.springframework.web.bind.annotation.ResponseBody;import org.springframework.web.servlet.ModelAndView;import javax.annotation.Resource;import java.util.HashMap;import java.util.List;import java.util.Map;@Controller@RequestMapping("/test")public class DeptController {    @Resource    private DeptServiceImp deptServiceImp;    @RequestMapping(value = "/all", method = RequestMethod.GET)    @ResponseBody    public List<Dept> selectAllDept() {        List<Dept> deptList = deptServiceImp.selectAllDept();        System.out.println(deptList);        return deptList;    }    @RequestMapping(value = "/into", method = RequestMethod.GET)    public void create() {        List<Dept> deptList = deptServiceImp.selectAllDept();        Dept dept = new Dept();        dept.setCode("cccc");        dept.setId("aaaa");        dept.setName("bbbb");        deptServiceImp.createDept(dept);        System.out.println(deptList);    }    @RequestMapping(value = "/update", method = RequestMethod.GET)    public void update(){        Map<String,String> map = new HashMap<String, String>();        map.put("id","aa");        map.put("name","gggg");        deptServiceImp.updateDept(map);    }    @RequestMapping(value = "/get/{id}", method = RequestMethod.GET)    public ModelAndView getDept(@PathVariable("id")String id){        Dept dept = deptServiceImp.selectDept(id);        ModelAndView modelAndView = new ModelAndView("test");        modelAndView.addObject(dept);        return modelAndView;    }    @RequestMapping(value = "/go", method = RequestMethod.GET)    public ModelAndView getDept(){        return new ModelAndView("test");    }}


访问路径:点击打开链接
到这里就基本结束了,前端页面了



阅读全文
0 0