/*
 * deletestu.java
 *
 *
 */

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

public class deleteplayer extends javax.swing.JFrame {
    
     MainJFrame MF=new MainJFrame();
    /** Creates new form deletestu */
    public deleteplayer() {
        initComponents();
    }
    
    
    private void del(){
      try{
          String num;
          num=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");
       
        String sql = "DELETE FROM player WHERE num='" + num + "'";
        PreparedStatement ps = conn.prepareStatement(sql);
       
        ps.executeUpdate();
        conn.close();
       JOptionPane.showMessageDialog(null,"刪除成功!");
        
        jTextField1.setText("");
        jTextField1.requestFocus();
     }
      catch(SQLException e){
         System.out.println("E Code"+ e.getErrorCode());
         System.out.println("E M="+e.getMessage());
      }
      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();

        setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
        setTitle("\u5220\u9664\u7403\u5458\u4fe1\u606f ");
        setResizable(false);
        jLabel1.setFont(new java.awt.Font("宋體", 1, 18));
        jLabel1.setText("\u8bf7\u8f93\u5165\u8981\u5220\u9664\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);
            }
        });

        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.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                        .addGroup(layout.createSequentialGroup()
                            .addContainerGap()
                            .addComponent(jButton1)
                            .addGap(65, 65, 65)
                            .addComponent(jButton2))
                        .addGroup(javax.swing.GroupLayout.Alignment.LEADING, layout.createSequentialGroup()
                            .addGap(98, 98, 98)
                            .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, 176, javax.swing.GroupLayout.PREFERRED_SIZE)))
                    .addGroup(layout.createSequentialGroup()
                        .addGap(72, 72, 72)
                        .addComponent(jLabel1)))
                .addContainerGap(76, Short.MAX_VALUE))
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addGap(29, 29, 29)
                .addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 34, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(33, 33, 33)
                .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(42, 42, 42)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jButton2)
                    .addComponent(jButton1))
                .addContainerGap(38, Short.MAX_VALUE))
        );
        pack();
    }// </editor-fold>//GEN-END:initComponents

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed
// 刪除學生信息
        del();
    }//GEN-LAST:event_jButton1ActionPerformed

    private void jButton2MouseClicked(java.awt.event.MouseEvent evt) {//GEN-FIRST:event_jButton2MouseClicked
// TODO 將在此處添加您的處理代碼：
         MF.setVisible(true);
        this.setVisible(false);
    }//GEN-LAST:event_jButton2MouseClicked
    
    /**
     * @param args the command line arguments
     */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new deleteplayer().setVisible(true);
            }
        });
    }
    
    // 變量聲明 - 不進行修改//GEN-BEGIN:variables
    private javax.swing.JButton jButton1;
    private javax.swing.JButton jButton2;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JTextField jTextField1;
    // 變量聲明結束//GEN-END:variables
    
}