maven+springMVC+hibernate项目搭建（三spring配置结束）

2.spring4+springmvc+hibernate4+mysql配置和demo

（1）先贴上项目目录结构（spring项目一般4层结构，entity，dao，service，controller，具体各层功能和文件夹等组织结构不是很清楚，

也在学习思考当中。这里只给了个例子，没写service层的东西）

（2）添加项目所需jar包

方法1：通过maven搜索添加 双击pom.xml文件->右侧窗口选择Dependencies->add，弹框如下

在中间输入关键字，Search Reaults窗口会自动匹配要用到的jar包，选中后点击OK，自动添加到pom.xml，无需手动填写。

下面列出个人测试需要的jar，只是基础部分，项目中用到别的jar，再进行引用（例：fastjson那个jar）。

这里可能遇到一个问题，搜索框输入后，results内不显示内容

解决方案为：Window->Preferences->Maven 选中途中两个选择确定

之后到主页面，下面之前打开的窗口，右键Local Repository或者central这两个，Update Index，问题应该就解决了

方法2：手动填写pom.xml文件，选择双击pom.xml文件弹出窗口，最右侧标签pom.xml，填写内容如下（注:hibernate-c3p0如果是5.0版本会有异常）

<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>com.mytest</groupId>
	<artifactId>cms</artifactId>
	<packaging>war</packaging>
	<version>0.0.1-SNAPSHOT</version>
	<name>cms Maven Webapp</name>
	<url>http://maven.apache.org</url>
	<dependencies>
		<dependency>
			<groupId>junit</groupId>
			<artifactId>junit</artifactId>
			<version>3.8.1</version>
			<scope>test</scope>
		</dependency>
		<dependency>
			<groupId>javax.servlet</groupId>
			<artifactId>servlet-api</artifactId>
			<version>2.5</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-core</artifactId>
			<version>4.1.6.RELEASE</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-beans</artifactId>
			<version>4.1.6.RELEASE</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-context</artifactId>
			<version>4.1.6.RELEASE</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-aop</artifactId>
			<version>4.1.6.RELEASE</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-context-support</artifactId>
			<version>4.1.6.RELEASE</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-jdbc</artifactId>
			<version>4.1.6.RELEASE</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-orm</artifactId>
			<version>4.1.6.RELEASE</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-webmvc</artifactId>
			<version>4.1.6.RELEASE</version>
		</dependency>
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-web</artifactId>
			<version>4.1.6.RELEASE</version>
		</dependency>
		<dependency>
			<groupId>org.hibernate</groupId>
			<artifactId>hibernate-core</artifactId>
			<version>4.3.5.Final</version>
			<type>jar.lastUpdated</type>
		</dependency>
		<dependency>
			<groupId>org.hibernate</groupId>
			<artifactId>hibernate-c3p0</artifactId>
			<version>4.3.8.Final</version>
		</dependency>
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>5.1.35</version>
		</dependency>
		<dependency>
			<groupId>com.alibaba</groupId>
			<artifactId>fastjson</artifactId>
			<version>1.2.16</version>
		</dependency>
		<dependency>
			<groupId>org.jboss.logging</groupId>
			<artifactId>jboss-logging</artifactId>
			<version>3.3.0.Beta1</version>
		</dependency>
		<dependency>
			<groupId>org.hibernate.common</groupId>
			<artifactId>hibernate-commons-annotations</artifactId>
			<version>4.0.4.Final</version>
			<type>jar.lastUpdated</type>
		</dependency>
	</dependencies>
	<build>
		<finalName>cms</finalName>
	</build>
</project>

（3）. 项目入口文件web.xml文件配置如下，在src->main->webapp->WEB-INF文件夹下，内容如下

配置文件放到src/main/resources目录下了，所以这里设置启动扫描classpath:spring*.xml文件

servlet名称为springMVC，实际spring配置文件是springMVC-servelet.xml

<!DOCTYPE web-app PUBLIC
 "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
 "http://java.sun.com/dtd/web-app_2_3.dtd" >

<web-app>
	<display-name>Archetype Created Web Application</display-name>
	<context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:spring*.xml</param-value>
    </context-param>
	<listener>
		<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
	</listener>
	<servlet>
		<servlet-name>springMVC</servlet-name>
		<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
		<init-param>
			<param-name>contextConfigLocation</param-name>
			<param-value>classpath:/springMVC*.xml</param-value>
		</init-param>
		<load-on-startup>1</load-on-startup>
	</servlet>
	<servlet-mapping>
		<servlet-name>springMVC</servlet-name>
		<url-pattern>/</url-pattern>
	</servlet-mapping>
