spring+springmvc+hibernate 整合之web接口开发

最新推荐文章于 2019-06-10 09:28:59 发布

Leoyoe~

最新推荐文章于 2019-06-10 09:28:59 发布

阅读量262

点赞数 2

分类专栏： javaweb 文章标签： ssh springmvc spring hibernate json

本文链接：https://blog.csdn.net/waitfor920/article/details/88598459

版权

javaweb 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

简单的web接口开发，比较简单，适合新手练习熟悉ssh流程，将中间可能会遇到的问题一并附上，代码如下。

1、新建maven工程

2、配置pom文件，添加hibernate、spring、springmvc相关依赖jar包配置

<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>com.udb</groupId>
	<artifactId>udbJsonData</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<packaging>war</packaging>


	<dependencies>
		<!--Spring ORM -->
		<!-- https://mvnrepository.com/artifact/org.springframework/spring-orm -->
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-orm</artifactId>
			<version>4.3.8.RELEASE</version>
		</dependency>
		<!--Spring WebMVC -->
		<!-- https://mvnrepository.com/artifact/org.springframework/spring-web -->
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-webmvc</artifactId>
			<version>4.3.8.RELEASE</version>
		</dependency>
		<!--Spring 切面 -->
		<!-- https://mvnrepository.com/artifact/org.springframework/spring-aspects -->
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-aspects</artifactId>
			<version>4.3.8.RELEASE</version>
		</dependency>
		<!-- Hibernate -->
		<!-- https://mvnrepository.com/artifact/org.hibernate/hibernate-core -->
		<dependency>
			<groupId>org.hibernate</groupId>
			<artifactId>hibernate-core</artifactId>
			<version>4.3.5.Final</version>
		</dependency>
		<!--数据库连接池 -->
		<!-- https://mvnrepository.com/artifact/com.mchange/c3p0 -->
		<dependency>
			<groupId>com.mchange</groupId>
			<artifactId>c3p0</artifactId>
			<version>0.9.5.2</version>
		</dependency>
		<!--数据库连接驱动 -->
		<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>5.1.39</version>
		</dependency>
		<!--JSTL -->
		<!-- https://mvnrepository.com/artifact/javax.servlet/jstl -->
		<dependency>
			<groupId>javax.servlet</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>
		<!--Servlet -->
		<!-- https://mvnrepository.com/artifact/javax.servlet/javax.servlet-api -->
		<dependency>
			<groupId>javax.servlet</groupId>
			<artifactId>javax.servlet-api</artifactId>
			<version>3.1.0</version>
			<scope>provided</scope>
		</dependency>
	</dependencies>
</project>

3、配置spring配置文件（applicationContext.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:aop="http://www.springframework.org/schema/aop"
	xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.3.xsd
		http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.3.xsd
		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd
		http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.3.xsd">

	<!--1、引用外部的配置文件 -->
	<context:property-placeholder location="classpath:dbconfig.properties" />

	<!--2、配置数据库连接池 -->
	<bean id="ds"
		class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<property name="driverClassName" value="${jdbc.driver}" />
		<property name="url" value="${jdbc.url}" />
		<property name="username" value="${jdbc.username}" />
		<property name="password" value="${jdbc.password}" />
	</bean>
	<!--3、配置SessionFactory -->
	<bean id="sessionFactory"
		class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
		<!--1、配置数据库连接池 -->
		<property name="dataSource" ref="ds"></property>
		<!--2、配置Hibernate的信息 -->
		<property name="hibernateProperties">
			<props>
				<!--方言 -->
				<prop key="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</prop>
				<!--显示建表语句 -->
				<prop key="hibernate.show_sql">true</prop>
				<!--格式化SQL语句 -->
				<prop key="hibernate.format_sql">true</prop>
				<!--自动创建表 -->
				<prop key="hibernate.hbm2ddl.auto">update</prop>
			</props>
		</property>
		<!--4、配置映射文件 mappingLocations:配置映射文件路径，支持* mappingJarLocationss:加载jar中映射 
			mappingDirectoryLocations:加载指定目录的映射文件 mappingResources：映射文件完整路径 -->
		<property name="mappingLocations" value="classpath:com/udb/entity/hbm/*.hbm.xml"></property>
	</bean>
	<!--5、配置事务管理器 -->
	<bean id="txManager"
		class="org.springframework.orm.hibernate4.HibernateTransactionManager">
		<property name="sessionFactory" ref="sessionFactory"></property>
	</bean>
	<!--6、配置事务通知 -->
	<tx:advice id="txAdvice" transaction-manager="txManager"></tx:advice>
	<!--7、声明式事务的AOP -->
	<aop:config proxy-target-class="true">
		<aop:pointcut expression="execution(* com.udb.dao.impl.*.*(..))"
			id="pt" />
		<!--引入通知 -->
		<aop:advisor advice-ref="txAdvice" pointcut-ref="pt" />
	</aop:config>
	<!--8、配置dao -->
	<bean id="udbDao" class="com.udb.dao.impl.UDBDaoImpl">
		<property name="sessionFactory" ref="sessionFactory"></property>
	</bean>
	<!--8、配置service -->
	<bean id="udbService" class="com.udb.service.impl.UDBServiceImpl">
		<property name="udbDao" ref="udbDao"></property>
	</bean>

</beans>

4、配置springMVC的配置文件。（springmvc.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:context="http://www.springframework.org/schema/context"
	xmlns:mvc="http://www.springframework.org/schema/mvc"
	xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd
		http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.3.xsd
		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd">

	<!--注解式实现控制器 -->
	<context:component-scan base-package="com.udb.controller"></context:component-scan>

	<!--配置所有页面的前缀和后缀 -->
	<bean id="viewResolver"
		class="org.springframework.web.servlet.view.InternalResourceViewResolver">
		<!--配置页面的前缀 -->
		<property name="prefix" value="/jsp/"></property>
		<!--配置后缀 -->
		<property name="suffix" value=".jsp"></property>
	</bean>

</beans>

5、配置数据库连接信息，同spring配置文件对应

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/spring?characterEncoding=UTF-8
jdbc.username=root
jdbc.password=1234

6、配置web.xml

此处需注意spring和springmvc配置文件的存放位置不同，需要做对应处理。本例中springmvc.xml、applicationContext.xml及db.properties放在resource目录下。

<?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>ssh</display-name>
	<context-param>
		<param-name>contextConfigLocation</param-name>
		<param-value>classpath:applicationContext.xml</param-value>
	</context-param>
	<listener>
		<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
	</listener>
	<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>
	<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>
	</servlet>
	<servlet-mapping>
		<servlet-name>springMVC</servlet-name>
		<url-pattern>/</url-pattern>
	</servlet-mapping>
	<welcome-file-list>
		<welcome-file>index.jsp</welcome-file>
	</welcome-file-list>
</web-app>

至此，配置文件部分初步配置完成。下面创建具体类。

7、创建实体类

package com.udb.entity;

public class UDBMetaInfo
{
	/**
	 * 序号
	 */
	private String seq_num;
	
	/**
	 * 月份
	 */
	private String check_mon;
	
	/**
	 * 库名
	 */
	private String tsdb_name;
	
	/**
	 * 库简称
	 */
	private String tsdb_id;
	
	/**
	 * 上线日期
	 */
	private String sx_date;
	
	/**
	 * 是否上线
	 */
	private String is_sx;
	
	......生成get和set方法...
}

实体对应hbm文件

<?xml version="1.0" encoding="UTF-8"?>
<!--约束文件 -->
<!DOCTYPE hibernate-mapping PUBLIC
	"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
	"http://www.hibernate.org/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="com.udb.entity">
	<class name="UDBMetaInfo" table="t_db_test">
		<id name="seq_num" column="seq_num" type="java.lang.String" length="30">
			<generator class="assigned"></generator>
		</id>
		
		<property name="check_mon" length="7" />
 
		<property name="tsdb_name" length="100" />
		<property name="tsdb_id" length="50" />
		<property name="sx_date" length="10" />
		<property name="is_sx" length="30" />
		
	</class>
</hibernate-mapping>

附加：表中数据

8、创建service接口及实现类

package com.udb.service;

import java.util.List;

import com.udb.entity.UDBMetaInfo;

public interface UDBService
{
	public List<UDBMetaInfo> getAllDbInfo();
}

service实现类

package com.udb.service.impl;

import java.util.List;

import com.udb.dao.UDBDao;
import com.udb.entity.UDBMetaInfo;
import com.udb.service.UDBService;

public class UDBServiceImpl implements UDBService
{
	private UDBDao udbDao;
	
	public UDBDao getUdbDao()
	{
		return udbDao;
	}

