/*
 * Querystu.java
 *
 */
package playermanager;
import java.sql.*;
import javax.swing.JOptionPane;

public class Queryplayer extends javax.swing.JFrame {
    MainJFrame MF=new MainJFrame();
    /** Creates new form Querystu */
    public Queryplayer() {
        initComponents();
    }
    String snum;
    
   private void Find(){ 
       
    
       
         double sum=0;
        switch(jComboBox1.getSelectedIndex())
        {
            case 0:
                try{
                 String s;
                s=jTextField1.getText();
               Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();
               String url="jdbc:sqlserver://127.0.0.1:1433;";
               Connection conn=DriverManager.getConnection(url,"sa","123");
                conn.setCatalog("data");
                 PreparedStatement pstmt = conn.prepareStatement("select num,name,sex,home,shenjia,club,birthday from player" +
                " where num=?");
                //將用戶的名字添加到具體的sql語句中
                  pstmt.setString(1, s);
                  ResultSet res = pstmt.executeQuery(); 
                   if (!res.next()) {
                      JOptionPane.showMessageDialog(this, "球員編號錯誤，此球員不存在！", "錯誤提示",
                                      JOptionPane.ERROR_MESSAGE);
              }else {
                      
                      
                    jTextField2.setText(res.getString("name")); 
                    jTextField3.setText(res.getString("sex"));  
                     
                    jTextField5.setText(res.getString("club"));  
                    jTextField6.setText(res.getString("birthday"));  
                    jTextField7.setText(res.getString("home"));  
                    //jTextField8.setText(res.getString("dtel"));  
                    jTextField9.setText(res.getString("num"));
                    jTextField4.setText(res.getString("shenjia")); 
      
             }
      
              pstmt.close();
               conn.close();
    
              }catch (InstantiationException e) {
            System.out.println(e.getMessage());
            }catch (IllegalAccessException e) {
              System.out.println(e.getMessage());
              }catch (ClassNotFoundException e) {
             System.out.println(e.getMessage());
            }catch(SQLException e){
            System.out.println("Error Code "+ e.getErrorCode());
              System.out.println("Erroe MMessage="+e.getMessage());
           }
           catch(Exception e){
             e.printStackTrace();
             }
                     break;
            
            case 1:
                    try{
                       String s;
                       s=jTextField1.getText();
               Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();
               String url="jdbc:sqlserver://127.0.0.1:1433;";
               Connection conn=DriverManager.getConnection(url,"sa","123");
                conn.setCatalog("data");
                   PreparedStatement pstmt = conn.prepareStatement("select num,name,sex,home,shenjia,club,birthday from player" +
                " where name=?");
              //將用戶的名字添加到具體的sql語句中
               pstmt.setString(1, s);  
               ResultSet res = pstmt.executeQuery();
                if (!res.next()) {
                      JOptionPane.showMessageDialog(this, "姓名錯誤，此學生不存在！", "錯誤提示",
                                      JOptionPane.ERROR_MESSAGE);
              }else {
                    jTextField2.setText(res.getString("name")); 
                    jTextField3.setText(res.getString("sex"));  
                     
                    jTextField5.setText(res.getString("club"));  
                    jTextField6.setText(res.getString("birthday"));  
                    jTextField7.setText(res.getString("home"));  
                    //jTextField8.setText(res.getString("dtel"));  
                    jTextField9.setText(res.getString("num"));
                    jTextField4.setText(res.getString("shenjia")); 
             }
      
               pstmt.close();
               conn.close();
    
              }catch (InstantiationException e) {
            System.out.println(e.getMessage());
            }catch (IllegalAccessException e) {
              System.out.println(e.getMessage());
              }catch (ClassNotFoundException e) {
             System.out.println(e.getMessage());
            }catch(SQLException e){
            System.out.println("Error Code "+ e.getErrorCode());
              System.out.println("Erroe MMessage="+e.getMessage());
           }
           catch(Exception e){
             e.printStackTrace();
             }
                       break;
 
           }
        
 
         //使用ResultSet中的方法executeQuery()來完成sql語句的執行
           
        
       
          
}
   
   private void clearForm(){
    jTextField1.setText("");
    jTextField2.setText("");
    jTextField3.setText("");
    jTextField4.setText("");
    jTextField5.setText("");
    jTextField6.setText("");
    jTextField7.setText("");
    //jTextField8.setText("");
    jTextField9.setText("");
    jTextField1.requestFocus();
      }
    
    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    // <editor-fold defaultstate="collapsed" desc=" 生成的代碼 ">//GEN-BEGIN:initComponents
    private void initComponents() {
        jLabel1 = new javax.swing.JLabel();
        jTextField1 = new javax.swing.JTextField();
        jButton1 = new javax.swing.JButton();
        jButton2 = new javax.swing.JButton();
        jLabel2 = new javax.swing.JLabel();
        jLabel3 = new javax.swing.JLabel();
        jLabel4 = new javax.swing.JLabel();
        jLabel5 = new javax.swing.JLabel();
        jLabel6 = new javax.swing.JLabel();
        jLabel8 = new javax.swing.JLabel();
        jTextField2 = new javax.swing.JTextField();
        jTextField3 = new javax.swing.JTextField();
        jTextField4 = new javax.swing.JTextField();
        jTextField5 = new javax.swing.JTextField();
        jTextField6 = new javax.swing.JTextField();
        jTextField7 = new javax.swing.JTextField();
        jButton3 = new javax.swing.JButton();
        jComboBox1 = new javax.swing.JComboBox();
        jLabel9 = new javax.swing.JLabel();
        jTextField9 = new javax.swing.JTextField();

        setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
        setTitle("\u7403\u5458\u4fe1\u606f\u67e5\u8be2 ");
        setResizable(false);
        jLabel1.setFont(new java.awt.Font("宋體", 1, 18));
        jLabel1.setText("\u8bf7\u9009\u62e9\u67e5\u8be2\u6761\u4ef6\u5e76\u8f93\u5165:   ");

        jButton1.setText("\u67e5\u8be2");
        jButton1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton1ActionPerformed(evt);
            }
        });