자바 – Lecture Note

전화번호부 관리 프로그램(HashTable사용)

프로젝트 생성 : File -> New -> Java Project Class 생성 : scr 폴더에서 마우스 오른쪽 버튼 클릭 -> New -> Class 생성된 클래스들 PhoneDTO.java 수정

package kr.ac.jj.ai_phone;

public class PhoneDTO {
	int _id;
	String name = "";
	String hp = "";
	int group = 0;


	public void myprint() {
		System.out.printf("%d %s %s %d",
				this._id, this.name, this.hp, this.group);
	}
}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

package kr.ac.jj.ai_phone;

public class PhoneDTO {

int _id;

String name = "";

String hp = "";

int group = 0;

public void myprint() {

System.out.printf("%d %s %s %d",

this._id, this.name, this.hp, this.group);

}

PhoneUI.java 수정 : UI 생성

package kr.ac.jj.ai_phone;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JTextField;

public class PhoneUI extends JFrame{
	JTextField tfId;
	JTextField tfName;
	JTextField tfHp;
	JTextField tfGroup;

	public PhoneUI() {
		this.setSize(800, 600);
		this.setLayout(null);

		this.tfName = new JTextField();
		this.tfName.setBounds(10, 10, 100, 25);
		this.add(tfName);

		this.tfHp = new JTextField();
		this.tfHp.setBounds(10, 50, 100, 25);
		this.add(tfHp);

		this.tfGroup = new JTextField();
		this.tfGroup.setBounds(10, 90, 100, 25);
		this.add(tfGroup);

		JButton btnSave = new JButton("저장");
		btnSave.setBounds(10, 300, 100, 25);
		this.add(btnSave);

		JButton btnDelete = new JButton("삭제");
		btnDelete.setBounds(10, 350, 100, 25);
		this.add(btnDelete);

		JButton btnUpdate = new JButton("수정");
		btnUpdate.setBounds(10, 400, 100, 25);
		this.add(btnUpdate);

		this.setVisible(true);
	}
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		new PhoneUI();
	}
}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

package kr.ac.jj.ai_phone;

import javax.swing.JButton;

import javax.swing.JFrame;

import javax.swing.JTextField;

public class PhoneUI extends JFrame{

JTextField tfId;

JTextField tfName;

JTextField tfHp;

JTextField tfGroup;

public PhoneUI() {

this.setSize(800, 600);

this.setLayout(null);

this.tfName = new JTextField();

this.tfName.setBounds(10, 10, 100, 25);

this.add(tfName);

this.tfHp = new JTextField();

this.tfHp.setBounds(10, 50, 100, 25);

this.add(tfHp);

this.tfGroup = new JTextField();

this.tfGroup.setBounds(10, 90, 100, 25);

this.add(tfGroup);

JButton btnSave = new JButton("저장");

btnSave.setBounds(10, 300, 100, 25);

this.add(btnSave);

JButton btnDelete = new JButton("삭제");

btnDelete.setBounds(10, 350, 100, 25);

this.add(btnDelete);

JButton btnUpdate = new JButton("수정");

btnUpdate.setBounds(10, 400, 100, 25);

this.add(btnUpdate);

this.setVisible(true);

}

public static void main(String[] args) {

// TODO Auto-generated method stub

new PhoneUI();

}

PhoneUI.java 수정 : ActionListener 추가

package kr.ac.jj.ai_phone;

import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JTextField;

public class PhoneUI extends JFrame implements ActionListener{
	JTextField tfId;
	JTextField tfName;
	JTextField tfHp;
	JTextField tfGroup;

