Spring+SpringMVC+Spring Data JPA完美整合

使用Maven实现SSS框架的整合。
方便记录，专门建了一个pom项目用来整合SSS框架所用的jar包

1、POM项目，作为父级项目，记录整个整合中的依赖jar包
pom文件

<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>org.qf</groupId>
<artifactId>M_SSS_Pom</artifactId>
<version>0.0.1-SNAPSHOT</version>
<packaging>pom</packaging>
<description>这是SSS整合框架的所有依赖</description>
<!–Spring+SpringMVC+SpringDataJPA+Hibernate JPA –>
<dependencies>
<!–Spring+Spring Data –>
<!– https://mvnrepository.com/artifact/org.springframework.data/spring-data-jpa –>
<dependency>
<groupId>org.springframework.data</groupId>
<artifactId>spring-data-jpa</artifactId>
<version>1.11.3.RELEASE</version>
</dependency>
<!–SpringMVC –>
<!– https://mvnrepository.com/artifact/org.springframework/spring-webmvc –>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>4.3.8.RELEASE</version>
</dependency>
<!–数据库连接池，Hibernate –>
<!– https://mvnrepository.com/artifact/org.hibernate/hibernate-c3p0 –>
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-c3p0</artifactId>
<version>5.2.10.Final</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>
<!– https://mvnrepository.com/artifact/com.alibaba/druid –>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.2</version>
</dependency>
</dependencies>
<!–构建信息 –>
<build>
<plugins>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<version>3.6.0</version>
<configuration>
<source>1.8</source>
<target>1.8</target>
<encoding>UTF-8</encoding>
</configuration>
</plugin>
</plugins>
</build>
</project>

2、创建整合的war项目继承刚刚创建的POM项目
pom文件：

<!– jsp页面支持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>
<!– https://mvnrepository.com/artifact/com.alibaba/fastjson –>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>fastjson</artifactId>
<version>1.2.36</version>
</dependency>

</dependencies>

</project>

接下来开始代码的编写：

3、domain层

@Entity
@Table(name=”tb_student”)
@NamedQuery(name=”Student.querys”,query=”select s from Student s”)
public class Student {

//@DateTimeFormat(pattern=”yyyy-MM-dd HH:mm:ss”)//日期格式化
@Id
@GeneratedValue(strategy=GenerationType.IDENTITY)
private int id;
@Column(length=50)
private String name;
@Column(length=2)
private String sex;
//@Basic
//@Transient只是属性不是字段
private int age;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
}

4、dao层
Spring Data JPA最大的改变就是dao层，只需定义接口即可，记住要继承指定的接口

public interface StudentDao extends JpaRepository<Student, Serializable>{

Student findById(int id);
Student findByIdAndName(int id,String name);

}

5、service层

public interface StudentService {

boolean save(Student stu);
List<Student> queryAll();
Student querySingle(int id);
}

@Service
public class StudentServiceImple implements StudentService{

@Autowired
private StudentDao dao;

@Override
public boolean save(Student stu) {
// TODO Auto-generated method stub
System.out.println(“—->”+dao.getClass().getName());
//有主键就修改，没有主键就新增
//System.out.println(1/0);
return dao.save(stu)!=null?true:false;
}

@Override
public List<Student> queryAll() {
// TODO Auto-generated method stub
//System.out.println(“数量：”+dao.count());
return dao.findAll();
}

@Override
public Student querySingle(int id) {
// TODO Auto-generated method stub
return dao.findById(id);
}
}

6、控制器层：

