使用IDEA和gradle搭建Spring MVC和MyBatis开发环境
1.新建一个工程
2.工程目录
3.添加gradle.properties文件
activeMQVersion=5.7.0 aspectJVersion=1.7.2 commonsLangVersion = 3.1 ehcacheVersion=2.7.4 ehcacheJCacheVersion=1.4.0-beta1 h2Version=1.4.182 hamcrestVersion = 1.3 hibernateVersion=4.1.6.Final hibernateEntityManagerVersion=4.0.1.Final hibernateValidatorVersion = 5.0.1.Final jacksonVersion=2.4.3 javaxMailVersion=1.4.7 jspApiVersion = 2.1 jspElVersion = 2.2.4 jstlVersion = 1.2 junitVersion=4.12 log4jVersion=1.2.14 mockitoVersion=1.9.5 servletApiVersion = 3.1.0 slf4jVersion = 1.7.5 springAMQPVersion=1.0.0.RELEASE springDataJpaVersion=1.3.2.RELEASE springSecurityVersion = 3.2.0.RELEASE springVersion=4.0.7.RELEASE springWebflowVersion=2.4.1.RELEASE systemRulesVersion=1.5.0 thymeleafVersion = 2.1.3.RELEASE tilesVersion = 3.0.1 mysql_Java = 5.1.38 commons_dbcp = 1.4 mybatis_spring =1.2.5 mybatisVersion = 3.3.1
4.添加依赖,修改build.gradle文件
group 'com.huang' version '1.0-SNAPSHOT' apply plugin: 'java' apply plugin: 'war' apply plugin: 'eclipse' apply plugin: 'idea' sourceCompatibility = 1.5 repositories { maven { url 'http://maven.springframework.org/release' } maven { url 'http://maven.springframework.org/milestone' } maven { url 'http://maven.springframework.org/snapshot' } maven { url 'http://download.java.net/maven/2' } mavenCentral() } dependencies { testCompile group: 'junit', name: 'junit', version: '4.12' testCompile"org.springframework:spring-test:${springVersion}" testCompile "com.github.stefanbirkner:system-rules:${systemRulesVersion}" compile "org.springframework:spring-core:$springVersion" compile "org.springframework:spring-context:$springVersion" compile "org.springframework:spring-jdbc:$springVersion" compile "org.mybatis:mybatis:$mybatisVersion" compile "org.mybatis:mybatis-spring:$mybatis_spring" compile "commons-dbcp:commons-dbcp:$commons_dbcp" compile "mysql:mysql-connector-java:$mysql_Java" compile "log4j:log4j:$log4jVersion" compile "com.h2database:h2:$h2Version" compile "javax.inject:javax.inject:1" compile "net.sf.ehcache:ehcache:$ehcacheVersion" compile "net.sf.ehcache:ehcache-jcache:$ehcacheJCacheVersion" }
5.执行sql脚本,创建数据库表
SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for tbl_dep -- ---------------------------- DROP TABLE IF EXISTS `tbl_dep`; CREATE TABLE `tbl_dep` ( `depId` varchar(20) NOT NULL, `name` varchar(20) DEFAULT NULL, PRIMARY KEY (`depId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of tbl_dep -- ---------------------------- INSERT INTO `tbl_dep` VALUES ('01', '总公司'); INSERT INTO `tbl_dep` VALUES ('0101', '一分公司'); INSERT INTO `tbl_dep` VALUES ('010101', '开发部'); INSERT INTO `tbl_dep` VALUES ('010102', '测试部'); INSERT INTO `tbl_dep` VALUES ('0102', '二分公司'); INSERT INTO `tbl_dep` VALUES ('010201', '开发部'); INSERT INTO `tbl_dep` VALUES ('010202', '测试部'); -- ---------------------------- -- Table structure for tbl_user -- ---------------------------- DROP TABLE IF EXISTS `tbl_user`; CREATE TABLE `tbl_user` ( `userId` varchar(20) NOT NULL, `name` varchar(20) DEFAULT NULL, `depId` varchar(20) NOT NULL, `sex` varchar(10) DEFAULT NULL, PRIMARY KEY (`userId`), KEY `TBL_USER_FK` (`depId`), CONSTRAINT `TBL_USER_FK` FOREIGN KEY (`depId`) REFERENCES `tbl_dep` (`depId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of tbl_user -- ---------------------------- INSERT INTO `tbl_user` VALUES ('user0001', '张三1', '010101', '男'); INSERT INTO `tbl_user` VALUES ('user0002', '张三2', '010101', '男'); INSERT INTO `tbl_user` VALUES ('user0003', '张三3', '010102', '男'); INSERT INTO `tbl_user` VALUES ('user0004', '张三4', '010201', '男'); INSERT INTO `tbl_user` VALUES ('user0005', '张三5', '010201', '男'); INSERT INTO `tbl_user` VALUES ('user0006', '张三6', '010102', '男'); SET FOREIGN_KEY_CHECKS=1;
6.创建实体类User,对应tbl_user表
package com.huang.domain; /** * Created by huangyichun on 2016/12/9. */ public class User { private String userId; private String name; private String depId; private String sex; public String getUserId() { return userId; } public void setUserId(String userId) { this.userId = userId; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getDepId() { return depId; } public void setDepId(String depId) { this.depId = depId; } public String getSex() { return sex; } public void setSex(String sex) { this.sex = sex; } @Override public String toString() { return "User{" + "userId='" + userId + '\'' + ", name='" + name + '\'' + ", depId='" + depId + '\'' + ", sex='" + sex + '\'' + '}'; } }
7. 创建接口UserMapper,其中部分采用注解形式
package com.huang.mapper; import com.huang.domain.User; import org.apache.ibatis.annotations.Delete; import org.apache.ibatis.annotations.Param; import org.apache.ibatis.annotations.Select; import org.apache.ibatis.annotations.Update; import java.util.List; public interface UserMapper { @Select("SELECT * FROM tbl_user") List<User> getUserList(); @Select("SELECT * FROM tbl_user WHERE userId = #{userId}") User getUserById(@Param("userId") String userId); @Update("UPDATE tbl_user SET sex = #{sex} WHERE userId = #{userId}") void updateUserEmailById(@Param("userId") String userId, @Param("sex") String sex); @Delete("DELETE FROM tbl_user WHERE userId = #{userId}") void deleteUserById(@Param("userId") String userId); void insertUser(User user); }
8.创建UserMapper.xml文件,放在
如果放在java的com.huang.mapper文件夹下,将不会自动加载,这个Idea有关系
9.创建配置类
package com.huang.config; import org.apache.commons.dbcp.BasicDataSource; import org.mybatis.spring.SqlSessionFactoryBean; import org.mybatis.spring.annotation.MapperScan; import org.springframework.context.annotation.Bean; import org.springframework.context.annotation.Configuration; import org.springframework.core.io.support.PathMatchingResourcePatternResolver; import org.springframework.jdbc.datasource.DataSourceTransactionManager; @Configuration @MapperScan(basePackages = "com.huang.mapper") public class DataConfig { @Bean public BasicDataSource dataSource(){ BasicDataSource dataSource = new BasicDataSource(); dataSource.setDriverClassName("com.mysql.jdbc.Driver"); dataSource.setUrl("jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8");//防止乱码 dataSource.setUsername("root"); dataSource.setPassword("huangyichun"); dataSource.setInitialSize(5); dataSource.setMaxActive(10); return dataSource; } @Bean public DataSourceTransactionManager transactionManager() { return new DataSourceTransactionManager(dataSource()); } @Bean public SqlSessionFactoryBean sqlSessionFactory() throws Exception { SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean(); sessionFactory.setDataSource(dataSource()); sessionFactory.setTypeAliasesPackage("com.huang.domain"); sessionFactory.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath:mapper/*.xml")); return sessionFactory; } }
10.创建测试类
import com.huang.config.DataConfig; import com.huang.domain.User; import com.huang.mapper.UserMapper; import org.junit.Test; import org.junit.runner.RunWith; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.test.context.ContextConfiguration; import org.springframework.test.context.junit4.SpringJUnit4ClassRunner; import java.util.List; @RunWith(SpringJUnit4ClassRunner.class) @ContextConfiguration(classes = DataConfig.class) public class TestMybatis { @Autowired private UserMapper userMapper; @Test public void getUserById(){ User user = userMapper.getUserById("user0005"); System.out.println(user.toString()); } @Test public void getUserList(){ List<User> list = userMapper.getUserList(); for (User user : list){ System.out.println(user.toString()); } } @Test public void updateUserEmailById(){ userMapper.updateUserEmailById("user0006","女"); } @Test public void deleteUserById(){ userMapper.deleteUserById("user0006"); } @Test public void insertUser(){ User user = new User(); user.setUserId("user0008"); user.setName("张三7"); user.setDepId("010102"); user.setSex("男"); userMapper.insertUser(user); } }
Gradle一分钟实现Spring-MVC
前提:
1,已安装JDK
2, 有Intellij IDEA
3, 已安装Gradle
一分钟实现步骤:
1,mkdir Spring-MVC;cd Spring-MVC
2,gradle init
3,edit build.gradle file
- /*
- * This build file was auto generated by running the Gradle 'init' task
- * by 'Administrator' at '16-10-2 下午8:42' with Gradle 3.1
- *
- * This generated file contains a commented-out sample Java project to get you started.
- * For more details take a look at the Java Quickstart chapter in the Gradle
- * user guide available at https://docs.gradle.org/3.1/userguide/tutorial_java_projects.html
- */
- buildscript {
- repositories {
- jcenter()
- }
- dependencies {
- classpath 'org.akhikhl.gretty:gretty:+'
- }
- }
- ext {
- springVersion = '4.3.3.RELEASE'
- }
- //apply from: 'https://raw.github.com/akhikhl/gretty/master/pluginScripts/gretty.plugin'
- apply plugin: 'org.akhikhl.gretty'
- apply plugin: 'java'
- apply plugin: 'war'
- apply plugin: 'eclipse'
- apply plugin: 'idea'
- // In this section you declare where to find the dependencies of your project
- repositories {
- // Use 'jcenter' for resolving your dependencies.
- // You can declare any Maven/Ivy/file repository here.
- jcenter()
- mavenCentral()
- maven { url 'http://repo.spring.io/release' }
- }
- // In this section you declare the dependencies for your production and test code
- dependencies {
- //core spring
- compile ("org.springframework:spring-context:$springVersion")
- compile ("org.springframework:spring-core:$springVersion")
- compile ("org.springframework:spring-webmvc:$springVersion")
- // The production code uses the SLF4J logging API at compile time
- compile ("org.slf4j:slf4j-api:1.7.21")
- // Declare the dependency for your favourite test framework you want to use in your tests.
- // TestNG is also supported by the Gradle Test task. Just change the
- // testCompile dependency to testCompile 'org.testng:testng:6.8.1' and add
- // 'test.useTestNG()' to your build script.
- testCompile ("junit:junit:4.12")
- }
build gradle
4,mkdir src\main\java ; mkdir src\main\resources ; mkdir src\main\webapp
mkdir src\main\webapp\WEB-INF
mkdir src\test\java ; mkdir src\test\resources
5,将项目导入idea,因为gradlew idea这个命令会生成一些多余的文件,不喜欢垃圾多余的东西,故直接导入
6,Spring MVC本质上就是Servlet, 所以需要定义一个web.xml和一个Spring MVC的配置文件,在WEB-INF下面添加web.xml和spring-mvc-servlet.xml文件
- <?xml version="1.0" encoding="UTF-8"?>
- <web-app version="3.1" 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_1.xsd">
- <servlet>
- <servlet-name>spring-mvc</servlet-name>
- <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
- <load-on-startup>1</load-on-startup>
- </servlet>
- <servlet-mapping>
- <servlet-name>spring-mvc</servlet-name>
- <url-pattern>/</url-pattern>
- </servlet-mapping>
- </web-app>
web.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:p="http://www.springframework.org/schema/p"
- 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:annotation-driven></mvc:annotation-driven>
- <context:component-scan base-package="org.springframework.samples"/>
- <bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
- <property name="prefix" value="/WEB-INF/views/"/>
- <property name="suffix" value=".jsp"/>
- </bean>
- </beans>
spring-mvc-servlet.xml
关于Spring MVC的配置文件,最简的配置是申明p,context,mvc命名空间即可。上面p其实是没有用到的。
7,根据第6步的spring-mvc-servlet.xml的配置,还需要在WEB-INF文件夹下面创建一个views文件夹,并且新建文件home.jsp
- <%--
- Created by IntelliJ IDEA.
- User: Administrator
- Date: 2016/10/2 0002
- Time: 21:53
- To change this template use File | Settings | File Templates.
- --%>
- <%@ page contentType="text/html;charset=UTF-8" language="java" %>
- <html>
- <head>
- <title>Home</title>
- </head>
- <body>
- <h1>
- Hello world!
- </h1>
- <P> The time on the server is ${serverTime}. </P>
- </body>
- </html>
home.jsp
8,HomeController.java
- package org.springframework.samples;
- import org.slf4j.Logger;
- import org.slf4j.LoggerFactory;
- import org.springframework.stereotype.Controller;
- import org.springframework.ui.Model;
- import org.springframework.web.bind.annotation.RequestMapping;
- import org.springframework.web.bind.annotation.RequestMethod;
- import java.text.DateFormat;
- import java.util.Date;
- import java.util.Locale;
- /**
- * Created by Administrator on 2016/10/2 0002.
- */
- @Controller
- public class HomeController {
- private static final Logger logger = LoggerFactory.getLogger(HomeController.class);
- /**
- * . * Simply selects the home view to render by returning its name.
- * .
- */
- @RequestMapping(value = "/", method = RequestMethod.GET)
- public String home(Locale locale, Model model) {
- logger.info("Welcome home! The client locale is {}.", locale);
- Date date = new Date();
- DateFormat dateFormat = DateFormat.getDateTimeInstance(DateFormat.LONG, DateFormat.LONG, locale);
- String formattedDate = dateFormat.format(date);
- model.addAttribute("serverTime", formattedDate);
- return "home";
- }
- }
HomeController.java
9,
- gradlew tomcatRun
10, http://localhost:8080/Spring-MVC/
11,理论延伸,Spring MVC的Servlet一共有三个层次
HttpServletBean,直接继承于Java的HttpServlet, 将Servlet中配置的参数设置到相应的属性,并不参与实际请求的处理
FrameworkServlet,初始化WebApplicationContext,将不同类型的请求合并到processRequest方法中统一处理
DispatcherServlet,初始化自身的9个组件,主要将请求交给doDispatch方法具体处理。哪9大组件呢?他们是:
HandlerMapping,根据request找到相应的Handler(就是常说的Controller)和Interceptors.
HandlerAdapter,共有3个方法,supports判断是否可以使用某Handler,handler方法具体用Handler干活,getLastModified是用来获取资源的Last Modified.
HandlerExceptionResolver,根据异常设置ModelAndView.并转交给render方法进行渲染。
ViewResolver,将String类型的视图名和Locale解析为View类型的视图
RequestToViewNameTranslator,根据request获取到视图名,因为有些handler并没有返回视图名的。我想这个是实现404的最好组件了,一个spring mvc容器里只能配置一个。
LocaleResolver,根据request解析出Locale
ThemeResolver,根据request解析出主题名
MultipartResolver,用于处理上传文件,将普通的request转换成MultipartHttpServletRequest
FlashMapManager,用于管理FlashMap的,而FlashaMap主要用于redirect中传递参数
Java配置
按Spring的发展趋势,现在推荐使用Java配置,下面就让我们来抛弃xml而拥抱Java配置吧
前面1-5步一样的。从第6步开始开始改变
6, 要抛弃web.xml,必须要在支持Servlet3.0+的服务器才行,实现只需扩展一下
- AbstractAnnotationConfigDispatcherServletInitializer
- public class SampleWebAppInitializer extends AbstractAnnotationConfigDispatcherServletInitializer {
- @Override
- protected Class<?>[] getRootConfigClasses() {
- return new Class<?>[0];
- }
- @Override
- protected Class<?>[] getServletConfigClasses() {
- return new Class<?>[]{SpringMVCConfig.class};
- }
- @Override
- protected String[] getServletMappings() {
- return new String[]{"/"};
- }
- }
SampleWebAppInitializer
接下来使用IDEA的Alter +Enter, 自动生成SpringMVCConfig.java
- @Configuration
- @EnableWebMvc
- @ComponentScan("org.springframework.samples.controllers")
- public class SpringMVCConfig extends WebMvcConfigurerAdapter {
- @Bean
- public ViewResolver viewResolver() {
- InternalResourceViewResolver resolver = new InternalResourceViewResolver();
- resolver.setPrefix("/WEB-INF/views/");
- resolver.setSuffix(".jsp");
- ;
- resolver.setExposeContextBeansAsAttributes(true);
- return resolver;
- }
- @Override
- public void configureDefaultServletHandling(DefaultServletHandlerConfigurer configurer) {
- configurer.enable();
- }
- }
SpringMVCConfig
7, 可以复制xml版本的jsp
8,根据SpringMVCConfig.java里的componentscan里的约定,我们将HomeController放在controllers下面。内容同xml版本
9,测试