用到的工具:maven,mybatis
1.创建新项目:
我创建的是maven项目,然后编辑pom.xml文件,通过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>myspringmvc</groupId>
<artifactId>myspringmvc</artifactId>
<packaging>war</packaging>
<version>1.0-SNAPSHOT</version>
<name>myspringmvc Maven Webapp</name>
<url>http://maven.apache.org</url>
<properties>
<spring.version>4.1.1.RELEASE</spring.version>
<mysql.jdbc.version>5.1.6</mysql.jdbc.version>
<!-- mybatis版本号 -->
<mybatis.version>3.3.0</mybatis.version>
</properties>
<dependencies>
<!-- springframe-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</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-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-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-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-test</artifactId>
<version>${spring.version}</version>
<scope>test</scope>
</dependency>
<!--junit-->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.11</version>
<scope>test</scope>
</dependency>
<!--servlet/jsp api-->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>3.0.1</version>
</dependency>
<dependency>
<groupId>javax.servlet.jsp</groupId>
<artifactId>jsp-api</artifactId>
<version>2.1</version>
<scope>provided</scope>
</dependency>
<!--aspectj start-->
<dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjweaver</artifactId>
<version>1.8.6</version>
</dependency>
<dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjrt</artifactId>
<version>1.8.6</version>
</dependency>
<!--c3p0-->
<dependency>
<groupId>com.mchange</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.5.1</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.3</version>
</dependency>
<!--mysql driver-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>${mysql.jdbc.version}</version>
</dependency>
<!--jstl-->
<dependency>
<groupId>jstl</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<!--log-->
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-api</artifactId>
<version>1.7.12</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-log4j12</artifactId>
<version>1.7.12</version>
</dependency>
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
</dependencies>
<build>
<finalName>myspringmvc</finalName>
<plugins>
<!--mybatis 逆向工程插件-->
<plugin>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-maven-plugin</artifactId>
<version>1.3.2</version>
<configuration>
<verbose>true</verbose>
<overwrite>true</overwrite>
<configurationFile>src/main/resources/generateConfig.xml</configurationFile>
</configuration>
</plugin>
<plugin>
<artifactId>maven-compiler-plugin</artifactId>
<configuration>
<source>1.6</source>
<target>1.6</target>
</configuration>
</plugin>
<plugin>
<artifactId>maven-surefire-plugin</artifactId>
<configuration>
<includes>
<include>**/*Tests.java</include>
</includes>
</configuration>
</plugin>
</plugins>
</build>
</project>
注意到下面有一个关于mybatis逆向工程插件的配置,是之后会用到的。
2.编辑目录:
在自己的项目目录线面mkdir一些目录出来,大致的结构如图:
这里面com.java.myspring.mvc 目录下面都是放的java代码,resource 是放一些配置资源,包括一些.xml文件也在这里,mapper目录是存放之后要生成的mybatis mapperl文件。
3.生成sql mapper
首先要给mybatis插件一个配置文件,根据这个配置文件生成。
编辑generateConfig.xml,生成的代码和配置文件位置如图,如图:
<!DOCTYPE generatorConfiguration
PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
"http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
<generatorConfiguration>
<!-- 配置文件路径 -->
<!--<properties url="${mybatis.generator.generatorConfig.properties}"/>-->
<!--数据库驱动包路径 -->
<!--<classPathEntry location="/Users/luolidong/.m2/repository/mysql/mysql-connector-java/5.1.34/mysql-connector-java-5.1.34.jar"/>-->
<classPathEntry location="/Users/zhangxingang/.m2/repository/mysql/mysql-connector-java/5.1.6/mysql-connector-java-5.1.6.jar"/>
<context id="SPYMySQLTables" targetRuntime="MyBatis3">
<!-- 自动识别数据库关键字,默认false,如果设置为true,根据SqlReservedWords中定义的关键字列表;
一般保留默认值,遇到数据库关键字(Java关键字),使用columnOverride覆盖
-->
<property name="autoDelimitKeywords" value="false"/>
<!-- 生成的Java文件的编码 -->
<property name="javaFileEncoding" value="UTF-8"/>
<!-- 格式化java代码 -->
<property name="javaFormatter" value="org.mybatis.generator.api.dom.DefaultJavaFormatter"/>
<!-- 格式化XML代码 -->
<property name="xmlFormatter" value="org.mybatis.generator.api.dom.DefaultXmlFormatter"/>
<!-- beginningDelimiter和endingDelimiter:指明数据库的用于标记数据库对象名的符号,比如ORACLE就是双引号,MYSQL默认是`反引号; -->
<property name="beginningDelimiter" value="`"/>
<property name="endingDelimiter" value="`"/>
<!--关闭注释 -->
<commentGenerator>
<!-- 是否去除自动生成的注释 true:是 : false:否 -->
<property name="suppressDate" value="true"/>
</commentGenerator>
<!--数据库连接信息 -->
<!-- <jdbcConnection driverClass="com.mysql.jdbc.Driver"
connectionURL="jdbc:mysql://set-gh-dba-dba-hulk-test181.corp.sankuai.com:5002/movie_service?characterEncoding=UTF-8"
userId="movie_service"
password="movie_service">
</jdbcConnection>-->
<jdbcConnection driverClass="com.mysql.jdbc.Driver"
connectionURL="jdbc:mysql://127.0.0.1:3306/testsql?characterEncoding=UTF-8"
userId="root"
password="">
</jdbcConnection>
<!-- 默认false,把JDBC DECIMAL 和 NUMERIC 类型解析为 Integer,为 true时把JDBC DECIMAL 和
NUMERIC 类型解析为java.math.BigDecimal -->
<javaTypeResolver>
<property name="forceBigDecimals" value="false" />
</javaTypeResolver>
<!--生成的model 包路径 -->
<javaModelGenerator targetPackage="com.java.myspring.mvc.model"
targetProject="src/main/java">
<!-- enableSubPackages:是否让schema作为包的后缀 -->
<property name="enableSubPackages" value="false" />
<!-- 从数据库返回的值被清理前后的空格 -->
<property name="trimStrings" value="true" />
</javaModelGenerator>
<!--生成xml mapper文件 路径 -->
<sqlMapGenerator targetPackage="mapper"
targetProject="src/main/resources">
<property name="enableSubPackages" value="false"/>
</sqlMapGenerator>
<!-- 生成的Dao接口 的包路径 -->
<javaClientGenerator type="XMLMAPPER" targetPackage="com.java.myspring.mvc.mapper"
targetProject="src/main/java">
<property name="enableSubPackages" value="false"/>
</javaClientGenerator>
<!--对应数据库表名 -->
<!--<table tableName="user_info" domainObjectName="UserInfo" enableCountByExample="true" enableUpdateByExample="true" enableDeleteByExample="true" enableSelectByExample="true" selectByExampleQueryId="true" />-->
<!--<table tableName="course" domainObjectName="Course" enableCountByExample="true" enableUpdateByExample="true" enableDeleteByExample="true" enableSelectByExample="true" selectByExampleQueryId="true"/>-->
<table tableName="user" domainObjectName="User" enableCountByExample="true" enableUpdateByExample="true" enableDeleteByExample="true" enableSelectByExample="true" selectByExampleQueryId="true" />
<!-- 有些表的字段需要指定java类型
<table schema="" tableName="">
<columnOverride column="" javaType="" />
</table>
-->
</context>
</generatorConfiguration>
代码里有关于生成的mapper类,mapper.xml文件的生成路径配置,和对数据库中哪个表生成类,有详细的配置,我这里面是把dao接口放在了mapper目录,model目录放生成的model。然后关于数据库是本地的mysql的testsql这个数据库中的user表。
—————————基本的项目结构搭建完成了,下面开始写代码了。—————————
Spring bean:
首先把关于项目用到的bean 配置好,我放在resource/config目录下面。
文件结构截图和代码如下:
jdbc.properties:
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/testsql
jdbc.username=root
jdbc.password=
#connection pool settings
# maxIdle是最大的空闲连接数,这里取值为20,表示即使没有数据库连接时依然可以保持20个空闲的连接,它们不会被清除,随时处于待命状态
# maxActive是最大激活连接数,这里取值为190,表示同时最多有190个数据库连接
jdbc.pool.maxIdle=20
jdbc.pool.minIdle=2
jdbc.pool.maxActive=190
jdbc.pool.maxIdleTime=60
log4j.properties:
log4j.rootLogger=DEBUG, Console
#Console
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n
log4j.logger.java.sql.ResultSet=INFO
log4j.logger.org.apache=INFO
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG
这里面有个方法,因为idea我没有找到直接new .properties文件的地方,我就是用sublime写的,然后存到这个目录下面。
然后是spring配置,这里我把这些.xml文件都放到了spring目录下。
applicationContext.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"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">
<import resource="classpath*:config/spring/applicationContext-*.xml"/>
</beans>
applicationContext-dao.xml:
<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"
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">
<!--获取数据库配置文件-->
<context:property-placeholder location="classpath:config/jdbc.properties"/>
<!--设置数据源c3p0-->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
<property name="driverClass" value="${jdbc.driver}"/>
<property name="jdbcUrl" value="${jdbc.url}"/>
<property name="user" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
<property name="maxPoolSize" value="${jdbc.pool.maxIdle}"/>
<property name="minPoolSize" value="${jdbc.pool.minIdle}"/>
<!-- <property name="maxActive" value="40"/>-->
<property name="maxIdleTime" value="${jdbc.pool.maxIdleTime}"/>
</bean>
<!--sqlsessionFactory bean-->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="mapperLocations" value="classpath:mapper/*.xml"/>
<property name="dataSource" ref="dataSource"/>
</bean>
<!--自动扫描mapper接口,并注入sqlsession-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.java.myspring.mvc.mapper”/>
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
</bean>
</beans>
applicationContext-transaction.xml:
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:aop="http://www.springframework.org/schema/aop"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd">
<import resource="applicationContext-dao.xml"/>
<bean id="dataSourceTransactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"/>
</bean>
<tx:advice id="txAdvice" transaction-manager="dataSourceTransactionManager">
<tx:attributes>
<tx:method name="find*" propagation="REQUIRED"/>
<tx:method name="update*" propagation="REQUIRED"/>
<tx:method name="delete*" propagation="REQUIRED"/>
<tx:method name="add*" propagation="REQUIRED"/>
</tx:attributes>
</tx:advice>
<aop:config>
<aop:advisor advice-ref="txAdvice" pointcut="execution(* cn.elinzhou.ixxs.service.*.*(..))"/>
</aop:config>
</beans>
applicationContext-service.xml:
<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"
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">
<!--扫描service-->
<context:component-scan base-package="com.java.myspring.mvc.service"/>
<!--
<bean name="zoo" class="com.meituan.spy.service.impl.BeanZooImpl">
<property name="name" value="monkey"/>
<property name="ability" value="climb"/>
</bean> -->
</beans>
Spring-mvc:
<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:task="http://www.springframework.org/schema/task"
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.0.xsd
http://www.springframework.org/schema/task
http://www.springframework.org/schema/task/spring-task-3.0.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd">
<context:component-scan base-package="com.java.myspring.mvc.controller"/>
<tx:annotation-driven/>
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/WEB-INF/pages/"/>
<property name="suffix" value=".jsp"/>
</bean>
</beans>
然后是java代码的实现,首先实现简单的一个服务,user get 和add del 服务,简单的三个类。
Interface UserService:
package com.java.myspring.mvc.service;
import com.java.myspring.mvc.model.User;
import java.util.List;
public interface UserService {
List<User> findUser() throws Exception;
User findUserById(int id) throws Exception;
int addUser(User user) throws Exception;
int deleteUser(int id) throws Exception;
}
UserServiceImpl :
package com.java.myspring.mvc.service.impl;
import com.java.myspring.mvc.mapper.UserMapper;
import com.java.myspring.mvc.model.User;
import com.java.myspring.mvc.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
@Service
public class UserServiceImpl implements UserService{
@Autowired
private UserMapper userMapper;
public List<User> findUser() throws Exception{
List<User> users = userMapper.selectByExample(null);
System.out.println(users);
return users;
}
public User findUserById(int id) throws Exception {
User user = userMapper.selectByPrimaryKey(id);
return user;
}
public int addUser(User user) throws Exception{
return userMapper.insert(user);
}
public int deleteUser(int id) throws Exception{
return userMapper.deleteByPrimaryKey(id);
}
}
以上两个是关于User的接口和实现,他们自动绑定了对应的Mapper。
UserController:
package com.java.myspring.mvc.controller;
import com.java.myspring.mvc.model.User;
import com.java.myspring.mvc.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;
import java.util.List;
import static org.springframework.web.bind.annotation.RequestMethod.DELETE;
import static org.springframework.web.bind.annotation.RequestMethod.GET;
import static org.springframework.web.bind.annotation.RequestMethod.POST;
@Controller
public class UserController {
@Autowired
private UserService userService;
public ModelAndView modelAndView = new ModelAndView();
@RequestMapping(value = "/users",method = GET)
public ModelAndView findUser()throws Exception{
//调用service方法得到用户列表
List<User> users = userService.findUser();
modelAndView.addObject("users",users);
//设置响应的jsp视图
modelAndView.setViewName("findUser");
return modelAndView;
}
@RequestMapping(value = "/user/{user_id}",method = GET)
public ModelAndView getUser(int id,@PathVariable("user_id") String user_id) throws Exception{
System.out.println("id:"+user_id);
User user = userService.findUserById(id);
modelAndView.addObject("user",user);
modelAndView.setViewName("getUser");
return modelAndView;
}
@RequestMapping(value = "/user/{id}",method = DELETE)
public ModelAndView deleteUser(@PathVariable("id") int id) throws Exception{
int status = userService.deleteUser(id);
modelAndView.addObject("status",status);
modelAndView.setViewName("success");
return modelAndView;
}
@RequestMapping(value = "/user/register",method=GET)
public String Register(){
return "register";
}
@RequestMapping(value = "/user/register",method = POST)
public ModelAndView addUser(User u) throws Exception{
int status = userService.addUser(u);
modelAndView.addObject("status",status);
modelAndView.setViewName("success");
return modelAndView;
}
}
这里是关于web 服务的api的Controller,最终的结果会通过modelAndView 找到对应名字的。jsp文件,返回到浏览器上,下面就是相关的.jsp文件的代码和截图。
findUser.jsp:
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%--
Created by IntelliJ IDEA.
User: proteen
Date: 16/6/23
Time: 下午3:02
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title></title>
</head>
<body>
<h1>findUser</h1>
<table>
<table>
<c:forEach items="${users}" var="u">
<tr>
<td>${u.id}</td>
<td>${u.name}</td>
<td>${u.kecheng}</td>
<td>${u.fenshu}</td>
</tr>
</c:forEach>
</table>
</table>
</body>
</html>
getUser.jsp:
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>Title</title>
</head>
<body>
<tr>
<td>${user.id}</td>
<td>${user.name}</td>
<td>${user.kecheng}</td>
<td>${user.fenshu}</td>
</tr>
</body>
</html>
register:
<%--
Created by IntelliJ IDEA.
User: zhangxingang
Date: 2017/10/18
Time: 下午2:42
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>Title</title>
</head>
<body>
<h1>Register</h1>
<form method="post">
name: <input type="text" name="name"/><br/>
kecheng: <input type="text" name="kecheng"/><br/>
fenshu: <input type="text" name="fenshu"/><br/>
<input type="submit" value="Reigster"/>
</form>
</body>
</html>
success.jsp:
<%--
Created by IntelliJ IDEA.
User: zhangxingang
Date: 2017/10/18
Time: 下午2:41
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>Title</title>
</head>
<body>
${status}
</body>
</html>
最后是servlet的配置,写在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/web-app_2.5.xsd"
version="2.5">
<display-name>Spring MVC Application</display-name>
<!--设置spring 配置文件的位置-->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:config/applicationContext.xml</param-value>
</context-param>
<!--配置spring listener-->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<!--解决POST乱码问题-->
<filter>
<filter-name>CharacterEncodingFilter</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>
</filter>
<filter-mapping>
<filter-name>CharacterEncodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<!--springmvc前端控制器配置-->
<servlet>
<servlet-name>movieServlet</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:config/spring/spring-mvc.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>movieServlet</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
</web-app>
这样就实现了一个简单的spring框架的user 增删查的web服务。
之后又补上了测试环境不同数据库资源,例子很简单,就是一个简单的get请求。
controllerTest.java:
package com.java.myspring.test;
import com.java.myspring.mvc.controller.UserController;
import com.java.myspring.mvc.service.UserService;
import org.junit.Before;
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 org.springframework.test.web.servlet.MockMvc;
import org.springframework.test.web.servlet.MvcResult;
import static org.springframework.test.web.servlet.request.MockMvcRequestBuilders.get;
import static org.springframework.test.web.servlet.setup.MockMvcBuilders.standaloneSetup;
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations = {"classpath:context.xml","classpath:spring/spring-mvc.xml"})
public class controllerTest {
private MockMvc mockMvc;
@Autowired
private UserService userService;
private UserController uc = new UserController();
@Before
public void setup(){
uc.setUserService(userService);
}
@Test
public void testUserCtlr() throws Exception{
//UserController uc = new UserController();
mockMvc = standaloneSetup(uc).build();
System.out.println("asdgdsg");
MvcResult result = mockMvc.perform(get("/users")).andReturn();
String strJson = result.getResponse().getContentAsString();
System.out.println(strJson);
}
}
下面的资源可以从main目录下面复制过来,然后修改jdbc.properties文件中的的数据库配置,配到测试环境,就可以了。
我的是
jdbc.driver=com.mysql.jdbc.Driver
#jdbc.url=jdbc:mysql://set-gh-dba-dba-hulk-test181.corp.sankuai.com:5002/movie_service
#jdbc.username=movie_service
#jdbc.password=movie_service
jdbc.url=jdbc:mysql://127.0.0.1:3306/testsql1 //这里面从testsql 改到testsql1了
jdbc.username=root
jdbc.password=
#connection pool settings
# maxIdle是最大的空闲连接数,这里取值为20,表示即使没有数据库连接时依然可以保持20个空闲的连接,它们不会被清除,随时处于待命状态
# maxActive是最大激活连接数,这里取值为190,表示同时最多有190个数据库连接
jdbc.pool.maxIdle=20
jdbc.pool.minIdle=2
jdbc.pool.maxActive=190
jdbc.pool.maxIdleTime=60