@Controller
public class StudentController {

@Autowired
private StudentService service;

@RequestMapping(“/{jn}”)
public String pre(@PathVariable String jn) {

return jn;
}

@RequestMapping(“/save”)
public void test1(Student stu) {
if (stu!=null &&stu.getName()!=null &&stu.getName().length()>0 ) {
stu.setId(2);
System.out.println(“控制器：新增：” + service.save(stu));
}
}
@RequestMapping(“/queryall”)
public void test2(Model m) {
System.out.println(“控制器：查询全部”);
if (!m.containsAttribute(“list”)) {
m.addAttribute(“list”, service.queryAll());
}
}

@RequestMapping(“/querysingle”)
public String test3(int id, Model m) {
System.out.println(“控制器：查询单个”);
List<Student> list=new ArrayList<>();
list.add(service.querySingle(id));
m.addAttribute(“list”, list);
return “queryall”;
}

}

7、页面，都是jsp页面
新增数据页面

<%@ page language=”java” contentType=”text/html; charset=UTF-8″
pageEncoding=”UTF-8″%>
<!DOCTYPE html PUBLIC “-//W3C//DTD HTML 4.01 Transitional//EN” “http://www.w3.org/TR/html4/loose.dtd”>
<html>
<head>
<meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″>
<title>新增学生</title>
</head>
<body>

<form action=”save”>
姓名：<input name=”name”/><br/>
性别：<input name=”sex”/><br/>
年龄：<input name=”age”/><br/>
<input type=”submit” value=”新增学生”/><br/>
</form>
<a href=”queryall”>查询所有学生</a>
</body>
</html>

查询数据页面：

<%@ page language=”java” contentType=”text/html; charset=UTF-8″
pageEncoding=”UTF-8″%>
<%@ taglib uri=”http://java.sun.com/jsp/jstl/core” prefix=”c”%>
<!DOCTYPE html PUBLIC “-//W3C//DTD HTML 4.01 Transitional//EN” “http://www.w3.org/TR/html4/loose.dtd”>
<html>
<head>
<meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″>
<title>所有学生</title>
</head>
<body>
<a href=”queryall”>刷新数据</a>
<a href=”save”>添加学生</a>
<table width=”70%” align=”center” border=”1″>
<c:forEach items=”${list }” var=”s”>
<tr>
<td>${s.id }</td>
<td>${s.name }</td>
<td>${s.sex }</td>
<td>${s.age }</td>

</tr>
</c:forEach>
</table>

</body>
</html>

8、数据库连接信息的配置文件persistence.xml
<?xml version=”1.0″ encoding=”UTF-8″?>
<persistence version=”2.0″ xmlns=”http://java.sun.com/xml/ns/persistence” xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xsi:schemaLocation=”http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd”>
<!–持久模块名称 –>
<persistence-unit name=”dbconfig” transaction-type=”RESOURCE_LOCAL”>
<!–标记持久层的具体实现 –>
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<!–数据库连接属性信息 –>
<properties>
<!–配置数据库驱动 –>
<property name=”hibernate.connection.driver_class” value=”com.mysql.jdbc.Driver” />
<!–配置数据库url –>
<property name=”hibernate.connection.url” value=”jdbc:mysql://localhost:3306/sss_sys?characterEncoding=UTF-8″ />
<!–配置数据库用户名 –>
<property name=”hibernate.connection.username” value=”lx” />
<!–配置数据库密码 –>
<property name=”hibernate.connection.password” value=”lx” />
<!–配置Hibernate方言 –>
<property name=”hibernate.dialect” value=”org.hibernate.dialect.MySQL57Dialect” />
<!–设置外连接抓取树的最大深度 –>
<property name=”hibernate.max_fetch_depth” value=”10″ />
<!–自动输出schema创建DDL语句 –>
<property name=”hibernate.hbm2ddl.auto” value=”create” />
<!– 显示SQL –>
<property name=”hibernate.show_sql” value=”true” />
<!–格式化SQL语句 –>
<property name=”hibernate.format_sql” value=”true” />
<property name=”javax.persistence.validation.mode” value=”none”/>
</properties>
</persistence-unit>
</persistence>

