package manger;

import javax.swing.JDialog;
import javax.swing.JFrame;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import java.awt.BorderLayout;
import java.awt.Dimension;
import java.awt.Toolkit;

import javax.swing.JDesktopPane;
import javax.swing.JButton;
import java.awt.Rectangle;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import javax.swing.JTextField;
import javax.swing.JLabel;


public class ModForm {

	private JFrame jFrame = null;  //  @jve:decl-index=0:visual-constraint="84,10"
	private JPanel jContentPane = null;
	private JDesktopPane jDesktopPane = null;
	private JButton jButtonOK = null;
	private JButton jButtonCancel = null;
	private JTextField jTextName = null;
	private JTextField jTextNum = null;
	private JTextField jTextGrade = null;
	private JLabel jLabelName = null;
	private JLabel jLabelNum = null;
	private JLabel jLabelGrade = null;
	int Mark = MainForm.jTable.getSelectedRow();

	/**
	 * This method initializes jFrame	
	 * 	
	 * @return javax.swing.JFrame	
	 */
	JFrame getJFrame() {
		if (jFrame == null) {
			jFrame = new JFrame();
			jFrame.setTitle("修改學生信息");
			jFrame.setSize(new Dimension(242, 205));
			Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();//窗口居中顯示
			screenSize = Toolkit.getDefaultToolkit().getScreenSize();
			jFrame.setLocation((screenSize.width-jFrame.getWidth())/2,(screenSize.height-jFrame.getHeight())/2);
			jFrame.setContentPane(getJContentPane());
		}
		return jFrame;
	}

	/**
	 * This method initializes jContentPane	
	 * 	
	 * @return javax.swing.JPanel	
	 */
	private JPanel getJContentPane() {
		if (jContentPane == null) {
			jContentPane = new JPanel();
			jContentPane.setLayout(new BorderLayout());
			jContentPane.add(getJDesktopPane(), BorderLayout.CENTER);
		}
		return jContentPane;
	}

	/**
	 * This method initializes jDesktopPane	
	 * 	
	 * @return javax.swing.JDesktopPane	
	 */
	private JDesktopPane getJDesktopPane() {
		if (jDesktopPane == null) {
			jLabelGrade = new JLabel();
			jLabelGrade.setBounds(new Rectangle(30, 100, 38, 18));
			jLabelGrade.setText("班級:");
			jLabelNum = new JLabel();
			jLabelNum.setBounds(new Rectangle(30, 60, 38, 18));
			jLabelNum.setText("學號:");
			jLabelName = new JLabel();
			jLabelName.setBounds(new Rectangle(30, 20, 38, 18));
			jLabelName.setText("姓名:");
			jDesktopPane = new JDesktopPane();
			jDesktopPane.add(getJButtonOK(), null);
			jDesktopPane.add(getJButtonCancel(), null);
			jDesktopPane.add(getJTextName(), null);
			jDesktopPane.add(getJTextNum(), null);
			jDesktopPane.add(getJTextGrade(), null);
			jDesktopPane.add(jLabelName, null);
			jDesktopPane.add(jLabelNum, null);
			jDesktopPane.add(jLabelGrade, null);
		}
		return jDesktopPane;
	}

	/**
	 * This method initializes jButtonOK	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButtonOK() {
		if (jButtonOK == null) {
			jButtonOK = new JButton();
			jButtonOK.setBounds(new Rectangle(20, 135, 80, 22));
			jButtonOK.setText("提交");
			jButtonOK.addMouseListener(new java.awt.event.MouseAdapter() {
				public void mouseClicked(java.awt.event.MouseEvent e) {
					try {
						MODSQL();
					} catch (Exception e1) {
						// TODO 自動生成 catch 塊
						e1.printStackTrace();
					} // TODO Auto-generated Event stub mouseClicked()
				}

				private void MODSQL() throws Exception {
					String str = (String) MainForm.jTable.getValueAt(Mark, 1);
					String DBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
					String Str="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=StuInfo";
					Connection con=null;
					Statement stmt=null;
					ResultSet rs=null;
					Class.forName(DBDriver);
					con=DriverManager.getConnection(Str);
					stmt=con.createStatement();
					String name = jTextName.getText();
					if(name.equals(""))
					{
						stmt.close();
						con.close();
						JOptionPane.showMessageDialog(new JDialog(),"姓名不能為空!");
						return;
					}
					String num = jTextNum.getText();
					if(num.equals(""))
					{
						stmt.close();
						con.close();
						JOptionPane.showMessageDialog(new JDialog(),"學號不能為空!");
						return;
					}
					else
					{
						if(!str.equals(num))
						{
							rs = stmt.executeQuery("Select * From StuInfo where Num = '"+num+"'");
							if(rs.next())
							{
								stmt.close();
								con.close();
								JOptionPane.showMessageDialog(new JDialog(),"學號重復!");
								return;
							}
						}
					}
					String grade = jTextGrade.getText();
					stmt.executeUpdate("Update StuInfo Set Name='"+name+"',Num='"+num+"',Grade='"+grade+"' where Num='"+str+"'");
					stmt.close();
					con.close();
					MainForm.Reflesh();
					getJFrame().dispose();
					JOptionPane.showMessageDialog(new JDialog(),"修改成功!");
				}
			});
		}
		return jButtonOK;
	}

	/**
	 * This method initializes jButtonCancel	
	 * 	
	 * @return javax.swing.JButton	
	 */
	private JButton getJButtonCancel() {
		if (jButtonCancel == null) {
			jButtonCancel = new JButton();
			jButtonCancel.setBounds(new Rectangle(137, 135, 80, 22));
			jButtonCancel.setText("取消");
			jButtonCancel.addMouseListener(new java.awt.event.MouseAdapter() {
				public void mouseClicked(java.awt.event.MouseEvent e) {
					getJFrame().dispose();
				}
			});
		}
		return jButtonCancel;
	}

	/**
	 * This method initializes jTextName	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextName() {
		if (jTextName == null) {
			jTextName = new JTextField();
			jTextName.setBounds(new Rectangle(90, 20, 120, 22));
			jTextName.setText((String) MainForm.jTable.getValueAt(Mark, 0));
		}
		return jTextName;
	}

	/**
	 * This method initializes jTextNum	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextNum() {
		if (jTextNum == null) {
			jTextNum = new JTextField();
			jTextNum.setBounds(new Rectangle(90, 60, 120, 22));
			jTextNum.setText((String) MainForm.jTable.getValueAt(Mark, 1));
		}
		return jTextNum;
	}

	/**
	 * This method initializes jTextGrade	
	 * 	
	 * @return javax.swing.JTextField	
	 */
	private JTextField getJTextGrade() {
		if (jTextGrade == null) {
			jTextGrade = new JTextField();
			jTextGrade.setBounds(new Rectangle(90, 100, 120, 22));
			jTextGrade.setText((String) MainForm.jTable.getValueAt(Mark, 2));
		}
		return jTextGrade;
	}

}