	public PhoneUI() {
		this.setSize(800, 600);
		this.setLayout(null);

		this.tfName = new JTextField();
		this.tfName.setBounds(10, 10, 100, 25);
		this.add(tfName);

		this.tfHp = new JTextField();
		this.tfHp.setBounds(10, 50, 100, 25);
		this.add(tfHp);

		this.tfGroup = new JTextField();
		this.tfGroup.setBounds(10, 90, 100, 25);
		this.add(tfGroup);

		JButton btnSave = new JButton("저장");
		btnSave.setBounds(10, 300, 100, 25);
		this.add(btnSave);
		btnSave.addActionListener(this);

		JButton btnDelete = new JButton("삭제");
		btnDelete.setBounds(10, 350, 100, 25);
		this.add(btnDelete);
		btnDelete.addActionListener(this);

		JButton btnUpdate = new JButton("수정");
		btnUpdate.setBounds(10, 400, 100, 25);
		this.add(btnUpdate);
		btnUpdate.addActionListener(this);

		this.setVisible(true);
	}

	public static void main(String[] args) {
		// TODO Auto-generated method stub
		new PhoneUI();
	}

	@Override
	public void actionPerformed(ActionEvent e) {
		// TODO Auto-generated method stub
		PhoneDTO dto;
		PhoneDAO dao;

		switch(e.getActionCommand()) {
		case "저장":
			dto = new PhoneDTO();
			//dto._id = Integer.parseInt( tfId.getText() );
			dto.name = tfName.getText();
			dto.hp = tfHp.getText();
			dto.group = Integer.parseInt( tfGroup.getText());

			dto.myprint();

			break;
		case "삭제":
			System.out.println("삭제 클릭");
			break;
		case "수정":
			System.out.println("수정 클릭");
			break;
		}
	}

}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

package kr.ac.jj.ai_phone;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import javax.swing.JButton;

import javax.swing.JFrame;

import javax.swing.JTextField;

public class PhoneUI extends JFrame implements ActionListener{

JTextField tfId;

JTextField tfName;

JTextField tfHp;

JTextField tfGroup;

public PhoneUI() {

this.setSize(800, 600);

this.setLayout(null);

this.tfName = new JTextField();

this.tfName.setBounds(10, 10, 100, 25);

this.add(tfName);

this.tfHp = new JTextField();

this.tfHp.setBounds(10, 50, 100, 25);

this.add(tfHp);

this.tfGroup = new JTextField();

this.tfGroup.setBounds(10, 90, 100, 25);

this.add(tfGroup);

JButton btnSave = new JButton("저장");

btnSave.setBounds(10, 300, 100, 25);

this.add(btnSave);

btnSave.addActionListener(this);

JButton btnDelete = new JButton("삭제");

btnDelete.setBounds(10, 350, 100, 25);

this.add(btnDelete);

btnDelete.addActionListener(this);

JButton btnUpdate = new JButton("수정");

btnUpdate.setBounds(10, 400, 100, 25);

this.add(btnUpdate);

btnUpdate.addActionListener(this);

this.setVisible(true);

}

public static void main(String[] args) {

// TODO Auto-generated method stub

new PhoneUI();

}

@Override

public void actionPerformed(ActionEvent e) {

// TODO Auto-generated method stub

PhoneDTO dto;

PhoneDAO dao;

switch(e.getActionCommand()) {

case "저장":

dto = new PhoneDTO();

//dto._id = Integer.parseInt( tfId.getText() );

dto.name = tfName.getText();

dto.hp = tfHp.getText();

dto.group = Integer.parseInt( tfGroup.getText());

dto.myprint();

break;

case "삭제":

System.out.println("삭제 클릭");

break;

case "수정":

System.out.println("수정 클릭");

break;

}

삽입 기능 추가 : PhoneDAO 수정

package kr.ac.jj.ai_phone;

import java.util.Enumeration;
import java.util.Hashtable;

public class PhoneDAO {
	Hashtable<Integer, PhoneDTO> hash;

	public PhoneDAO() {}

	public PhoneDAO(Hashtable<Integer, PhoneDTO> hash) {
		this.hash = hash;
	}

	public void insert(PhoneDTO dto) {
		int newid = 10001;

		Enumeration<Integer> enumer = hash.keys();
		while (enumer.hasMoreElements()) {
			int no = hash.get(enumer.nextElement())._id;
			if(no >= newid) {
				newid = no + 1;
			}
		}

		dto._id = newid;

		hash.put(newid, dto);
	}

	public void update(PhoneDTO dto) {
		PhoneDTO d = this.hash.get(dto._id);
		d.name = dto.name;
		d.hp = dto.hp;
		d.group = dto.group;
		//....
	}

	public void delete(int _id) {
		this.hash.remove(_id);
	}

	public PhoneDTO getOne(int _id) {
		return this.hash.get(_id);
	}

	public Object[] getTableHeader() {
		Object [] cols = {"_id", "이름", "전화번호", "그룹"};
		return cols;
	}

	public Object[][] getListVector(){
		Object[][] data = new Object[hash.size()][];

		Enumeration<Integer> enumer = hash.keys();
		int i=0;
		while (enumer.hasMoreElements()) {
			int key = enumer.nextElement();
			data[i] = new Object[4];
			data[i][0] = hash.get(key)._id + "";
			data[i][1] = hash.get(key).name;
			data[i][2] = hash.get(key).hp;
			data[i][3] = hash.get(key).group + "";
			i++;
		}
		return data;
	}
}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

package kr.ac.jj.ai_phone;

import java.util.Enumeration;

import java.util.Hashtable;

public class PhoneDAO {

Hashtable<Integer, PhoneDTO> hash;

public PhoneDAO() {}

public PhoneDAO(Hashtable<Integer, PhoneDTO> hash) {

this.hash = hash;

}

public void insert(PhoneDTO dto) {

int newid = 10001;

Enumeration<Integer> enumer = hash.keys();

while (enumer.hasMoreElements()) {

int no = hash.get(enumer.nextElement())._id;

if(no >= newid) {

newid = no + 1;

}

dto._id = newid;

hash.put(newid, dto);

}

public void update(PhoneDTO dto) {

PhoneDTO d = this.hash.get(dto._id);

d.name = dto.name;

d.hp = dto.hp;

d.group = dto.group;

//....

}

public void delete(int _id) {

this.hash.remove(_id);

}

public PhoneDTO getOne(int _id) {

return this.hash.get(_id);

}

public Object[] getTableHeader() {

Object [] cols = {"_id", "이름", "전화번호", "그룹"};

return cols;

}

public Object[][] getListVector(){

Object[][] data = new Object[hash.size()][];

Enumeration<Integer> enumer = hash.keys();

int i=0;

while (enumer.hasMoreElements()) {

int key = enumer.nextElement();

data[i] = new Object[4];

data[i][0] = hash.get(key)._id + "";

data[i][1] = hash.get(key).name;

data[i][2] = hash.get(key).hp;

data[i][3] = hash.get(key).group + "";

i++;

}

return data;

}

삽입 기능 추가 :… Continue Reading 전화번호부 관리 프로그램(HashTable사용)

참조 https://elfinlas.github.io/2017/12/14/java-annotation/ https://medium.com/@aaaalpooo/%EB%A7%8E%EC%9D%B4-%EC%93%B0%EB%8A%94-spring-framework-annotation-%EC%A0%95%EB%A6%AC-summary-of-annotations-frequently-used-in-spring-framework-935e1c1a4877 어노테이션(Annotation) 주석이라는 사전적 의미 컴파일 혹은 런타임에 해석 메타데이터라고도 불림 자바 기본 어노테이션 @Override 선언된 메서드가 오버라이드 되었음 부코 클래스(또는 인터페이스)에서 해당 메서드를 못찾으면 컴파일 에러 발생 @Deprecated 해당 메서드가 곧 없어짐을 표시 만약 사용할 경우 컴파일 경고를 발생 @SuppressWarnings 선언한 곳의 컴파일 경고를 무시하도록 함 @SafeVarargs… Continue Reading 자바 어노테이션(Java Annotation) 종류

자바로 쇼핑몰 구현하기

참조 SQL(Structured Query Language) : 내가 정리한 것 최종 실행파일 : [추후 공지]을 압축해지 한 후 a.bat 파일을 더블클릭하면 실행됨 상품테이블(tshop) : db파일명은 myshop.db 회원테이블(tmember) : 주문테이블(torder) : 외래키(foreign key)를 2개 사용해서 생성해야 함 MyConst.java

package kr.co.moak.summer2020;

public class MyConst {
	//Sqlite 설정
	public static String DB = System.getProperty("user.dir") + "\\myshop.db";

	//MySql 설정
	public static final String DRIVER = "com.mysql.cj.jdbc.Driver"; //8.0.11버전
	public static final String URL = "jdbc:mysql://ora.jj.ac.kr:3306/XXXXXX?serverTimezone=UTC";//8.0.11버전
	public static final String USER = "XXXXXX"; // DB ID
	public static final String PASS = "XXXXXX"; // DB 암호
}

1

2

3

4

5

6

7

8

9

10

11

12

package kr.co.moak.summer2020;

public class MyConst {

//Sqlite 설정

public static String DB = System.getProperty("user.dir") + "\\myshop.db";

//MySql 설정

public static final String DRIVER = "com.mysql.cj.jdbc.Driver"; //8.0.11버전

public static final String URL = "jdbc:mysql://ora.jj.ac.kr:3306/XXXXXX?serverTimezone=UTC";//8.0.11버전

public static final String USER = "XXXXXX"; // DB ID

public static final String PASS = "XXXXXX"; // DB 암호

}

GoodsDTO.java GoodsDAO.java GoodsUI.java MemberDTO.java MemberDAO.java MemberUI.java OrderDTO.java OrderDAO.java OrderUI.java MainUI.java

[자바] 도서관리 #6 도서관리 데이터베이스 설계 및 구현(2020년 MySql)

참조 SQL(Structured Query Language) : 내가 정리한 것 최종 실행파일 : Summber20200614.zip을 압축해지 한 후 a.bat 파일을 더블클릭하면 실행됨 학과테이블(tdept)

CREATE TABLE tdept (
	dept_no	INTEGER,
	dept_name	VARCHAR(50),
	dept_tel	VARCHAR(50),
	dept_room	VARCHAR(50),
	PRIMARY KEY(dept_no)
);

INSERT INTO tdept (dept_no,dept_name,dept_tel,dept_room) VALUES (14,'스마트미디어','2330','공학1관229호');
INSERT INTO tdept (dept_no,dept_name,dept_tel,dept_room) VALUES (19,'일본언어문화','2311','진리관107호');
INSERT INTO tdept (dept_no,dept_name,dept_tel,dept_room) VALUES (23,'게임콘텐츠','3181','예술관209호');
INSERT INTO tdept (dept_no,dept_name,dept_tel,dept_room) VALUES (25,'역사문화','2325','진리관107호');
INSERT INTO tdept (dept_no,dept_name,dept_tel,dept_room) VALUES (62,'사회복지','2426','평화관113호');
INSERT INTO tdept (dept_no,dept_name,dept_tel,dept_room) VALUES (70,'문헌정보','2235','평화관113호');

1

2

3

4

5

6

7

8

9

10

11

12

13

14

CREATE TABLE tdept (

dept_no INTEGER,

dept_name VARCHAR(50),

dept_tel VARCHAR(50),

dept_room VARCHAR(50),

PRIMARY KEY(dept_no)

);

INSERT INTO tdept (dept_no,dept_name,dept_tel,dept_room) VALUES (14,'스마트미디어','2330','공학1관229호');

INSERT INTO tdept (dept_no,dept_name,dept_tel,dept_room) VALUES (19,'일본언어문화','2311','진리관107호');

INSERT INTO tdept (dept_no,dept_name,dept_tel,dept_room) VALUES (23,'게임콘텐츠','3181','예술관209호');

INSERT INTO tdept (dept_no,dept_name,dept_tel,dept_room) VALUES (25,'역사문화','2325','진리관107호');

INSERT INTO tdept (dept_no,dept_name,dept_tel,dept_room) VALUES (62,'사회복지','2426','평화관113호');

INSERT INTO tdept (dept_no,dept_name,dept_tel,dept_room) VALUES (70,'문헌정보','2235','평화관113호');

도서테이블(tbook)

CREATE TABLE tbook (
	no	VARCHAR(10),
	title	VARCHAR(255),
	pric	INTEGER,
	publ	VARCHAR(50),
	typ	VARCHAR(20),
	pos	VARCHAR(10),
	PRIMARY KEY(no)
);

INSERT INTO tbook (no,title,pric,publ,typ,pos) VALUES ('201900001','자바',20000,'생능출판','기술과학', '3층');
INSERT INTO tbook (no,title,pric,publ,typ,pos) VALUES ('201900002','알고리즘',19000,'이지스퍼블릭','자연과학', '1층');
INSERT INTO tbook (no,title,pric,publ,typ,pos) VALUES ('201900003','데이터베이스',21000,'이한출판사','기술과학', '3층');
INSERT INTO tbook (no,title,pric,publ,typ,pos) VALUES ('201900004','정보검색',15000,'한빛미디어','자연과학', '2층');
INSERT INTO tbook (no,title,pric,publ,typ,pos) VALUES ('201900005','오라클',25000,'생능출판','기술과학', '1층');
INSERT INTO tbook (no,title,pric,publ,typ,pos) VALUES ('201900006','운영체제',20000,'이지스퍼블릭','기술과학', '2층');
INSERT INTO tbook (no,title,pric,publ,typ,pos) VALUES ('202000001','인공지능',30000,'길벗','기술과학','1층');
INSERT INTO tbook (no,title,pric,publ,typ,pos) VALUES ('202000004','정보검색',15000,'한빛미디어','자연과학','1층');
INSERT INTO tbook (no,title,pric,publ,typ,pos) VALUES ('202000007','운영체제',20000,'이지스퍼블릭','기술과학','1층');
INSERT INTO tbook (no,title,pric,publ,typ,pos) VALUES ('202000008','오라클',25000,'생능출판','기술과학','2층');

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

CREATE TABLE tbook (

no VARCHAR(10),

title VARCHAR(255),

pric INTEGER,

publ VARCHAR(50),

typ VARCHAR(20),

pos VARCHAR(10),

PRIMARY KEY(no)

);

INSERT INTO tbook (no,title,pric,publ,typ,pos) VALUES ('201900001','자바',20000,'생능출판','기술과학', '3층');

INSERT INTO tbook (no,title,pric,publ,typ,pos) VALUES ('201900002','알고리즘',19000,'이지스퍼블릭','자연과학', '1층');

INSERT INTO tbook (no,title,pric,publ,typ,pos) VALUES ('201900003','데이터베이스',21000,'이한출판사','기술과학', '3층');

INSERT INTO tbook (no,title,pric,publ,typ,pos) VALUES ('201900004','정보검색',15000,'한빛미디어','자연과학', '2층');

INSERT INTO tbook (no,title,pric,publ,typ,pos) VALUES ('201900005','오라클',25000,'생능출판','기술과학', '1층');

INSERT INTO tbook (no,title,pric,publ,typ,pos) VALUES ('201900006','운영체제',20000,'이지스퍼블릭','기술과학', '2층');

INSERT INTO tbook (no,title,pric,publ,typ,pos) VALUES ('202000001','인공지능',30000,'길벗','기술과학','1층');

INSERT INTO tbook (no,title,pric,publ,typ,pos) VALUES ('202000004','정보검색',15000,'한빛미디어','자연과학','1층');

INSERT INTO tbook (no,title,pric,publ,typ,pos) VALUES ('202000007','운영체제',20000,'이지스퍼블릭','기술과학','1층');

INSERT INTO tbook (no,title,pric,publ,typ,pos) VALUES ('202000008','오라클',25000,'생능출판','기술과학','2층');

회원테이블(tmember) : 학과를 학과테이블(tdept)와 외래키를 사용해서 연결

CREATE TABLE tmember (
	no	VARCHAR(10),
	name	VARCHAR(50),
	dept	INTEGER,
	major	VARCHAR(50),
	PRIMARY KEY(no),
	FOREIGN KEY(dept) REFERENCES tdept(dept_no)
		ON DELETE SET NULL
		ON UPDATE CASCADE
);

INSERT INTO tmember (no,name,dept,major) VALUES ('201912346','길동이',62,'2');
INSERT INTO tmember (no,name,dept,major) VALUES ('201912345','홍길동',19,'1');
INSERT INTO tmember (no,name,dept,major) VALUES ('10000','홍교수',70,'2');
INSERT INTO tmember (no,name,dept,major) VALUES ('202012345','박길동',14,'3');

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

CREATE TABLE tmember (

no VARCHAR(10),

name VARCHAR(50),

dept INTEGER,

major VARCHAR(50),

PRIMARY KEY(no),

FOREIGN KEY(dept) REFERENCES tdept(dept_no)

ON DELETE SET NULL

ON UPDATE CASCADE

);

INSERT INTO tmember (no,name,dept,major) VALUES ('201912346','길동이',62,'2');

INSERT INTO tmember (no,name,dept,major) VALUES ('201912345','홍길동',19,'1');

INSERT INTO tmember (no,name,dept,major) VALUES ('10000','홍교수',70,'2');

INSERT INTO tmember (no,name,dept,major) VALUES ('202012345','박길동',14,'3');

대출테이블(tlend) : 외래키(foreign key)를 사용해서 생성해야 함

CREATE TABLE tlend (
	no	VARCHAR(50),
	bno	VARCHAR(10),
	mno	VARCHAR(10),
	cdate	DATETIME DEFAULT NOW(),
	days	INTEGER DEFAULT 14,
	PRIMARY KEY(no),
	FOREIGN KEY(bno) REFERENCES tbook(no)
		ON DELETE SET NULL
		ON UPDATE CASCADE,
	FOREIGN KEY(mno) REFERENCES tmember(no)
		ON DELETE SET NULL
		ON UPDATE CASCADE
);

1

2

3

4

5

6

7

8

9

10

11

12

13

14

CREATE TABLE tlend (

no VARCHAR(50),

bno VARCHAR(10),

mno VARCHAR(10),

cdate DATETIME DEFAULT NOW(),

days INTEGER DEFAULT 14,

PRIMARY KEY(no),

FOREIGN KEY(bno) REFERENCES tbook(no)

ON DELETE SET NULL

ON UPDATE CASCADE,

FOREIGN KEY(mno) REFERENCES tmember(no)

ON DELETE SET NULL

ON UPDATE CASCADE

);

회원 뷰(vmember) : 회원정보와 학과정보를 조인

CREATE VIEW vmember AS
SELECT *
	FROM tmember, tdept
	WHERE tmember.dept = tdept.dept_no

1

2

3

4

CREATE VIEW vmember AS

SELECT *

FROM tmember, tdept

WHERE tmember.dept = tdept.dept_no

대출가능한 도서 뷰(vlendablebook)

CREATE VIEW vlendablebook AS
	SELECT * FROM tbook
	WHERE no NOT IN (SELECT bno FROM tlend);

1

2

3

CREATE VIEW vlendablebook AS

SELECT * FROM tbook

WHERE no NOT IN (SELECT bno FROM tlend);

회원-대출-도서… Continue Reading [자바] 도서관리 #6 도서관리 데이터베이스 설계 및 구현(2020년 MySql)

[자바] 도서관리 #6 도서관리 데이터베이스 설계 및 구현(2020년 Sqlite)

참조 SQL(Structured Query Language) : 내가 정리한 것 최종 실행파일 : Summber20200614.zip을 압축해지 한 후 a.bat 파일을 더블클릭하면 실행됨 학과테이블(tdept)

CREATE TABLE tdept (
	dept_no	INTEGER,
	dept_name	TEXT,
	dept_tel	TEXT,
	dept_room	TEXT,
	PRIMARY KEY(dept_no)
);

INSERT INTO tdept (dept_no,dept_name,dept_tel,dept_room) VALUES (14,'스마트미디어','2330','공학1관229호');
INSERT INTO tdept (dept_no,dept_name,dept_tel,dept_room) VALUES (19,'일본언어문화','2311','진리관107호');
INSERT INTO tdept (dept_no,dept_name,dept_tel,dept_room) VALUES (23,'게임콘텐츠','3181','예술관209호');
INSERT INTO tdept (dept_no,dept_name,dept_tel,dept_room) VALUES (25,'역사문화','2325','진리관107호');
INSERT INTO tdept (dept_no,dept_name,dept_tel,dept_room) VALUES (62,'사회복지','2426','평화관113호');
INSERT INTO tdept (dept_no,dept_name,dept_tel,dept_room) VALUES (70,'문헌정보','2235','평화관113호');

1

2

3

4

5

6

7

8

9

10

11

12

13

14

CREATE TABLE tdept (

dept_no INTEGER,

dept_name TEXT,

dept_tel TEXT,

dept_room TEXT,

PRIMARY KEY(dept_no)

);

INSERT INTO tdept (dept_no,dept_name,dept_tel,dept_room) VALUES (14,'스마트미디어','2330','공학1관229호');

INSERT INTO tdept (dept_no,dept_name,dept_tel,dept_room) VALUES (19,'일본언어문화','2311','진리관107호');

INSERT INTO tdept (dept_no,dept_name,dept_tel,dept_room) VALUES (23,'게임콘텐츠','3181','예술관209호');

INSERT INTO tdept (dept_no,dept_name,dept_tel,dept_room) VALUES (25,'역사문화','2325','진리관107호');

INSERT INTO tdept (dept_no,dept_name,dept_tel,dept_room) VALUES (62,'사회복지','2426','평화관113호');

INSERT INTO tdept (dept_no,dept_name,dept_tel,dept_room) VALUES (70,'문헌정보','2235','평화관113호');

도서테이블(tbook)

CREATE TABLE tbook (
	no	TEXT,
	title	TEXT,
	pric	INTEGER,
	publ	TEXT,
	typ	TEXT,
	pos	TEXT,
	PRIMARY KEY(no)
);

INSERT INTO tbook (no,title,pric,publ,typ,pos) VALUES ('201900001','자바',20000,'생능출판','기술과학', '3층');
INSERT INTO tbook (no,title,pric,publ,typ,pos) VALUES ('201900002','알고리즘',19000,'이지스퍼블릭','자연과학', '1층');
INSERT INTO tbook (no,title,pric,publ,typ,pos) VALUES ('201900003','데이터베이스',21000,'이한출판사','기술과학', '3층');
INSERT INTO tbook (no,title,pric,publ,typ,pos) VALUES ('201900004','정보검색',15000,'한빛미디어','자연과학', '2층');
INSERT INTO tbook (no,title,pric,publ,typ,pos) VALUES ('201900005','오라클',25000,'생능출판','기술과학', '1층');
INSERT INTO tbook (no,title,pric,publ,typ,pos) VALUES ('201900006','운영체제',20000,'이지스퍼블릭','기술과학', '2층');
INSERT INTO tbook (no,title,pric,publ,typ,pos) VALUES ('202000001','인공지능',30000,'길벗','기술과학','1층');
INSERT INTO tbook (no,title,pric,publ,typ,pos) VALUES ('202000004','정보검색',15000,'한빛미디어','자연과학','1층');
INSERT INTO tbook (no,title,pric,publ,typ,pos) VALUES ('202000007','운영체제',20000,'이지스퍼블릭','기술과학','1층');
INSERT INTO tbook (no,title,pric,publ,typ,pos) VALUES ('202000008','오라클',25000,'생능출판','기술과학','2층');

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

CREATE TABLE tbook (

no TEXT,

title TEXT,

pric INTEGER,

publ TEXT,

typ TEXT,

pos TEXT,