본문 바로가기

Java/jdbc

Java/jdbc 2020. 1. 21. 일괄 삭제 하기 public boolean deleteCustUsers(String ids[]) { String sql = " DELETE FROM CUSTUSER " + " WHERE ID=? "; Connection conn = null; PreparedStatement psmt = null; int count[] = new int[ids.length]; try { conn = getConnection(); conn.setAutoCommit(false); //넣다가 잘못될수있기떄문에 꺼준다 psmt = conn.prepareStatement(sql); for(int i = 0; i< ids.length; i++) { psmt.setString(1, ids[i]); psmt.addBatch();//누적 축적 } cou..
Java/jdbc 2019. 12. 24. jdbc Select DBConnection 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 package db; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class DBConnection { public static void initConnection() { try { Class.forName("oracle.jdbc.driver.OracleDriver"); System.out.println("Driver Loading Success! "); } catch (..
Java/jdbc 2019. 12. 23. jdbc update(DBConnection, DBClose 활용) DBConnection 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 package db; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class DBConnection { public static void initConnection() { try { Class.forName("oracle.jdbc.driver.OracleDriver"); System.out.println("Driver Loading Success! "); } catch (..
Java/jdbc 2019. 12. 23. jdbc delete JDBC Test 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 package jdbc; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.State..
Java/jdbc 2019. 12. 23. jdbc Insert JDBC(Insert 선언 쪽) 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 package jdbc; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement; public class JdbcTest ..
Java/jdbc 2019. 12. 23. jdbc eclipse기본 설정하기 이클립스 기본 DB연결 설정하기 perspective -> database Connetions (우클릭 -> new) -> oracle -> 오라클 버전 11누르고 - > Edit Driver Definition(삼각형 모앙 클릭) Jar List에 가서 ojbc6.jar 추가하고 다른 jar파일 지워준다 -> service Name : xe로 변경 -> Host는 localhost로 지정하거나 ipconfig로 ip 확인후 입력 하기 username hr password hr 입력하고 ping connection open SQL Scrapbook 클릭 -> Type Oracle 11 name: new oracle database: xe 선택 드래그 하고 alt c로 연결 한 db의 select 구문 테..
Java/jdbc 2019. 12. 23. DBConnection, DBClose 만들어두기 DBConnection 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 package db; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class DBConnection { public static void initConnection() { try { Class.forName("oracle.jdbc.driver.OracleDriver"); System.out.println("Driver Loading Success! "); } catch (..

티스토리툴바