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

最新推荐文章于 2023-10-14 22:30:33 发布

趴一会

最新推荐文章于 2023-10-14 22:30:33 发布

阅读量1.2k

点赞数 1

本文链接：https://blog.csdn.net/luqili1990/article/details/48970567

版权

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>

整体结构图: