Hibernate+Spring+Struts2+ExtJS开发CRUD功能

Hibernate+Spring+Struts2+ExtJS开发CRUD功能/myloon/archive/2007/11/08/1873652.aspx入门：各种开源框架环境及下载：Hibernate：3.x /需要hibernate core 和annotations 包。

Spring：2.x /Struts2：2.x /2.x/ExtJS：2.X /JSON：JSON可以到/查看详细内容，这里使用json-lib /本所需要的包：2、配置：（1）首先是配置web.xml，配置方法可以在下面的配置文件代码注释中查看，这里主要是Struts2的配置：<filter><filter-name>struts2</filter-name><filter-class>org.apache.struts2.dispatcher.FilterDispatcher</filter-clas s></filter><filter-mapping><filter-name>struts2</filter-name><url-pattern>/*</url-pattern></filter-mapping>和Spring的配置：<context-param><param-name>contextConfigLocation</param-name><param-value>/WEB-INF/spring/*.xml</param-value></context-param><listener><listener-class>org.springframework.web.context.ContextLoaderList ener</listener-class></listener>Web.xml的全部文件：<?xml version="1.0" encoding="UTF-8"?><web-app id="WebApp_ID" version="2.4" xmlns="/xml/ns/j2ee" xmlns:xsi="/2001/XMLSchema-instance"xsi:schemaLocation="/xml/ns/j2ee/xml/ns/j2ee/web-app_2_4.xsd"><display-name>struts2</display-name><!-- Spring ApplicationContext配置文件的路径,可使用通配符*，多个路径用,号分隔,此参数用于后面的Spring-Context loader --><context-param><param-name>contextConfigLocation</param-name><param-value>/WEB-INF/spring/*.xml</param-value></context-param><!-- 著名 Character Encoding filter --><filter><filter-name>encodingFilter</filter-name><filter-class>org.springframework.web.filter.CharacterEncodingFilter</fil ter-class><init-param><param-name>encoding</param-name><param-value>UTF-8</param-value></init-param></filter><!-- struts2 滤镜配置 --><filter><filter-name>struts2</filter-name><filter-class>org.apache.struts2.dispatcher.FilterDispatcher</filter-clas s></filter><filter-mapping><filter-name>struts2</filter-name><url-pattern>/*</url-pattern></filter-mapping><!--Spring ApplicationContext 载入，必须--><listener><listener-class>org.springframework.web.context.ContextLoaderListener</li stener-class></listener><!-- Spring 刷新Introspector防止内存泄露 --><listener><listener-class>org.springframework.web.util.IntrospectorCleanupListener< /listener-class></listener><!-- session超时定义,单位为分钟 --><session-config><session-timeout>10</session-timeout></session-config><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>（2）Hibernate配置：<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE hibernate-configuration PUBLIC"-//Hibernate/Hibernate Configuration DTD 3.0//EN""/hibernate-configuration-3.0.dtd"><hibernate-configuration><session-factory><!—-数据库驱动类名称 --><propertyname="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</pr operty><!—-数据库用户名 --><property name="ername">MY</property><property name="hibernate.default_schema">MY</property> <!—-数据库用户密码 --><property name="hibernate.connection.password">MY</property> <!—-数据库连接字符串--><propertyname="hibernate.connection.url">jdbc:oracle:thin:@localhost:1521:loon</prope rty><propertyname="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</property> <!—-控制台是否输出SQL语句 --><property name="hibernate.show_sql">true</property><mapping class="privilege.database.Level" /></session-factory></hibernate-configuration>（3）Spring基本配置：配置文件应该在WEB-INF/spring/下面<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN""/dtd/spring-beans.dtd"><beans default-autowire="autodetect"><!—如果用的是XML配置文件，sessionFactory用这个配置"org.springframework.orm.hibernate3.LocalSessionFactoryBean" --> <bean id="sessionFactory"class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactor yBean"><property name="configLocation"><value>classpath:hibernate.cfg.xml</value></property><!-- 配置多个hibernate.cfg.xml<property name="configLocations"><list><value>classpath:hibernate_admin1.cfg.xml</value><value>classpath:hibernate_admin2.cfg.xml</value></list></property>--></bean><!-- Hibernate 事务管理 --><bean id="transactionManager"class="org.springframework.orm.hibernate3.HibernateTransactionManager"> <property name="sessionFactory" ref="sessionFactory" /> </bean><bean id="baseTransactionProxy"class="org.springframework.transaction.interceptor.TransactionProxyFactoryBe an" abstract="true"><property name="transactionManager" ref="transactionManager" /><property name="transactionAttributes"><props><prop key="find*">PROPAGATION_REQUIRED,readOnly</prop><prop key="persist*">PROPAGATION_REQUIRED,-Exception</prop><prop key="remove*">PROPAGATION_REQUIRED,-Exception</prop><!--<prop key="insert*">PROPAGATION_REQUIRED</prop><prop key="save">PROPAGATION_REQUIRED</prop><prop key="update*">PROPAGATION_REQUIRED</prop><prop key="edit*">PROPAGATION_REQUIRED</prop><prop key="del*">PROPAGATION_REQUIRED</prop><prop key="get*">PROPAGATION_REQUIRED,readOnly</prop><prop key="query*">PROPAGATION_REQUIRED,readOnly</prop><prop key="disPlay*">PROPAGATION_REQUIRES_NEW</prop>--></props></property></bean><bean id="LevelService" parent="baseTransactionProxy"><property name="target"><bean class="privilege.service.LevelService"><property name="dao"><bean class="privilege.dao.LevelDAO"><property name="sessionFactory" ref="sessionFactory" /></bean></property></bean></property></bean><bean id="LevelAction" class="privilege.action.LevelAction"><property name="levelService" ref="LevelService" /></bean></beans>（4）struts.xml文件的配置：<!DOCTYPE struts PUBLIC"-//Apache Software Foundation//DTD Struts Configuration 2.0//EN""/dtds/struts-2.0.dtd"><struts><package name="privilege" extends="struts-default"><action name="LoadLevel" class="LevelAction" method="findLevelById"> <result>/resource/json_struts2.jsp</result></action><action name="LevelAjaxJsonData" class="LevelAction"method="jsonExecute"><result>/resource/json_struts2.jsp</result></action></package></struts>3、建立的项目目录：Root：/resource/ext2.0/ 将下载的ext-2.0-beta1.zip文件解压到该目录/WEB-INF/web.xml/WEB-INF/lib/WEB-INF/classes/struts.xml/WEB-INF/spring/applicationContext.xml4、代码清单：Level.javaimport javax.persistence.Column;import javax.persistence.Entity;import javax.persistence.Id;import javax.persistence.Table;@Entity@Table(name = "LOON_LEVEL")public class Level implements java.io.Serializable {private Long levelid;private String levelname;private String description;public Level() {}public Level(Long levelid) {this.levelid = levelid;}public Level(Long levelid, String levelname, String description) { this.levelid = levelid;this.levelname = levelname;this.description = description;}@Id@Column(name = "LEVELID", unique = true, nullable = false, precision = 5, scale = 0)public Long getLevelid() {return this.levelid;}public void setLevelid(Long levelid) {this.levelid = levelid;}@Column(name = "LEVELNAME", length = 64)public String getLevelname() {return this.levelname;}public void setLevelname(String levelname) {this.levelname = levelname;}@Column(name = "DESCRIPTION", length = 256)public String getDescription() {return this.description;}public void setDescription(String description) {this.description = description;}}ILevelDAO.javaimport java.util.List;public interface ILevelDAO {public Level findLevelById(Long id);public List<Level> findAllLevels();public void persistLevel(Level level);public void removeLevel(Level level);public void removeById(Long id);}LevelDAO.javaimport java.util.List;import org.hibernate.Session;import org.springframework.orm.hibernate3.HibernateCallback;importorg.springframework.orm.hibernate3.support.HibernateDaoSupport;public class LevelDAO extends HibernateDaoSupport implements ILevelDAO {public LevelDAO() {super();}public Level findLevelById(Long id) {return (Level) getHibernateTemplate().get(Level.class, id);}public List<Level> findAllLevels() {returngetHibernateTemplate().loadAll(Level.class);// .find("from Level o");//}public void persistLevel(Level level) {getHibernateTemplate().saveOrUpdate(level);}public void removeLevel(Level level) {getHibernateTemplate().delete(level);}public void removeById(final Long id) {this.getHibernateTemplate().execute(new HibernateCallback() { public Object doInHibernate(Session session) {session.createQuery("delete from Level o where o.levelid=" + id + "").executeUpdate();return 1;}});}}ILevelService.javaimport java.util.List;public interface ILevelService {public Level findLevelById(Long id) throws Exception;public List<Level> findAllLevels() throws Exception;public List<Level> findLevelsByExample(Level level) throws Exception;public void persistLevel(Level level) throws Exception;public void removeLevel(Level level) throws Exception;public void removeLevelById(Long id) throws Exception;}LevelService.javaimport java.util.List;import privilege.dao.*;import privilege.database.Level;import org.springframework.context.ApplicationContext;public class LevelService implements ILevelService {private ILevelDAO dao;private static final String SERVICE_BEAN_ID = "LevelService";public LevelService() {super();}public static ILevelService getInstance(ApplicationContext context) {return (ILevelService) context.getBean(SERVICE_BEAN_ID);}public Level findLevelById(Long id) throws Exception {try {return getDao().findLevelById(id);} catch (RuntimeException e) {throw new Exception("findLevelById failed with the id " + id + ": " + e.getMessage());}}public void persistLevel(Level level) throws Exception {try {getDao().persistLevel(level);} catch (RuntimeException e) {throw new Exception("persistLevel failed: "+ e.getMessage());}}public void removeLevel(Level level) throws Exception {try {getDao().removeLevel(level);} catch (RuntimeException e) {throw new Exception("removeLevel failed: "+ e.getMessage());}}public void removeLevelById(Long id) throws Exception {try {getDao().removeById(id);} catch (RuntimeException e) {throw new Exception("removeLevel failed: "+ e.getMessage());}}public void setDao(ILevelDAO dao) {this.dao = dao;}public ILevelDAO getDao() {return this.dao;}}ExtJSONActionSuport.java辅助类,继承了ActionSupportimport com.opensymphony.xwork2.ActionSupport;public class ExtJSONActionSuport extends ActionSupport { private int totalCount = 0;// 总数private transient int start = 0;// 开始数private transient int limit = 0;// 限制数量private String jsonString = "";public String getJsonString() {return jsonString;}public void setJsonString(String jsonString) { this.jsonString = jsonString;}public String jsonExecute() throws Exception { return super.execute();}public int getTotalCount() {return totalCount;}public void setTotalCount(int totalCount) {this.totalCount = totalCount;}public int getStart() {return start;}public void setStart(int start) {this.start = start;}public int getLimit() {return limit;}public void setLimit(int limit) {this.limit = limit;}}LevelAction.javaimport java.util.List;import java.util.ArrayList;import javax.servlet.http.HttpSession;import org.apache.struts2.ServletActionContext;import net.sf.json.JSONArray;import privilege.database.Level;import privilege.service.*;import commons.utils.action.ExtJSONActionSuport;public class LevelAction extends ExtJSONActionSuport {private static final long serialVersionUID = 1L;private Level level = null;private List<Level> levels = new ArrayList<Level>(0);private ILevelService levelService = null;private String delData;public String execute() {return this.SUCCESS;}@Overridepublic String jsonExecute() throws Exception {if (this.getDelData() != null && !"".equals(this.getDelData())) {if (this.getDelData().indexOf(",") < 0) {this.levelService.removeLevelById(Long.parseLong(this.getDelData( )));System.out.println("del_id:" + getDelData());} else {String id[] = this.getDelData().split(",");for (int i = 0; i < id.length; i++) {System.out.println("del:" + id[i]);this.levelService.removeLevelById(Long.parseLong(id[i]));}}}HttpSession session =ServletActionContext.getRequest().getSession();Object o = null;// session.getAttribute("Level_Data1");if (o == null) {try {this.levels = this.getLevelService().findAllLevels();session.setAttribute("Level_Data1", this.levels);System.out.println("query database");} catch (Exception e) {e.printStackTrace();}} else {this.setLevels(((List<Level>) o));}this.setTotalCount(this.levels.size());JSONArray array = JSONArray.fromObject(this.levels);// System.out.println(this.getStart() + "---" + this.getLimit());this.setJsonString("{success:true,totalCount : " +this.getTotalCount() + ", list:" + array.toString() + "}");// System.out.println(this.getJsonString());return super.jsonExecute();}/***Find an entity by its id(primary key).**@param id*@return The found entity instance or null if the entity does not exist.*/public String findLevelById(Long id) {try {this.level = this.getLevelService().findLevelById(id);} catch (Exception e) {e.printStackTrace();}JSONArray array = JSONArray.fromObject(this.levels);this.setJsonString(array.toString());return SUCCESS;}public String findLevelById() {System.out.println(this.level.getLevelid());try {this.level =this.getLevelService().findLevelById(this.level.getLevelid());} catch (Exception e) {e.printStackTrace();}JSONArray array = JSONArray.fromObject(this.level);this.setJsonString(array.toString());this.setJsonString("{success:true,totalCount:1,list:" +array.toString() + "}");System.out.println(array.toString());return SUCCESS;}/***@return Return all persistent instances of the<code>Level</code> entity.*/public String getAllLevels() {try {this.levels = this.getLevelService().findAllLevels();} catch (Exception e) {e.printStackTrace();}return SUCCESS;}/***Make the given instance managed and persistent.**@return*/public String persistLevel() {System.out.println(this.level.getLevelid() + "---" + this.level.getLevelname() + "---"+ this.level.getDescription());this.setJsonString("{success:true}");try {this.getLevelService().persistLevel(this.getLevel());} catch (Exception e) {e.printStackTrace();}return SUCCESS;}/***Remove the given persistent instance.**@return*/public String removeLevel() {try {this.getLevelService().removeLevel(this.getLevel());} catch (Exception e) {e.printStackTrace();}return SUCCESS;}/***Remove an entity by its id(primary key).***@return*/public String removeLevelById(Long id) {try {this.getLevelService().removeLevelById(id);} catch (Exception e) {e.printStackTrace();}return SUCCESS;}public Level getLevel() {return level;}public void setLevel(Level level) {this.level = level;}public List<Level> getLevels() {return levels;}public void setLevels(List<Level> levels) {this.levels = levels;}public ILevelService getLevelService() {return levelService;}public void setLevelService(ILevelService levelService) { this.levelService = levelService;}public String getDelData() {return delData;}public void setDelData(String delData) {this.delData = delData;}}配置spring，添加：<bean id="LevelService" parent="baseTransactionProxy"><property name="target"><bean class="privilege.service.LevelService"><property name="dao"><bean class="privilege.dao.LevelDAO"><property name="sessionFactory"ref="sessionFactory" /></bean></property></bean></property></bean><bean id="LevelAction" class="privilege.action.LevelAction"> <property name="levelService" ref="LevelService" /> </bean>配置struts.xml:添加操作配置：<action name="AddLevel" class="LevelAction" method="persistLevel"> <result>/resource/json_struts2.jsp</result></action>修改时载入数据操作配置：<action name="LoadLevel" class="LevelAction" method="findLevelById"> <result>/resource/json_struts2.jsp</result></action>列表查询和删除数据时操作配置：<action name="LevelAjaxJsonData" class="LevelAction" method="jsonExecute"> <result>/resource/json_struts2.jsp</result></action>json_struts2.jsp :这个页面是一个公用的页面，服务器段向客户端传输时用于JSON字符串的输出，特别注意的是：<s:property>标签的escape属性一定要是false，默认是true，不然输出的JSON字符串被转码。