56,677
社区成员
发帖
与我相关
我的任务
分享
CREATE DEFINER=`root`@`localhost` PROCEDURE `forum_register`(
in email varchar(30),
in password varchar(16),
in userName char(8),
in qq char(10),
in securityQuestion1 varchar(40),
in securityQuestion2 varchar(40),
in securityAnswer1 varchar(40),
in securityAnswer2 varchar(40),
in headPicture blob,
in registerTime datetime,
in participatedTopicsCount int,
in createdTopicsCount int,
in managingSectionID smallint,
in currentUploadSize float,
in state char(1)
)
begin
insert into forum_users(
用户名,
邮箱,
参与主题数,
发起主题数,
密码,
QQ,
头像,
注册时间,
密保问题1,
密保答案1,
密保问题2,
密保答案2,
管理版块ID,
当前上传容量,
状态
)
values(
userName,
email ,
participatedTopicsCount ,
createdTopicsCount,
password,
qq,
headPicture ,
registerTime,
securityQuestion1,
securityAnswer1 ,
securityQuestion2 ,
securityAnswer2,
managingSectionID,
currentUploadSize,
state
);
SELECT LAST_INSERT_ID();
end
callableStatement=con.prepareCall(cmdstr);
callableStatement.executeQuery();
call forum_register('1','2','3','463127310','1','1','2','2',null,'2009-010-05 15:25:00',0,0,null,1024,'0');
mysql> set names 'gb2312';
Query OK, 0 rows affected (0.06 sec)
mysql> delimiter //
mysql> CREATE PROCEDURE `forum_register`(
-> in email varchar(30),
-> in password varchar(16),
-> in userName char(8),
-> in qq char(10),
-> in securityQuestion1 varchar(40),
-> in securityQuestion2 varchar(40),
-> in securityAnswer1 varchar(40),
-> in securityAnswer2 varchar(40),
-> in headPicture blob,
-> in registerTime datetime,
-> in participatedTopicsCount int,
-> in createdTopicsCount int,
-> in managingSectionID smallint,
-> in currentUploadSize float,
-> in state char(1)
-> )
-> begin
-> insert into forum_users(
-> 用户名,
-> 邮箱,
-> 参与主题数,
-> 发起主题数,
-> 密码,
-> QQ,
-> 头像,
-> 注册时间,
-> 密保问题1,
-> 密保答案1,
-> 密保问题2,
-> 密保答案2,
-> 管理版块ID,
-> 当前上传容量,
-> 状态
->
->
-> )
-> values(
-> userName,
-> email ,
-> participatedTopicsCount ,
-> createdTopicsCount,
-> password,
-> qq,
-> headPicture ,
-> registerTime,
-> securityQuestion1,
-> securityAnswer1 ,
-> securityQuestion2 ,
-> securityAnswer2,
-> managingSectionID,
-> currentUploadSize,
-> state
-> );
-> SELECT LAST_INSERT_ID();
-> end
-> //
Query OK, 0 rows affected (0.34 sec)
mysql> delimiter ;
mysql>
delimiter //
CREATE DEFINER=`root`@`localhost` PROCEDURE `forum_register`(
in email varchar(30),
in password varchar(16),
in userName char(8),
in qq char(10),
in securityQuestion1 varchar(40),
in securityQuestion2 varchar(40),
in securityAnswer1 varchar(40),
in securityAnswer2 varchar(40),
in headPicture blob,
in registerTime datetime,
in participatedTopicsCount int,
in createdTopicsCount int,
in managingSectionID smallint,
in currentUploadSize float,
in state char(1)
)
begin
insert into forum_users(
用户名,
邮箱,
参与主题数,
发起主题数,
密码,
QQ,
头像,
注册时间,
密保问题1,
密保答案1,
密保问题2,
密保答案2,
管理版块ID,
当前上传容量,
状态
) values(
userName,
email ,
participatedTopicsCount ,
createdTopicsCount,
password,
qq,
headPicture ,
registerTime,
securityQuestion1,
securityAnswer1 ,
securityQuestion2 ,
securityAnswer2,
managingSectionID,
currentUploadSize,
state
);
SELECT LAST_INSERT_ID();
end
//