9、Spring的配置文件applicationContext.xml
<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:tx=”http://www.springframework.org/schema/tx”
xmlns:jpa=”http://www.springframework.org/schema/data/jpa”
xsi:schemaLocation=”http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd
http://www.springframework.org/schema/data/jpa
http://www.springframework.org/schema/data/jpa/spring-jpa.xsd”>
<!– 开启IOC注解扫描 –>
<context:component-scan base-package=”cn.code404″ >
<!–必须排除掉控制器 –>
<context:exclude-filter type=”annotation”
expression=”org.springframework.stereotype.Controller” />
</context:component-scan>

<!–跟之前的sessionFactory，JPA操作数据库 –>
<bean id=”entityManagerFactory” class=”org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean”>
<!–持久模块名称 –>
<property name=”persistenceUnitName” value=”dbconfig”></property>
<!–数据库连接信息的配置文件 –>
<property name=”persistenceXmlLocation” value=”classpath:persistence.xml”></property>
<!–jpa适配器 –>
<property name=”jpaVendorAdapter”>
<!–基于hibernate的 –>
<bean class=”org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter”>

</bean>
</property>
</bean>

<!– 配置事务管理器 –>
<bean id=”transactionManager” class=”org.springframework.orm.jpa.JpaTransactionManager”>
<!–事物添加的机制 –>
<property name=”entityManagerFactory” ref=”entityManagerFactory” />
</bean>
<!– 启用 annotation事务 –>
<tx:annotation-driven transaction-manager=”transactionManager” />
<!– 配置Spring Data JPA扫描目录 –>
<!– 自动扫描并注入Spring Data JPA –>
<jpa:repositories base-package=”cn.code404″ transaction-manager-ref=”transactionManager” entity-manager-factory-ref=”entityManagerFactory” />
</beans>

10、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:aop=”http://www.springframework.org/schema/aop” xmlns:beans=”http://www.springframework.org/schema/beans”
xmlns:mvc=”http://www.springframework.org/schema/mvc”
xsi:schemaLocation=”
http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc.xsd”>
<!–扫描控制器所在的包 –>
<context:component-scan base-package=”org.qf.web.controller” />
<mvc:annotation-driven>
<!–注册转换器 –>
<mvc:message-converters register-defaults=”true”>
<!– @ResponseBody乱码问题，将StringHttpMessageConverter的默认编码设为UTF-8 –>
<beans:bean
class=”org.springframework.http.converter.StringHttpMessageConverter”>
<beans:constructor-arg value=”UTF-8″ />
</beans:bean>
<!– 配置Fastjson支持 –>
<beans:bean
class=”com.alibaba.fastjson.support.spring.FastJsonHttpMessageConverter”>
<!–设置编码格式 –>
<beans:property name=”charset” value=”UTF-8″ />
<!–支持的类型 –>
<beans:property name=”supportedMediaTypes”>
<beans:list>
<beans:value>application/json</beans:value>
<beans:value>text/html;charset=UTF-8</beans:value>
</beans:list>
</beans:property>
<!–写出规则 –>
<beans:property name=”features”>
<beans:list>
<beans:value>WriteMapNullValue</beans:value>
<beans:value>QuoteFieldNames</beans:value>
<beans:value>WriteDateUseDateFormat</beans:value>
<beans:value>WriteEnumUsingToString</beans:value>
</beans:list>
</beans:property>
</beans:bean>
</mvc:message-converters>
</mvc:annotation-driven>
<!–放行静态资源 –>
<mvc:default-servlet-handler />

<!–视图解析器，可以设置页面的前缀和后缀 –>
<bean class=”org.springframework.web.servlet.view.InternalResourceViewResolver”>
<property name=”prefix” value=”/WEB-INF/views/”></property>
<property name=”suffix” value=”.jsp”></property>
</bean>
</beans>

11、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” version=”2.5″>
<display-name>M_SSS_War</display-name>
<!–Spring –>
<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>
<!–SpringMVC –>
<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>
</web-app>

ok,发布到Tomcat即可进行操作

转载于:https://www.cnblogs.com/chinaifae/p/10593329.html

你可能也喜欢