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

1、 Hibernate+Spring+Struts2+ExtJS开发CRUD功能 新一篇: 学习Hibernate JPA 1、 入门：各种开源框架环境及下载：Hibernate：3.x / 需要hibernate core 和annotations 包。Spring：2.x / Struts2：2.x /2.x/ ExtJS：2.X / JSON：JSON可以到/ 查看详细内容，这里使用j

2、son-lib / 本所需要的包： 2、 配置：（1）首先是配置web.xml，配置方法可以在下面的配置文件代码注释中查看，这里主要是Struts2的配置： struts2 org.apache.struts2.dispatcher.FilterDispatcher struts2 /*和Spring的配置： contextConfigLocation /WEB-INF/spring/*.xml org.springframework.web.context.ContextLoaderListenerWeb.xml的全部文件： str

3、uts2 contextConfigLocation /WEB-INF/spring/*.xml encodingFilter org.springframework.web.filter.CharacterEncodingFilter encoding UTF-8 struts2 org.apache.struts2.dispatcher.FilterDispatcher struts2 /* org.springframework.web.context.ContextLoaderListener org.springframework.web.util.IntrospectorClean

4、upListener 10 index.html index.htm index.jsp default.html default.htm default.jsp （2）Hibernate配置： oracle.jdbc.driver.OracleDriver MY MY MY jdbc:oracle:thin:localhost:1521:loon org.hibernate.dialect.Oracle9Dialect true （3）Spring基本配置：配置文件应该在WEB-INF/spring/下面 classpath:hibernate.cfg.xml !- 配置多个hibernat

5、e.cfg.xml classpath:hibernate_admin1.cfg.xml classpath:hibernate_admin2.cfg.xml - PROPAGATION_REQUIRED,readOnly PROPAGATION_REQUIRED,-Exception PROPAGATION_REQUIRED,-Exception !- PROPAGATION_REQUIRED PROPAGATION_REQUIRED PROPAGATION_REQUIRED PROPAGATION_REQUIRED PROPAGATION_REQUIRED PROPAGATION_REQU

6、IRED,readOnly PROPAGATION_REQUIRED,readOnly PROPAGATION_REQUIRES_NEW - （4）struts.xml文件的配置： /resource/json_struts2.jsp /resource/json_struts2.jsp 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.xm

7、l4、 代码清单： Level.java import javax.persistence.Column;import javax.persistence.Entity;import javax.persistence.Id;import javax.persistence.Table; EntityTable(name = LOON_LEVEL)public class Level implements java.io.Serializable private Long levelid; private String levelname; private String description

8、; 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

9、) 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, len

10、gth = 256) public String getDescription() return this.description; public void setDescription(String description) this.description = description; ILevelDAO.java import java.util.List;public interface ILevelDAO public Level findLevelById(Long id); public List findAllLevels(); public void persistLevel

11、(Level level); public void removeLevel(Level level); public void removeById(Long id); LevelDAO.java import java.util.List;import org.hibernate.Session;import org.springframework.orm.hibernate3.HibernateCallback;import org.springframework.orm.hibernate3.support.HibernateDaoSupport;public class LevelD

12、AO extends HibernateDaoSupport implements ILevelDAO public LevelDAO() super(); public Level findLevelById(Long id) return (Level) getHibernateTemplate().get(Level.class, id); public List findAllLevels() return getHibernateTemplate().loadAll(Level.class);/ .find(from Level o);/ public void persistLev

13、el(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(de

14、lete from Level o where o.levelid= + id + ).executeUpdate(); return 1; ); ILevelService.java import java.util.List;public interface ILevelService public Level findLevelById(Long id) throws Exception; public List findAllLevels() throws Exception; public List findLevelsByExample(Level level) throws Ex

15、ception; public void persistLevel(Level level) throws Exception; public void removeLevel(Level level) throws Exception;public void removeLevelById(Long id) throws Exception; LevelService.java import java.util.List;import privilege.dao.*;import privilege.database.Level;import org.springframework.cont

16、ext.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(SERVI

17、CE_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);

18、 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) thro

19、ws 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.Actio

20、nSupport; 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) th

21、is.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 = star

22、t; public int getLimit() return limit; public void setLimit(int limit) this.limit = limit; LevelAction.java import 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.Lev

23、el;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 levels = new ArrayList(0); private ILevelService levelService = null; private

24、String delData; public String execute() return this.SUCCESS; Override public 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

25、_id: + getDelData(); else String id = this.getDelData().split(,); for (int i = 0; i id.length; i+) System.out.println(del: + idi); this.levelService.removeLevelById(Long.parseLong(idi); HttpSession session = ServletActionContext.getRequest().getSession(); Object o = null;/ session.getAttribute(Level

26、_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) o); this.setTotalCount(this.levels.size(); JSONArray array = JSONArr

27、ay.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

28、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.setJsonStr

29、ing(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.setJsonStri

30、ng(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 Level entity. */ public String getAllLevels() try this.levels = this.getLevelService().findAllLevels

31、(); 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().persi