yeony._.
๐Ÿข์ฝฉ๋ถ€๐Ÿข
yeony._.
์ „์ฒด ๋ฐฉ๋ฌธ์ž
์˜ค๋Š˜
์–ด์ œ
  • ๋ถ„๋ฅ˜ ์ „์ฒด๋ณด๊ธฐ (99)
    • ๐Ÿ’ปProgramming (91)
      • โ˜•๏ธJava (19)
      • ๐Ÿ’ฝOracle (21)
      • ๐Ÿ‘ฉ‍๐ŸŽจHTML&CSS (12)
      • ๐ŸŽจ ์‹ค์Šต (4)
      • ๐Ÿƒ‍โ™€๏ธJavaScript (25)
      • JSP (8)
      • ๐ŸƒSpring (0)
      • ๐Ÿฅงpython (0)
      • API (0)
      • ๐Ÿ˜ˆGit (1)
    • ๐ŸคซPrivate (0)
      • -- (0)
      • + (0)
      • S (0)
      • P (0)
      • B (0)
    • ๐Ÿ˜ŽProject (4)
      • ๐Ÿ—“๏ธwbs ํ”„๋กœ์ ํŠธ (3)

๋ธ”๋กœ๊ทธ ๋ฉ”๋‰ด

  • ํ™ˆ
  • ํƒœ๊ทธ
  • ๋ฐฉ๋ช…๋ก

๊ณต์ง€์‚ฌํ•ญ

์ธ๊ธฐ ๊ธ€

ํƒœ๊ทธ

  • HTML #CSS #HTML์ด๋ฏธ์ง€ #HTML์ด๋ฏธ์ง€์—๊ธ€์”จ #HTML์ด๋ฏธ์ง€์—์ด๋ฏธ์ง€

์ตœ๊ทผ ๋Œ“๊ธ€

์ตœ๊ทผ ๊ธ€

ํ‹ฐ์Šคํ† ๋ฆฌ

hELLO ยท Designed By ์ •์ƒ์šฐ.
yeony._.

๐Ÿข์ฝฉ๋ถ€๐Ÿข

Statement
๐Ÿ’ปProgramming/โ˜•๏ธJava

Statement

2022. 8. 19. 11:42
SQLDeveloper์—์„œ ์ƒ์„ฑํ•œ ํ…Œ์ด๋ธ”์— ์ดํด๋ฆฝ์Šค์—์„œ ๋ฐ์ดํ„ฐ๋ฅผ ์ถ”๊ฐ€ํ•˜๊ณ  ํ™•์ธํ•ด๋ณด๊ธฐ

Statement ์ธํ„ฐํŽ˜์ด์Šค 

์ •์ ์ธ SQL๋ฌธ์„ ์‹คํ–‰ํ•˜์—ฌ ์ž‘์„ฑ๋œ ๊ฒฐ๊ณผ๋ฅผ ๋Œ๋ ค์ฃผ๋Š” ๊ฐ์ฒด

Statement ๊ฐ์ฒด๋Š” Connection์˜ createStatement() ๋ฉ”์†Œ๋“œ๋ฅผ ํ˜ธ์ถœํ•˜์—ฌ ์–ป์Œ. 

๋‚˜์ค‘์— ์‚ฌ์šฉ ์•ˆ ํ•จ 

 

์˜ค๋ผํด์„ ์‚ฌ์šฉํ•˜๋Š” ๊ฒฝ์šฐ Statement๋ฅผ ์ด์šฉํ•œ JDBC ํ”„๋กœ๊ทธ๋žจ ์ž‘์„ฑ ์ˆœ์„œ 

1) JDBC ๋“œ๋ผ์ด๋ฒ„ ๋กœ๋”ฉ

์˜ค๋ผํด ์„œ๋ฒ„๋ฅผ ์ ‘์†ํ•  ์ˆ˜ ์žˆ๋„๋ก ๋“œ๋ผ์ด๋ฒ„ ๋กœ๋”ฉ 

Class.forName("oracle.jdbc.driver.OracleDriver");

 

2) Connection ๊ฐ์ฒด ์ƒ์„ฑ

conn = DriverManager.getConnection(url, user, pwd);

์‰ฝ๊ฒŒ ๋งํ•ด ์นด์นด์˜คํ†ก์—์„œ์˜ ๋กœ๊ทธ์ธ

์˜ค๋ผํด์˜ IP์ฃผ์†Œ, ํฌํŠธ๋ฒˆํ˜ธ, SID, ์˜ค๋ผํด ๊ณ„์ • ๋น„๋ฐ€๋ฒˆํ˜ธ 

 

3) Connection์˜ createStatement() ๋ฉ”์†Œ๋“œ๋ฅผ ํ˜ธ์ถœํ•˜์—ฌ ์ฟผ๋ฆฌ๋ฅผ ์‹คํ–‰ํ•  Statement ๊ฐ์ฒด๋ฅผ ์–ป์Œ

Statement stmt = conn.createStatement();

 

1. SQLDeveloper ์—์„œ ํ…Œ์ด๋ธ” ์ƒ์„ฑ

CREATE TABLE SCORE(
    hak VARCHAR2(30) PRIMARY KEY,
    name  VARCHAR2(30) NOT NULL,
    birth DATE NOT NULL,
    kor NUMBER(3)  NOT NULL,
    eng NUMBER(3) NOT NULL,
    mat NUMBER(3) NOT NULL
);
DESC ํ…Œ์ด๋ธ”๋ช…;

ํ…Œ์ด๋ธ”์ด ์ž˜ ์ƒ์„ฑ๋œ ๊ฒƒ์„ ํ™•์ธํ•  ์ˆ˜ ์žˆ๋‹ค. 

 

