WON.dev

package org.joonzis.ex; import java.sql.Connection; import java.sql.ResultSet; import java.sql.Statement; import org.joonzis.db.DBConnection; public class Ex04_select { public static void main(String[] args) { Connection conn = null; Statement st = null; ResultSet rs = null; // select의 결과 (table)은 ResultSet이다. try { conn = DBConnection.getConnection(); st = conn.createStatement(); String sql = "..

package org.joonzis.ex; import java.sql.Connection; import java.sql.Statement; import org.joonzis.db.DBConnection; public class Ex02_update { public static void main(String[] args) { //스콧 나이를 21살로변경 //성공 시 - "업데이트 성공" //실패 시 - "업데이트 실패" 출력 Connection conn = null; Statement st = null; try { conn = DBConnection.getConnection(); st = conn.createStatement(); String sql = " UPDATE PERSON SET AGE=21 w..

package org.joonzis.ex; import java.sql.Connection; import java.sql.Statement; import org.joonzis.db.DBConnection; public class Ex01_insert { public static void main(String[] args) { Connection conn = null; Statement st = null; try { conn = DBConnection.getConnection(); // Statement 생성 st = conn.createStatement(); // 쿼리 작성 - > 스콧, 99 , 인천 // 세미콜론 주의 String sql = "insert INTO PERSON VALUES('스콧',9..

package org.joonzis.db; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class DBConnection { public static Connection getConnection() throws ClassNotFoundException, SQLException{ Class.forName("oracle.jdbc.driver.OracleDriver");// 외우자 String user = "scott"; String password = "tiger"; String url = "jdbc:oracle:thin:@localhost:1521:xe";// 외우자 Connect..