spring spring mvc hibernate整合（注解）（xml）

一、項目結構

二、采用maven管理架構所使用到的架包 pom檔案如下

<!-- 設定架包版本配置 -->
  <properties>
  	<spring.version>4.2.6.RELEASE</spring.version>
  </properties>
  
  <!-- 依賴架包 -->
  <dependencies>
  	<!-- spring 依賴 -->
  	 <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-core</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-web</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <!-- 使用SpringMVC需配置 -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-webmvc</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <!-- 關系型資料庫整合時需配置 如hibernate jpa等 -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-orm</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-tx</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-test</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-jdbc</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-expression</artifactId>
        <version>${spring.version}</version>
    </dependency>
    
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-aop</artifactId>
        <version>${spring.version}</version>
    </dependency>
    
    <!-- log4j 依賴 -->
  	<dependency>
	    <groupId>log4j</groupId>
	    <artifactId>log4j</artifactId>
	    <version>1.2.14</version>
	</dependency>
	
  	<!-- hibernate 依賴 -->
  	<dependency>
        <groupId>org.hibernate</groupId>
        <artifactId>hibernate-core</artifactId>
        <version>4.3.5.Final</version>
    </dependency>
    
    <dependency>
		<groupId>org.hibernate</groupId>
		<artifactId>hibernate-ehcache</artifactId>
		<version>4.3.5.Final</version>
	</dependency>
	

  	<!-- 資料源 依賴 -->
		<dependency>
		    <groupId>commons-dbcp</groupId>
		    <artifactId>commons-dbcp</artifactId>
		    <version>1.2.2</version>
		</dependency>
		
	<!-- json依賴 -->
	<dependency>
	    <groupId>com.fasterxml.jackson.core</groupId>
	    <artifactId>jackson-core</artifactId>
	    <version>2.5.1</version>
	</dependency>
	<dependency>
	    <groupId>com.fasterxml.jackson.core</groupId>
	    <artifactId>jackson-annotations</artifactId>
	    <version>2.5.1</version>
	</dependency>
	<dependency>
	    <groupId>com.fasterxml.jackson.core</groupId>
	    <artifactId>jackson-databind</artifactId>
	    <version>2.5.1</version>
	</dependency>
	
  	<!--  servlet 運作時環境依賴 -->
  	<dependency>    
        <groupId>javax.servlet</groupId>    
        <artifactId>servlet-api</artifactId>
        <version>2.5</version>
        <!-- 隻在編譯的classpath中加載和使用，打包的時候不會包含在目标包中。 -->
        <scope>provided</scope>
    </dependency>
  	<!-- 資料庫驅動 -->	
	 <dependency>
            <groupId>com.oracle</groupId>
            <artifactId>ojdbc6</artifactId>
            <version>6.0</version>
        </dependency>
     <!-- https://mvnrepository.com/artifact/jstl/jstl -->
	<dependency>
	    <groupId>jstl</groupId>
	    <artifactId>jstl</artifactId>
	    <version>1.2</version>
	</dependency>
     
     <!-- https://mvnrepository.com/artifact/taglibs/standard -->
	<dependency>
	    <groupId>taglibs</groupId>
	    <artifactId>standard</artifactId>
	    <version>1.1.2</version>
	</dependency>
     
  </dependencies>

三、整合spring hibernate 配置的spring-hibernate.xml

db.properties 檔案

jdbc.driver=oracle.jdbc.driver.OracleDriver
jdbc.url=jdbc:oracle:thin:@100.100.70.31:1521:hcdb
jdbc.username=tyh
jdbc.password=1234
hibernate.dialect=org.hibernate.dialect.Oracle9Dialect
hibernate.show_sql=true

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:context="http://www.springframework.org/schema/context"
    xmlns:mvc="http://www.springframework.org/schema/mvc"
    xmlns:p="http://www.springframework.org/schema/p"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:tx="http://www.springframework.org/schema/tx"
    xsi:schemaLocation="
        http://www.springframework.org/schema/beans     
        http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context-3.0.xsd
        http://www.springframework.org/schema/mvc
        http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd
        http://www.springframework.org/schema/tx
        http://www.springframework.org/schema/tx/spring-tx-3.1.xsd
        ">
        <context:component-scan base-package="com.sxc.ssh.*"></context:component-scan>
   <!-- 加載db配置檔案 -->
   <context:property-placeholder location="classpath:db.properties"/>
  
   <!-- 配置資料源 datasource -->     
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
    	<property name="driverClassName" value="${jdbc.driver}"></property>
    	<property name="url" value="${jdbc.url}"></property>
    	<property name="username" value="${jdbc.username}"></property>
    	<property name="password" value="${jdbc.password}"></property>
    </bean>
    
   <!--  配置sessionFactory,hibernate配置 -->
    <bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
    	<property name="dataSource" ref="dataSource"></property>
    	<property name="packagesToScan" value="com.sxc.ssh.entity" />
    	<property name="hibernateProperties">
    		<props>
    			<prop key="hibernate.dialect">${hibernate.dialect}</prop>
    			<prop key="hibernate.show_sql">${hibernate.show_sql}</prop>
    		</props>
    	</property>
    </bean>
    <!-- 建立hibernateTemplate 模闆類 -->
    <bean id="hibernateTemplate" class="org.springframework.orm.hibernate4.HibernateTemplate">
    	<property name="sessionFactory" ref="sessionFactory" />
    </bean>
    
 <!--    配置事物管理器transcationManager -->
 <bean id="tansactionManager"
 					 class="org.springframework.orm.hibernate4.HibernateTransactionManager">
 	<property name="sessionFactory" ref="sessionFactory" />
 </bean>
 
 <!--啟動注解用注解來管理事務-->  
 <tx:annotation-driven transaction-manager="transactionManager"/>
 
