SSH框架下的增刪改查.doc

SSH實現(xiàn)的增刪改查實例 分類： ssh 2010-10-01 17:12 4591人閱讀 評論(7) 收藏 舉報 一.整合步驟1.通過MyEclipse向?qū)В砑觭truts功能2.通過MyEclipse向?qū)?，添加Hibernate3功能：生成會話工廠的那個步驟中一定要將那個對號要去掉，不能由hibernate來生成，而是交給Spring來生成；還有就是導(dǎo)入jar包的時候選擇復(fù)制到lib目錄下這一項。3.通過MyEclipse向?qū)?，?dǎo)入實現(xiàn)Spring功能，注意導(dǎo)入jar包的時候選擇復(fù)制到lib目錄下這一項。3.利用MyEclipse反向工程的方法，以Spring生成dao對象的方式創(chuàng)建Hibernate DAO，相關(guān)POJO及其xxx.hbm.xml。4. DAO實現(xiàn)類加入Transactional標(biāo)記。5. 修改applicationContext.xml文件，增加Spring事務(wù)管理、DAO等bean的配置。6. 編寫action類。7. 在applicationContext.xml文件中添加Action的代理bean。8. 在struts的配置文件中，添加相應(yīng)的Action，類名指向Spring中的代理bean，并加入和。9. 編寫Jsp文件。10. 發(fā)布web項目。11. 啟動web服務(wù)器，運行項目二.SSH實現(xiàn)關(guān)于書籍增刪改查實例1.創(chuàng)建mysql數(shù)據(jù)庫及其表create database book;create table book(id int not null primary key auto_increment,bookname varchar(30),bookauthor varchar(30);2.表現(xiàn)層(1)index.jsp(首頁)java view plaincopyprint?1. 2. 3. 4. 5. 6. 歡迎7. 8. 9. 查看書籍列表10. 11. (2)list.jsp(書籍列表頁面)c-sharp view plaincopyprint?1. 2. 3. 4. 9. 10. 11. 12. basehref=13. 書籍列表頁面14. 15. 16. 17. /*給鏈接加入鼠標(biāo)移過變色和去除下劃線功能*/24. a:hover25. color:red;26. text-decoration:none27. 28. 29. 30. 書籍列表頁面31. 32. 33. 34. 35. 36. 38. 39. 40. 書籍ID41. 42. 43. 書籍名稱44. 45. 46. 作者47. 48. 49. 價格50. 51. 52. 操作53. 54. 55. 56. 57. 58. 59. $book.id60. 61. 62. $book.bookname63. 64. 65. $book.bookauthor66. 67. 68. $book.bookprice69. 70. 71. ahref=/book.do?method=modifybook&id=$book.id修改72. ahref=/book.do?method=deletebook&id=$book.id刪除73. 74. 75. 76. 77. 78. 79. 抱歉,沒有找到相關(guān)的記錄!80. 81. ahref=/new.jsp添加書籍82. formaction=/book.do?method=searchbookmethod=postonsubmit=returncheckSearchForm(this);83. 84. 85. 查找書籍86. 87. 書籍名:88. 89. 90. 91. 92. 93. (3)new.jsp(新增書籍頁面)c-sharp view plaincopyprint?1. 2. 3. 4. 5. 6. 7. 添加書籍8. 9. 10. 11. 12. 13. 14. 15. 添加書籍16. 17. formaction=/book.do?method=addbookonsubmit=returncheckForm(this);method=post18. 19. 20. 21. 22. 書籍名：23. 24. 25. 26. 27. 28. 29. 30. 31. 32. 作者:33. 34. 35. 36. 37. 38. 39. 40. 41. 價格：42. 43. 44. 45. 46. 47. 48. 49. 50. 51. 52. 53. 54. 55. 56. 57. 58. 59. 60. 61. inputtype=buttononclick=document.location=/book.do?method=listbook;62. value=63. 返回列表64. 65. (4)edit.jsp(書籍修改頁面)c-sharp view plaincopyprint?1. 2. 3. 4. 5. 修改書籍6. 7. 8. 9. 10. 11. 12. 13. 修改書籍14. 15. formaction=/book.do?method=updatebookonsubmit=returncheckForm(this);method=post16. 17. 18. 19. 20. 21. 書籍名：22. 23. 24. 25. 26. 27. 28. 29. 30. 31. 作者:32. 33. 34. 35. 36. 37. 38. 39. 40. 價格：41. 42. 43. 44. 45. 46. 47. 48. 49. 50. 51. 52. 53. 54. 55. 56. 57. 58. 59. 60. 61. 62. (5)error.jsp(錯誤公用頁面)c-sharp view plaincopyprint?1. 2. 7. 8. 9. 10. basehref=11. 出錯了！12. 13. 14. 出錯了！15. 詳細(xì)信息是：16. $message17. 返回18. 19. (6)form.jsc-sharp view plaincopyprint?1. /驗證表單輸入不為空的腳本代碼 2. functioncheckForm(form)3. if(form.bookname.value=)4. alert(書名不能為空!);5. form.bookname.focus();6. returnfalse;7. 8. if(form.bookauthor.value=)9. alert(作者不能為空!);10. form.bookauthor.focus();11. returnfalse;12. 13. if(form.bookprice.value=)14. alert(價格不能為空!);15. form.bookprice.focus();16. returnfalse;17. 18. returntrue;19. 20. functioncheckSearchForm(form)21. if(form.bookname.value.match(/s*$/)22. alert(查詢條件不能為空!);23. form.bookname.focus();24. returnfalse;25. 26. returntrue;27. 3.公用類及其javabean(1)EncodingFilter.java(過濾器)c-sharp view plaincopyprint?1. packagefilter;2. importjava.io.IOException;3. importjavax.servlet.Filter;4. importjavax.servlet.FilterChain;5. importjavax.servlet.FilterConfig;6. importjavax.servlet.ServletException;7. importjavax.servlet.ServletRequest;8. importjavax.servlet.ServletResponse;9. publicclassEncodingFilterimplementsFilter10. protectedFilterConfigconfig;11. protectedStringEncoding=null;12. publicvoidinit(FilterConfigconfig)throwsServletException13. this.config=config;14. this.Encoding=config.getInitParameter(Encoding);15. 16. publicvoiddoFilter(ServletRequestrequest,ServletResponseresponse,17. FilterChainchain)throwsIOException,ServletException18. if(request.getCharacterEncoding()=null)19. if(Encoding!=null)20. request.setCharacterEncoding(Encoding);21. response.setCharacterEncoding(Encoding);22. 23. 24. chain.doFilter(request,response);25. 26. publicvoiddestroy()27. 28. (2)book.javac-sharp view plaincopyprint?1. packagedao;2. /*3. *Bookentity.authorMyEclipsePersistenceTools4. */5. publicclassBookimplementsjava.io.Serializable6. /Fields 7. privateIntegerid;8. privateStringbookname;9. privateStringbookauthor;10. privateFloatbookprice;11. /Constructors 12. /*defaultconstructor*/13. publicBook()14. 15. /*fullconstructor*/16. publicBook(Stringbookname,Stringbookauthor,Floatbookprice)17. this.bookname=bookname;18. this.bookauthor=bookauthor;19. this.bookprice=bookprice;20. 21. /Propertyaccessors 22. publicIntegergetId()23. returnthis.id;24. 25. publicvoidsetId(Integerid)26. this.id=id;27. 28. publicStringgetBookname()29. returnthis.bookname;30. 31. publicvoidsetBookname(Stringbookname)32. this.bookname=bookname;33. 34. publicStringgetBookauthor()35. returnthis.bookauthor;36. 37. publicvoidsetBookauthor(Stringbookauthor)38. this.bookauthor=bookauthor;39. 40. publicFloatgetBookprice()41. returnthis.bookprice;42. 43. publicvoidsetBookprice(Floatbookprice)44. this.bookprice=bookprice;45. 46. 4.DAO層BookDAO.javac-sharp view plaincopyprint?1. packagedao;2. importjava.util.List;3. importorg.hibernate.LockMode;4. importorg.hibernate.Query;5. importorg.slf4j.Logger;6. importorg.slf4j.LoggerFactory;7. importorg.springframework.context.ApplicationContext;8. importorg.springframework.context.support.ClassPathXmlApplicationContext;9. importorg.springframework.orm.hibernate3.support.HibernateDaoSupport;10. importorg.springframework.transaction.annotation.Transactional;11. /*12. *Adataaccessobject(DAO)providingpersistenceandsearchsupportforBook13. *entities.Transactioncontrolofthesave(),update()anddelete()operations14. *candirectlysupportSpringcontainer-managedtransactionsortheycanbe15. *augmentedtohandleuser-managedSpringtransactions.Eachofthesemethods16. *providesadditionalinformationforhowtoconfigureitforthedesiredtype17. *oftransactioncontrol.18. *19. *seedao.Book20. *authorMyEclipsePersistenceTools21. */22. Transactional23. publicclassBookDAOextendsHibernateDaoSupport24. privatestaticfinalLoggerlog=LoggerFactory.getLogger(BookDAO.class);25. /propertyconstants 26. publicstaticfinalStringBOOKNAME=bookname;27. publicstaticfinalStringBOOKAUTHOR=bookauthor;28. publicstaticfinalStringBOOKPRICE=bookprice;29. protectedvoidinitDao()30. /donothing 31. 32. publicvoidsave(BooktransientInstance)33. log.debug(savingBookinstance);34. try35. getHibernateTemplate().save(transientInstance);36. log.debug(savesuccessful);37. catch(RuntimeExceptionre)38. log.error(savefailed,re);39. throwre;40. 41. 42. publicvoidupdate(BooktransientInstance)43. log.debug(savingBookinstance);44. try45. getHibernateTemplate().update(transientInstance);46. log.debug(savesuccessful);47. catch(RuntimeExceptionre)48. log.error(savefailed,re);49. throwre;50. 51. 52. publicvoiddelete(BookpersistentInstance)53. log.debug(deletingBookinstance);54. try55. getHibernateTemplate().delete(persistentInstance);56. log.debug(deletesuccessful);57. catch(RuntimeExceptionre)58. log.error(deletefailed,re);59. throwre;60. 61. 62. publicBookfindById(java.lang.Integerid)63. log.debug(gettingBookinstancewithid:+id);64. try65. Bookinstance=(Book)getHibernateTemplate().get(dao.Book,id);66. returninstance;67. catch(RuntimeExceptionre)68. log.error(getfailed,re);69. throwre;70. 71. 72. publicListfindByExample(Bookinstance)73. log.debug(findingBookinstancebyexample);74. try75. Listresults=getHibernateTemplate().findByExample(instance);76. log.debug(findbyexamplesuccessful,resultsize:77. +results.size();78. returnresults;79. catch(RuntimeExceptionre)80. log.error(findbyexamplefailed,re);81. throwre;82. 83. 84. publicListfindByProperty(