目錄

• • 1. pom依賴
  • 2. web.xml
  • 3. spring核心配置文件
  • • 3.1 jdbc配置信息
    • 3.2 sping 配置文件
  • 4. 實體映射
  • 5. 項目結構
  • • 5.1 curd
    • 5.2 頁面
  • 6. 測試

1. spring版本 5.1.5 RELEASE 2. hibernate版本 5.3.9.Final 3. 數據源使用c3p0

項目使用eclipse2017 + maven構建, 完成學生的新增，查詢功能。學生表是根據hibernate對實體類進行映射生成的。

1. pom依賴

<?xml version="1.0" encoding="UTF-8"?><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>cn.bitqian</groupId><artifactId>springmvc02</artifactId><version>0.0.1-SNAPSHOT</version><packaging>war</packaging><name>springmvc02 Maven Webapp</name><!-- FIXME change it to the project's website --><url>http://www.example.com</url><properties><project.build.sourceEncoding>UTF-8</project.build.sourceEncoding><maven.compiler.source>1.8</maven.compiler.source><maven.compiler.target>1.8</maven.compiler.target></properties><dependencies><!-- servlet --><dependency><groupId>javax.servlet</groupId><artifactId>javax.servlet-api</artifactId><version>4.0.1</version></dependency> <!-- mvc --><dependency><groupId>org.springframework</groupId><artifactId>spring-webmvc</artifactId><version>5.1.5.RELEASE</version></dependency><!-- 整合包 --><!-- https://mvnrepository.com/artifact/org.springframework/spring-orm --><dependency><groupId>org.springframework</groupId> <artifactId>spring-orm</artifactId><version>5.1.6.RELEASE</version></dependency> <!-- https://mvnrepository.com/artifact/org.springframework/spring-orm --><dependency><groupId>org.springframework</groupId><artifactId>spring-context</artifactId><version>5.1.5.RELEASE</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-tx</artifactId><version>5.1.5.RELEASE</version></dependency> <!-- https://mvnrepository.com/artifact/org.aspectj/aspectjweaver --><dependency><groupId>org.aspectj</groupId><artifactId>aspectjweaver</artifactId><version>1.9.2</version><scope>runtime</scope></dependency><!-- https://mvnrepository.com/artifact/com.mchange/c3p0 --><dependency><groupId>com.mchange</groupId><artifactId>c3p0</artifactId><version>0.9.5.2</version></dependency><!-- hibernate --><dependency><groupId>org.hibernate</groupId><artifactId>hibernate-core</artifactId><version>5.3.9.Final</version></dependency><dependency><groupId>javax.servlet</groupId><artifactId>jstl</artifactId><version>1.2</version></dependency><!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java --><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>8.0.20</version></dependency><!-- junit --><dependency><groupId>junit</groupId><artifactId>junit</artifactId><version>4.11</version><scope>test</scope></dependency> </dependencies><build><finalName>springmvc02</finalName><pluginManagement><!-- lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) --><plugins><plugin><artifactId>maven-clean-plugin</artifactId><version>3.1.0</version></plugin><!-- see http://maven.apache.org/ref/current/maven-core/default-bindings.html#Plugin_bindings_for_war_packaging --><plugin><artifactId>maven-resources-plugin</artifactId><version>3.0.2</version></plugin><plugin><artifactId>maven-compiler-plugin</artifactId><version>3.8.0</version></plugin><plugin><artifactId>maven-surefire-plugin</artifactId><version>2.22.1</version></plugin><plugin><artifactId>maven-war-plugin</artifactId><version>3.2.2</version></plugin><plugin><artifactId>maven-install-plugin</artifactId><version>2.5.2</version></plugin><plugin><artifactId>maven-deploy-plugin</artifactId><version>2.8.2</version></plugin></plugins></pluginManagement></build> </project>

2. web.xml

注意xml的頭文件，版本，2.3的頭文件有坑low，這里用的是3.0版本。

ioc容器加載。mvc核心控制器的創建。

<?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>Archetype Created Web Application</display-name><!-- 啟動項目時加載容器 --><servlet><servlet-name>dispatcherServlet</servlet-name><servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class><init-param><param-name>contextConfigLocation</param-name><param-value>classpath:spring-mvc.xml</param-value></init-param><load-on-startup>1</load-on-startup></servlet><servlet-mapping><servlet-name>dispatcherServlet</servlet-name><url-pattern>/</url-pattern></servlet-mapping></web-app>

3. spring核心配置文件

3.1 jdbc配置信息

driver=com.mysql.cj.jdbc.Driver url=jdbc:mysql://localhost:3306/ssh_study?serverTimezone=GMT jdbc.username=root password=123456

3.2 sping 配置文件

hibernate 使用了注解的方式，沒有配置映射文件。

<?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:mvc="http://www.springframework.org/schema/mvc"xmlns:tx="http://www.springframework.org/schema/tx"xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsdhttp://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsdhttp://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsdhttp://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsdhttp://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd"><!-- 開啟mvc注解驅動 --><mvc:annotation-driven /><context:component-scan base-package="cn.bitqian.**" /><!-- 加載jdbc配置文件 --><context:property-placeholder location="classpath:jdbc.properties"/><!-- c3p0數據源 --><bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"><property name="driverClass" value="${driver}"></property><property name="jdbcUrl" value="${url}"></property><property name="user" value="${jdbc.username}"></property><property name="password" value="${password}"></property></bean><!-- session 工廠 --><bean id="sessionFactory" class="org.springframework.orm.hibernate5.LocalSessionFactoryBean"><property name="dataSource" ref="dataSource"></property><!-- hibernate 相關配置 --><property name="hibernateProperties"><props><prop key="hibernate.dialect">org.hibernate.dialect.MySQL5InnoDBDialect</prop><!-- 根據實體類反轉表 --><prop key="hibernate.hbm2ddl.auto">update</prop> <prop key="hibernate.show_sql">true</prop><prop key="hibernate.format_sql">true</prop></props></property><!-- hibernate映射文件 注解掃描 --><property name="packagesToScan" value="cn/bitqian/entity"></property></bean><!-- hibernate模板來操作數據庫 --><bean id="hibernateTemplate" class="org.springframework.orm.hibernate5.HibernateTemplate"><property name="sessionFactory" ref="sessionFactory"></property></bean><!-- 事務 --><bean id="transactionManager" class="org.springframework.orm.hibernate5.HibernateTransactionManager"><property name="sessionFactory" ref="sessionFactory"></property></bean><!-- xml事務配置 --><tx:advice id="advice" transaction-manager="transactionManager"><tx:attributes><!-- 對下面的符合規則方法進行事務控制 --><tx:method name="save*" propagation="REQUIRED"/><tx:method name="add*" propagation="REQUIRED"/><tx:method name="insert*" propagation="REQUIRED"/><tx:method name="update*" propagation="REQUIRED"/><tx:method name="delete*" propagation="REQUIRED"/><!-- 只讀 --><tx:method name="*" read-only="true" propagation="SUPPORTS"/></tx:attributes></tx:advice><aop:config><!-- 切點 --><aop:pointcut expression="execution(* cn.bitqian.service.impl.*.*(..))" id="pointcut"/><!-- 事務顧問 --><aop:advisor advice-ref="advice" pointcut-ref="pointcut"/></aop:config><!-- 開啟事務注解驅動 --><tx:annotation-driven transaction-manager="transactionManager"/></beans>

4. 實體映射