</web-app>

（4）.springMVC+hibernate4事务，数据库连接配置文件springMVC-servelet.xml。

里边有一些注释，具体的也没测试过。能完成根据entity注解，自动更新表结构。在sessionFactory属性中配置的。

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:mvc="http://www.springframework.org/schema/mvc" 
	xmlns:context="http://www.springframework.org/schema/context"
	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/mvc
        http://www.springframework.org/schema/mvc/spring-mvc-4.1.xsd   
        http://www.springframework.org/schema/beans    
        http://www.springframework.org/schema/beans/spring-beans-4.1.xsd
        http://www.springframework.org/schema/context    
        http://www.springframework.org/schema/context/spring-context-4.1.xsd
        http://www.springframework.org/schema/aop
        http://www.springframework.org/schema/aop/spring-aop-4.1.xsd
        http://www.springframework.org/schema/tx
        http://www.springframework.org/schema/tx/spring-tx-4.1.xsd"
	default-autowire="byName">
	
	<context:component-scan base-package="com.cms.*" />	
	<mvc:annotation-driven />
	<!--加载静态资源配置，如js,html,css-->
	<mvc:default-servlet-handler/>
	<bean
		class="org.springframework.web.servlet.view.InternalResourceViewResolver">
		<property name="prefix" value="/" />
		<property name="suffix" value=".jsp" />
	</bean>


	<!-- 加载资源文件 其中包含变量信息，必须在Spring配置文件的最前面加载，即第一个加载 -->
	<context:property-placeholder location="classpath:config.properties" />


	<!-- 配置数据源 -->
	<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
		<property name="driverClass" value="${jdbc.driverClass}"></property>
		<property name="jdbcUrl" value="${jdbc.url}"></property>
		<property name="user" value="${jdbc.user}"></property>
		<property name="password" value="${jdbc.password}"></property>
		<!-- 其他配置 -->
		<!--初始化时获取三个连接，取值应在minPoolSize与maxPoolSize之间。Default: 3 -->
		<property name="initialPoolSize" value="3"></property>
		<!--连接池中保留的最小连接数。Default: 3 -->
		<property name="minPoolSize" value="3"></property>
		<!--连接池中保留的最大连接数。Default: 15 -->
		<property name="maxPoolSize" value="5"></property>
		<!--当连接池中的连接耗尽的时候c3p0一次同时获取的连接数。Default: 3 -->
		<property name="acquireIncrement" value="3"></property>
		<!-- 控制数据源内加载的PreparedStatements数量。如果maxStatements与maxStatementsPerConnection均为0，则缓存被关闭。Default:0 -->
		<property name="maxStatements" value="8"></property>
		<!--maxStatementsPerConnection定义了连接池内单个连接所拥有的最大缓存statements数。Default: 0 -->
		<property name="maxStatementsPerConnection" value="5"></property>
		<!--最大空闲时间,1800秒内未使用则连接被丢弃。若为0则永不丢弃。Default: 0 -->
		<property name="maxIdleTime" value="1800"></property>
	</bean>


	<!-- spring Hibernate SessionFactory -->
	<bean id="sessionFactory"
		class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
		<property name="dataSource" ref="dataSource"></property>
		<property name="packagesToScan" value="com.cms.*"></property>
		<property name="hibernateProperties">
			<props>
				<prop key="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</prop>
				<prop key="hibernate.show_sql">true</prop>
				<prop key="hibernate.format_sql">false</prop>
				<prop key="hibernate.jdbc.fetch_size">80</prop>
				<prop key="hibernate.jdbc.batch_size">35</prop>
				<prop key="hibernate.hbm2ddl.auto">update</prop>
			</props>
		</property>
	</bean>


	<!-- 配置Hibernate事务管理器 -->
	<bean id="transactionManager"
		class="org.springframework.orm.hibernate4.HibernateTransactionManager">
		<property name="sessionFactory" ref="sessionFactory" />
	</bean>
	
	<!-- 配置事务异常封装 -->
    <bean id="persistenceExceptionTranslationPostProcessor" 
       class="org.springframework.dao.annotation.PersistenceExceptionTranslationPostProcessor" />
     <!--  声明式容器事务管理 ,transaction-manager指定事务管理器为transactionManager -->
    <tx:annotation-driven transaction-manager="transactionManager" proxy-target-class="true"/>
 
