본문 바로가기

Java

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 (..
Java/java 기초 2019. 12. 10. 쓰레드를 활용한 오브젝트 전송하기 서버 부분 package main; import java.io.ObjectInputStream; import java.io.ObjectOutputStream; import java.net.Socket; public class ObjectTread extends Thread { Socket socket; int memberNum; public ObjectTread(Socket socket, int memberNum) { this.socket = socket; this.memberNum = memberNum; } @Override public void run() { // TODO Auto-generated method stub super.run(); try { while (true) { ObjectInput..
Java/java 기초 2019. 12. 10. 쓰레드 공부하기 서버 부분 쓰레드 파트 import java.io.BufferedReader; import java.io.IOException; import java.io.InputStreamReader; import java.io.PrintWriter; import java.net.Socket; import java.util.List; public class ServerThread extends Thread { Socket socket; List list; public ServerThread(Socket socket, List list) { this.socket = socket; this.list = list; } @Override public void run() { // TODO Auto-generated metho..

티스토리툴바