2. ์ž๋ฐ” ์ฝ”๋“œ ์ž‘์„ฑ 

์ฃผ์˜์‚ฌํ•ญ ์˜ค๋ผํด์—์„œ๋Š”  ' ' ๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ ๋ฌธ์ž๋‚˜ ์ˆซ์ž

package db.ch2;

import java.sql.Connection;
import java.sql.Statement;
import db.util.DBConn;

public class Ex01 {
	public static void main(String[] args) {
		Connection conn = DBConn.getConnection();
		Statement stmt = null;
		String sql;
		int result;

		try {
			stmt = conn.createStatement();

			// INSERT INTO ํ…Œ์ด๋ธ”๋ช…(์ปฌ๋Ÿผ, ์ปฌ๋Ÿผ) VALUES (๊ฐ’, ๊ฐ’)
			sql = "INSERT INTO score(hak, name, birth, kor, eng, mat) VALUES ("
					+ " '1001', 'ํ™๊ธธ๋™', '2002-10-10', 80, 90, 95)";

			result = stmt.executeUpdate(sql);

			System.out.println(result + "ํ–‰์ด ์ถ”๊ฐ€๋˜์—ˆ์Šต๋‹ˆ๋‹ค");

		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			if (stmt != null) {
				try {
					stmt.close();

				} catch (Exception e2) {
				}
			}

		}

	}
}

 

package db.ch2;

import java.sql.Connection;

public class Ex02 {
	public static void main(String[] args) {
		Connection conn = DBConn.getConnection();
		String sql;
		int result;

		// try~ with ~resource๋ฅผ ์ด์šฉํ•œ ๋ฆฌ์†Œ์Šค ์ž๋™ close 
		try (Statement stmt = conn.createStatement()) {
			// INSERT INTO ํ…Œ์ด๋ธ”๋ช…(์ปฌ๋Ÿผ, ์ปฌ๋Ÿผ) VALUES (๊ฐ’, ๊ฐ’)
			sql = "INSERT INTO score(hak, name, birth, kor, eng, mat) VALUES ("
					+ " '2001', '๋„ˆ์ž๋ฐ”', '2002-10-11', 100, 90, 95)";

			result = stmt.executeUpdate(sql);

			System.out.println(result + "ํ–‰์ด ์ถ”๊ฐ€๋˜์—ˆ์Šต๋‹ˆ๋‹ค");

		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			DBConn.close();
		}
	}
}

 

- executeUpdate()

DML(INSERT, UPDATE, DELETE), ๋ชจ๋“  DDL(CREATE, ALTER, DROP)๋ฅผ ์‹คํ–‰ 

์ฆ‰, SELECT ๋ฌธ์„ ์ œ์™ธํ•œ ๋‚˜๋จธ์ง€ ์ฟผ๋ฆฌ๋ฅผ ์‹คํ–‰ํ•œ๋‹ค. 

DML์€ ๋ณ€๊ฒฝ ํ–‰์ˆ˜๋ฅผ ๋ฐ˜ํ™˜ํ•˜๊ณ  DDL์€ 0์„ ๋ฐ˜ํ™˜

์ž๋ฐ”์—์„œ๋Š” INSERT, UPDATE, DELET๋“ฑ์˜ ๋ช…ใ…‡๋ น์„ ์ƒํ–‰ํ•˜๋ฉด ๊ธฐ๋ณธ์ ์œผ๋กœ ์ž๋™ ์ปค๋ฐ‹

 

์ž๋ฐ” ์ฝ˜์†”์ฐฝ์„ ํ†ตํ•ด ๋ฐ์ดํ„ฐ ์ถ”๊ฐ€ ์—ฌ๋ถ€ ํ™•์ธ 

 

SQLDeveloper ์—์„œ ์ถ”๊ฐ€๋œ ๋ฐ์ดํ„ฐ ํ™•์ธ

 

 

 

์ผ๋ฐ˜์ ์œผ๋กœ ํšŒ์›๊ฐ€์ž…ํ•  ๋•Œ ๋ฐ์ดํ„ฐ๋ฅผ ์ž…๋ ฅํ•˜๋ฉด ์ž๋ฐ”์—์„œ ์ฟผ๋ฆฌ๋ฅผ ๋งŒ๋“ค์–ด ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์— ๋„˜๊ฒจ์คŒ

 

'๐Ÿ’ปProgramming > โ˜•๏ธJava' ์นดํ…Œ๊ณ ๋ฆฌ์˜ ๋‹ค๋ฅธ ๊ธ€

PreparedStatement ํ™œ์šฉ  (0) 2022.08.22
PreparedStatement  (0) 2022.08.22
[JAVA] Collections Framework - Queue  (0) 2022.08.03
[JAVA] Collections Framework - Map  (0) 2022.08.03
[JAVA] Collections Framework - Set  (0) 2022.08.03
    '๐Ÿ’ปProgramming/โ˜•๏ธJava' ์นดํ…Œ๊ณ ๋ฆฌ์˜ ๋‹ค๋ฅธ ๊ธ€
    • PreparedStatement ํ™œ์šฉ
    • PreparedStatement
    • [JAVA] Collections Framework - Queue
    • [JAVA] Collections Framework - Map
    yeony._.
    yeony._.
    ํž˜ ์„ธ์ง€๋Š” ์•Œ์•ฝ๐Ÿ’Š๐Ÿ’Š๐Ÿ’Š

    ํ‹ฐ์Šคํ† ๋ฆฌํˆด๋ฐ”