springmvc+mybatis很经典的例子

r囧r小猫 2022-07-18 05:14 135阅读 0赞

# springMVC+mybatis框架搭建 #

首先我们先要弄清搭建项目的一般流程，需要注意哪些方面，想要什么样的效果，自己的功能有哪些？

（假设效果：项目目录结构清晰，能够查询到本地数据库中的内容。。）

## 1.  工程目录结构整理清楚 ##

在src/main/java文件夹中，新建包cn.springmvc.model(存放javabean),

cn.springmvc.dao（存放spring与mybatis连接接口）,

cn.springmvc.service（service接口）,

cn.springmvc.service.impl（service接口的实现），

cn.springmvc.controller（存放控制层controller）

在src/main/resource文件夹中，新建包conf（存放配置文件），

mapper（mybatis的mapper文件）

在src/test/java文件夹中，新建包cn.springmvc.test(存放测试文件)

在WEB-INF文件夹下新建jsp文件夹（存放jsp文件）

这样项目结构基本完成了

## 2.  引入依赖包 ##

打开maven的pom文件，对本次开发所需使用的架包依次导入（maven项目管理的优势）

查找依赖结构有个不错的网站，[http://search.maven.org/][http_search.maven.org]   只要输入包名即可查找引来关系

pom.xml(包依赖)

<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>eyas.springmvc</groupId>
    	<artifactId>springmvc</artifactId>
    	<packaging>war</packaging>
    	<version>0.0.1-SNAPSHOT</version>
    	<name>springmvc Maven Webapp</name>
    	<url>http://maven.apache.org</url>
    	<properties>
    		
    		<spring.version>3.2.4.RELEASE</spring.version>
    		
    		<mybatis.version>3.2.4</mybatis.version>
    		
    		<slf4j.version>1.6.6</slf4j.version>
    		<log4j.version>1.2.9</log4j.version>
    	</properties>
    	<dependencies>
    		
    		
    		<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-aop</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>
    		
    
    		
    		<dependency>
    			<groupId>org.mybatis</groupId>
    			<artifactId>mybatis</artifactId>
    			<version>${mybatis.version}</version>
    		</dependency>
    		
    		<dependency>
    			<groupId>org.mybatis</groupId>
    			<artifactId>mybatis-spring</artifactId>
    			<version>1.2.2</version>
    		</dependency>
    		
    		<dependency>
    			<groupId>mysql</groupId>
    			<artifactId>mysql-connector-java</artifactId>
    			<version>5.1.29</version>
    		</dependency>
    		
    		<dependency>
    			<groupId>junit</groupId>
    			<artifactId>junit</artifactId>
    			<version>4.11</version>
    			<scope>test</scope>
    		</dependency>
    		
    		<dependency>
    			<groupId>com.alibaba</groupId>
    			<artifactId>druid</artifactId>
    			<version>1.0.2</version>
    		</dependency>
    
    		
    		<dependency>
    			<groupId>org.codehaus.jackson</groupId>
    			<artifactId>jackson-mapper-asl</artifactId>
    			<version>1.9.13</version>
    		</dependency>
    
    		
    		
    		<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>
    		
    	</dependencies>
    	<build>
    		<finalName>springmvc</finalName>
    	</build>
    </project>

## 3. 配置数据库连接属性 ##

conf/ jdbc.properties（jdbc配置文件)

jdbc_driverClassName=com.mysql.jdbc.Driver
    jdbc_url=jdbc:mysql://localhost:3306/mydays?useUnicode=true&characterEncoding=utf-8
    jdbc_username=root
    jdbc_password=root

## 4.  配置spring配置文件 ##

conf/spring.xml(spring配置文件的扫描)

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans"
     xmlns:context="http://www.springframework.org/schema/context"
     xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
     xsi:schemaLocation="http://www.springframework.org/schema/beans
          http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
          http://www.springframework.org/schema/context
          http://www.springframework.org/schema/context/spring-context.xsd">
    
        
        <context:property-placeholder location="classpath:conf/jdbc.properties"/>
        
        
        <context:component-scan base-package="cn.springmvc.service"/>
    </beans>

