5/14 컴보2A 스윙

import java.awt.Color;
import java.awt.Container;
import java.awt.FlowLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JScrollPane;
import javax.swing.JTextArea;
import javax.swing.JTextField;

 

public class Student extends JFrame{
 JTextArea taList;//목록
 JTextField tfID;//아이디
 JTextField tfName; //이름
 JTextField tfDepartment; //학과
 JTextField tfAddress; //주소
 Connection conn;//연결객체
 Statement s; //스테이트먼트
 //생성자
 Student(){
  try {
   Class.forName("com.mysql.jdbc.Driver");
   conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/sampledb","root","1234");
   s=conn.createStatement();
  } catch (Exception e1) {   
   e1.printStackTrace();
  }
  
  setTitle("학생관리");//타이틀
  
  Container c=getContentPane();//컨테이너생성
  c.setBackground(Color.orange);//배경색
  c.setLayout(new FlowLayout(FlowLayout.LEFT,10,10));//레이아웃설정
  
  c.add(new JLabel("이름"));
  tfName=new JTextField(20);
  c.add(tfName);
  
  c.add(new JLabel("학번"));
  tfID=new JTextField(20);
  c.add(tfID);
  
  c.add(new JLabel("학과"));
  tfDepartment=new JTextField(20);
  c.add(tfDepartment);
  
  c.add(new JLabel("주소"));
  tfAddress=new JTextField(20);
  c.add(tfAddress);
  
  taList=new JTextArea(7, 23);
  c.add(new JScrollPane(taList));
  
  JButton btnOK=new JButton("Insert");
  c.add(btnOK);
  btnOK.addActionListener(new ActionListener(){
   @Override
   public void actionPerformed(ActionEvent e) {
    if(tfName.getText().equals("")){
     JOptionPane.showMessageDialog(null, "이름을 입력하세요!", "확인", JOptionPane.WARNING_MESSAGE);
     tfName.requestFocus();//포커스
     return;//함수종료     
    }
    
    if(tfDepartment.getText().equals("")){
     JOptionPane.showMessageDialog(null, "학과를 입력하세요!", "확인", JOptionPane.WARNING_MESSAGE);
     tfDepartment.requestFocus();//포커스
     return;//함수종료     
    }
    
    if(tfAddress.getText().equals("")){
     JOptionPane.showMessageDialog(null, "주소를 입력하세요!", "확인", JOptionPane.WARNING_MESSAGE);
     tfAddress.requestFocus();//포커스
     return;//함수종료     
    }
    
    
    try{   
     
     String sql="insert into student(id,name,dept,address) "
        +" values('"+tfID.getText()+"','"+tfName.getText()+"','"+tfDepartment.getText()+"','"+tfAddress.getText()+"')";
     s.executeUpdate(sql);
     
     
     /* String sql="update student set dept='그래픽' "
       +" where id='2014123412'";
     s.executeUpdate(sql); */
     
     /* String sql="delete from student "
       +" where id='2014123412'";
     s.executeUpdate(sql);
     */
     
     sql="select * from student";
     ResultSet rs=s.executeQuery(sql);
     
     taList.setText("");//목록초기화
     
     taList.append("학번\t");
     taList.append("이름\t");
     taList.append("주소\t");
     taList.append("학과\n");
     taList.append("==============================================\n");
     while(rs.next()){       
      taList.append(rs.getString("id")+"\t");
      taList.append(rs.getString("name")+"\t");
      taList.append(rs.getString("address")+"\t");
      taList.append(rs.getString("dept")+"\n");
     }
     rs.close();//rs종료
     
     
    }catch(Exception a){
     a.printStackTrace();
    }
    
    
    
   }});
  
  JButton btnCancel=new JButton("List");
  c.add(btnCancel);
  btnCancel.addActionListener(new ActionListener(){
   @Override
   public void actionPerformed(ActionEvent e) {
    try{
     
     /* String sql="update student set dept='그래픽' "
       +" where id='2014123412'";
     s.executeUpdate(sql); */
     
     /* String sql="delete from student "
       +" where id='2014123412'";
     s.executeUpdate(sql);
     */
     
     String sql="select * from student";
     ResultSet rs=s.executeQuery(sql);
     
     taList.setText("");//목록초기화
     
     taList.append("학번\t");
     taList.append("이름\t");
     taList.append("주소\t");
     taList.append("학과\n");
     taList.append("==============================================\n");
     while(rs.next()){       
      taList.append(rs.getString("id")+"\t");
      taList.append(rs.getString("name")+"\t");
      taList.append(rs.getString("address")+"\t");
      taList.append(rs.getString("dept")+"\n");
     }
     rs.close();//rs종료
     
     
    }catch(Exception a){
     a.printStackTrace();
    }
   }});
    
  //한건 검색
  JButton btnSearch=new JButton("Search");
  c.add(btnSearch);
  btnSearch.addActionListener(new ActionListener(){

   @Override
   public void actionPerformed(ActionEvent arg0) {
    try{
     
     String sql="select * from student "
        +" where id='"+tfID.getText()+"'";
     ResultSet rs=s.executeQuery(sql);
     
     taList.setText("");//목록초기화
     
     taList.append("학번\t");
     taList.append("이름\t");
     taList.append("주소\t");
     taList.append("학과\n");
     taList.append("==============================================\n");
     while(rs.next()){       
      taList.append(rs.getString("id")+"\t");
      taList.append(rs.getString("name")+"\t");
      taList.append(rs.getString("address")+"\t");
      taList.append(rs.getString("dept")+"\n");
      
      tfID.setText(rs.getString("id"));
      tfName.setText(rs.getString("name"));
      tfAddress.setText(rs.getString("address"));
      tfDepartment.setText(rs.getString("dept"));
     }
     
     
     rs.close();//rs종료
     
     
    }catch(Exception a){
     a.printStackTrace();
    }
    
   }});
  
  setSize(300,340);//사이즈
  setVisible(true);//보이게하기
  setResizable(false);//사이즈고정
  //종료
  setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
  
 }
 
 
 
 /*private class MyActionListener implements ActionListener{
  @Override
  public void actionPerformed(ActionEvent e) {
   JButton btn=(JButton)e.getSource();//클릭한버튼구하기
   if(btn.getText().equals("OK")){
    System.out.println("OK버튼이 클릭됨");
   }else if(btn.getText().equals("Cancel")){
    System.out.println("Cancel버튼이 클릭됨");
   }  
  } 
 }*/

 
 
 public static void main(String[] args) {
  new Student();//생성자호출.인스턴스생성

 }

}