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/beans
http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop-4.0.xsd
http://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=root
jdbcUrl=jdbc:mysql://localhost:3306/hr
password=*******
driverClass=com.mysql.jdbc.Driver
mypro_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;
@Controller
public 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{
@Override
public User getUserById(Integer id ){
return getSqlSession().selectOne("com.lu.db.beans.User.selectUser", id);
}
@Override
public User getUserByName(String name ){
return getSqlSession().selectOne("com.lu.db.beans.User.selectUserByName", name);
}
@Override
public List<User> getUserLikeName(String name ){
return getSqlSession().selectList("com.lu.db.beans.User.selectUserLikeName", getLikeKey(name));
}
@Override
public 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;
}
@Override
public 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>
整体结构图:
流程基本就是这个情况,有不合理的地方还请指正.