디비 연동 후 zip code 예제 소스

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 Exam06 {

 public static void main(String[] ar){
  
  try{
   
   Class.forName("org.gjt.mm.mysql.Driver");
   
  }catch(Exception e){
    System.err.println(e);
    System.exit(1);
  }
  
  Connection conn = null;
  PreparedStatement pstmt = null;
  Statement stmt = null;
  String url = "jdbc:mysql://localhost:3306/java";
  String id = "root";
  String pass= "1423";
  String query = null;
  
  try{
   
   conn = DriverManager.getConnection(url,id,pass);
   
  }catch(Exception e){
   System.err.println(e);
   System.exit(1);
  }
  
  // ------------- Databases 접속 ----------------//
  
  Scanner sc = new Scanner(System.in);
  System.out.println("동이름 = ");
  String dongname = sc.next();
  
  query = "select * from zipcode where dong like ?";
  
  try{
  pstmt = conn.prepareStatement(query);
  pstmt.setString(1, dongname+ "%");
  
  ResultSet rs = pstmt.executeQuery();
  
  while(rs.next()){
   String addr = "[" + rs.getString("zipcode") + "]";
   addr += rs.getString("sido")+" ";
   addr += rs.getString("gugun")+" ";
   addr += rs.getString("dong")+" ";
   if(!rs.getString("ri").isEmpty()){
    addr += rs.getString("ri");
   }
   String b = rs.getString("bunji");
   if(b != null && b.length() != 0 ) addr+= b;
  System.out.println(addr);
  }
   
  }catch(Exception e){
   System.err.println(e);
  }
  
  
  
  
  
 }
 
}