spring mvc 环境搭建

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"><welcome-file-list><welcome-file>index.jsp</welcome-file></welcome-file-list><context-param><param-name>log4jRefreshInterval</param-name><param-value>3000</param-value></context-param><listener><listener-class>org.springframework.web.util.Log4jConfigListener</listener-class></listener><context-param><param-name>webAppRootKey</param-name><param-value>webapp.root</param-value></context-param><!-- spring core 配置 --><servlet><servlet-name>spring</servlet-name><!-- 该拦截器默认加载servlet.xml 格式的 --><servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class><!-- load-on-startup：表示启动容器时初始化该Servlet --><init-param><param-name>contextConfigLocation</param-name><param-value>classpath:main-servlet.xml</param-value></init-param><load-on-startup>1</load-on-startup></servlet><!-- 所有的请求交由spring进行拦截 --><servlet-mapping><servlet-name>spring</servlet-name><url-pattern>/api/*</url-pattern></servlet-mapping></web-app>

main-servlet.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-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/mvc                            http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">                          <!-- 扫描com.eazy下面的所有注解 --><context:component-scan base-package="com.eazy" /> <mvc:annotation-driven /><!-- 引入配置文件 --><bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"><property name="location" value="classpath:db.properties" /></bean><bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"destroy-method="close"><property name="driverClassName" value="${db.driver}" /><property name="url" value="${db.url}" /><property name="username" value="${db.username}" /><property name="password" value="${db.password}" /><!-- 初始化连接大小 --><property name="initialSize" value="${initialSize}"></property><!-- 连接池最大数量 --><property name="maxActive" value="${maxActive}"></property><!-- 连接池最大空闲 --><property name="maxIdle" value="${maxIdle}"></property><!-- 连接池最小空闲 --><property name="minIdle" value="${minIdle}"></property><!-- 获取连接最大等待时间 --><property name="maxWait" value="${maxWait}"></property></bean><!-- 定义事务管理 --><bean id="transactionManager"class="org.springframework.jdbc.datasource.DataSourceTransactionManager"p:dataSource-ref="dataSource" /><!-- 配置Jdbc模板 --><bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate"><property name="dataSource" ref="dataSource" /></bean><!-- 文件上传 --><bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">          <property name="defaultEncoding" value="utf-8"></property>           <property name="maxUploadSize" value="10485760000"></property>          <property name="maxInMemorySize" value="40960"></property>      </bean>  <!-- 转换返回json格式配置 --><beanclass="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter"><property name="messageConverters"><list><ref bean="mappingJacksonHttpMessageConverter" /></list></property></bean><bean id="mappingJacksonHttpMessageConverter" class="org.springframework.http.converter.json.MappingJacksonHttpMessageConverter" /></beans>

db.properties

db.driver=com.mysql.jdbc.Driverdb.url=jdbc:mysql://127.0.0.1:3306/testdb.username=accpdb.password=#\u5B9A\u4E49\u521D\u59CB\u8FDE\u63A5\u6570  initialSize=0#\u5B9A\u4E49\u6700\u5927\u8FDE\u63A5\u6570  maxActive=20#\u5B9A\u4E49\u6700\u5927\u7A7A\u95F2  maxIdle=20#\u5B9A\u4E49\u6700\u5C0F\u7A7A\u95F2  minIdle=1#\u5B9A\u4E49\u6700\u957F\u7B49\u5F85\u65F6\u95F4  maxWait=60000

log4j

log4j.rootLogger=DEBUG, CONSOLE,FILElog4j.appender.CONSOLE=org.apache.log4j.ConsoleAppenderlog4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayoutlog4j.appender.CONSOLE.layout.ConversionPattern=%-d{yyyy-MM-dd HH:mm:ss,SSS} [%c]-[%p] %m%nlog4j.appender.FILE=org.apache.log4j.RollingFileAppenderlog4j.appender.FILE.File=E://log/login_server.loglog4j.appender.FILE.MaxFileSize=4000KBlog4j.appender.FILE.MaxBackupIndex=10log4j.appender.FILE.layout=org.apache.log4j.PatternLayoutlog4j.appender.FILE.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss,SSS} [%c]-[%p] %m%nlog4j.logger.org.apache.commons.httpclient.HttpClient=ERRORlog4j.logger.org.apache.commons.httpclient.params.DefaultHttpParams=ERRORlog4j.logger.org.apache.commons.httpclient.methods.EntityEnclosingMethod=ERRORlog4j.logger.org.apache.commons.httpclient.HttpMethodBase=ERRORlog4j.logger.org.apache.commons.httpclient.HttpConnection=ERRORlog4j.logger.httpclient.wire.content=ERRORlog4j.logger.httpclient.wire.header=ERROR

--------------------------------------------------------------------------分割线---------------------------------------------------------

dao层代码

package com.eazy.dao;import java.util.List;import java.util.Map;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.jdbc.core.JdbcTemplate;import org.springframework.stereotype.Repository;// 标注为Dao层 默认当前类名@Repositorypublic class UserDao {@Autowired private JdbcTemplate jdbcTemplate;// 查询用户列表public List<Map<String,Object>> selectUser() {return jdbcTemplate.queryForList("select * from user");}}

service 层代码

package com.eazy.service;import java.util.List;import java.util.Map;public interface UserService {public List<Map<String,Object>> selectUser();}

service impl

package com.eazy.service.impl;import java.util.List;import java.util.Map;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;import com.eazy.dao.UserDao;import com.eazy.service.UserService;// 服务标注，推荐使用@Servicepublic class UserServiceImpl implements UserService {@Autowiredprivate UserDao userDao;public List<Map<String, Object>> selectUser() {return userDao.selectUser();}}

controller

package com.eazy.controller;import java.util.HashMap;import java.util.Map;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Controller;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.RequestMethod;import org.springframework.web.bind.annotation.ResponseBody;import com.eazy.service.UserService;@Controller@RequestMapping("/user")public class UserController {// controller 提供spring restful 功能，把返回数据提供给手机端，适合用于api 提供@Autowiredprivate UserService userService;@RequestMapping(value = "list" , method = RequestMethod.GET)@ResponseBodypublic Map<String,Object> selectUser() {Map<String,Object> map = new HashMap<String,Object>();map.put("result", userService.selectUser());return map;}}