package cn.bitqian.entity;import java.io.Serializable; import java.util.Date;import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.GenerationType; import javax.persistence.Id; import javax.persistence.Table; import javax.persistence.Transient;import org.springframework.format.annotation.DateTimeFormat;/*** * @author echo lovely* @time 2020/11/4**/ @Entity(name="StudentInfo") @Table(name="student_info") public class StudentInfo implements Serializable {private static final long serialVersionUID = -5075710692395281523L;@Id@GeneratedValue(strategy=GenerationType.AUTO) // 主鍵自增// @Column(name="stu_id")private Integer stuId;@Column(name="stu_name")// 列名private String stuName;@Column(name="stu_gender")private Integer stuGender;@Column(name="stu_birth")@DateTimeFormat(pattern="yyyy-MM-dd") // mvc將字符串轉換日期private Date stuBirth;// 此字段會被忽悠，不會被反轉@Transientprivate String abc;public StudentInfo() {}public Integer getStuId() {return stuId;}public void setStuId(Integer stuId) {this.stuId = stuId;}public String getStuName() {return stuName;}public void setStuName(String stuName) {this.stuName = stuName;}public Integer getStuGender() {return stuGender;}public void setStuGender(Integer stuGender) {this.stuGender = stuGender;}public Date getStuBirth() {return stuBirth;}public void setStuBirth(Date stuBirth) {this.stuBirth = stuBirth;}}

5. 項目結構

5.1 curd

dao

package cn.bitqian.dao.impl;import java.util.List;import org.springframework.beans.factory.annotation.Autowired; import org.springframework.orm.hibernate5.HibernateTemplate; import org.springframework.stereotype.Repository;import cn.bitqian.dao.StudentInfoDao; import cn.bitqian.entity.StudentInfo;@Repository public class StudentInfoDaoImpl implements StudentInfoDao {@Autowiredprivate HibernateTemplate ht;@Overridepublic List<StudentInfo> queryAll() {// 查詢所有// return (List<StudentInfo>) ht.find("from StudentInfo");return ht.loadAll(StudentInfo.class);}@Overridepublic void add(StudentInfo stu) {// 新增ht.save(stu);}}

service(省略)，沒有業務

package cn.bitqian.service.impl;import java.util.List;import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional;import cn.bitqian.dao.StudentInfoDao; import cn.bitqian.entity.StudentInfo; import cn.bitqian.service.StudentInfoService;@Service public class StudentInfoServiceImpl implements StudentInfoService {@Autowiredprivate StudentInfoDao stuDao;@Overridepublic List<StudentInfo> queryAll() throws Exception {List<StudentInfo> list = null;try {list = stuDao.queryAll();} catch (Exception e) {// 捕捉到異常并拋出e.printStackTrace();throw new Exception(e);}return list;}@Overridepublic void add(StudentInfo stu) throws Exception {try {stuDao.add(stu);} catch (Exception e) {e.printStackTrace();throw new Exception(e);}}/*** 測試為事務注解*/@Transactional@Overridepublic void testAdd1(StudentInfo stu) {stuDao.add(stu);}}

controller

package cn.bitqian.controller;import javax.annotation.Resource;import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.PostMapping; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.servlet.ModelAndView;import cn.bitqian.entity.StudentInfo; import cn.bitqian.service.StudentInfoService;@Controller @RequestMapping("/stu") public class StudentInfoController {@Resource()private StudentInfoService stuInfoService;@GetMapping("/list")public ModelAndView queryAllStu() {ModelAndView mv = new ModelAndView();try {// 帶上查詢的數據mv.addObject("stuList", stuInfoService.queryAll());} catch (Exception e) {e.printStackTrace();mv.addObject("msg", "出錯拉");}mv.setViewName("/list.jsp");return mv;}@PostMapping("/add")public ModelAndView saveStu(StudentInfo stuInfo) {stuInfoService.testAdd1(stuInfo);// 查詢一遍return this.queryAllStu();}}

5.2 頁面

新增

<%@ page language="java" contentType="text/html; charset=UTF-8"pageEncoding="UTF-8"%><html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>新增學生</title> </head> <body><form action="stu/add" method="post"><input type="text" name="stuName"/> <br/><input type="radio" name="stuGender" value="0"/>男<input type="radio" name="stuGender" value="1"/>女 <br/><input type="date" name="stuBirth"/> <br/><input type="submit" value="add"/> <br/></form></body> </html>

查詢
坑：jstl,識別不了。。可能我導入的servlet（4.0）版本太高，而頭文件的版本當時是2.3… 把頭文件改為3.0就行了

無法在web.xml或使用此應用程序部署的jar文件中解析絕對uri:[http://java.sun.com <%@ page language="java" isELIgnored="false" contentType="text/html; charset=UTF-8"pageEncoding="UTF-8"%><%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>學生查詢</title> </head> <body><table><tr><td>id</td><td>name</td><td>gender</td><td>birth</td></tr><c:forEach items="${stuList}" var="stu"><tr><td>${stu.stuId}</td><td>${stu.stuName}</td><td>${stu.stuGender == 0 ? "男" : "女"}</td><td>${stu.stuBirth} </td></tr></c:forEach></table></body> </html>

6. 測試

創作挑戰賽新人創作獎勵來咯，堅持創作打卡瓜分現金大獎

總結

以上是生活随笔為你收集整理的springmvc，spring，hibernate5.0整合的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。