nalaolla

1. Creating a PackageINSERT, UPDATE, DELETE 의 경우는 프로시져 생성시 별다른 이슈가 발생하지 않는다..리턴값이 발생하지 않기 때문에..하지만 SELECT의 경우 리턴값을 받아야 하기때문에 커서에 해당 ResultSet을 담아 리턴해주어야 한다.먼저 패키지를 생성한다.CREATE OR REPLACE PACKAGE TYPES AS --> 패키지명은 "TYPES" TYPE cursorType is REF CURSOR; --> 패키지에 생성된 커서타입 REF CURSOR END TYPES; 2. Creating a Procedure CREATE OR REPLACE PROCEDURE UP_GET_TABLES ( PSEARCH_FIELD IN VARCHAR2, --SEARCH F..

Creating a Table오라클 스키마에 해당 테이블 등록CREATE TABLE "JAVA_PROJECT"."BOARD" ("NUM" NUMBER, "TITLE" VARCHAR2(50 BYTE), "CONTENT" VARCHAR2(2000 BYTE), "WRITER" VARCHAR2(20 BYTE), "REGDATE" DATE ); Creating a Package1. test.com.board.control2. test.com.board.model3. test.com.board.view Package test.com.board.controlBoardDAO.javapackage test.com.board.control; import java.util.List; public interface Board..

Creating a JDBC GUI ApplicationJava in its core is inherently a GUI language, rich in more than one graphical user interface, such as AWT, Swing, JavaFX, QtJambi, SWT, and so forth. It presents a user-friendly mechanism for application interaction, giving a distinctive look and feel. Although they have different architectural cores, they do not fail to provide applications with consistent, intui..

// MemberDTO 클래스 public class MemberDTO { private String id; private String pwd; private String name; private String tel; private String addr; private String birth; private String job; private String gender; private String email; private String intro; public String getId() { return id; } public void setId(String id) { this.id = id; } public String getPwd() { return pwd; } public void setPwd(Stri..

// MemberDAO 클래스 // JDBC 사용 방법// 1. JDBC 드라이버 로드 : Class.forName(oracle.jdbc.driver.OracleDriver);// 2. DB Server 연결 : DriverManager.getConnection(jdbc:oracle:thin:@localhost:XE, scott, tiger)// 3. SQL 쿼리문 명령 : Statement 또는 PreparedStatement// 4. 결과 처리 : executeQuery(SELECT 일 때), executeUpdate(UPDATE, INSERT, DELETE)// 5. 연결 종료 : // 연결 순서 : Connection > Statement 또는 PreparedStatement > ResultSet..

package test.com; import java.util.HashSet;import java.util.Random;import java.util.Scanner; public class BaseBallGame { public static String[] ballNum; //랜덤생성된 야구번호 public static int checkcnt; //도전한 횟수 public static void main(String[] args) { System.out.println("[4자리수 야구게임]"); HashSet ballNumber = new HashSet(); final int ballLength = 4; //야구게임 자리수 고정 Random rdm = new Random(); for (int i = 0; ..

package test.com; import java.util.Random; public class Test01Random { public static void main(String[] args) { System.out.println("Random..."); System.out.println(Math.random()); //난수발생 Random ran = new Random(); System.out.println(ran.nextInt(45+1)); System.out.println(ran.nextDouble()); System.out.println(ran.nextBoolean()); } }============================================랜덤객체는 Math.random과 Ra..

package test.com; import java.util.ArrayList;import java.util.HashMap;import java.util.HashSet;import java.util.Hashtable;import java.util.Iterator;import java.util.LinkedList;import java.util.List;import java.util.Set;import java.util.Vector; public class Test01CollectionAndMap4 { public static void main(String[] args) { // TODO Auto-generated method stub System.out.println("CollectionAndMap.."..

package test.com; import java.util.HashMap;import java.util.HashSet;import java.util.Hashtable;import java.util.Iterator;import java.util.LinkedList;import java.util.List;import java.util.Set;import java.util.Vector; public class Test01CollectionAndMap3 { public static void main(String[] args) { // TODO Auto-generated method stub System.out.println("CollectionAndMap.."); System.out.println("====..

package test.com; import java.util.ArrayList;import java.util.Hashtable;import java.util.List;import java.util.Random; public class Test01CollectionAndMap2 { public static void main(String[] args) { // TODO Auto-generated method stub System.out.println("CollectionAndMap.."); System.out.println("============ List ==========="); //1. Collection(List.Set) : 가변 객체배열 //a. List >> ArrayList, Vector //..