sql.properties

jsp_javabean+tomcat的web管理系统！

listBlessConfig=select sql from msrv.business.obj.BlessConfig as sql
listMiscService=select sql from msrv.business.obj.MISCService as sql
listUser=select sql from msrv.obj.User as sql
listUserQuery=select sql from msrv.query.UserQuery as sql where sql.user.id\=[key]
selectUserquery=select s from msrv.query.SqlObject s
listBless=select sql from msrv.business.obj.Bless   where type\=$1

listBlessConfigxlt=select sql from msrv.business.obj.BlessConfigXLT as sql
listBlessxlt=select sql from msrv.business.obj.BlessXLT  where type\=$1
listContent=select sql from msrv.service.Content as sql
listCfdg =select sql from  msrv.business.obj.Cfdg as sql
listBlessTemp =select sql from  msrv.business.obj.BlessTemp as sql


listFolowNews =select sql from  msrv.business.obj.FolowNews as sql where sql.busiType.id=[key] order by hits desc

listDailyNews =select sql from  msrv.business.obj.DailyNews as sql

listMinBusiType =select sql from  msrv.business.obj.MinBusiType as sql

listAdvertiseContent =select sql from  msrv.business.obj.AdvertiseContent as sql

listAdvertiseConfig =select sql from  msrv.business.obj.AdvertiseConfig as sql where sql.content.id=[key]

# ring and picture

listRing =select sql from  msrv.business.obj.Ring as sql

listPicInType =select sql from  msrv.business.obj.PicInType as sql  where sql.pictureBusiness.id=[key]

listRingInType =select sql from  msrv.business.obj.RingInType as sql where sql.ringBusiness.id=[key]

listRingContent =select sql from  msrv.business.obj.RingContent as sql where sql.ring.id=[key]

listMobileType =select sql from  msrv.business.obj.MobileType as sql

listRingBusiness =select sql from  msrv.business.obj.RingBusiness as sql

listProvider =select sql from  msrv.business.obj.Provider as sql

listPicContent =select sql from  msrv.business.obj.PicContent as sql where sql.picture.id=[key]

listPicture =select sql from  msrv.business.obj.Picture as sql

listPictureBusiness =select sql from  msrv.business.obj.PictureBusiness as sql
#duo biao
listDuoBiao =select sql from  msrv.business.obj.DuoBiao as sql order by sql.id desc

#jia xiao tong
listSchool =select sql from  msrv.business.obj.School as sql

listSchoolUser =select sql from  msrv.business.obj.SchoolUser as sql where sql.school.id=[key]
#MXW

listThumbkingConfig =select sql from  msrv.business.obj.ThumbkingConfig as sql

listThumbkingMsgConfig =select sql from  msrv.business.obj.ThumbkingMsgConfig as sql
#service

listBsinessVariable =select sql from  msrv.service.BsinessVariable as sql where sql.business.id=[key]

listBsinessBackWord =select sql from  msrv.service.BsinessBackWord as sql where sql.business.id=[key]

listSrviceBusiness =select sql from  msrv.service.SrviceBusiness as sql

#cfdg

listDiffcultLevel =select sql from  msrv.business.obj.DiffcultLevel as sql

listFinanceGate =select sql from  msrv.business.obj.FinanceGate as sql

listAwards =select sql from  msrv.business.obj.Awards as sql

listScoreLever =select sql from  msrv.business.obj.ScoreLever as sql

listQustion =select sql from  msrv.business.obj.Question as sql

listPovinceGate =select sql from  msrv.business.obj.PovinceGate as sql where sql.financeGate.id=[key]

listChangeRatio =select sql from  msrv.business.obj.ChangeRatio as sql

listRegionInfo =select sql from  msrv.business.obj.RegionInfo as sql
listSrviceCustomVariable =select sql from  msrv.service.SrviceCustomVariable as sql where sql.srviceProperty=[key]

listSrviceCustomBackWord =select sql from  msrv.service.SrviceCustomBackWord as sql  where sql.srviceProperty=[key]

listSrviceProperty =select sql from  msrv.service.SrviceProperty as sql
listSrvicePropertyCondition =select sql from  msrv.service.SrviceProperty as sql where sql.gateWayMark=$1


listGateWayRefer =select sql from  msrv.service.GateWayRefer as sql