자바 select / insert / Update /delete

Select

package k_jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;

public class select {

   public static void main(String[] args) {
  
  String url = "jdbc:oracle:thin:@localhost:1521:xe";
  String user = "JSG99";
  String password ="java";

  Connection con = null;
  PreparedStatement ps = null;
  ResultSet rs = null; 

  try {
     con = DriverManager.getConnection(url, user, password); // 커넥션 얻기=연결
     String sql = "select * from LPROD ORDER BY 1 ";
     ps = con.prepareStatement(sql);
     rs = ps.executeQuery();
     
     ResultSetMetaData metaData = rs.getMetaData(); 
     int columnCount = metaData.getColumnCount(); 
     
     while(rs.next()){ 

        for(int i=1; i<= columnCount; i++){ //가로
           Object value = rs.getObject(i);
           System.out.print(value+"\t");
        }
        System.out.println();
        
     }
     } catch (SQLException e) {
     e.printStackTrace();
  }finally{ 
     if(rs != null) try { rs.close();} catch (Exception e){}
     if(ps != null) try { ps.close();} catch (Exception e){}
     if(con != null) try { con.close();} catch (Exception e){}
     
     }
  }
}

insert

 package k_jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class insert {

 public static void main(String[] args) {
    String url = "jdbc:oracle:thin:@localhost:1521:xe";
    String user = "JSG99";
    String password ="java";

  Connection con = null;
  PreparedStatement ps = null;
  ResultSet rs = null; 
  
  try {
     con = DriverManager.getConnection(url, user, password);
     String sql = "insert into LPROD values(?,?,?)";
     ps = con.prepareStatement(sql);
     ps.setObject(1, "7");
     ps.setObject(2, "P401");
     ps.setObject(3, "아이패드");
     
  
  
     int result = ps.executeUpdate();
     System.out.println(result);

     
  } catch (SQLException e) {
     e.printStackTrace();
  
  }finally{ 
     if(rs != null) try { rs.close();} catch (Exception e){}
     if(ps != null) try { ps.close();} catch (Exception e){}
     if(con != null) try { con.close();} catch (Exception e){}
     
     }
   }
}

Update

 package k_jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;

import javax.xml.transform.Result;

public class Update {

   public static void main(String[] args) {
         String url = "jdbc:oracle:thin:@localhost:1521:xe";
         String user = "JHY990208";
         String password ="java";

     Connection con = null;
     PreparedStatement ps = null;
     ResultSet rs = null; 

     try {
        con = DriverManager.getConnection(url, user, password);
        String sql = "update LPROD set LPROD_NM = ? WHERE LPROD_ID= 4 ";
        ps = con.prepareStatement(sql);
        ps.setObject(1, "남봄셔츠");
        int result = ps.executeUpdate();
        System.out.println(result);
        

        
     } catch (SQLException e) {
        e.printStackTrace();
     
     }finally{ 
        if(rs != null) try { rs.close();} catch (Exception e){}
        if(ps != null) try { ps.close();} catch (Exception e){}
        if(con != null) try { con.close();} catch (Exception e){}
        
        }
    }
}

delete

package k_jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class delete {

   public static void main(String[] args) {
      String url = "jdbc:oracle:thin:@localhost:1521:xe";
      String user = "JSG99";
      String password ="java";

  Connection con = null;
  PreparedStatement ps = null;
  ResultSet rs = null; 
  
  try {
     con = DriverManager.getConnection(url, user, password);
     String sql = "delete from LPROD where LPROD_GU = ?";
     ps = con.prepareStatement(sql);
     ps.setObject(1, "P508");
     int result = ps.executeUpdate();
     System.out.println(result);
     

     
  } catch (SQLException e) {
     e.printStackTrace();
  
  }finally{ 
     if(rs != null) try { rs.close();} catch (Exception e){}
     if(ps != null) try { ps.close();} catch (Exception e){}
     if(con != null) try { con.close();} catch (Exception e){}
     
     }

   }

 }