/*
 * modificationstu.java
 */

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

public class modifiplayer extends javax.swing.JFrame {
    MainJFrame MF=new MainJFrame();
    /** Creates new form modificationstu */
    public modifiplayer() {
        initComponents();
    }
     private void clearForm(){
    jTextField1.setText("");
    jTextField2.setText("");
    jTextField3.setText("");
    jTextField4.setText("");
    jTextField5.setText("");
    jTextField6.setText("");
    jTextField7.setText("");
   
    jTextField1.requestFocus();
      }
    
     
     public void update() {
   
     String  s2, s3, s4, s5, s6,s7,s1;
     s1 =  jTextField1.getText();
     s2 =  jTextField2.getText();
     s3 =  jTextField3.getText();
     s4 =  jTextField4.getText();
     s5 =  jTextField5.getText();
     s6 =  jTextField6.getText();
     s7 =  jTextField7.getText();
    
      if(s2.length() == 0||s3.length() == 0||s4.length() == 0||s5.length() == 0||s6.length() == 0||s7.length() == 0)
        JOptionPane.showMessageDialog(this,"請先點擊確定,然后修改數據！");
    
     else {
       try {
          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("update player set name=?,sex=?,birthday=?,home=?,shenjia=?,club=? where num=?");
          //將用戶的名字添加到具體的sql語句中
          pstmt.setString(7, s1);
          pstmt.setString(1, s2);
          pstmt.setString(2, s3);
          pstmt.setString(3, s4);
          pstmt.setString(4, s5);
          pstmt.setString(5, s6);
          pstmt.setString(6, s7);
         
         pstmt.executeUpdate();

         conn.close();
         
         JOptionPane.showMessageDialog(null, "更新成功!");
      
       }
       catch (SQLException e){
         JOptionPane.showMessageDialog(null, "更新失敗!");
            //e.printStackTrace();
       }
       catch(Exception e){
         e.printStackTrace();
       }
     }
   }
    /** 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();
        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();
        jLabel7 = new javax.swing.JLabel();
        jButton4 = new javax.swing.JButton();

        setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
        setTitle("\u4fee\u6539\u7403\u5458\u4fe1\u606f");
        setResizable(false);
        jLabel1.setFont(new java.awt.Font("宋體", 1, 18));
        jLabel1.setText("\u8bf7\u8f93\u5165\u8981\u4fee\u6539\u7403\u5458\u7684\u7f16\u53f7 ");

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

        jButton2.setText("\u53d6\u6d88 ");
        jButton2.addMouseListener(new java.awt.event.MouseAdapter() {
            public void mouseClicked(java.awt.event.MouseEvent evt) {
                jButton2MouseClicked(evt);
            }
        });

        jLabel2.setText("\u751f\u65e5\uff1a");

        jLabel3.setText("\u59d3\u540d\uff1a");

        jLabel4.setText("\u6027\u522b\uff1a");

        jLabel6.setText("\u8eab\u4ef7\uff1a");

        jLabel8.setText("\u6240\u5c5e\u4ff1\u4e50\u90e8\uff1a ");

        jButton3.setText("\u4fee\u6539");
        jButton3.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton3ActionPerformed(evt);
            }
        });

        jLabel7.setText("\u56fd\u7c4d\uff1a ");

        jButton4.setText("\u6e05\u7a7a ");
        jButton4.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton4ActionPerformed(evt);
            }
        });

        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addGroup(layout.createSequentialGroup()
                        .addGap(38, 38, 38)
                        .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addComponent(jLabel1)
                            .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                                .addGroup(javax.swing.GroupLayout.Alignment.LEADING, layout.createSequentialGroup()
                                    .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                        .addComponent(jLabel6, javax.swing.GroupLayout.Alignment.TRAILING)
                                        .addComponent(jLabel2, javax.swing.GroupLayout.Alignment.TRAILING)
                                        .addComponent(jLabel3, javax.swing.GroupLayout.Alignment.TRAILING))
                                    .addGap(34, 34, 34)
                                    .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                        .addGroup(layout.createSequentialGroup()
                                            .addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, 116, javax.swing.GroupLayout.PREFERRED_SIZE)
                                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED))
                                        .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
                                            .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                                                .addComponent(jTextField4, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, 116, Short.MAX_VALUE)
                                                .addComponent(jTextField6, javax.swing.GroupLayout.DEFAULT_SIZE, 116, Short.MAX_VALUE))