</beans>

四、spring mvc配置 spring-servlet.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:context="http://www.springframework.org/schema/context"
    xmlns:mvc="http://www.springframework.org/schema/mvc"
    xmlns:p="http://www.springframework.org/schema/p"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:tx="http://www.springframework.org/schema/tx"
    xsi:schemaLocation="
        http://www.springframework.org/schema/beans     
        http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
        http://www.springframework.org/schema/context
        http://www.springframework.org/schema/context/spring-context-3.0.xsd
        http://www.springframework.org/schema/mvc
        http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd
        http://www.springframework.org/schema/tx
        http://www.springframework.org/schema/tx/spring-tx-3.1.xsd
        ">
        <!-- 啟動自動掃描該包下的所有bean -->
     <context:component-scan base-package="com.sxc.ssh.*" />
     
     <!-- 配置請求url傳回json資料 -->
     <bean class="org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping" />
	    <bean class="org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter">
	    <property name="messageConverters">
	            <list>
                <bean class="org.springframework.http.converter.StringHttpMessageConverter">
                    <property name="supportedMediaTypes">
                        <list>
                            <value>text/html; charset=UTF-8</value>
                            <value>application/json;charset=UTF-8</value>
                        </list>
                    </property>
                </bean>
                <bean class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter">
                    <property name="supportedMediaTypes">
                        <list>
                            <value>text/html; charset=UTF-8</value>
                            <value>application/json;charset=UTF-8</value>
                        </list>
                    </property>
                </bean>
            </list>
        </property>
    </bean>
     
     <!-- 定義視圖解析器 -->
     <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
     	<property name="prefix" value="/view/"></property>
     	<property name="suffix" value=".jsp"></property>
     </bean>
     
</beans>

五、web.xml 配置

