선수 정보 입력하는 프레임 만들고, '추가' 버튼 누를시 데이터베이스에 연결(PlayerSwing)

package swingTest;
 
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.MouseAdapter;
import java.awt.event.MouseEvent;
import java.awt.event.MouseListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
 
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTextArea;
import javax.swing.JTextField;
 
public class PlayerSwing extends JFrame {
    JTextField []tf=new JTextField[6];
    Connection con;
    
    public PlayerSwing() {
        dbCon(); //db연결
        setTitle("Player Test");
        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        setLayout(new GridLayout(2,2));
        
        add(new PanelPane()); //1행 1열
        
        JTextArea ta=new JTextArea(); //1행 2열
        JScrollPane jsp=new JScrollPane(ta);
        add(jsp); 
        ta.addMouseListener(new MouseAdapter() { //인터페이스를 구현한 클래스=Adapter
            public void mouseReleased(MouseEvent e) {
              try {
                int num = Integer.parseInt(ta.getSelectedText().trim()); //선택한 num
                tf[0].setText(num+"");
                String sql="SELECT*FROM player WHERE num="+num;
                Statement st=con.createStatement();
                ResultSet rs=st.executeQuery(sql);
                if(rs.next()) {
                    tf[1].setText(rs.getString("name"));
                    tf[2].setText(rs.getString("birth"));
                    tf[3].setText(rs.getDouble("height")+"");
                    tf[4].setText(rs.getDouble("weight")+"");
                    tf[5].setText(rs.getString("kind"));
                }
              }catch(NullPointerException n) {
                JOptionPane.showMessageDialog(null, "번호를 선택하세요");
              }catch(NumberFormatException n2) {
                JOptionPane.showMessageDialog(null, "번호를 선택하세요");
              }catch(SQLException e1) {
                e1.printStackTrace();
              }
            }
        });
    
        
        JPanel p1=new JPanel(); //2행 1열
        JButton insertBtn=new JButton("추가");
        JButton viewBtn=new JButton("보기");
        JButton updateBtn=new JButton("수정");
        JButton deleteBtn=new JButton("삭제");
        p1.add(insertBtn); p1.add(viewBtn); p1.add(updateBtn); p1.add(deleteBtn);
        add(p1); 
        
        //추가 
        insertBtn.addActionListener(new ActionListener() {
            
            public void actionPerformed(ActionEvent e) {
                String sql="INSERT INTO player "
                        + "VALUES (player_seq.nextval,?,?,?,?,?)";
                try {
                    PreparedStatement ps=con.prepareStatement(sql);
                    ps.setString(1, tf[1].getText());
                    ps.setString(2, tf[2].getText());
                    ps.setDouble(3, Double.parseDouble(tf[3].getText()));
                    ps.setDouble(4, Double.parseDouble(tf[4].getText()));
                    ps.setString(5, tf[5].getText());
                    ps.executeUpdate();
                    clearText();
                    viewBtn.doClick(); //보기 버튼 안눌러도 됨
                } catch (SQLException e1) {
                    e1.printStackTrace();
                } catch (NumberFormatException n1) {
                    n1.printStackTrace();
                }
            }
        });
 
        
        //보기
        viewBtn.addActionListener(new ActionListener() {
            
            public void actionPerformed(ActionEvent e) {
                ta.setText("");
                String sql="SELECT * FROM player order by num desc";
                try {
                Statement st=con.createStatement();
                ResultSet rs=st.executeQuery(sql);
                while(rs.next()) {
                    ta.append("번호: "+rs.getInt("num")+"\n");
                    ta.append("이름: "+rs.getString("name")+"\n");
                    ta.append("생일: "+rs.getString("birth")+"\n");
                    ta.append("키: "+rs.getDouble("height")+"\n");
                    ta.append("몸무게: "+rs.getDouble("weight")+"\n");
                    ta.append("종목: "+rs.getString("kind")+"\n");
                    ta.append("\n");
                }
                } catch (SQLException e1) {
                    e1.printStackTrace();
                }
                
            }
        });
        
        //수정
        updateBtn.addActionListener(new ActionListener() {
            
            public void actionPerformed(ActionEvent e) {
                String sql="UPDATE player SET name=?, birth=?, "
                        + "height=?, weight=?,kind=? where num=?";
                try {
                    PreparedStatement ps=con.prepareStatement(sql);
                    ps.setString(1, tf[1].getText());
                    ps.setString(2, tf[2].getText());
                    ps.setDouble(3, Double.parseDouble(tf[3].getText()));
                    ps.setDouble(4, Double.parseDouble(tf[4].getText()));
                    ps.setString(5, tf[5].getText());
                    ps.setInt(6, Integer.parseInt(tf[0].getText()));
                    ps.executeUpdate();
                    clearText();
                    viewBtn.doClick();
                } catch (SQLException e1) {
                    e1.printStackTrace();
                }
            }
        });
 
        //삭제
        deleteBtn.addActionListener(new ActionListener() {
            
            public void actionPerformed(ActionEvent e) {
                int result=JOptionPane.showConfirmDialog(null, "정말 삭제할까요?",
                        "Confirm",JOptionPane.YES_NO_OPTION);
                if(JOptionPane.YES_OPTION==result) { //삭제
                    int num=Integer.parseInt(tf[0].getText());
                    try {
                        String sql="DELETE FROM player where num="+num;
                        Statement st=con.createStatement();
                        st.executeUpdate(sql);
                        clearText(); 
                        viewBtn.doClick();
                    } catch (SQLException e1) {
                        e1.printStackTrace();
                    }
                }
            }
        });
        
        JPanel p2=new JPanel(); //2행 2열
        JComboBox<String>jcb=new JComboBox<String>();
        jcb.addItem("이름");
        jcb.addItem("종목");
        JTextField searchtf=new JTextField(10);
        JButton searchBtn=new JButton("검색");
        p2.add(jcb); p2.add(searchtf); p2.add(searchBtn);
        add(p2); 
        
        //검색버튼
        searchBtn.addActionListener(new ActionListener() {
            
            public void actionPerformed(ActionEvent e) {
                
            }
        });
        
        setSize(600,400);
        setVisible(true);
        
    }
    
    class PanelPane extends JPanel {
        private String[] text= {"번호","이름","생일","키","몸무게","종목"};
        public PanelPane() {
            setLayout(null); //좌표를 내가 정하겠다.
            for(int i=0;i<text.length;i++) {
                JLabel la=new JLabel(text[i]);
                la.setHorizontalAlignment(JLabel.RIGHT);
                la.setSize(50,20);
                la.setLocation(30,50+i*20); //y좌표를 늘여야지 글자가 겹치지 않음
                add(la);
                tf[i]=new JTextField(50);
                tf[i].setHorizontalAlignment(JTextField.CENTER);
                tf[i].setSize(150,20);
                tf[i].setLocation(120, 50+i*20);
                add(tf[i]);
            }
            tf[0].setEditable(false);
        }
    }
    
    //디비연결
    private void dbCon() {
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            String url="jdbc:oracle:thin:@localhost:1521:xe"; //1521:오라클이 깔린 포트 번호
            String user="scott";
            String pwd="1234";
            con=DriverManager.getConnection(url,user,pwd);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException s) {
            s.printStackTrace();
        }
    }
    
    private void clearText() {
        for(int i=0;i<tf.length;i++) {
            tf[i].setText("");
        }
    }
    
    public static void main(String[] args) {
        new PlayerSwing();
    }
}