conf/spring-mybatis.xml（spring与mybatis连接属性）

<?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:aop="http://www.springframework.org/schema/aop"
      xmlns:tx="http://www.springframework.org/schema/tx"
      xmlns:util="http://www.springframework.org/schema/util"
      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/tx
        http://www.springframework.org/schema/tx/spring-tx-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/util 
        http://www.springframework.org/schema/util/spring-util-3.2.xsd">
    
        <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init"
        destroy-method="close" >
        <property name="driverClassName">
          <value>${jdbc_driverClassName}</value>
        </property>
        <property name="url">
          <value>${jdbc_url}</value>
        </property>
        <property name="username">
          <value>${jdbc_username}</value>
        </property>
        <property name="password">
          <value>${jdbc_password}</value>
        </property>
        
        <property name="maxActive">
          <value>20</value>
        </property>
        
        <property name="initialSize">
          <value>1</value>
        </property>
        
        <property name="maxWait">
          <value>60000</value>
        </property>
        
        <property name="maxIdle">
          <value>20</value>
        </property>
        
        <property name="minIdle">
          <value>3</value>
        </property>
        
        <property name="removeAbandoned">
          <value>true</value>
        </property>
        
        <property name="removeAbandonedTimeout">
          <value>180</value>
        </property>
        
        <property name="connectionProperties">
          <value>clientEncoding=UTF-8</value>
        </property>
      </bean>
        
        
          <bean id="sqlSessionFactory"
              class="org.mybatis.spring.SqlSessionFactoryBean"
              p:dataSource-ref="dataSource"
              p:configLocation="classpath:conf/mybatis-config.xml"
              p:mapperLocations="classpath:mapper/*.xml"/>
          
       
     <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"
            p:basePackage="cn.springmvc.dao" 
            p:sqlSessionFactoryBeanName="sqlSessionFactory"/>
     
       
      <bean id="transactionManager" 
            class="org.springframework.jdbc.datasource.DataSourceTransactionManager"
            p:dataSource-ref="dataSource"/>
    </beans>

## 5.  java代码编写（model，dao，service层代码） ##

cn.springmvc.model/User.java(用户基本信息)

package cn.springmvc.model;
    
    
    /**
     * 用户表
     */
    public class User {
    
    	private int id;
    	private int state;
    	private String nickname;
    	public int getId() {
    		return id;
    	}
    	public void setId(int id) {
    		this.id = id;
    	}
    	public int getState() {
    		return state;
    	}
    	public void setState(int state) {
    		this.state = state;
    	}
    	public String getNickname() {
    		return nickname;
    	}
    	public void setNickname(String nickname) {
    		this.nickname = nickname;
    	}
    }

cn.springmvc.dao/UserDAO.java(dao操作接口)

package cn.springmvc.dao;
    
    import cn.springmvc.model.User;
    
    
    public interface UserDAO {
    
    	/**
    	 * 添加新用户
    	 * @param user
    	 * @return
    	 */
    	public int insertUser(User user);
    	
    	
    }

cn.springmvc.service/UserService.java(service层接口)

package cn.springmvc.service;
    
    import cn.springmvc.model.User;
    
    
    public interface UserService {
    
    	public int insertUser(User user);
    }

cn.springmvc.service.impl/UserServiceImpl.java(service层接口实现)

package cn.springmvc.service.impl;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    import cn.springmvc.dao.UserDAO;
    import cn.springmvc.model.User;
    import cn.springmvc.service.UserService;
    
    
    @Service
    public class UserServiceImpl implements UserService{
    
    	@Autowired
    	private UserDAO userDAO;
    	
    	@Override
    	public int insertUser(User user) {
    		// TODO Auto-generated method stub
    		return userDAO.insertUser(user);
    	}
    
    }

## 6.  mybatis配置 ##

conf/mybatis-config.xml(mybatis配置的基本文件)

<?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>
             <typeAlias alias="User" type="cn.springmvc.model.User"/> 
        </typeAliases>
    
        
        <mappers>
        </mappers>
    </configuration>

mapper/UserMapper.xml(mybatis的实现)

