note.sql

来自「MVC留言」· SQL 代码 · 共 44 行

create table USERS (
USERID varchar2(10),
USERNAME varchar2(30),
PASSWORD varchar2(15),
constraint PK_USERID primary key (USERID)
)
/
insert into users values('U001','bob','bbbbbb');
insert into users values('U002','tom','tttttt');
/
create table NOTE(
NOTEID number(15),
USERID varchar2(10),
TITLE varchar2(30),
NOTE varchar2(2000),
constraint PK_NOTEID primary key (NOTEID),
constraint FK_UID foreign key (USERID) references USERS(USERID)
)
/
insert into NOTE values(1,'U001','中文乱码','jsp中如何有效的处理乱码');
/
create or replace procedure pro_note(
p_noteid varchar,
p_userid varchar2,
p_title varchar2,
p_note varchar2,
p_model varchar2)
as
begin
 if(p_model='save') then
 begin
   insert into note values(to_char(sysdate,'yymmddhhmiss'),p_userid,p_title,p_note);
 end if;
 
 if(p_model='modify') then
 begin
   update note set title=p_title,note=p_note where noteid=p_noteid;
 end if;
 
 if(p_model-'remove') then
 begin
    delete note where noteid=p_noteid;
 end if;
end;