[JAVA JDBC, SWING, AWT]자바 AWT,스윙을 이용하여 오라클 EMP 테이블데이터 로딩 및 편집하기(JAVA JDBC, AWT, SWING)

[JAVA JDBC, SWING, AWT]자바 AWT,스윙을 이용하여 오라클 EMP 테이블데이터 로딩 및 편집하기(JAVA JDBC, AWT, SWING)   1. DBConnect.java   import java.sql.*; public class  DBConnect  {  private Connection con;  private Statement stmt;  private String url = "jdbc:oracle:thin:@192.168.0.7:1521:onj";  private String ID = "scott";  private String PW = "tiger";  public DBConnect()  {   try{    Class.forName("oracle.jdbc.driver.OracleDriver");   // JDBC Driver Loading      con = DriverManager.getConnection(url, ID, PW);    // Connect 확득    stmt = con.createStatement();                               //명령실행을 위한 Statement 획득   }   catch(Exception ex)   {    System.err.println(ex);   }    }  public Statement getStatement()  {   return stmt;  } }       2.  DBEdit.java   import java.awt.*; import java.awt.event.*; import javax.swing.*; import javax.swing.event.*; import java.sql.*;   public class  DBEdit extends JFrame {  private ResultSet rs=null;  private Statement stmt=null;  private JButton[] btn = new JButton[5];  private JLabel[] label = new JLabel[8];  private JTextField[] text = new JTextField[8];  private JTable table;  private JScrollPane jp = new JScrollPane();  private JPanel p[]  = new JPanel[4];  private JPanel p2  = new JPanel();  private String[][] data=new String[100][8];  private String[] col = {"empno    ","ename   ","job         ","mgr      ","hiredate",  "sal        ","comm     ","deptno   "};  private String[] string = {"","","","","","","",""};  public DBEdit()  {   super("DBEdit");      /////////////   // DB에 연결   DBConnect connect = new DBConnect();    stmt = connect.getStatement();   JPanel p1 = new JPanel();     p1.setLayout(new GridLayout(5,1));     JPanel p3 = new JPanel();     btn[0] = new JButton("선택");   btn[1] = new JButton("출력");   btn[2] = new JButton("입력");   btn[3] = new JButton("수정");   btn[4] = new JButton("삭제");     for( int i= 0 ; i < 5 ; i++)   {    btn[i].addActionListener(action);    p3.add(btn[i]);   }     for (int i = 0; i< 8; i++) {    label[i] = new JLabel(col[i]);      }      for (int i = 0; i< 8; i++) {    text[i] = new JTextField(15);      }      for ( int i = 0 ; i < 4 ; i++)      {       p[i] = new JPanel();      }           int j= -1;      for( int i = 0 ; i < 8 ; i++)      {            if( i%2==0)       {        j++;       }       p[j].add(label[i]);       p[j].add(text[i]);      }           p1.add(p3);      p1.add(p[0]);      p1.add(p[1]);      p1.add(p[2]);      p1.add(p[3]);     table = new JTable(data,col);   jp=new JScrollPane(table);   jp.addMouseListener(new MouseAdapter(){});       Container cp = this.getContentPane();   cp.setLayout(new GridLayout(2,1));   cp.add(p1);   cp.add(jp);        setDefaultCloseOperation(DISPOSE_ON_CLOSE);    setBounds(100,100,500,500);   setVisible(true);   showTable();    }  public void showTable()  {   table.removeAll();   try{    for(int i = 0 ; i <100 ; i++)    {     for(int j = 0 ; j <  8;j++)     {      data[i][j]="";     }    }    rs=stmt.executeQuery("select * from emp");    int i=0;      while(rs.next())    {     data[i][0]=rs.getString(1);     data[i][1]=rs.getString(2);     data[i][2]=rs.getString(3);     data[i][3]=rs.getString(4);     data[i][4]=rs.getString(5);     data[i][5]=rs.getString(6);     data[i][6]=rs.getString(7);        data[i++][7]=rs.getString(8);    }    table.repaint();   }   catch(Exception e)   {    System.err.println("보여 주기 에러");   }  }  ActionBtn action = new ActionBtn();  class ActionBtn extends Exception implements ActionListener  {   public void actionPerformed(ActionEvent e)   {    if(e.getActionCommand().equals("출력"))    {        showTable();    }    else if(e.getActionCommand().equals("선택"))    {     int row=table.getSelectedRow();     /////////////////////     // 텍스트 필드에 받아온 데이터 보여주기     for( int i= 0 ; i < 8 ;i++)     {      text[i].setText(data[row][i]);     }       }    else if(e.getActionCommand().equals("입력"))    {     try{      for(int i = 0 ; i < 8; i++)      {       if( text[i].getText().equals(""))       {        if( i==0 || i==3||i==5||i==6||i==7)         string[i]="\'\'";        else         string[i]="";       }       else        string[i]=text[i].getText();      }      stmt.executeQuery(      "insert into emp values(" + string[0]+ ",'" +      string[1]+ "' ,'" +string[2]+ "'," +string[3]+ ",'" +      string[4]+ "'," +string[5]+ "," +string[6]+ "," +      string[7]+ ")");      stmt.executeQuery("commit");     }     catch(Exception ex)     {      System.err.println("입력 에러");     }     ////////////////////     //화면에 출력하기     showTable();     for( int i = 0 ; i < 8 ; i++)     {      text[i].setText("");     }    }    else if(e.getActionCommand().equals("수정"))    {     try{      stmt.executeQuery(      "update emp set" + " empno = " +text[0].getText()+ " ,ename='" +      text[1].getText()+ "',job='" +text[2].getText()+ "',mgr=" +text[3].getText()+ ",hiredate='" +      text[4].getText()+ "',sal=" +text[5].getText()+ ",comm=" +text[6].getText()+ ",deptno =" +      text[7].getText()+"where empno = "+text[0].getText());      stmt.executeQuery("commit");     }     catch(Exception ex)     {      System.err.println("수정 에러");     }     ////////////////////     //화면에 출력하기     showTable();     for( int i = 0 ; i < 8 ; i++)     {      text[i].setText("");     }    }    else if(e.getActionCommand().equals("삭제"))    {     try{      System.out.println (text[0].getText());      stmt.executeQuery("delete from emp where" + " empno = " +text[0].getText());      stmt.executeQuery("commit");     }     catch(Exception ex)     {      System.err.println("삭제 에러");     }     ////////////////////     //화면에 출력하기     showTable();     for( int i = 0 ; i < 8 ; i++)     {      text[i].setText("");     }    }   }  }  public static void main(String[] args)  {   DBEdit db = new DBEdit();  } }   <결과그림 SWING,JDBC예제>