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 |