sqlcode.properties~54~

JSP+SQL实现了一个拥有添加、删除、查询基本功能的CRM系统

#--基础信息维护--#
#--对区域信息表的操作(tb_Client_qyxx)--#
#--查询的操作--
sql.qyxx.select=select *  from tb_Client_qyxx
#--删除的操作--
sql.qyxx.delete=delete from tb_Client_qyxx where qyxx_id='?'
#--插入的操作--
sql.qyxx.insert=insert into tb_Client_qyxx values('?','?','?','?','?','?')
#--以区域编号查找数据的操作--
sql.qyxx.selectOne=select * from tb_Client_qyxx where qyxx_id='?'
#--以区域编号修改区域信息--
sql.qyxx.update=update tb_Client_qyxx set qyxx_qymc='?',qyxx_qyjb='?',qyxx_zscd='?',qyxx_qygml='?',qyxx_bz='?' where qyxx_id='?'
#--查找出数据库中的最大流水号,以便做帐号存贮--
sql.qyxx.count=select MAX(id) as t from tb_Client_qyxx

#--对企业性质信息表的操作(tb_Client_qyxz)--#
#--查询的操作--
sql.qyxz.select=select * from tb_Client_qyxz
#--删除的操作--
sql.qyxz.delete=delete from tb_Client_qyxz where qyxz_id='?'
#--以企业性质编号查找数据的操作--
sql.qyxz.selectOne=select * from tb_Client_qyxz where qyxz_id='?'
#--以企业性质编号修改数据的操作--
sql.qyxz.update=update tb_Client_qyxz set qyxz_xzmc='?',qyxz_bz='?' where qyxz_id='?'
#--查找出数据库中的最大流水号,以便做帐号存贮--
sql.qyxz.count=select MAX(id) as t from tb_Client_qyxz
#--插入的操作--
sql.qyxz.insert=insert into tb_Client_qyxz values('?','?','?')

#--对企业类型信息表的操作(tb_Client_qylx)--#
#--查询的操作--
sql.qylx.select=select * from tb_Client_qylx
#--删除的操作--
sql.qylx.delete=delete from tb_Client_qylx where qylx_id='?'
#--以企业类型编号修改数据的操作--
sql.qylx.update=update tb_Client_qylx set qylx_lxmc='?',qylx_bz='?' where qylx_id='?'
#--以企业类型编号查找数据的操作--
sql.qylx.selectOne=select * from tb_Client_qylx where qylx_id='?'
#--查找出数据库中的最大流水号,以便做帐号存贮--
sql.qylx.count=select MAX(id) as t from tb_Client_qylx
#--插入的操作--
sql.qylx.insert=insert into tb_Client_qylx values('?','?','?')

#--对企业资信信息表的操作(tb_Client_qyzx)--#
#--查询的操作--
sql.qyzx.select=select * from tb_Client_qyzx
#--删除的操作--
sql.qyzx.delete=delete from tb_Client_qyzx where qyzx_id='?'
#--以企业资信编号修改数据的操作--
sql.qyzx.update=update tb_Client_qyzx set qyzx_zxjb='?',qyzx_bz='?' where qyzx_id='?'
#--以企业资信编号查找数据的操作--
sql.qyzx.selectOne=select * from tb_Client_qyzx where qyzx_id='?'
#--查找出数据库中的最大流水号,以便做帐号存贮--
sql.qyzx.count=select MAX(id) as t from tb_Client_qyzx
#--插入的操作--
sql.qyzx.insert=insert into tb_Client_qyzx values('?','?','?')

#--对企业资信信息表的操作(tb_Client_khjb)--#
#--查询的操作--
sql.khjb.select=select * from tb_Client_khjb
#--删除的操作--
sql.khjb.delete=delete from tb_Client_khjb where khjb_id='?'
#--以客户级别编号修改数据的操作--
sql.khjb.update=update tb_Client_khjb set khjb_jbmc='?',khjb_zdywl=?,khjb_bz='?' where khjb_id='?'
#--以客户级别编号查找数据的操作--
sql.khjb.selectOne=select * from tb_Client_khjb where khjb_id='?'
#--查找出数据库中的最大流水号,以便做帐号存贮--
sql.khjb.count=select MAX(id) as t from tb_Client_khjb
#--插入的操作--
sql.khjb.insert=insert into tb_Client_khjb values('?','?',?,'?')