<?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_2_5.xsd" id="WebApp_ID" 
		version="2.5">
		<!-- 加載所有資源配置檔案 -->
		<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>
			<servlet-name>ssh-servlet</servlet-name>
			<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
			<init-param>
			<!-- 預設/WEB-INF/[servlet名字]-servlet.xml加載上下文， 
		          如果配置了contextConfigLocation參數，
		          将使用classpath:/lei-dispatcher-servlet.xml加載上下文
		      -->
				<param-name>contextConfigLocation</param-name>
				<param-value>classpath:/sepring-servlet.xml</param-value>
			</init-param>
			<load-on-startup>1</load-on-startup>
		</servlet>
		<servlet-mapping>
		 <!-- 攔截比對的請求，這裡所有請求采用名字為ssh-servlet的DispatcherServlet處理 -->
			<servlet-name>ssh-servlet</servlet-name>
			<url-pattern>/rest/*</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>  
</web-app>

六、測試代碼

（1）實體類

@Entity
@Table(name="MES_PLANT")
public class MesPlant implements Serializable {
	private static final long serialVersionUID = 1L;

	@Id
	@Column(name="M_PLANT_ID")
	private String mPlantId;

	@Column(name="CREATE_DATE")
	private Date createDate;

	@Column(name="CREATE_USER")
	private String createUser;

	@Column(name="CREATE_USER_NAME")
	private String createUserName;

	@Column(name="LAST_DATE")
	private Date lastDate;

	@Column(name="LAST_USER")
	private String lastUser;

	@Column(name="LAST_USER_NAME")
	private String lastUserName;

	@Column(name="M_ORG_ID")
	private String mOrgId;

	private String plant;

	@Column(name="PLANT_NAME")
	private String plantName;

	@Column(name="\"SORT\"")
	private BigDecimal sort;

	public MesPlant() {
	}

	public String getMPlantId() {
		return this.mPlantId;
	}

	public void setMPlantId(String mPlantId) {
		this.mPlantId = mPlantId;
	}

	public Date getCreateDate() {
		return this.createDate;
	}

	public void setCreateDate(Date createDate) {
		this.createDate = createDate;
	}

	public String getCreateUser() {
		return this.createUser;
	}

	public void setCreateUser(String createUser) {
		this.createUser = createUser;
	}

	public String getCreateUserName() {
		return this.createUserName;
	}

	public void setCreateUserName(String createUserName) {
		this.createUserName = createUserName;
	}

	public Date getLastDate() {
		return this.lastDate;
	}

	public void setLastDate(Date lastDate) {
		this.lastDate = lastDate;
	}

	public String getLastUser() {
		return this.lastUser;
	}

	public void setLastUser(String lastUser) {
		this.lastUser = lastUser;
	}

	public String getLastUserName() {
		return this.lastUserName;
	}

	public void setLastUserName(String lastUserName) {
		this.lastUserName = lastUserName;
	}

	public String getMOrgId() {
		return this.mOrgId;
	}

	public void setMOrgId(String mOrgId) {
		this.mOrgId = mOrgId;
	}

	public String getPlant() {
		return this.plant;
	}

	public void setPlant(String plant) {
		this.plant = plant;
	}

	public String getPlantName() {
		return this.plantName;
	}

	public void setPlantName(String plantName) {
		this.plantName = plantName;
	}

	public BigDecimal getSort() {
		return this.sort;
	}

	public void setSort(BigDecimal sort) {
		this.sort = sort;
	}

}

（2）dao層

@Repository
public class PlantDaoImpl implements PlantDao {

	@Autowired
	private HibernateTemplate hibernateTemplate;
	
	public List<MesPlant> getAll() {
		return (List<MesPlant>) hibernateTemplate.find("from MesPlant");
	}

	public static void main(String[] args) {
		ApplicationContext app = 
				new ClassPathXmlApplicationContext("classpath:spring-hibernate.xml");
		PlantDao pd = (PlantDao) app.getBean("plantDao");
		List<MesPlant> lsit = pd.getAll();
		
		for (MesPlant mesPlant : lsit) {
			System.out.println(mesPlant.getPlantName());
		}
	}
}

（3）service層

package com.sxc.ssh.service.impl;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.sxc.ssh.dao.PlantDao;
import com.sxc.ssh.entity.MesPlant;
import com.sxc.ssh.service.PlantService;

@Service
public class PlantServiceImpl implements PlantService {

	@Autowired
	private PlantDao plantDao;
	
	public List<MesPlant> getAll() {
		
		return plantDao.getAll();
	}

}

（4）controller層

@RestController
@RequestMapping(path="plantCtrl")
public class PlantCtrl {

	@Autowired
	private PlantService plantService;
	
	@RequestMapping(path="getAll",method=RequestMethod.GET)
	public List<MesPlant> getAll(){
		return plantService.getAll();
	}
	
	@RequestMapping(path="getPlant",method=RequestMethod.GET)
	public ModelAndView getPlant(){
		ModelAndView md = new ModelAndView();
		md.addObject("list", plantService.getAll());
		md.setViewName("index");
		return md;
	}
}

至此spring spring mvc hibernate整合完成

spring spring mvc hibernate整合（注解）（xml）

三、整合spring hibernate 配置的spring-hibernate.xml

四、spring mvc配置 spring-servlet.xml

繼續閱讀

Spring Cloud整合Sleuth，當請求完成後，Zipkin沒有鍊路資訊

JAVA自學之路——馬士兵

隻進 ResultSet 不支援請求的操作。

Rabbitmq指令行手動建立隊列

整合 Spring 開發架構及服務端技術

SSM整合02---Spring-SpringMVC層一、添加web架構支援二、web.xml三、spring-mvc.xml

SSM架構（二）------------表現層的SpringMVC

Intellij idea基于Maven 的SSM 架構整合

Spring資料和Redis

SpringMVC的啟動過程源碼分析1 SpringMVC 配置XML的方式啟動2 SpringMVC純注解模式啟動

Java Spring 架構

Hibernate使用Hibernate的“3個準備，7個步驟”Hibernate API簡介操作實體對象對象識别

SpringCloud微服務（四）之ribbon筆記ribbon是什麼？入門案例自定義均衡負載算法

Could not determine type for: String

SpringMVC傳回用戶端Json/XML資料

Ajax發送和擷取json資料到Spring mvc 1.spring mvc後端2.web前段