xml文件:
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://www.ibatis.com/dtd/sql-map-2.dtd"><!-- The SQL in these maps files has purposely been typed with more verbosity than is actually required.
For example, many of the selects could have just used SELECT * FROM... instead of listing all of the columns.
This is to demonstrate that even complex SQL can be handled and coded and formatted the way SQL was meant
to be (i.e. not a bunch of concatenated strings in a Java class). --><sqlMap namespace="Company"> <typeAlias alias="company" type="com.yadcom.mbs.properties.bean.Company"/>
<typeAlias alias="qcompany" type="com.yadcom.mbs.AgentAdmin.action.bean.QCompany"/> <resultMap id="companyResult" class="company">
<result property="companyID" column="companyID"/>
<result property="companyName" column="companyName"/>
<result property="sms" column="sms"/>
<result property="meeting" column="meeting"/>
<result property="mobileData" column="mobileData"/>
<result property="mobileOA" column="mobileOA"/>
<result property="banlance" column="banlance"/>
<result property="status" column="status"/>
<result property="postcode" column="postcode"/>
<result property="address" column="address"/>
<result property="phone_number" column="phone_number"/>
<result property="fax_number" column="fax_number"/>
<result property="contact" column="contact"/>
<result property="contact_number" column="contact_number"/>
<result property="create_date" column="create_date"/>
<result property="fee_date" column="fee_date"/>
<result property="area" column="area"/>
<result property="vocation" column="vocation"/>
<result property="adminName" column="admin_name"/>
<result property="overdraft" column="overdraft"/>
<result property="agentID" column="agentID"/>
<result property="monthfee" column="monthfee"/>
<result property="eter" column="eter"/>
</resultMap>
<insert id="insertCompany" parameterClass="company">
insert into mb_company (companyID,companyName,sms,meeting,mobileData,mobileOA,banlance,area,vocation,status,postcode,address,contact,contact_number,create_date,admin_name,overdraft,agentID,monthfee,eter,phone_number) values (#companyID#,#companyName#,#sms#,#meeting#,#mobileData#,#mobileOA#,#banlance#,#area#,#vocation#,#status#,#postcode#,#address#,#contact#,#contact_number#,to_date(#create_date#,'yyyy-MM-dd'),#adminName#,#overdraft#,#agentID#,#monthfee#,#eter#,#phone_number#)
</insert> <insert id="insertCompanyOld" parameterClass="company">
insert into ei_company (company_ID,company_Name,area_name,status,postcode,address,contact,contact_mobile,create_date,admin_name,overdraft,memo)
values (#companyID#,#companyName#,#area#,#status#,#postcode#,#address#,#contact#,#contact_number#,to_date(#create_date#,'yyyy-MM-dd'),#adminName#,#overdraft#,#memo#)
</insert> <select id="getCompanyList" resultMap="companyResult">
select * from mb_company where (status=0 or status=2)
</select> <select id="countCompanyList" resultClass="java.lang.String">
select count(*) from mb_company where (status=0 or status=2)
</select>
<select id="getCompanyByCompanyID" resultMap="companyResult" parameterClass="java.lang.String">
select * from mb_company where companyID=#value#
</select> <select id="getCompanyByCompanyName" resultMap="companyResult" parameterClass="java.lang.String">
select * from mb_company where CompanyName=#value# and (status=0 or status=2)
</select> <select id="queryCompanyListByCompanyName" resultMap="companyResult" parameterClass="java.lang.String">
select * from mb_company where companyName like #value# and (status=0 or status=2) order by create_date desc
</select> <select id="countCompanyBySmsNumber" resultClass="java.lang.String" parameterClass="java.lang.String">
select count(*) from mb_company,ei_company where ei_company.sms_number = #value# and mb_company.companyID=ei_company.company_ID
</select> <select id="getCompanyBySms" resultMap="companyResult" parameterClass="java.lang.String">
select * from mb_company,ei_company where ei_company.sms_number = #value# and mb_company.companyID=ei_company.company_ID and (mb_company.status=0 or mb_company.status=2) and (ei_company.status=0 or ei_company.status=2)
</select> <select id="countQueryCompanyListByCompanyName" resultClass="java.lang.String" parameterClass="java.lang.String">
select count(*) from mb_company where companyName like #value# and (status=0 or status=2)
</select>
<update id="updateCompanyByID" parameterClass="company">
update mb_company set address=#address# ,contact=#contact#,contact_number=#contact_number#,overdraft=#overdraft#,banlance=#banlance#,sms=#sms#,meeting=#meeting#,mobileData=#mobileData#,mobileOA=#mobileOA#,area=#area#,status=#status#,postcode=#postcode#,vocation=#vocation#,agentID=#agentID#,monthfee=#monthfee#,eter=#eter#,phone_number=#phone_number# where companyID=#companyID#
</update>
<select id="queryCompanyListByCompanyNameAgent" resultMap="companyResult" parameterClass="qcompany">
select * from mb_company where companyName like #var_string# and agentID=#agentID# and (status=0 or status=2) order by create_date desc
</select>
<!-- 新增 -->
<select id="queryCompanyListByMarketer" resultMap="companyResult" parameterClass="java.lang.String">
select * from mb_company where eter=#value# and (status=0 or status=2)
</select>
<select id="countQueryCompanyListByMarketer" resultClass="java.lang.String" parameterClass="java.lang.String">
select count(*) from mb_company where eter=#value# and (status=0 or status=2)
</select>
<select id="queryCompanyListByMarketerName" resultMap="companyResult" parameterClass="java.util.Map">
select * from mb_company where eter=#eter# and companyName like #companyName# and (status=0 or status=2)</select>
<select id="countCompanyListByMarketName" resultClass="java.lang.String" parameterClass="java.util.Map">
select count(*) from mb_company where eter=#eter# and companyName like #companyName# and (status=0 or status=2)
</select>
<!-- 20071120新增结束 -->
<select id="countQueryCompanyListByCompanyNameAgent" resultClass="java.lang.String" parameterClass="qcompany">
select count(*) from mb_company where companyName like #var_string# and agentID=#agentID# and (status=0 or status=2)
</select> <select id="getCompanyByCompanyNameAgent" resultMap="companyResult" parameterClass="qcompany">
select * from mb_company where CompanyName=#var_string# and agentID=#agentID# and (status=0 or status=2)
</select> <update id="delCompanyByIDOfOld" parameterClass="java.lang.String">
update ei_company set status=1 where company_id=#value#
</update> <update id="delCompanyByID" parameterClass="java.lang.String">
update mb_company set status=1 , logoutDate=sysdate where companyID=#value#
</update> <select id="getCompanyListByAgentID" resultMap="companyResult" parameterClass="java.lang.String">
select * from mb_company where agentID=#value# and (status=0 or status=2)
</select> <select id="countCompanyListByAgentID" resultClass="java.lang.String" parameterClass="java.lang.String">
select count(*) from mb_company where agentID=#value# and (status=0 or status=2)
</select>
<update id="openSms" parameterClass="java.lang.String">
update ei_company set status=0 where company_id=#value#
</update> <select id="countCompanyQlByCompanyID" resultClass="java.lang.String" parameterClass="java.lang.String">
select count(*) from ei_company where ei_company.company_id = #value# and ei_company.memo='ql'
</select>
</sqlMap>
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://www.ibatis.com/dtd/sql-map-2.dtd"><!-- The SQL in these maps files has purposely been typed with more verbosity than is actually required.
For example, many of the selects could have just used SELECT * FROM... instead of listing all of the columns.
This is to demonstrate that even complex SQL can be handled and coded and formatted the way SQL was meant
to be (i.e. not a bunch of concatenated strings in a Java class). --><sqlMap namespace="Company"> <typeAlias alias="company" type="com.yadcom.mbs.properties.bean.Company"/>
<typeAlias alias="qcompany" type="com.yadcom.mbs.AgentAdmin.action.bean.QCompany"/> <resultMap id="companyResult" class="company">
<result property="companyID" column="companyID"/>
<result property="companyName" column="companyName"/>
<result property="sms" column="sms"/>
<result property="meeting" column="meeting"/>
<result property="mobileData" column="mobileData"/>
<result property="mobileOA" column="mobileOA"/>
<result property="banlance" column="banlance"/>
<result property="status" column="status"/>
<result property="postcode" column="postcode"/>
<result property="address" column="address"/>
<result property="phone_number" column="phone_number"/>
<result property="fax_number" column="fax_number"/>
<result property="contact" column="contact"/>
<result property="contact_number" column="contact_number"/>
<result property="create_date" column="create_date"/>
<result property="fee_date" column="fee_date"/>
<result property="area" column="area"/>
<result property="vocation" column="vocation"/>
<result property="adminName" column="admin_name"/>
<result property="overdraft" column="overdraft"/>
<result property="agentID" column="agentID"/>
<result property="monthfee" column="monthfee"/>
<result property="eter" column="eter"/>
</resultMap>
<insert id="insertCompany" parameterClass="company">
insert into mb_company (companyID,companyName,sms,meeting,mobileData,mobileOA,banlance,area,vocation,status,postcode,address,contact,contact_number,create_date,admin_name,overdraft,agentID,monthfee,eter,phone_number) values (#companyID#,#companyName#,#sms#,#meeting#,#mobileData#,#mobileOA#,#banlance#,#area#,#vocation#,#status#,#postcode#,#address#,#contact#,#contact_number#,to_date(#create_date#,'yyyy-MM-dd'),#adminName#,#overdraft#,#agentID#,#monthfee#,#eter#,#phone_number#)
</insert> <insert id="insertCompanyOld" parameterClass="company">
insert into ei_company (company_ID,company_Name,area_name,status,postcode,address,contact,contact_mobile,create_date,admin_name,overdraft,memo)
values (#companyID#,#companyName#,#area#,#status#,#postcode#,#address#,#contact#,#contact_number#,to_date(#create_date#,'yyyy-MM-dd'),#adminName#,#overdraft#,#memo#)
</insert> <select id="getCompanyList" resultMap="companyResult">
select * from mb_company where (status=0 or status=2)
</select> <select id="countCompanyList" resultClass="java.lang.String">
select count(*) from mb_company where (status=0 or status=2)
</select>
<select id="getCompanyByCompanyID" resultMap="companyResult" parameterClass="java.lang.String">
select * from mb_company where companyID=#value#
</select> <select id="getCompanyByCompanyName" resultMap="companyResult" parameterClass="java.lang.String">
select * from mb_company where CompanyName=#value# and (status=0 or status=2)
</select> <select id="queryCompanyListByCompanyName" resultMap="companyResult" parameterClass="java.lang.String">
select * from mb_company where companyName like #value# and (status=0 or status=2) order by create_date desc
</select> <select id="countCompanyBySmsNumber" resultClass="java.lang.String" parameterClass="java.lang.String">
select count(*) from mb_company,ei_company where ei_company.sms_number = #value# and mb_company.companyID=ei_company.company_ID
</select> <select id="getCompanyBySms" resultMap="companyResult" parameterClass="java.lang.String">
select * from mb_company,ei_company where ei_company.sms_number = #value# and mb_company.companyID=ei_company.company_ID and (mb_company.status=0 or mb_company.status=2) and (ei_company.status=0 or ei_company.status=2)
</select> <select id="countQueryCompanyListByCompanyName" resultClass="java.lang.String" parameterClass="java.lang.String">
select count(*) from mb_company where companyName like #value# and (status=0 or status=2)
</select>
<update id="updateCompanyByID" parameterClass="company">
update mb_company set address=#address# ,contact=#contact#,contact_number=#contact_number#,overdraft=#overdraft#,banlance=#banlance#,sms=#sms#,meeting=#meeting#,mobileData=#mobileData#,mobileOA=#mobileOA#,area=#area#,status=#status#,postcode=#postcode#,vocation=#vocation#,agentID=#agentID#,monthfee=#monthfee#,eter=#eter#,phone_number=#phone_number# where companyID=#companyID#
</update>
<select id="queryCompanyListByCompanyNameAgent" resultMap="companyResult" parameterClass="qcompany">
select * from mb_company where companyName like #var_string# and agentID=#agentID# and (status=0 or status=2) order by create_date desc
</select>
<!-- 新增 -->
<select id="queryCompanyListByMarketer" resultMap="companyResult" parameterClass="java.lang.String">
select * from mb_company where eter=#value# and (status=0 or status=2)
</select>
<select id="countQueryCompanyListByMarketer" resultClass="java.lang.String" parameterClass="java.lang.String">
select count(*) from mb_company where eter=#value# and (status=0 or status=2)
</select>
<select id="queryCompanyListByMarketerName" resultMap="companyResult" parameterClass="java.util.Map">
select * from mb_company where eter=#eter# and companyName like #companyName# and (status=0 or status=2)</select>
<select id="countCompanyListByMarketName" resultClass="java.lang.String" parameterClass="java.util.Map">
select count(*) from mb_company where eter=#eter# and companyName like #companyName# and (status=0 or status=2)
</select>
<!-- 20071120新增结束 -->
<select id="countQueryCompanyListByCompanyNameAgent" resultClass="java.lang.String" parameterClass="qcompany">
select count(*) from mb_company where companyName like #var_string# and agentID=#agentID# and (status=0 or status=2)
</select> <select id="getCompanyByCompanyNameAgent" resultMap="companyResult" parameterClass="qcompany">
select * from mb_company where CompanyName=#var_string# and agentID=#agentID# and (status=0 or status=2)
</select> <update id="delCompanyByIDOfOld" parameterClass="java.lang.String">
update ei_company set status=1 where company_id=#value#
</update> <update id="delCompanyByID" parameterClass="java.lang.String">
update mb_company set status=1 , logoutDate=sysdate where companyID=#value#
</update> <select id="getCompanyListByAgentID" resultMap="companyResult" parameterClass="java.lang.String">
select * from mb_company where agentID=#value# and (status=0 or status=2)
</select> <select id="countCompanyListByAgentID" resultClass="java.lang.String" parameterClass="java.lang.String">
select count(*) from mb_company where agentID=#value# and (status=0 or status=2)
</select>
<update id="openSms" parameterClass="java.lang.String">
update ei_company set status=0 where company_id=#value#
</update> <select id="countCompanyQlByCompanyID" resultClass="java.lang.String" parameterClass="java.lang.String">
select count(*) from ei_company where ei_company.company_id = #value# and ei_company.memo='ql'
</select>
</sqlMap>
放到服务器上就不行了
服务器环境是jdk1.4,tomcat5,oracle9
本地是jdk1.5,tomcat5,oracle9根据错误可能是eter这个有问题
但是拼写什么都没问题
怎么就出错呢
create table MB_COMPANY
(
COMPANYID NUMBER(10) not null,
COMPANYNAME VARCHAR2(100),
SMS NUMBER(1),
MEETING NUMBER(1),
MOBILEDATA NUMBER(1),
MOBILEOA NUMBER(1),
BANLANCE NUMBER(11,3) default 0,
STATUS CHAR(1),
POSTCODE CHAR(10),
ADDRESS VARCHAR2(100),
PHONE_NUMBER VARCHAR2(30),
FAX_NUMBER VARCHAR2(30),
CONTACT VARCHAR2(30),
CONTACT_NUMBER VARCHAR2(30),
CREATE_DATE DATE default sysdate,
FEE_DATE VARCHAR2(30),
BANKTYPE VARCHAR2(20),
BANKACCOUNT VARCHAR2(30),
AREA VARCHAR2(4),
VOCATION NUMBER(4),
OVERDRAFT NUMBER(11,3) default 0,
ADMIN_NAME VARCHAR2(20),
AGENTID NUMBER(10),
LOGOUTDATE DATE,
MONTHFEE NUMBER(11,3) default 0,
MARKETER VARCHAR2(30),
MEMO VARCHAR2(100)
)
这样可以了吗
还是在本地是可以运行的没错
select * from mb_company where companyName like #value# and (status=0 or status=2) order by create_date desc
</select>
这条语句在数据库种执行正确
select * from mb_company where companyName like '%%' and (status=0 or status=2) order by create_date desc
在那里看看有无能回答你的,谢谢,LZ,甭忘了给俺分哦,谢谢LZ