	public void setUdbDao(UDBDao udbDao)
	{
		this.udbDao = udbDao;
	}


	@Override
	public List<UDBMetaInfo> getAllDbInfo()
	{		
		return udbDao.getAllDb();
	}
}

9、创建dao接口及实现类

package com.udb.dao;

import java.util.List;

import com.udb.entity.UDBMetaInfo;

public interface UDBDao
{
	public List<UDBMetaInfo> getAllDb();
}

dao实现类，此处可使用hql，也可以适配调整使用原生sql；

package com.udb.dao.impl;

import java.util.ArrayList;
import java.util.List;

import org.springframework.orm.hibernate4.support.HibernateDaoSupport;

import com.udb.dao.UDBDao;
import com.udb.entity.UDBMetaInfo;

public class UDBDaoImpl extends HibernateDaoSupport implements UDBDao
{

	public List<UDBMetaInfo> getAllDb()
	{
		List<UDBMetaInfo> list = new ArrayList<UDBMetaInfo>();
		
		String hql = "from UDBMetaInfo";
		list = getHibernateTemplate().getSessionFactory().openSession().createQuery(hql).list();
		return list;
	}	
}

·10、编写Controller，本例只对controller做注解扫描。

package com.udb.controller;

import java.util.ArrayList;
import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import com.udb.entity.UDBMetaInfo;
import com.udb.service.UDBService;

@Controller
public class UDBController
{
	@Autowired
	private UDBService udbService;
	
	
	@RequestMapping(value = "/getAllDbList.do")
	@ResponseBody
	public List<UDBMetaInfo>  findAllKpi()
	{
		List<UDBMetaInfo> list = new ArrayList<UDBMetaInfo>();
		list = udbService.getAllDbInfo();
		
		return list;
	}
}

至此spring+springmvc+hibernate整合已完成，可启动服务测试。

11、浏览器输入 http://localhost:8080/udbJsonData/getAllDbList.do 报错406

针对此问题略做说明如下：

在springmvc中，当在浏览器中输入对应的MappingUrl时，报错The resource identified by this request is only capable of generating responses with characteristics not acceptable according to the request "accept" headers.

是告诉你指定的资源已经找到，但它的MIME类型和客户在Accpet头中所指定的不兼容

@ResponseBody返回json格式的数据，而浏览器接受的是text/html;charset=UTF-8文本类型

此处在controller中可将list的数据打印出来，会发现已经获取到具体数据，但是因为此问题而导致报错406。解决方式如下.

12、在pom文件中添加json相关依赖

		<dependency>
			<groupId>com.fasterxml.jackson.core</groupId>
			<artifactId>jackson-databind</artifactId>
			<version>2.7.4</version>
		</dependency>
		<dependency>
			<groupId>com.fasterxml.jackson.core</groupId>
			<artifactId>jackson-core</artifactId>
			<version>2.7.4</version>
		</dependency>
		<dependency>
			<groupId>com.fasterxml.jackson.core</groupId>
			<artifactId>jackson-annotations</artifactId>
			<version>2.7.4</version>
		</dependency>

13、在springmvc.xml中添加json转换器相关bean配置

<!--转化json -->
	<bean
		class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter">
		<property name="messageConverters">
			<list>
				<!--json视图拦截器，读取@ResponseBody加载 -->
				<ref bean="mappingJacksonHttpMessageConverter" />
			</list>
		</property>
	</bean>
	<!--json 数据转化器 -->
	<bean id="mappingJacksonHttpMessageConverter"
		class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter">
		<property name="supportedMediaTypes">
			<list>
				<value>application/json;charset=UTF-8</value>
			</list>
		</property>
	</bean>

14、重新访问 http://localhost:8080/udbJsonData/getAllDbList.do 即可获取自动转换后的json数据

附工程结构：

至此整个流程结束，可在此基础上进行扩展，全篇除controller使用注解外，其他配置为xml配置方式。个人认为使用注解的前提是对xml配置方式熟知。简单整理，如有问题，请及时指正，谢谢！

Leoyoe~

关注

2
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
spring+springmvc+hibernate 整合之web接口开发

简单的web接口开发，比较简单，适合新手练习熟悉ssh流程，将中间可能会遇到的问题一并附上，代码如下。1、新建maven工程2、配置pom文件，添加hibernate、spring、springmvc相关依赖jar包配置&lt;project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.or...
复制链接

扫一扫