</beans>

（5）上面文件上部先加载了一个 config.properties文件，用于配置一些参数，如${jdbc.driverClass}

jdbc.driverClass=com.mysql.jdbc.Driver

jdbc.url=jdbc:mysql://localhost:3306/sme?useUnicode=true&characterEncoding=utf-8

jdbc.user=root
jdbc.password=root
jdbc.initialPoolSize=1
jdbc.minPoolSize=1
jdbc.maxPoolSize=10

（6）请确定数据库开启，用数据库工具（这里是Navicat for MySQL）打开数据库并创建sme数据库。

数据表无需创建按照下面给出代码，可自动创建。

（7）样例代码

User.java

package com.cms.user.entity;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name="user")
public class User {

	@Column(name = "id")
	@Id
	String id;
	
	@Column(name = "username")
	String userName;
	
	@Column(name = "sex")
	String sex;

	@Column(name = "age")
	Integer age;
	
	public String getId() {
		return id;
	}

	public void setId(String id) {
		this.id = id;
	}

	public String getUserName() {
		return userName;
	}

	public void setUserName(String userName) {
		this.userName = userName;
	}

	public String getSex() {
		return sex;
	}

	public void setSex(String sex) {
		this.sex = sex;
	}

	public Integer getAge() {
		return age;
	}

	public void setAge(Integer age) {
		this.age = age;
	}
}

UserDaoImpl.java

package com.cms.user.dao.impl;

import javax.annotation.Resource;

import org.hibernate.SessionFactory;
import org.springframework.stereotype.Repository;

import com.cms.base.impl.BaseDaoImpl;
import com.cms.user.dao.UserDao;
import com.cms.user.entity.User;

@Repository("userDao")
public class UserDaoImpl extends BaseDaoImpl<User, String> implements UserDao{
	
	@Resource(name="sessionFactory")
	private SessionFactory sessionFactory;

	public void saveA(User user){
		this.sessionFactory.getCurrentSession().saveOrUpdate(user);
	}
}

UserDao.java

package com.cms.user.dao;

import com.cms.user.entity.User;

public interface UserDao {

	public void saveA(User user);
}

UserServiceImpl.java

package com.cms.user.service.impl;

import javax.annotation.Resource;

import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import com.cms.base.impl.BaseServiceImpl;
import com.cms.user.dao.UserDao;
import com.cms.user.entity.User;
import com.cms.user.service.UserService;

@Service("userService")
@Transactional
public class UserServiceImpl extends BaseServiceImpl<User, String> implements UserService{

	@Resource(name="userDao")
	private UserDao userDao;
	
	public void saveA(User user)throws Exception {
		this.userDao.saveA(user);
	}
}

UserService.java

package com.cms.user.service;

import com.cms.base.BaseService;
import com.cms.user.entity.User;

public interface UserService extends BaseService<User, String>{
	
	public void saveA(User user) throws Exception;
}

UserController.java

package com.cms.user.controller;

import javax.annotation.Resource;

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.alibaba.fastjson.JSON;
import com.cms.user.entity.User;
import com.cms.user.service.UserService;
@Controller
@ResponseBody
@RequestMapping("/user")
public class UserController {
	@Resource(name = "userService")
	private UserService userService;
	
	@RequestMapping("/getUserName")
	public String getUserName(User u){
		User uu = this.userService.find(u.getId());
		try {
			this.userService.saveA(u);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return "111";
	}
}

（8）可以进行测试了，先在数据库添加一条数据啊

在浏览器输入http://localhost:8080/cms/user/getUserName?id=10&age=14&userName=222&sex=3

看看是否能返回111，并在数据库查询该条数据是否更新了字段，如果是，祝贺你成功完成了。

如果没有，哈哈哈，看console日志错误吧，真的可能会有各种异常，我也是一点点查错，蒙出来的。

按照这个如果还有问题的话，啊，祝你好运，请认真搜索解决方案。

希望能对一开始接触spring框架的有些帮助。感谢csdn和其它网站各位给出的配置说明，在各位帮助下终于攒出一个基本框架。

在该项目中终于能添加功能了。