<?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.springmvc.dao.UserDAO">
               
             <insert id="insertUser" parameterType="User" keyProperty="id">
                 insert into days_user(  
             state,
             nickname) 
             values 
             (        
             #{state},
             #{nickname})
             </insert>
             
    </mapper>

这样就完成了基本插入用户的功能！

## 7.  junit测试插入功能 ##

cn.springmvc.test/UserTest.java(用户测试模块)

package cn.springmvc.test;
    
    import org.junit.Before;
    import org.junit.Test;
    import org.springframework.context.ApplicationContext;
    import org.springframework.context.support.ClassPathXmlApplicationContext;
    
    import cn.springmvc.model.User;
    import cn.springmvc.service.UserService;
    
    
    
    public class UserTest {
    
    private UserService userService;
    	
    	@Before
    	public void before(){                                                                    
    		@SuppressWarnings("resource")
    		ApplicationContext context = new ClassPathXmlApplicationContext(new String[]{"classpath:conf/spring.xml"
    				,"classpath:conf/spring-mybatis.xml"});
    		userService = (UserService) context.getBean("userServiceImpl");
    	}
    	
    	@Test
    	public void addUser(){
    		User user = new User();
    		user.setNickname("你好");
    		user.setState(2);
    		System.out.println(userService.insertUser(user));
    	}
    }

测试结果如图：

![maven+springMVC+mybatis+junit详细搭建过程][maven_springMVC_mybatis_junit]

即完成插入功能！

## 8.  springMVC模块搭建  ##

web.xml（web功能配置）

<?xml version="1.0" encoding="UTF-8"?>
    <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    	xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
    	xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
    	id="WebApp_ID" version="2.5">
    	<display-name>Archetype Created Web Application</display-name>
    
    	
    	<context-param>
    		<param-name>contextConfigLocation</param-name>
    		<param-value>classpath:conf/spring.xml;
    			classpath:conf/spring-mybatis.xml
    		</param-value>
    	</context-param>
    	
    	<context-param>
    		<param-name>webAppRootKey</param-name>
    		<param-value>springmvc.root</param-value>
    	</context-param>
    
    
    	
    	<filter>
    		<filter-name>SpringEncodingFilter</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>SpringEncodingFilter</filter-name>
    		<url-pattern>/*</url-pattern>
    	</filter-mapping>
    
    	
    	<context-param>
    		
    		<param-name>log4jConfigLocation</param-name>
    		<param-value>classpath:conf/log4j.properties</param-value>
    	</context-param>
    	<context-param>
    		
    		<param-name>log4jRefreshInterval</param-name>
    		<param-value>6000</param-value>
    	</context-param>
    	<listener>
    		<listener-class>org.springframework.web.util.Log4jConfigListener</listener-class>
    	</listener>
    
    	<listener>
    		<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    	</listener>
    
    	
    	<servlet>
    		<servlet-name>spring</servlet-name>
    		<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    		<init-param>
    			<param-name>contextConfigLocation</param-name>
    			<param-value>classpath:conf/spring-mvc.xml</param-value>
    		</init-param>
    		<load-on-startup>2</load-on-startup>
    	</servlet>
    	<servlet-mapping>
    		<servlet-name>spring</servlet-name>
    		<url-pattern>*.do</url-pattern>
    	</servlet-mapping>
    
    	<welcome-file-list>
    		<welcome-file>index.jsp</welcome-file>
    	</welcome-file-list>
    
    	
    	<error-page>
    		
    		<error-code>404</error-code>
    		<location>/WEB-INF/errorpage/404.jsp</location>
    	</error-page>
    	<error-page>
    		
    		<error-code>405</error-code>
    		<location>/WEB-INF/errorpage/405.jsp</location>
    	</error-page>
    	<error-page>
    		
    		<error-code>500</error-code>
    		<location>/WEB-INF/errorpage/500.jsp</location>
    	</error-page>
    </web-app>

conf/spring-mvc.xml(mvc配置文件)

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans"
      xmlns:p="http://www.springframework.org/schema/p"
      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-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/mvc
        http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd">
        
        
       <context:component-scan base-package="cn.springmvc.controller"/>
       
       
       <bean id="jacksonMessageConverter" class="org.springframework.http.converter.json.MappingJacksonHttpMessageConverter">		
    		<property name="supportedMediaTypes">
    			<list>
    				<value>text/html;charset=UTF-8</value>
    			</list>
    		</property>
    	</bean>
    	
       
         <bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver" 
          p:prefix="/WEB-INF/jsp/" p:suffix=".jsp"/>
    </beans>

## 9.  log4j日志记录搭建 ##

conf/log4j.properties(日志记录的配置文件)

### set log levels ###
    #log4j.rootLogger = debug , stdout , D , E
    log4j.rootLogger = debug , stdout , D
    
    ###  output to the console ###
    log4j.appender.stdout = org.apache.log4j.ConsoleAppender
    log4j.appender.stdout.Target = System.out
    log4j.appender.stdout.layout = org.apache.log4j.PatternLayout
    #log4j.appender.stdout.layout.ConversionPattern = %d{ABSOLUTE} %5p %c{ 1 }:%L - %m%n
    log4j.appender.stdout.layout.ConversionPattern = %-d{yyyy-MM-dd HH:mm:ss} [%c]-[%p] %m%n
    
    ### Output to the log file ###
    log4j.appender.D = org.apache.log4j.DailyRollingFileAppender
    log4j.appender.D.File = ${springmvc.root}/WEB-INF/logs/log.log
    log4j.appender.D.Append = true
    log4j.appender.D.Threshold = DEBUG 
    log4j.appender.D.layout = org.apache.log4j.PatternLayout
    log4j.appender.D.layout.ConversionPattern = %-d{yyyy-MM-dd HH:mm:ss} [ %t:%r ] - [ %p ] %m%n
    
    ### Save exception information to separate file ###
    log4j.appender.D = org.apache.log4j.DailyRollingFileAppender
    log4j.appender.D.File = ${springmvc.root}/WEB-INF/logs/error.log 
    log4j.appender.D.Append = true
    log4j.appender.D.Threshold = ERROR 
    log4j.appender.D.layout = org.apache.log4j.PatternLayout
    log4j.appender.D.layout.ConversionPattern = %-d{yyyy-MM-dd HH:mm:ss} [ %t:%r ] - [ %p ] %m%n

## 10.  测试运行 ##

WEB-INF/jsp/index.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>
    <h1>欢迎你！！！</h1>
    </body>
    </html>

cn.springmvc.controller/UserComtroller.java(controller层控制)

package cn.springmvc.controller;
    
    import org.springframework.stereotype.Controller;
    import org.springframework.web.bind.annotation.RequestMapping;
    
    @Controller
    @RequestMapping("/")
    public class UserController {
    
    	@RequestMapping("index")
    	public String index(){
    		return "index";
    	}
    	
    }

将该项目部署到本地tomcat6中

右击该项目选择Run as，选择Run on Server

选择自己建立的tomcat6运行如图：

![maven+springMVC+mybatis+junit详细搭建过程][maven_springMVC_mybatis_junit 1]

控制台打印出日志如图（启动成功）：

![maven+springMVC+mybatis+junit详细搭建过程][maven_springMVC_mybatis_junit 2]

在浏览器中输入：http://localhost:8080/springmvc/index.do 进行测试

效果如图（返回成功）：

![maven+springMVC+mybatis+junit详细搭建过程][maven_springMVC_mybatis_junit 3]

## 整体包下载地址： ##

http://download.csdn.net/detail/fengerfhf/6916831

来自：http://my.oschina.net/u/1011897/blog/199172

[http_search.maven.org]: http://search.maven.org/
[maven_springMVC_mybatis_junit]: /images/20220717/7ce3a770aea14baaa787429be4450c1d.png
[maven_springMVC_mybatis_junit 1]: /images/20220717/286763caa93a4ce8b4f11cf8a410072b.png
[maven_springMVC_mybatis_junit 2]: /images/20220717/57e96c37e79f443c8659beba639d323c.png
[maven_springMVC_mybatis_junit 3]: /images/20220717/4caea2052a3c4a86881248f1abf1d25f.png