import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Scanner;

public class DB1 {
	public static void main(String[] args) throws ClassNotFoundException {
		Class.forName("oracle.jdbc.driver.OracleDriver");
		String url = "jdbc:oracle:thin:@192.168.10.21:1521:orcl";
		Connection con = null;
		Statement stmt = null;
		ResultSet rs = null;
		String sql;
		Statement fstmt = null;
		ResultSet frs = null;
		String fsql;
		try{
			con = DriverManager.getConnection(url, "dvd","1111"); 
			Scanner scan = new Scanner(System.in);
			while(true){
				System.out.println("고객조회창");
				System.out.print("고객명 : ");
				String name = scan.next();

				sql = "SELECT * FROM member";
				stmt = con.createStatement(); 
				rs = stmt.executeQuery(sql);
				fsql = "SELECT * FROM family";
				fstmt = con.createStatement(); 
				frs = fstmt.executeQuery(fsql);

				while(rs.next()){
					if (rs.getString(2).equals(name)){
						System.out.println("고객번호\t고객명\t\t주소\t\t\t나이\t전화번호\t가족(관계)");
						System.out.print(rs.getInt(1)+"\t\t");
						System.out.print(rs.getString(2)+"\t\t");
						System.out.print(rs.getString(3)+"\t");
						System.out.print(rs.getInt(4)+"\t");
						System.out.print(rs.getInt(5)+"\t");

						while(frs.next()){
							if(rs.getInt(1)==frs.getInt(1)){
								System.out.print(frs.getString(2)+"(");
								System.out.print(frs.getString(3)+")\t");
							}else
								break;
						}

						System.out.println("");
					}
					else {
						System.out.println("검색된 고객이 없습니다.");
					}
				}
			}
		}
		catch(Exception err){
			err.printStackTrace();
		}
		finally{
			if(frs != null) try{frs.close();}catch(Exception err){}
			if(rs != null) try{rs.close();}catch(Exception err){}
			if(fstmt != null) try{fstmt.close();}catch(Exception err){}
			if(stmt != null) try{stmt.close();}catch(Exception err){}
			if(con != null) try{con.close();}catch(Exception err){}
		}
	}
}


@@ -654,16 +654,18 @@
 n);%0D%0A%09%09%09
+//
 while(tr
@@ -726,19 +726,22 @@
 .print(%22
-%EA%B3%A0%EA%B0%9D%EB%AA%85
+%EC%A0%84%ED%99%94%EB%B2%88%ED%98%B8%EC%A1%B0%ED%9A%8C
  : %22);%0D%0A
@@ -751,20 +751,25 @@
 %09String 
-name
+phone_num
  = scan.
@@ -812,16 +812,58 @@
 member%22;
+ //WHERE phone_num LIKE '%22+phone_num+%22$'%22;
 %0D%0A%09%09%09%09st
@@ -1083,17 +1083,17 @@
 tString(
-2
+5
 ).equals
@@ -1097,12 +1097,17 @@
 als(
-name
+phone_num
 ))%7B%0D
@@ -1151,18 +1151,16 @@
 t%5Ct%EC%A3%BC%EC%86%8C%5Ct%5C
-t%5C
 t%EB%82%98%EC%9D%B4%5Ct%EC%A0%84%ED%99%94%EB%B2%88
@@ -1306,24 +1306,26 @@
 tring(3)+%22%5Ct
+%5Ct
 %22);%0D%0A%09%09%09%09%09%09S
@@ -1390,19 +1390,22 @@
 t(rs.get
-Int
+String
 (5)+%22%5Ct%22
@@ -1732,16 +1732,18 @@
 %09%09%7D%0D%0A%09%09%09
+//
 %7D%0D%0A%09%09%7D%0D%0A

Update Search_Customer.java