Eclipse创建WEB工程Maven+Spring+SpringMVC+MyBatis示例

Eclipse创建WEB工程Maven+Spring+SpringMVC+MyBatis示例

准备工作:

1.下载 JDK 地址: http://www.oracle.com/technetwork/java/javase/downloads/index-jsp-138363.html

2.下载 Eclipse 地址: http://www.eclipse.org/downloads/

3.下载 Tomcat 地址:http://tomcat.apache.org/download-80.cgi

Windows下 :

  先安装JDK,直接 下一步到底,安装版的JDK无需配置环境变量

  Eclipse解压后直接能用

  Tomcat解压后使用(其他细节以后有机会再补充)

首次写Blog,请见谅.

1.打开Eclipse JEE版,我使用的版本为:eclipse-jee-mars-R-win32-x86_64

2.配置Tomcat   Window->Preferences->Server->Runtime Environments Add... 选择对应的服务器容器版本 如 Apache Tomcat v7.0 设置Tomcat文件目录

3.File->New->Dynamic Web Project

在生成web.xml上划上对勾

4.工程名上右键 选择configure -> Convert to Maven Project 转换为Maven工程

5.增加必备Jar包 Spring SpringMVC MyBatis 

<properties><dependencies>标签下问新增内容 pom.xml文件如下 <dependencies>标签下问新增内容

<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/xsd/maven-4.0.0.xsd"><modelVersion>4.0.0</modelVersion><groupId>TestSSM</groupId><artifactId>TestSSM</artifactId><version>0.0.1-SNAPSHOT</version><packaging>war</packaging><properties><spring.version>4.0.6.RELEASE</spring.version></properties><dependencies><dependency><groupId>org.springframework</groupId><artifactId>spring-webmvc</artifactId><version>${spring.version}</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-orm</artifactId><version>${spring.version}</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-context-support</artifactId><version>${spring.version}</version></dependency><dependency><groupId>org.mybatis</groupId><artifactId>mybatis</artifactId><version>3.3.0</version></dependency><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>5.1.35</version></dependency><dependency><groupId>log4j</groupId><artifactId>log4j</artifactId><version>1.2.17</version></dependency><dependency><groupId>junit</groupId><artifactId>junit</artifactId><version>4.12</version><scope>test</scope></dependency></dependencies><build><sourceDirectory>src</sourceDirectory><plugins><plugin><artifactId>maven-compiler-plugin</artifactId><version>3.3</version><configuration><source>1.7</source><target>1.7</target></configuration></plugin><plugin><artifactId>maven-war-plugin</artifactId><version>2.6</version><configuration><warSourceDirectory>WebContent</warSourceDirectory><failOnMissingWebXml>false</failOnMissingWebXml></configuration></plugin></plugins></build></project>

6.建包 com.lu.config 存放配置文件(其他位置也可以)

7.添加Spring配置文件 applicationCentext.xml

详细内容:

