목록JSP (284)
WON.dev
0) { System.out.println("데이터 삭제 성공!"); }else { System.out.println("데이터 삭제 실패"); } } catch (Exception e) { e.printStackTrace(); } finally { try { if (ps != null) { ps.close(); } if (conn != null) { conn.close(); } } catch (Exception e2) { e2.printStackTrace(); } } %>
회원 정보 관리 아이디 비밀번호 이름 나이 주소
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..
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..