《ssdev4培训02》由会员分享，可在线阅读，更多相关《ssdev4培训02（57页珍藏版）》请在金锄头文库上搜索。
1、4.0框架培训目 录 页01OPTION02OPTION03OPTION04OPTION安装配置框架简介后台开发门户开发安装配置01 JDK1.8https:/wiki.bsoft.work/download/attachments/23691704/jdk-8u241-windows-x64.exe?version=1&modificationDate=1581990453000&api=v2&download=true MySQLhttp:/ftp.yz.yamagata-u.ac.jp/pub/dbms/mariadb/mariadb-10.3.13/winx64-packages/ma
2、riadb-10.3.13-winx64.msi Tomcathttps:/ ZooKeeperhttps:/archive.apache.org/dist/zookeeper/zookeeper-3.4.8/zookeeper-3.4.8.tar.gz公司wiki：https:/wiki.bsoft.work/display/SSDEV/ssdevBBP安装部署：1. 解压war包2. 新建数据库3. 修改bbp环境配置（bbp.properties）4. 启动zookeeper5. 启动tomcatbsoftsystem123门户部署下载地址： https:/ modifyDate对应“修
3、改日期“字段。Expression(value=$,%server.date.now)privateDatemodifyDate;/修改日期Expression(value=$,%$ur.userId,updatable=false)privateStringcreateUser;/创建人Expression(value=$,%$ur.userId)privateStringmodifyUser;/修改人/省略 getter/setter自动生成字段值。注意：类体上必须要加 Schema注解DAOpackagedao;importctd.persistence.support.hibernat
4、e.HibernateSupportDelegateDAO;importdao.entity.A;publicabstractclassADAOextendsHibernateSupportDelegateDAO/*HibernateQuery接口的uniqueResult()*单条件获取单条记录 getBy$条件字段*相当于fromAwherecd=:cd;*/DAOMethodpublicabstractAgetByCd(Stringcd);/*HibernateQuery接口的uniqueResult()*俩条件与查询获 取单条记录 getBy$条件字段一And$条件字段二*相当于fro
5、mAwherecd=:cdandactive=:active;*/DAOMethodpublicabstractAgetByCdAndActive(Stringcd,booleanactive);/*HibernateQuery接口的uniqueResult()*俩条件或查询获 取单条记录 getBy$条件字段一or$条件字段二*相当于fromAwherecd=:cdoractive=:active;*/DAOMethodpublicabstractAgetByCdOrActive(Stringcd,booleanactive);get查询单条/*HibernateQuery接口的list()
6、*单条件获取多条记录findBy$表字段*相当于fromAwherecd=:cd;*/DAOMethodpublicabstractListfindByCd(Stringcd);/*HibernateQuery接口的list()*俩条件与查询获 取多条记录findBy$条件字段一And$条件字段二*相当于fromAwherecd=:cdandactive=:active;*/DAOMethodpublicabstractListfindByCdAndActive(Stringcd,booleanactive);/*HibernateQuery接口的list()*俩条件或查询获 取多条记录fin
7、dBy$条件字段一Or$条件字段二*相当于fromAwherecd=:cdoractive=:active;*/DAOMethodpublicabstractListfindByCdOrActive(Stringcd,booleanactive);/*HibernateQuery接口的list()*单条件获取多个字段值find$结果字段By$条件字段*相当于selectnafromAwherecd=:cd;*/DAOMethodpublicabstractListfindNaByCd(Stringcd);/*HibernateQuery接口的list()*俩条件与查询获 取多个字段值find$
8、结果字段By$条件字段一And$条件字段二*相当于selectnafromAwherecd=:cdandactive=:active;*/DAOMethodpublicabstractListfindNaByCdAndActive(Stringcd,booleanactive);/*HibernateQuery接口的list()*俩条件或查询获 取多个字段值find$结果字段By$条件字段一Or$条件字段二*相当于selectnafromAwherecd=:cdoractive=:active;*/DAOMethodpublicabstractListfindNaByCdOrActive(St
9、ringcd,booleanactive);find查询多条/*HibernateQuery接口的 list()*单条件分页获取多条记录 findBy$表字段*相当于 fromAwherecd=:cdlimit$pageStart,$pageLimit;*return返回 List*/DAOMethodpublicabstractListqueryByCd(Stringcd,DAOParam(pageStart=true)longstart,DAOParam(pageLimit=true)intlimit);/*HibernateQuery接口的 list()*单条件分页获取多条记录 find
10、By$表字段*相当于 fromAwherecd=:cdlimit$pageStart,$pageLimit;*return返回 QueryResult*/DAOMethodpublicabstractQueryResultqueryByCd(Stringcd,DAOParam(pageStart=true)longstart,DAOParam(pageLimit=true)intlimit);分页查询/*HibernateQuery接口的list()*单条件排序分页获 取多条记录 findBy$表字段*相当于fromAwherecd=:cdorderbynalimit$pageStart,$p
11、ageLimit;*/DAOMethod(orderBy=na)publicabstractListqueryByCd(Stringcd,DAOParam(pageStart=true)longstart,DAOParam(pageLimit=true)intlimit);排序查询/*单条件更新字段值update$目标字段By$条件字段*相当于updateAsetna=:nawherecd=:cd;*/DAOMethodpublicabstractvoidupdateNaByCd(Stringna,Stringcd);/*俩条件与操作更新字段值update$目标字段By$条件字段一And$条件
12、字段二*相当于updateAsetna=:nawherecd=:cdAndactive=:active;*/DAOMethodpublicabstractvoidupdateNaByCdAndActive(Stringna,Stringcd,booleanactive);/*俩条件或操作更新字段值update$目标字段By$条件字段一Or$条件字段二*相当于updateAsetna=:nawherecd=:cdAndactive=:active;*/DAOMethodpublicabstractvoidupdateNaByCdOrActive(Stringna,Stringcd,boolean
13、active);更新/*单条件删除数据removeBy$条件字段*相当于deletefromAwherecd=:cd;*/DAOMethodpublicabstractvoiddeleteByCd(Stringcd);/*俩条件与操作删除数据removeBy$条件字段一And$条件字段二*相当于deletefromAwherecd=:cdAndactive=:active;*/DAOMethodpublicabstractvoiddeleteByCdAndActive(Stringcd,booleanactive);/*俩条件或操作删除数据removeBy$条件字段一Or$条件字段二*相当于d
14、eletefromAwherecd=:cdAndactive=:active;*/DAOMethodpublicabstractvoiddeleteByCdOrActive(Stringcd,booleanactive);删除sql自定义查询方法命名规则：find$自定义字符串DAOMethod(sql=fromBwherecd=:cdandtenantId=:tenantIdandactive=:active)publicabstractListfindB(DAOParam(cd)Stringcd,DAOParam(tenantId)StringtenantId,DAOParam(activ
15、e)booleanactive);DAOMethod(sql=selectnafromBwherecd=:cdandtenantId=:tenantIdandactive=:active,params=DAOParam(name=tenantId,value=%$tenantId,dataType=string)publicabstractListfindB(DAOParam(cd)Stringcd,DAOParam(active)booleanactive);DAOMethod(sql=fromBwherecd=:cdandactive=:active)publicabstractQuery
16、ResultfindB(DAOParam(cd)Stringcd,DAOParam(active)booleanactive,DAOParam(pageStart=true)intpageStart,DAOParam(pageLimit=true)intpageSize);更新方法命名规则：update$自定义字符串DAOMethod(sql=updateBsetactive=:activewherecd=:cdandna=:naandtenantId=:tenantId)publicabstractvoidupdateActive(DAOParam(active)booleanactive,DAOParam(cd)Stringcd,DAOParam(na)Stringna,DAOParam(tenantId)StringtenantId);删除方法命名规则：delete$自定义字符串DAOMethod(sql=deletefromBwhereactive=:activeandcd=:cdandna=:na)publicabstractvoiddeleteB(DAOParam(acti
