15第十五講支出添加功能實現(xiàn)

1、1.添加支出顯示界面。function payOutAddFn()var payOutAddForm = new Ext.FormPanel( bodyStyle:padding-left:230px, width:800,frame:true, labelAlign:right, monitorValid:true, items:new Ext.form.TextField( id:payOutname, name:payOutname,fieldLabel:支出名稱, minLength:3,minLengthText:支出名稱長度不能小于3個字符, maxLength:12,maxLen

2、gthText:支出名稱長度不能大于12個字符, allowBl:false,blText:支出名稱不能為空),new Ext.form.NumberField( id:payOutMoney, name:payOutMoney,fieldLabel:支出金額,allowNegative : false,/不允許輸入負(fù)數(shù) nanText :請輸入有效的整數(shù),/無效數(shù)字提示 allowDecimals : true,/允許輸入小數(shù) maxValue : 10000,/最大值minValue : 0,/最小值mext:支出金額不能小于0元, maxText:支出金額不能大于1萬元),new Ext

3、.form.DateField( id:payOutDate, name:payOutDate,fieldLabel:支出日期,width:130, maxValue:12/31/2009, minValue:01/01/2009,maxText:日期不能大于0, mext:日期不能小于0,format:Y年m月d日),buttons:text:添加,formBind:true,handler:function()alert(payOutAddForm.items.itemAt(0).getValue();,text:重置,handler:function() payOutAddForm.ge

4、tForm().reset(););if(!payOutAddPageIsOpen)var tabPage = tabPanel.add(title:支出添加,height:300, closable:true, layout:fit, items:payOutAddForm,listeners: beforedestroy:function()payOutAddPageIsOpen = false;2.添加數(shù)據(jù)庫表3.添加 PO 類和文件。package com.ibeifeng.po;import java.util.Date;/* PayOut entity. author MyEcli

5、pse Persistence Tools*/public class PayOut implements java.io.Serializable / Fieldsprivateeger id;private User user;private String payOutName; private Double payOutMoney; private Date payOutDate;/ ConstructorsCREATE TABLE payout (Id(11) NOT NULL auto_increment,payOutName varchar(12) default NULL,pay

6、OutMoney double(7,2) default NULL,payOutDate date default NULL,userId(11) default NULL, PRIMARY KEY(Id),KEY userId (userId),CONSTRApayout_ibfk_1 FOREIGN KEY (userId) REFERENuser (Id) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312;);tabPanel.setActiveTab(tabPage); payOutAddPageIsOpen = true;/*

7、 default constructor */public PayOut() /* full constructor */public PayOut(User user, String payOutName, Double payOutMoney, Date payOutDate) this.user = user; this.payOutName = payOutName; this.payOutMoney = payOutMoney; this.payOutDate = payOutDate;/ Property acsorspubliceger getId() return this.i

8、d;public void setId(eger id) this.id = id;public User getUser() return this.user;public void setUser(User user) this.user = user;public String getPayOutName() return this.payOutName;public void setPayOutName(String payOutName) this.payOutName = payOutName;public Double getPayOutMoney() return this.p

9、ayOutMoney;public void setPayOutMoney(Double payOutMoney) this.payOutMoney = payOutMoney;public Date getPayOutDate() return this.payOutDate;public void setPayOutDate(Date payOutDate) this.payOutDate = payOutDate;4.添加接口和實現(xiàn)類。package com.ibeifeng.; import java.util.List;import com.ibeifeng.po.PayOut; p

10、ublicerface PayOutpublic abstract void save(PayOut transientInstance); public abstract void delete(PayOut persistentInstance); public abstract PayOut findById(java.lang.eger id); public abstract List findByExle(PayOut instance);public abstract List findByProperty(String propertyName, Object value);

11、public abstract List findByPayOutName(Object payOutName);public abstract List findByPayOutMoney(Object payOutMoney); public abstract List findAll();public abstract PayOut merge(PayOut detachedInstance);com/ibeifeng/po/User.hbm.xmlcom/ibeifeng/po/PayOut.hbm.xmlpackage com.ibeifeng.; import java.util.

12、List;importmons.logging.Log;importmons.logging.LogFactory; import.hibernaockMode;import.hibernate.Query;import.hibernate.criterion.Exle;import.springframework.orm.hibernate3.support.HibernateSupport; import com.ibeifeng.po.PayOut;/* A data acs object () providing persistence and search support for P

13、ayOut entities.* Tranion control of the save(), update() and delete() operationscan directly support Spring container-managed tranions or they can be augmented to handle user-managed Spring tranions.Each of these methods provides additional information for how to configure it for the desired type of

14、 tranion control.* see com.ibeifeng.po.PayOut* author MyEclipse Persistence Tools*/public class PayOutImpl extends HibernateSupport implements PayOut private sic final Log log = LogFactory.getLog(PayOutImpl.class);/property constantspublic sic final String PAY_OUT_NAME = payOutName; public sic final

15、 String PAY_OUT_MONEY = payOutMoney;/* (non-Javadoc)* see com.ibeifeng.PayOut#save(com.ibeifeng.po.PayOut)*/public void save(PayOut transientInstance) public abstract void attachDirty(PayOut instance); public abstract void attachClean(PayOut instance);log.debug(saving PayOut instance); try getSes ()

16、.save(transientInstance); log.debug(save suc sful); catch (RuntimeException re) log.error(save failed, re); throw re;/* (non-Javadoc)see com.ibeifeng.PayOut#delete(com.ibeifeng.po.PayOut)*/public void delete(PayOut persistentInstance) log.debug(deleting PayOut instance); try getSes().delete(persiste

17、ntInstance); log.debug(delete sucsful); catch (RuntimeException re) log.error(delete failed, re); throw re;/* (non-Javadoc)see com.ibeifeng.PayOut#findById(java.lang.eger)*/public PayOut findById( java.lang.eger id) log.debug(getting PayOut instance with id: + id); try PayOut instance = (PayOut) get

18、Ses().get(com.ibeifeng.po.PayOut, id); return instance; catch (RuntimeException re) log.error(get failed, re); throw re;/* (non-Javadoc)see com.ibeifeng.PayOut#findByExle(com.ibeifeng.po.PayOut)*/public List findByExle(PayOut instance) log.debug(finding PayOut instance by exle); try List results = g

19、etSes().createCriteria(com.ibeifeng.po.PayOut).add(Exle.create(instance).list();log.debug(find by exle sucsful, result size: + results.size(); return results; catch (RuntimeException re) log.error(find by exle failed, re); throw re;/* (non-Javadoc)see com.ibeifeng.PayOut#findByProperty(java.lang.Str

20、ing, java.lang.Object)*/public List findByProperty(String propertyName, Object value) log.debug(finding PayOut instance with property: + propertyName+ , value: + value);try String queryString = from PayOut as mwhere m.+ propertyName + = ?;Query queryObject = getSes().createQuery(queryString); queryO

21、bject.setParameter(0, value);return queryObject.list(); catch (RuntimeException re) log.error(find by property name failed, re); throw re;/* (non-Javadoc)see com.ibeifeng.PayOut#findByPayOutName(java.lang.Object)*/public List findByPayOutName(Object payOutName) return findByProperty(PAY_OUT_NAME, pa

22、yOutName);/* (non-Javadoc)see com.ibeifeng.PayOut#findByPayOutMoney(java.lang.Object)*/public List findByPayOutMoney(Object payOutMoney) return findByProperty(PAY_OUT_MONEY, payOutMoney);/* (non-Javadoc)see com.ibeifeng.PayOut#findAll()*/public List findAll() log.debug(finding all PayOut instan); tr

23、y String queryString = from PayOut;Query queryObject = getSes().createQuery(queryString); return queryObject.list(); catch (RuntimeException re) log.error(find all failed, re); throw re;/* (non-Javadoc)see com.ibeifeng.PayOut#merge(com.ibeifeng.po.PayOut)*/public PayOut merge(PayOut detachedInstance

24、) log.debug(merging PayOut instance);try PayOut result = (PayOut) getSes().merge(detachedInstance); log.debug(merge sucsful); return result; catch (RuntimeException re) log.error(merge failed, re); throw re;/* (non-Javadoc)see com.ibeifeng.PayOut#attachDirty(com.ibeifeng.po.PayOut)*/public void atta

25、chDirty(PayOut instance) log.debug(attaching dirty PayOut instance); try 5.定義payOut和對象 payOutProxygetSes().saveOrUpdate(instance); log.debug(attach sucsful); catch (RuntimeException re) log.error(attach failed, re); throw re;/* (non-Javadoc)* see com.ibeifeng.PayOut#attachClean(com.ibeifeng.po.PayOu

26、t)*/public void attachClean(PayOut instance) log.debug(attaching clean PayOut instance); try getSes().lock(instance, LockMode.NONE); log.debug(attach sucsful); catch (RuntimeException re) log.error(attach failed, re); throw re;6.添加支出Action.package com.ibeifeng.action;import java.text.SimpleDateForma

27、t; import java.util.Date;import java.util.Map;import com.ibeifeng.PayOut; import com.ibeifeng.User; import com.ibeifeng.po.PayOut; import com.ibeifeng.po.User;import com.opensymphony.xwork2.ActionContext; import com.opensymphony.xwork2.ActionSupport;public class AddPayOutAction extendionSupport priv

28、ate String payOutName;private Double payOutMoney; private String payOutDate; privatesucs; private String msg;private PayOutpayOut; private Useruser;public String getPayOutName() return payOutName;public void setPayOutName(String payOutName) this.payOutName = payOutName;public UsergetUser() return us

29、er;public void setUser(Useruser) PROPAGATION_REQUIREDthis.user= user;public Double getPayOutMoney() return payOutMoney;public void setPayOutMoney(Double payOutMoney) this.payOutMoney = payOutMoney;public String getPayOutDate() return payOutDate;public void setPayOutDate(String payOutDate) this.payOutDate = payOutDate;publicics() return sucs;public void setSucs(sucs) thics = sucs;public String getMsg()