<?xml version="1.0" encoding="UTF-8"?><beans xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xmlns:p="http://www.springframework.org/schema/p"xmlns="http://www.springframework.org/schema/beans"xmlns:tx="http://www.springframework.org/schema/tx" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:context="http://www.springframework.org/schema/context" xsi:schemaLocation="http://www.springframework.org/schema/beanshttp://www.springframework.org/schema/beans/spring-beans-4.0.xsd http://www.springframework.org/schema/txhttp://www.springframework.org/schema/tx/spring-tx-4.0.xsd http://www.springframework.org/schema/aophttp://www.springframework.org/schema/aop/spring-aop-4.0.xsdhttp://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd "><context:property-placeholder location="classpath:com/lu/config/jdbc.properties"/><!-- 加载配置文件 --><context:component-scan base-package="com.lu"></context:component-scan><!-- 扫描路径,使用注解管理JavaBean --><!-- MyBatis整合 --><bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean" >  <property name="dataSource" ref="dataSource" />  <property name="mapperLocations" value="classpath*:com/lu/db/beans/mappers/*.xml" /></bean><bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close" p:driverClass="${driverClass}" p:jdbcUrl="${jdbcUrl}" p:user="${user}" p:password="${password}"><property name="minPoolSize" value="5"></property>            <property name="maxPoolSize" value="30"></property>            <property name="initialPoolSize" value="10"></property>            <property name="maxIdleTime" value="60"></property>            <property name="acquireIncrement" value="5"></property>            <property name="maxStatements" value="0"></property>                <property name="idleConnectionTestPeriod" value="60"></property>            <property name="acquireRetryAttempts" value="30"></property>            <property name="acquireRetryDelay" value="1000"></property>            <property name="testConnectionOnCheckout" value="false"></property>  <property name="breakAfterAcquireFailure" value="false"></property>  </bean><bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">  <property name="dataSource" ref="dataSource" /></bean><bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">  <constructor-arg ref="sqlSessionFactory"></constructor-arg></bean><tx:annotation-driven transaction-manager="transactionManager"/></beans>

数据库配置文件 jdbc.properties

user=rootjdbcUrl=jdbc:mysql://localhost:3306/hrpassword=*******driverClass=com.mysql.jdbc.Drivermypro_version=1.1.26

8.添加Spring MVC配置文件 eaction-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" xmlns:util="http://www.springframework.org/schema/util"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/util http://www.springframework.org/schema/util/spring-util-4.0.xsd        http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd "><!-- 扫描web包，应用Spring的注解 --><context:component-scan base-package="com.lu.action" /><mvc:annotation-driven><mvc:message-converters><bean class="org.springframework.http.converter.StringHttpMessageConverter"><property name="supportedMediaTypes"><list><value>text/plain;charset=UTF-8</value><value>text/html;charset=UTF-8</value></list></property></bean></mvc:message-converters></mvc:annotation-driven><bean class="org.springframework.web.servlet.view.ContentNegotiatingViewResolver"p:order="0" p:defaultContentType="text/html" p:favorParameter="true"><property name="defaultViews"><list><bean class="org.springframework.web.servlet.view.json.MappingJacksonJsonView"></bean></list></property></bean><!-- 配置视图解析器，将ModelAndView及字符串解析为具体的页面 --><bean class="org.springframework.web.servlet.view.InternalResourceViewResolver" p:prefix="/WEB-INF/views/" p:suffix=".jsp" /><!-- 文件上传,大小为3M=3145728 2M=2097152 1M=1048576 --><bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver" p:defaultEncoding="UTF-8" p:maxUploadSize="3145728" p:uploadTempDir="/uploadfile/temp"p:resolveLazily="true"></bean></beans>

9.编辑web.xml文件,加载Spring

详细内容:

<?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" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0">  <display-name>TestSSM</display-name>  <session-config><!-- SESSION 有效期 --><session-timeout>30</session-timeout><tracking-mode>COOKIE</tracking-mode></session-config><context-param><param-name>contextConfigLocation</param-name><param-value>classpath:com/lu/config/applicationContext.xml</param-value></context-param><listener><listener-class>org.springframework.web.context.ContextLoaderListener</listener-class></listener><servlet><servlet-name>eaction</servlet-name><servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class><init-param><param-name>contextConfigLocation</param-name><param-value>classpath:com/lu/config/eaction-servlet.xml</param-value></init-param><load-on-startup>1</load-on-startup></servlet><servlet-mapping><servlet-name>eaction</servlet-name><url-pattern>*.lu</url-pattern></servlet-mapping><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>  <welcome-file-list>    <welcome-file>index.lu</welcome-file>    <welcome-file>index.html</welcome-file>    <welcome-file>index.htm</welcome-file>    <welcome-file>default.jsp</welcome-file>  </welcome-file-list></web-app>

action的代码示例:

package com.lu.action;import javax.annotation.Resource;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.beans.factory.annotation.Qualifier;import org.springframework.stereotype.Controller;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.servlet.ModelAndView;import com.lu.db.beans.User;import com.lu.db.dao.UserDao;import com.lu.db.dao.impl.UserDaoImpl;import com.lu.service.UserService;@Controllerpublic class Index {@Resource(name = "userService")private UserService userService;@RequestMapping(value = "/index")public ModelAndView OneIndex() {ModelAndView mv = new ModelAndView();mv.addObject("p", "Hello Word!");mv.setViewName("/index/index");return mv;}@RequestMapping(value = "/saveuser")public ModelAndView saveUser(String username, String password, Integer age, String sex) {User u = userService.saveUser(username, password, age, sex.charAt(0));String msg = null;if (u == null) {msg = "用户信息保存失败";} else {msg = "用户信息保存成功,user=" + u;}ModelAndView mv = new ModelAndView();mv.addObject("msg", msg);mv.setViewName("/index/msg");return mv;}@RequestMapping(value = "/getuser")public ModelAndView getUserr(Integer id) {String msg = "";User user = userService.getUserById(id);if (user != null) {msg = user.toString();} else {msg = "未查询到用户信息";}ModelAndView mv = new ModelAndView();mv.addObject("msg", "User=" + msg);mv.setViewName("/index/msg");return mv;}}

DAO代码示例

package com.lu.db.dao;import org.mybatis.spring.support.SqlSessionDaoSupport;public abstract class DaoSupport extends SqlSessionDaoSupport {public String getLikeKey(String key){StringBuffer sbf = new StringBuffer();sbf.append("%");sbf.append(key);sbf.append("%");return sbf.toString();}}

package com.lu.db.dao;import java.util.List;import com.lu.db.beans.User;public interface UserDao {public User getUserById(Integer id );public User getUserByName(String name );public List<User> getUserLikeName(String name );public Integer insertUser(User user);}

package com.lu.db.dao.impl;import java.util.List;import org.apache.ibatis.jdbc.SQL;import org.springframework.stereotype.Repository;import com.lu.db.beans.User;import com.lu.db.dao.DaoSupport;import com.lu.db.dao.UserDao;@Repository(value="userDao")public class UserDaoImpl extends DaoSupport implements UserDao{@Overridepublic User getUserById(Integer id ){return getSqlSession().selectOne("com.lu.db.beans.User.selectUser", id);}@Overridepublic User getUserByName(String name ){return getSqlSession().selectOne("com.lu.db.beans.User.selectUserByName", name);}@Overridepublic List<User> getUserLikeName(String name ){return getSqlSession().selectList("com.lu.db.beans.User.selectUserLikeName", getLikeKey(name));}@Overridepublic Integer insertUser(User user){return getSqlSession().insert("com.lu.db.beans.User.saveUser", user);}public Integer getUserByAge(Integer age){String sql=new SQL(){{SELECT("count(u.id)");FROM("User u");WHERE("u.page=?");}}.toString();System.out.println(sql);return getSqlSession().selectOne(sql, age);}}

Bean代码示例:

package com.lu.db.beans;public class User {private Integer id;private String username;private String password;private Integer page;private Character sex;public Integer getId() {return id;}public void setId(Integer id) {this.id = id;}public String getUsername() {return username;}public void setUsername(String username) {this.username = username;}public String getPassword() {return password;}public void setPassword(String password) {this.password = password;}public Integer getPage() {return page;}public void setPage(Integer page) {this.page = page;}public Character getSex() {return sex;}public void setSex(Character sex) {this.sex = sex;}@Overridepublic String toString() {return "User{id="+this.id+";username="+this.username+";password="+this.password+";page="+this.page+";sex="+this.sex+"}";}}

<?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.lu.db.beans.User"><select id="selectUser" resultType="com.lu.db.beans.User">select * from User where id = #{id}  </select><select id="selectUserByName" resultType="com.lu.db.beans.User">select * from User where username = #{name}  </select><select id="selectUserLikeName" resultType="com.lu.db.beans.User">select * from User where username like #{name}  </select><select id="selectUserNameAndSex" resultType="com.lu.db.beans.User">select * from User where username = #{name} and sex=#{sex}  </select>  <insert id="saveUser" parameterType="com.lu.db.beans.User" useGeneratedKeys="true" keyProperty="id" >  insert into User (username,password,page,sex) values (#{username},#{password},#{page},#{sex})  </insert>  </mapper>

整体结构图:

流程基本就是这个情况,有不合理的地方还请指正.