/*
 * ChanClassJFrame.java
 *
 * Created on 2006年5月25日, 下午10:14
 */

package stucontrol;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.*;
import javax.swing.*;
/**
 *
 * @author  min
 */
public class ChanClassJFrame extends javax.swing.JFrame {
    
    /** Creates new form ChanClassJFrame */
    public ChanClassJFrame() {
        initComponents();
        init();
    }
    
    /** 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() {
        jPanel1 = new javax.swing.JPanel();
        jLabel1 = new javax.swing.JLabel();
        jLabel2 = new javax.swing.JLabel();
        jLabel3 = new javax.swing.JLabel();
        jTextField1 = new javax.swing.JTextField();
        jTextField2 = new javax.swing.JTextField();
        jTextField3 = new javax.swing.JTextField();
        jLabel4 = new javax.swing.JLabel();
        jTextField4 = new javax.swing.JTextField();
        jButton1 = new javax.swing.JButton();
        jButton2 = new javax.swing.JButton();

        setTitle("\u5b66\u751f\u4fe1\u606f\u7ba1\u7406\u7cfb\u7edf");
        jLabel1.setText("\u5b66\u751f\u5b66\u53f7\uff1a");

        jLabel2.setText("\u6240\u5728\u73ed\u7ea7\uff1a");

        jLabel3.setText("\u8f6c\u5165\u73ed\u7ea7\uff1a");

        jLabel4.setText("\u6240\u5728\u5e74\u7ea7\uff1a");

        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.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton2ActionPerformed(evt);
            }
        });

        org.jdesktop.layout.GroupLayout jPanel1Layout = new org.jdesktop.layout.GroupLayout(jPanel1);
        jPanel1.setLayout(jPanel1Layout);
        jPanel1Layout.setHorizontalGroup(
            jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(jPanel1Layout.createSequentialGroup()
                .add(31, 31, 31)
                .add(jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                    .add(jPanel1Layout.createSequentialGroup()
                        .add(29, 29, 29)
                        .add(jButton1)
                        .add(32, 32, 32)
                        .add(jButton2))
                    .add(jPanel1Layout.createSequentialGroup()
                        .add(jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.TRAILING)
                            .add(jLabel3)
                            .add(jLabel4)
                            .add(jLabel2)
                            .add(jLabel1))
                        .add(26, 26, 26)
                        .add(jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING, false)
                            .add(jTextField1, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 115, Short.MAX_VALUE)
                            .add(jTextField4)
                            .add(jTextField2)
                            .add(jTextField3))))
                .addContainerGap(94, Short.MAX_VALUE))
        );
        jPanel1Layout.setVerticalGroup(
            jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(jPanel1Layout.createSequentialGroup()
                .addContainerGap()
                .add(jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(jLabel1)
                    .add(jTextField1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
                .add(5, 5, 5)
                .add(jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(jLabel4)
                    .add(jTextField4, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                .add(jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(jLabel2)
                    .add(jTextField2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                .add(jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(jLabel3)
                    .add(jTextField3, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED, 16, Short.MAX_VALUE)
                .add(jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(jButton2)
                    .add(jButton1))
                .addContainerGap())
        );
        getContentPane().add(jPanel1, java.awt.BorderLayout.CENTER);

        pack();
    }// </editor-fold>//GEN-END:initComponents

    private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton2ActionPerformed
// TODO 將在此處添加您的處理代碼：
        jTextField1.setText(""); jTextField2.setText("");
         jTextField3.setText(""); jTextField4.setText("");
         
    }//GEN-LAST:event_jButton2ActionPerformed

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed
// TODO 將在此處添加您的處理代碼：
        doAction();
         jTextField1.setText(""); jTextField2.setText("");
         jTextField3.setText(""); jTextField4.setText("");
         
    }//GEN-LAST:event_jButton1ActionPerformed
        public void init(){
    String url = "jdbc:odbc:stu"; 
String username = ""; 
String password = ""; 
//加載驅動程序以連接數據庫 

try { 
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" ); 
connection = DriverManager.getConnection( 
url, username, password ); 
} 

//捕獲加載驅動程序異常 
catch ( ClassNotFoundException cnfex ) { 
System.err.println( 
"裝載 JDBC/ODBC 驅動程序失敗。" ); 
cnfex.printStackTrace(); 
System.exit( 1 ); // terminate program 
} 

//捕獲連接數據庫異常 
catch ( SQLException sqlex ) { 
System.err.println( "無法連接數據庫" ); 
sqlex.printStackTrace(); 
System.exit( 1 ); // terminate program 
} 
    
    }
        
  public void doAction(){
  if(!rearchStu())return;
   String query="update stu set 班級='"+jTextField3.getText()+"'where 學號='"+jTextField1.getText()+"' and 年級='"
                    +jTextField4.getText()+"' and 班級='"+jTextField2.getText()+"'";
             try { 
                        //執行SQL語句 
                  statement = connection.createStatement(); 
                  resultSet = statement.executeQuery(query); 
                } 
                catch ( SQLException sqlex ) { 
                }
     JOptionPane.showMessageDialog( this, "轉班成功！！" );
  }
  
  public boolean rearchStu(){
    String query="select * from stu where 學號='"+jTextField1.getText()+"' and 年級='"
                    +jTextField4.getText()+"' and 班級='"+jTextField2.getText()+"'";
                 try { 
                        //執行SQL語句 
                  statement = connection.createStatement(); 
                  resultSet = statement.executeQuery(query); 
                    if(!resultSet.next()){
               JOptionPane.showMessageDialog( this, "輸入有誤！！" );
               return false;
              }
                } 
                catch ( SQLException sqlex ) { 
                }
            return true;
  }
    /**
     * @param args the command line arguments
     */
  /*
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new ChanClassJFrame().setVisible(true);
            }
        });
    }*/
    
    // 變量聲明 - 不進行修改//GEN-BEGIN:variables
    private javax.swing.JButton jButton1;
    private javax.swing.JButton jButton2;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JTextField jTextField1;
    private javax.swing.JTextField jTextField2;
    private javax.swing.JTextField jTextField3;
    private javax.swing.JTextField jTextField4;
    // 變量聲明結束//GEN-END:variables

    private Connection connection;
    private Statement statement; 
    private ResultSet resultSet; 
}