회원가입, 수정 탈퇴, 게시판까지

Project.zip

프로시져 추가

CREATE PROCEDURE `test`.`deleteMember`(

IN v_userid VARCHAR(12)

)

BEGIN

DELETE FROM Member

    WHERE userid = v_userid;

END

프로시져 추가

CREATE PROCEDURE updateMember

(IN v_userid VARCHAR(12),

IN v_zipcode CHAR(7),

IN v_address VARCHAR(200),

IN v_email VARCHAR(50))

BEGIN

UPDATE Member

    SET zipcode=v_zipcode, address=v_address, email=v_email

    WHERE userid=v_userid;

END

프로시져 추가

CREATE PROCEDURE `test`.`getMember`(IN v_userid VARCHAR(12))

BEGIN

SELECT userid, passwd, name, zipcode,address,email

    FROM Member

    WHERE userid=v_userid;

END

프로시져 추가

CREATE PROCEDURE glist()

BEGIN 

SELECT num,name,email,title,contents

    FROM GuestBook

    ORDER BY num DESC; 

END

프로시져 추가

CREATE PROCEDURE boardInsert

(

IN v_name VARCHAR(20),

    IN v_email VARCHAR(20),

    IN v_title VARCHAR(50),

    IN v_contents TEXT

)

BEGIN

INSERT INTO GuestBook(name,email,title,contents)

    VALUES(v_name,v_email,v_title,v_contents);

END

프로시져 추가

CREATE PROCEDURE selectBoard

(

IN v_num INTEGER(11)

    

)

BEGIN

SELECT name, email, title, contents

    FROM GuestBook

    WHERE num = v_num;

END

DB의 테이블 추가했던것.

CREATE TABLE `Member` (

  `userid` varchar(12) NOT NULL,

  `passwd` varchar(12) NOT NULL,

  `name` varchar(20) NOT NULL,

  `zipcode` char(7) DEFAULT NULL,

  `address` varchar(200) DEFAULT NULL,

  `email` varchar(50) NOT NULL,

  PRIMARY KEY (`userid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

---

CREATE TABLE `Student` (

  `hakbun` char(4) NOT NULL,

  `irum` varchar(20) NOT NULL,

  `eng` int(11) NOT NULL,

  `kor` int(11) NOT NULL,

  `mat` int(11) NOT NULL,

  `edp` int(11) NOT NULL,

  `avg` double DEFAULT NULL,

  `tot` int(11) DEFAULT NULL,

  `grade` char(1) DEFAULT NULL,

  PRIMARY KEY (`hakbun`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

---- 그리고 zipcode까지.