import java.awt.*;
import javax.swing.*;
import java.sql.*;
import java.awt.event.*;
import javax.swing.event.*;


public class Diary{

  // GUI±¸ÇöÀ» À§ÇÑ ÀνºÅϽº º¯¼öµéÀ» ¼±¾ð.
  JFrame theFrame = new JFrame("Diary 2.0");;
  JPanel mainPanel;
  String[] lbString = {"À̸§", "¼ºº°", "³ªÀÌ", "ÀüÈ­", "ÁÖ¼Ò"};
  String[] btString = {"µî·Ï", "»èÁ¦", "Á¾·á"};
  String[] cbString = {"³²ÀÚ", "¿©ÀÚ"};

  List lstName;
  JButton[] bt;
  JLabel[] lb;
  JTextField tf0, tf1, tf2, tf3;
  private JTextArea tArea;
  JComboBox cb;

  Connection con;
  Statement stat;
  ResultSet rs;

  String tableName = "test";
  String sqlSelectString = "Select * from " + tableName;

  // Main Method
  public static void main(String[] args){
    new Diary().buildGui();
  }

  public void buildGui(){
    mainPanel = new JPanel(new BorderLayout());
    JPanel pan = new JPanel();

      lb = new JLabel[lbString.length];
      bt = new JButton[btString.length];
    for(int i=0; i<lbString.length; i++)
      lb[i] = new JLabel(lbString[i]);
    for(int i=0; i<btString.length; i++)
      bt[i] = new JButton(btString[i]);

    pan.add(lb[0]);
      tf0 = new JTextField(8);
    pan.add(tf0);
    pan.add(lb[1]);
      cb = new JComboBox(cbString);
    pan.add(cb);
    pan.add(lb[2]);
      tf1 = new JTextField(3);
    pan.add(tf1);
    pan.add(lb[3]);
      tf2 = new JTextField(10);
    pan.add(tf2);
    pan.add(lb[4]);
      tf3 = new JTextField(20);
    pan.add(tf3);

    JPanel pan2 = new JPanel();
    for(int i=0; i<btString.length; i++){
      pan2.add(bt[i]);
      bt[i].addActionListener(new btAction());
    }

    JPanel pan3 = new JPanel(new BorderLayout());
    tArea = new JTextArea("TextArea", 5, 10);
    tArea.setEditable(false);
    lstName = new List(5);
    lstName.addActionListener(new lstNameAction());
    pan3.add(lstName, "West");
    pan3.add(tArea, "Center");

  try{
    Class.forName("org.gjt.mm.mysql.Driver").newInstance();
    con=DriverManager.getConnection( "jdbc:mysql://localhost:3309/test", "root", "Password" );
    stat = con.createStatement();
    rs = stat.executeQuery(sqlSelectString);
    while(rs.next())
      lstName.add(rs.getString("name"));
    rs.close();      stat.close();      con.close();
    tAreaSetText("DB Connection Success!!");
  }
  catch(SQLException ex){ System.out.println("SQLException" + ex);}
  catch(Exception ex){ System.out.println("Exception:" + ex);}

    mainPanel.add(pan, "Center");
    mainPanel.add(pan2, "South");
    mainPanel.add(pan3, "North");

    theFrame.add(mainPanel);
    theFrame.pack();
    theFrame.setVisible(true);

    theFrame.addWindowListener(new WindowAdapter(){
      public void windowClosing(WindowEvent we){
        theFrame.dispose();
        System.exit(0);
      }
    });
  }

  // ¹öÆ° À̺¥Æ®¸¦ À§ÇÑ ³»ºÎŬ·¡½º btAction Class
  public class btAction implements ActionListener{
    public void actionPerformed(ActionEvent event){
    Object getEvent = event.getSource();
    if(getEvent.equals(bt[0])){
     try{
         Class.forName("org.gjt.mm.mysql.Driver").newInstance();
         con=DriverManager.getConnection( "jdbc:mysql://localhost:3309/test", "root", "Password" );
         String sqlInsertString = "insert into " + tableName + " values('" +
                            tf0.getText() + "','" + cb.getSelectedItem() + "','"
                            + Integer.parseInt(tf1.getText()) + "','" + tf2.getText()
                            + "','" + tf3.getText() + "')";
         stat = con.createStatement();
         stat.executeUpdate(sqlInsertString);

         lstName.add(tf0.getText());
         rs.close();      stat.close();        con.close();
         tAreaSetText("DB Insert Success!!");
      } catch(SQLException ex){
          System.out.println("SQLException" + ex);
          tAreaSetText("³»¿ëÀ» ÀÔ·ÂÇØÁÖ¼¼¿ä!!");
      }
        catch(Exception ex){
          System.out.println("Exception:" + ex);
          tAreaSetText("³»¿ëÀ» ÀÔ·ÂÇØÁÖ¼¼¿ä!!");
      }
    }else if(getEvent.equals(bt[1])){
     try{
         Class.forName("org.gjt.mm.mysql.Driver").newInstance();
         con=DriverManager.getConnection( "jdbc:mysql://localhost:3309/test", "root", "Password" );
         stat = con.createStatement();
         String sqlDeleteString = "delete from " + tableName + " where name='"
                               + lstName.getSelectedItem()+"'";
         stat.executeUpdate(sqlDeleteString);

         lstName.remove(lstName.getSelectedIndex());
         rs.close();      stat.close();        con.close();
         tAreaSetText("DB Delete Success!!");
      } catch(SQLException ex){
         System.out.println("SQLException" + ex);
         tAreaSetText("¸®½ºÆ®¿¡¼­ À̸§À» ¼±ÅÃÇØÁÖ¼¼¿ä.");
      }
        catch(Exception ex){
         System.out.println("Exception:" + ex);
         tAreaSetText("¸®½ºÆ®¿¡¼­ À̸§À» ¼±ÅÃÇØÁÖ¼¼¿ä.");
      }
    }else if(getEvent.equals(bt[2])){
      theFrame.dispose();
      System.exit(0);
    }else
      System.out.println("Error!!");
    }
  }// btAction Class End

  public class lstNameAction implements ActionListener{
    public void actionPerformed(ActionEvent event){
    try{
      Class.forName("org.gjt.mm.mysql.Driver").newInstance();
      con=DriverManager.getConnection( "jdbc:mysql://localhost:3309/test", "root", "Password" );
      stat = con.createStatement();
      rs = stat.executeQuery(sqlSelectString);
      rs.absolute(lstName.getSelectedIndex()+1);
      String sqlSelectDB = "Name: "+rs.getString("name")+"   Sex: "+rs.getString("sex")
                          +"   Year: "+rs.getString("year")+"   Tel: "+rs.getString("tel")
                          +"   Address: "+rs.getString("address");
      tAreaSetText(sqlSelectDB);
      rs.close();       stat.close();           con.close();
    } catch(SQLException ex){ System.out.println("SQLException" + ex);}
      catch(Exception ex){ System.out.println("Exception:" + ex);}
    }
  }

  public void tAreaSetText(String text){
    tArea.setText(text);
  }
  public String tAreaGetText(){
    return tArea.getText();
  }
}