// 带参数存储过程含赋值方式 CREATE OR REPLACE PACKAGE BODY Pkg_User IS -- Function and procedure implementations
FUNCTION tryUserName(
p_userName IN PERSON.Username%TYPE)
RETURN NUMBER
IS
v_validFlag NUMBER := 1 ;
v_usernum NUMBER := 0 ;
BEGIN SELECT COUNT(*) INTO v_usernum FROM PERSON,PERSONDYNAMIC
WHERE username = lower(p_userName) AND vtimes>0 AND PERSON.nid = PERSONDYNAMIC.nid; IF v_usernum = 1 THEN
v_validFlag := 0 ;
END IF; RETURN v_validFlag;
END; -- register userName
--return userID
--delete Bp, add sex, mobilenum, homepage
FUNCTION register(
p_userName IN VARCHAR2,
p_cname IN VARCHAR2,
p_nickname IN VARCHAR2, p_birthday IN PERSON.Birthday%TYPE,
p_sex IN PERSON.Sex%TYPE,
p_company IN VARCHAR2,
p_address IN VARCHAR2,
p_tele IN VARCHAR2, p_mobileCode IN VARCHAR2,
p_email IN VARCHAR2,
p_icq IN VARCHAR2,
p_homePage IN VARCHAR2,
p_iconURL IN VARCHAR2,
p_info IN VARCHAR2, p_passwd IN VARCHAR2,
p_question IN VARCHAR2,
p_answer IN VARCHAR2, p_secrecy IN PERSON.Secrecy%TYPE --p_userip IN VARCHAR2 )
RETURN NUMBER
上面是我的存储过程
我要怎么写jdbc调用它
FUNCTION tryUserName(
p_userName IN PERSON.Username%TYPE)
RETURN NUMBER
IS
v_validFlag NUMBER := 1 ;
v_usernum NUMBER := 0 ;
BEGIN SELECT COUNT(*) INTO v_usernum FROM PERSON,PERSONDYNAMIC
WHERE username = lower(p_userName) AND vtimes>0 AND PERSON.nid = PERSONDYNAMIC.nid; IF v_usernum = 1 THEN
v_validFlag := 0 ;
END IF; RETURN v_validFlag;
END; -- register userName
--return userID
--delete Bp, add sex, mobilenum, homepage
FUNCTION register(
p_userName IN VARCHAR2,
p_cname IN VARCHAR2,
p_nickname IN VARCHAR2, p_birthday IN PERSON.Birthday%TYPE,
p_sex IN PERSON.Sex%TYPE,
p_company IN VARCHAR2,
p_address IN VARCHAR2,
p_tele IN VARCHAR2, p_mobileCode IN VARCHAR2,
p_email IN VARCHAR2,
p_icq IN VARCHAR2,
p_homePage IN VARCHAR2,
p_iconURL IN VARCHAR2,
p_info IN VARCHAR2, p_passwd IN VARCHAR2,
p_question IN VARCHAR2,
p_answer IN VARCHAR2, p_secrecy IN PERSON.Secrecy%TYPE --p_userip IN VARCHAR2 )
RETURN NUMBER
上面是我的存储过程
我要怎么写jdbc调用它
解决方案 »
- Could not find action or result报错?
- 在给学校做一个人事管理系统,人事处那边要求能自定义字段,求问如何解决?
- 求助,当页面提交后点返回按钮提示页面过期。
- ireport 编译报表后为什么无法读取数据库内容
- 不同数据库,取得table的第m条到第n条记录(n〉m)的高效sql语句
- jsp自定义标记问题, 找不到处理标记类?????
- ssh中进行分页的问题
- 求救!
- 用jsp怎么实现这种QQ (http://www1.mocoto.com/iiqq)
- 关于程序月份+N的问题
- 在用邮件发送附件的时候,如何在页面上上传多个附件并发送?
- 有没有能够格式化JSP代码的软件呢??
楼主截止到2008-06-18 17:06:40的汇总数据:
发帖数:3
结贴数:2
结贴率:66.67%
楼主加油