日期:2014-05-17 浏览次数:20821 次
create or replace procedure SH_VEH_CX(
vhpzl IN varchar2,
vhphm IN varchar2,
vRES out varchar2,
VCLSBDH out varchar2,
VFDJH out varchar2,
VCLLX out varchar2,
VCSYS out varchar2,
Vsyxz out varchar2,
VSFZMHM out varchar2,
VSYR out varchar2,
Vsyq out varchar2,
Vccdjrq out date,
Vyxqz out date,
Vqzbfqz out date,
Vzt out varchar2,
Vsjhm out varchar2
)
IS
rowcount number;
begin
if length(vHPHM)<=5 then
vRES := 0;
return;
END IF;
select
CLSBDH,
FDJH,
CLLX,
CSYS,
syxz,
SFZMHM,
SYR,
syq,
ccdjrq,
yxqz,
qzbfqz,
zt,
sjhm
INTO
vCLSBDH,
vFDJH,
vCLLX,
vCSYS,
vsyxz,
vSFZMHM,
vSYR,
vsyq,
vccdjrq,
vyxqz,
vqzbfqz,
vzt,
vsjhm
from jx_VEHICLE
where HPHM=vHPHM AND HPZL=VHPZL and rownum=1;
rowcount := sql%rowcount;
if rowcount=1 then
vRES := 1;
else
vRES := 0;
end if;
exception
when OTHERS then
vRES := 0;
end SH_VEH_CX;
public static void main(String[] args) {
Test test = new Test();
String str1="a";
String str2="b";
String result = test.select(str1, str2);
//result算是输出值么?放到哪里?
}
//这里就是根据输入值进行sql查询的过程
public String select(String str1,String str2){
return "";
}