table.sql--사원관리create table semployee(num number primary key,id varchar2(12) unique not null,name varchar2(30) not null,passwd varchar2(12) not null,salary number(8) not null,job varchar2(30) not null,reg_date date default sysdate not null);create sequence semployee_seq;--사원게시판create table story(snum number not null, --프라이머리 키title varchar2(150) not null,content clob not null,ip varchar2(30) not..
table.sqlcreate table semployee(num number primary key,id varchar2(12) unique not null,name varchar2(30) not null,passwd varchar2(12) not null,salary number(8) not null,job varchar2(30) not null,reg_date date default sysdate not null);create sequence semployee_seq;kr.employee.vo => 패키지EmployeeVO.javapackage kr.employee.vo;import java.sql.Date;public class EmployeeVO { //프로퍼티 private int num; pri..
table.sqlcreate table mboard(num number not null,title varchar2(150) not null,name varchar2(30) not null,passwd varchar2(12) not null,content clob not null,ip varchar2(30) not null,reg_date date default sysdate not null,constraint mboard_pk primary key (num));create sequence mboard_seq;kr.board.vo ->package BoardVOpackage kr.board.vo;import java.sql.Date;public class BoardVO { //프로퍼티 private in..
table.sql create table smember(num number not null,id varchar2(12) unique not null,name varchar2(30) not null,passwd varchar2(12) not null,email varchar2(50) not null,phone varchar2(15),reg_date date default sysdate not null,constraint smember_pk primary key (num));create sequence smember_seq;main.jsp 회원관리 메인 회원가입 로그인 MyPage [님 로그인 중] 로그아웃 kr.member.vo(폴더) MemberVO.java -> 이클립스가 이름을 인..