#--对客户满意表的操作(tb_Client_khmyd)--#
#--查询的操作--
sql.khmyd.select=select * from tb_Client_khmyd
#--删除的操作--
sql.khmyd.delete=delete from tb_Client_khmyd where khmyd_id='?'
#--以客户满意度编号修改数据的操作--
sql.khmyd.update=update tb_Client_khmyd set khmyd_myd='?',khmyd_bz='?' where khmyd_id='?'
#--以客户满意度编号查找数据的操作--
sql.khmyd.selectOne=select * from tb_Client_khmyd where khmyd_id='?'
#--查找出数据库中的流水号,以便做帐号存贮--
sql.khmyd.count=select MAX(id) as t from tb_Client_khmyd
#--插入的操作--
sql.khmyd.insert=insert into tb_Client_khmyd values('?','?','?')

#--对客户银行表的操作(tb_Client_bank)--#
#--查询的操作--
sql.bank.select=select * from tb_Client_bank
#--删除的操作--
sql.bank.delete=delete from tb_Client_bank where bank_id='?'
#--以客户银行表编号修改数据的操作--
sql.bank.update=update tb_Client_bank set bank_name='?',bank_bz='?' where bank_id='?'
#--以客户银行表编号查找数据的操作--
sql.bank.selectOne=select * from tb_Client_bank where bank_id='?'
#--查找出数据库的最大流水号,以便做帐号存贮--
sql.bank.count=select MAX(id) as t from tb_Client_bank
#--插入的操作--
sql.bank.insert=insert into tb_Client_bank values('?','?','?')

#--客户信息维护--#
#--对客户信息表的操作(tb_khxx)--#
#--查询的操作--
sql.khxx.select=select * from tb_khxx
#--以客户编号去查询--
sql.khxx.selectOne=select * from tb_khxx where khxx_id='?'
#--以数据库中的记录数，查找出多少记录计算,以便做帐号存贮--
sql.khxx.count=select MAX(id) as t from tb_khxx
#--插入的操作--
sql.khxx.insert=insert into tb_khxx values('?','?','?','?','?','?','?','?','?','?','?','?','?','?','?','?','?','?','?','?','?')
#--删除的操作--
sql.khxx.delete=delete from tb_khxx where khxx_id='?'
#--修改的操作--
sql.khxx.update=update tb_khxx set khxx_mc='?',khxx_qyxz='?',khxx_qylx='?',khxx_qyzx='?',khxx_qydz='?',khxx_szsf='?',khxx_szcs='?',khxx_gsyb='?',khxx_frdb='?',khxx_khyh='?',khxx_yhzh='?',khxx_nsh='?',khxx_ICcard='?',khxx_gswz='?',khxx_gsdh='?',khxx_gscz='?',khxx_lxr='?',khxx_lxrdh='?',khxx_khjb='?',khxx_bz='?' where khxx_id='KH-2'
sql.khxx.mc=select * from tb_khxx where khxx_mc='?'

#--对业务来往表的操作(tb_Client_Cpxs)--#
#--查询的操作--
sql.khcpx.select=select * from tb_Client_Cpxs
#--以业务来往表编号去查询--
sql.khcpx.selectOne=select * from tb_Client_Cpxs where cpxs_id='?'
#--插入的操作--
sql.khcpx.insert=insert into tb_Client_Cpxs values('?','?','?','?','?','?','?','?')
#--删除的操作--
sql.khcpx.delete=delete from tb_Client_Cpxs where cpxs_id='?'
#--修改的操作--
sql.khcpx.update=update tb_Client_Cpxs set cpxs_mc='?',cpxs_cpdj='?',cpxs_xssl='?',cpxs_ywl='?',cpxs_khmc='?',cpxs_xsrq='?',cpxs_bz='?' where cpxs_id='?'


#--客户服务--#
#--对客户反馈表的操作(tb_Client_khfk)--#
#--查询的操作--
sql.khfk.select=select * from tb_Client_khfk
#--以客户反馈编号去查询的操作--
sql.khfk.selectOne=select * from tb_Client_khfk where khfk_id='?'
#--删除的操作--
sql.khfk.delete=delete from tb_Client_khfk where khfk_id='?'
#--修改的操作--
sql.khfk.update=update tb_Client_khfk set khfk_fkbt='?',khfk_khmc='?',khfk_fknr='?',khfk_fkrq='?',khfk_fkslr='?',khfk_khmyd='?',khfk_bz='?' where khfk_id='?'
#--插入的操作--
sql.khfk.insert=insert into tb_Client_khfk (khfk_id,khfk_fkbt,khfk_khmc,khfk_fknr,khfk_fkrq,khfk_fkslr,khfk_khmyd,khfk_bz) values('?','?','?','?','?','?','?','?')
#--查出流水号，以便做帐号存贮--
sql.khfk.count=select MAX(id) as t from tb_Client_khfk
#--根据客户满意程度去查询--
sql.khfk.myd=select * from tb_Client_khfk where khfk_khmyd='?'

#--对(tb_Client_sfzy)的操作--#
sql.sfzy.myd=select * from tb_Client_sfzy