createorreplaceprocedureinsertuser
(
puidinuserinfo.userid%type,
punameinuserinfo.username%type,
pupwdinuserinfo.userpwd%type,
puaddressinuserinfo.useraddress%type
)
is
resultnumnumber;
begin
resultnum:=0;
selectcount(*)intoresultnumfromuserinfowhereuserid=puidorusername=puname;
ifresultnum=0then
insertintouserinfovalues(puid,puname,pupwd,puaddress);
commit;
dbms_output.put_line(\'成功插入数据\');
else
ifuserid=puidthen
dbms_output.put_line(\'这个ID已经存在了,请换过一个!\');
else
dbms_output.put_line(\'该数据已经存在\');
endif;
endif;
end;
|