【正文】 項目實現(xiàn) 部分 代碼 1. 配置文件 ?xml version= encoding=GBK? beans xmlns= xmlns:xsi= xmlns:aop= xmlns:tx= xmlns:p= xsi:schemaLocation= bean id=dataSource class= destroymethod=close ! 指定連接數(shù)據(jù)庫的驅(qū)動 property name=driverClass value=/ ! 指定連接數(shù)據(jù)庫的 URL property name=jdbcUrl value=jdbc:ding=utf8/ 31 ! 指定連接數(shù)據(jù)庫的用戶名 property name=user value=root/ ! 指定連接數(shù)據(jù)庫的密碼 property name=password value=root/ ! 指定連接數(shù)據(jù)庫連接池的最大連接數(shù) property name=maxPoolSize value=40/ ! 指定連接數(shù)據(jù)庫連接池的最小連接數(shù) property name=minPoolSize value=1/ ! 指定連接數(shù)據(jù)庫連接池的初始化連接數(shù) property name=initialPoolSize value=1/ ! 指定連接數(shù)據(jù)庫連接池的連接的最大空閑時間 property name=maxIdleTime value=20/ property name=idleConnectionTestPeriod value=18000/ /bean bean id=sessionFactory class= property name=dataSource ref bean=dataSource / /property property name=hibernateProperties props prop key= /prop ! 是否根據(jù)需要每次自動創(chuàng)建數(shù)據(jù)庫 prop key=update/prop ! 顯示 Hibernate持久化操作所生成的 SQL prop key=true/prop ! 將 SQL腳本進行格式化后再輸出 prop key=true/prop /props /property property name=mappingResources list value/eshop/bean//value value/eshop/bean//value value/eshop/bean//value value/eshop/bean//value value/eshop/bean//value value/eshop/bean//value value/eshop/bean//value value/eshop/bean//value /list /property /bean ! ****************事務(wù)管理 配置 *************** bean id=transactionManager 32 class= property name=sessionFactory ref=sessionFactory/ /bean ! ****************配置切面 Bean，指定事務(wù)管理器 tx:advice id=txAdvice transactionmanager=transactionManager tx:attributes tx:method name=*/ /tx:attributes /tx:advice ! 配置一個切入點匹配指定包下所有類 aop:config aop:pointcut id=pointcut expression=execution(* .*Impl.*(..))/ aop:advisor adviceref=txAdvice pointcutref=pointcut/ /aop:config ! 引進 import resource=/ !*****************Service************************ bean id=headService class= property name=typesDAO ref=typesDAO/ property name=merchantableDAO ref=merchantableDAO/ property name=cartDAO ref=cartDAO/ property name=evaluateDAO ref=evaluateDAO/ property name=ordersDAO ref=ordersDAO/ property name=recordDAO ref=recordDAO/ /bean bean id=userService class= property name=memberDAO ref=memberDAO/ property name=cartDAO ref=cartDAO/ property name=adminDAO ref=adminDAO/ /bean bean id=pageService class= property name=pageDAO ref=pageDAO/ /bean ! *****************Action*********************** bean id=typesAction class= scope=prototype property name=headService ref=headService/ /bean bean id=merchantableAction class= scope=prototype property name=headService ref=headService/ 33 property name=pageService ref=pageService/ /bean ! scope注意默認為單例模式 sington bean id=loginAction class= scope=prototype property name=userService ref=userService/ property name=pageService ref=pageService/ /bean bean id=loginJsonAction class= scope=prototype property name=userService ref=userService/ /bean bean id=cartAction class= scope=prototype property name=headService ref=headService/ /bean bean id=cartJsonAction class= scope=prototype property name=headService ref=headService/ /bean bean id=evaluateJsonAction class= scope=prototype property name=headService ref=headService/ /bean bean id=evalAction class= scope=prototype property name=headService ref=headService/ /bean bean id=orderAction class= scope=prototype property name=headService ref=headService/ property name=pageService ref=pageService/ /bean bean id=adminAction class= scope=prototype property name=userService ref=userService/ /bean /beans 2. 配置文件 ?xml version= encoding=UTF8? ! 指定 Spring配置文件的 DTD信息 !DOCTYPE beans PUBLIC //SPRING//DTD BEAN beans bean id=template abstract=true lazyinit=true 34 property name=sessionFactory ref=sessionFactory / /bean bean id=adminDAO class= parent=template/ bean id=cartDAO class= parent=template/ bean id=evaluateDAO class= parent=template/ bean id=memberDAO class= parent=template/ bean id=merchantableDAO class= parent=template/ bean id=ordersDAO class= parent=template/ bean id=recordDAO class= parent=template/ bean id=typesDAO class= parent=template/ bean id=pageDAO class= parent=template/ /beans 3. 配置文件 ?xml version= encoding=GBK ? !DOCTYPE struts PUBLIC //Apache Software Foundation//DTD Struts Configuration struts constant name= value=UTF8/ constant name= value=messageResource/ package name=head extends=strutsdefault namespace=/head action name=index class=typesAction result name=success/result result name=exit type=redirect/result /action action name=login class=loginAction result name=error/result result name=modifymember//result result name=modifyaddressmember//result result name=regist/result result name=inputmember//result /action action name=merchantable class=merchantableAction result name=success/result result name=showone/result result name=research/result 35 /action action name=eval class=evalAction result name=success/resul。 訂單表 CREATE TABLE orders ( order_id INT(6) AUTO_INCREMENT, order_date VARCHAR(20), order_mem_id INT(5), order_status