[数据库]简单存储过程

create or replace PROCEDURE "USERINFO_INSERT" (P_k_User IN VARCHAR2, P_UserName IN VARCHAR2, P_Password IN VARCHAR2) AS BEGIN

   INSERT INTO UserInfo (k_User, UserName, Password) VALUES (P_k_User, P_UserName, P_Password);

END UserInfo_INSERT;

 

create or replace PROCEDURE "USERINFO_UPDATE" (P_k_User IN VARCHAR2, P_UserName IN VARCHAR2, P_Password IN VARCHAR2)  AS BEGIN

   UPDATE UserInfo    SET k_User = P_k_User, UserName = P_UserName,  Password = P_Password    WHERE k_User = P_k_User;

END UserInfo_UPDATE;

 

create or replace PROCEDURE "USERINFO_DELETE" (P_k_User IN VARCHAR2) AS BEGIN

   DELETE FROM UserInfo    WHERE k_User = P_k_User;

END UserInfo_DELETE;