ssh整合思想 Spring分模块开发 crud参数传递 解决HTTP Status 500 - Write operations are not allowed in read-only mode (FlushMode.MANUAL): Turn your Session into FlushMode.COMMIT/AUTO or(增加事务)
在Spring核心配置文件中没有增加事务方法,导致以上问题
Action类UserAction
package com.swift.action; import com.opensymphony.xwork2.ActionSupport; import com.swift.service.UserService; public class UserAction extends ActionSupport { private UserService userService; public void setUserService(UserService userService) { this.userService = userService; } @Override public String execute() throws Exception { System.out.println("action.................."); userService.add("fly","War of Mercenaries"); userService.add("big-dog","War of Mercenaries"); userService.add("ram","War of Mercenaries"); userService.add("rabbit","War of Mercenaries"); userService.add("hama","War of Mercenaries"); userService.add("shiguan","War of Mercenaries"); userService.update("ram","War of Mercenaries","公羊","佣兵的战争"); userService.delete("rabbit","War of Mercenaries"); userService.getOne(2); userService.findAll(); userService.findYouWant("ram","War of Mercenaries"); return NONE; } }
UserService类
package com.swift.service; import org.springframework.transaction.annotation.Transactional; import com.swift.dao.UserDao; @Transactional public class UserService { private UserDao userDao; public void setUserDao(UserDao userDao) { this.userDao = userDao; } public void add(String userName,String address) { System.out.println("UserService.................add"); userDao.add(userName,address); } public void update(String userName,String address,String modifyName,String modifyAddress) { System.out.println("UserService.................update"); userDao.update(userName,address,modifyName,modifyAddress); } public void delete(String userName,String address) { System.out.println("UserService.................delete"); userDao.delete(userName,address); } public void getOne(int number) { System.out.println("UserService.................get the number of"); userDao.getOne(number); } public void findAll() { System.out.println("UserService.................find all"); userDao.findAll(); } public void findYouWant(String userName,String address) { System.out.println("UserService.................find you want"); userDao.findYouWant(userName,address); } }
UserDao接口
package com.swift.dao; public interface UserDao { public void add(String userName,String address); public void update(String userName,String address,String modifyName,String modifyAddress); public void delete(String userName,String address); public void getOne(int number); public void findAll(); public void findYouWant(String userName,String address); }
UserDaoImplements类
package com.swift.dao; import java.util.List; import org.springframework.orm.hibernate5.HibernateTemplate; import com.swift.entity.User; public class UserDaoImplements implements UserDao { private HibernateTemplate hibernateTemplate; private User user; public void setHibernateTemplate(HibernateTemplate hibernateTemplate) { this.hibernateTemplate = hibernateTemplate; } public void setUser(User user) { this.user = user; } @Override public void add(String userName, String address) { // 增加 user.setUsername(userName); user.setAddress(address); hibernateTemplate.save(user); } @Override public void update(String userName, String address, String modifyName, String modifyAddress) { List<User> list = (List<User>) hibernateTemplate.find("from User where userName=? and address=?", userName, address); if (list != null) { for (User user : list) { System.out.println(user.getUsername() + " :: " + user.getAddress()); user.setUsername(modifyName); user.setAddress(modifyAddress); hibernateTemplate.update(user); } } else { System.out.println("您要更新的记录不存在!!!!!"); } } @Override public void delete(String userName, String address) { List<User> list = (List<User>) hibernateTemplate.find("from User where userName=? and address=?", userName, address); if (list != null) { for (User user : list) { System.out.println(user.getUsername() + " :: " + user.getAddress()); hibernateTemplate.delete(user); } } else { System.out.println("您要删除的记录不存在!!!!!"); } } @Override public void getOne(int number) { User user = hibernateTemplate.get(User.class, number); System.out.println(user.getUsername() + " :: " + user.getAddress()); } @Override public void findAll() { List<User> list = (List<User>) hibernateTemplate.find("from User"); for (User user : list) { System.out.println(user.getUsername() + " :: " + user.getAddress()); } } @Override public void findYouWant(String userName, String address) { List<User> list = (List<User>) hibernateTemplate.find("from User where userName=? and address=?", userName, address); System.out.println(list.toString()); for (User user : list) { System.out.println(user.getUsername() + " :: " + user.getAddress()); } } }
User实体类:
package com.swift.entity; public class User { private Integer uid; private String username; private String address; public Integer getUid() { return uid; } public void setUid(Integer uid) { this.uid = uid; } public String getUsername() { return username; } public void setUsername(String username) { this.username = username; } public String getAddress() { return address; } public void setAddress(String address) { this.address = address; } public User(String username, String address) { this.username = username; this.address = address; } public User(Integer uid, String username, String address) { this.uid = uid; this.username = username; this.address = address; } public User() { super(); // TODO Auto-generated constructor stub } }
web.xml 自动启动监听和过滤器
<?xml version="1.0" encoding="UTF-8"?> <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" id="WebApp_ID" version="3.1"> <display-name>2018-01-03_Spring_Hibernate</display-name> <context-param> <param-name>contextConfigLocation</param-name> <param-value>classpath:bean.xml</param-value> </context-param> <listener> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener> <filter> <filter-name>struts2</filter-name> <filter-class> org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter</filter-class> </filter> <filter-mapping> <filter-name>struts2</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> <welcome-file-list> <welcome-file>index.html</welcome-file> <welcome-file>index.htm</welcome-file> <welcome-file>index.jsp</welcome-file> <welcome-file>default.html</welcome-file> <welcome-file>default.htm</welcome-file> <welcome-file>default.jsp</welcome-file> </welcome-file-list> </web-app>
Spring核心配置文件bean.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:tx="http://www.springframework.org/schema/tx" 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/tx http://www.springframework.org/schema/tx/spring-tx.xsd"> <!-- c3p0连接池得到dataSource --> <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"> <property name="driverClass" value="com.mysql.jdbc.Driver"></property> <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/sw_database"></property> <property name="user" value="root"></property> <property name="password" value="root"></property> </bean> <!-- 创建hibernate事务管理器 --> <bean id="hibernateTransactionManager" class="org.springframework.orm.hibernate5.HibernateTransactionManager"> <property name="sessionFactory" ref="sessionFactory"></property> </bean> <!-- 启动Hibernate事务管理器 --> <tx:annotation-driven transaction-manager="hibernateTransactionManager"></tx:annotation-driven> <!-- 引入分模块 --> <import resource="classpath:User.xml"/> </beans>
分模块User.xml 只负责Action部分
<?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:tx="http://www.springframework.org/schema/tx" 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/tx http://www.springframework.org/schema/tx/spring-tx.xsd"> <bean id="userAction" class="com.swift.action.UserAction" scope="prototype"> <property name="userService" ref="userService"></property> </bean> <bean id="sessionFactory" class="org.springframework.orm.hibernate5.LocalSessionFactoryBean"> <!-- Hibernate核心配置文件没有连接数据库,所以需要注入 --> <property name="dataSource" ref="dataSource"></property> <!-- Hibernate核心配置文件的位置 --> <property name="configLocations" value="classpath:hibernate.cfg.xml"></property> </bean> <bean id="userService" class="com.swift.service.UserService"> <property name="userDao" ref="userDaoImplements"></property> </bean> <bean id="userDaoImplements" class="com.swift.dao.UserDaoImplements"> <property name="hibernateTemplate" ref="hibernateTemplate"></property> <property name="user" ref="user"></property> </bean> <bean id="hibernateTemplate" class="org.springframework.orm.hibernate5.HibernateTemplate"> <!-- 前一个sessionFactory是HibernateTemplate类内部的 --> <property name="sessionFactory" ref="sessionFactory"></property> </bean> <bean id="user" class="com.swift.entity.User"></bean> </beans>
Hibernate核心配置文件hibernate.cfg.xml
<?xml version="1.0" encoding='UTF-8'?> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"> <hibernate-configuration> <session-factory> <!-- <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property> <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/sw_database</property> <property name="hibernate.connection.username">root</property> <property name="hibernate.connection.password">root</property> --> <property name="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</property> <!-- 方言的数字很重要一定找到该项目名的连接类 --> <property name="hibernate.show_sql">true</property> <property name="hibernate.format_sql">true</property><!-- 别处复制过来的代码要重新在Eclipse中一点点输入否则会出错 --> <!-- create: 先删表,再建表。 create-drop: 启动时建表,退出前删表。 update: 如果表结构不一致,就创建或更新。 validate: 启动时验证表结构,如果不致就抛异常。 --> <property name="hibernate.hbm2ddl.auto">update</property> <!--指定映射文件,可映射多个映射文件 --> <mapping resource="User.hbm.xml"></mapping> </session-factory> </hibernate-configuration>
Hibernate映射文件
<?xml version="1.0" encoding='UTF-8'?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <!-- 实体类映射文件 --> <hibernate-mapping> <class name="com.swift.entity.User" table="t_user"> <!-- 主键 --> <id name="uid"> <generator class="native"></generator> </id> <!-- 其他属性 --> <property name="username"/> <property name="address"/> </class> </hibernate-mapping>
struts2的Action配置文件
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE struts PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 2.3//EN" "http://struts.apache.org/dtds/struts-2.3.dtd"> <struts> <package name="default" extends="struts-default" namespace="/"> <!-- action的class不要写全名会创建两个对象,而写Spring配置文件中id的内容,只建一个对象 前提有struts2-spring-plugin-2.3.4.1.jar --> <action name="userAction" class="userAction"> </action> </package> </struts>
浏览器操作
控制台显示
数据库显示
Never waste time any more, Never old man be a yong man