목록JAVA (194)
WON.dev
package org.joonzis.ex; import java.sql.Connection; import java.sql.PreparedStatement; import org.joonzis.db.DBConnection; public class Ex01_insert { public static void main(String[] args) { Connection conn = null; PreparedStatement ps = null; // sql의 값을 변수 처리 할 수 있다. try { conn = DBConnection.getConnection(); String sql = "insert into person(name, age, region) values(?, ?, ?)"; // 나중에 setter로 채..
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..
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..
package org.joonzis.ex2; 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";// 외우자 Connec..
package org.joonzis.ex; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; /* * Oracle jdbc를 프로젝트에 등록 * 1.프로젝트 우클릭 * 2.Build Path - Configure Build Path * 3.Libraries 탭 * 4.Add External JARs * 5.ojdbc6.jar 파일을 찾아서 선택 */ public class Ex01_connextion { public static void main(String[] args) { // 1. Connection 인스턴스 Connection conn = null; try { // 2. Oracle jdb..
package org.joonzis.test; import java.io.BufferedInputStream; import java.io.BufferedOutputStream; import java.io.BufferedReader; import java.io.File; import java.io.FileInputStream; import java.io.FileOutputStream; import java.io.FileReader; import java.io.IOException; //Q1. Test01.java //nationalAnthem 데이터 파일을 읽어들여 화면에 출력하고, //nationalAnthem2.txt 파일명으로 복사하는 프로그램 작성 public class Test01 { public..
package org.joonzis.ex; import java.io.BufferedInputStream; import java.io.BufferedOutputStream; import java.io.File; import java.io.FileInputStream; import java.io.FileOutputStream; import java.io.IOException; public class Ex06_FileCopy { public static void main(String[] args)throws IOException { File file = new File("cat.jpg"); if(file.exists()) { BufferedInputStream bis = new BufferedInputStr..