목록JSP/DB (1) (7)
WON.dev
package org.joonzis.ex; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import org.joonzis.db.DBConnect; public class Ex06_select { //no가 1인 데이터 삭제 public static void main(String[] args) { Connection conn = null; PreparedStatement ps = null; ResultSet rs = null; try { conn = DBConnect.getConnection(); String sql ="select * from sample"; ps = conn.prepare..
package org.joonzis.ex; import java.sql.Connection; import java.sql.PreparedStatement; import org.joonzis.db.DBConnect; public class Ex05_delete { //no가 1인 데이터 삭제 public static void main(String[] args) { Connection conn = null; PreparedStatement ps = null; try { conn = DBConnect.getConnection(); String sql ="delete from sample where no=?"; ps = conn.prepareStatement(sql); ps.setInt(1,1); int res..
package org.joonzis.ex; import java.sql.Connection; import java.sql.PreparedStatement; import org.joonzis.db.DBConnect; public class Ex04_update { //김씨 이름을 "박씨로 변경 public static void main(String[] args) { Connection conn = null; PreparedStatement ps = null; try { conn = DBConnect.getConnection(); String sql ="update sample set name=? where name='김씨'"; ps = conn.prepareStatement(sql); ps.setStrin..
package org.joonzis.ex; import java.sql.Connection; import java.sql.PreparedStatement; import org.joonzis.db.DBConnect; public class Ex03_insert { public static void main(String[] args) { Connection conn = null; PreparedStatement ps = null; try { conn = DBConnect.getConnection(); String sql ="insert into sample(no,name,reg_date) " + " values(sample_seq.nextval, ?, sysdate)"; ps = conn.prepareSta..
package org.joonzis.ex; import java.sql.Connection; import java.sql.PreparedStatement; import org.joonzis.db.DBConnect; public class Ex02_create { // 시퀀스 생성 // sample_seq (시작 값 1, 증가 값 1) public static void main(String[] args) { Connection conn = null; PreparedStatement ps = null; try { conn = DBConnect.getConnection(); String sql = "create sequence sample_seq " + "start with 1 increment by 1"; ..
package org.joonzis.ex; import java.sql.Connection; import java.sql.PreparedStatement; import org.joonzis.db.DBConnect; public class Ex01_create { public static void main(String[] args) { Connection conn = null; PreparedStatement ps = null; try { conn = DBConnect.getConnection(); String sql ="CREATE TABLE sample(" +" no NUMBER PRIMARY KEY," +" name VARCHAR2(20) not null," +" reg_date date not nu..
package org.joonzis.db; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class DBConnect { 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"; Connection conn = Driv..