package testsystem;

import java.awt.*;
import java.sql.*;
import javax.swing.*;
import java.awt.Rectangle;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

public class tjstFrom extends JFrame {
    private ImageIcon im1 = new ImageIcon("img\\forum.gif");
    public tjstFrom() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        this.setResizable(false);
        setTitle("添加試題");
        getContentPane().setLayout(null);
        jLabel1.setToolTipText("");
        jLabel1.setHorizontalAlignment(SwingConstants.CENTER);
        jLabel1.setText("添  加  試  題");
        jLabel1.setBounds(new Rectangle(108, 3, 188, 34));
        jt5.setBounds(new Rectangle(92, 275, 82, 26));
        jLabel7.setHorizontalAlignment(SwingConstants.CENTER);
        jLabel7.setText("答案：");
        jLabel7.setBounds(new Rectangle(46, 275, 40, 26));
        jButton1.setBounds(new Rectangle(151, 314, 107, 34));
        jButton1.setIcon(im1);
        jButton1.setText("添加");
        jButton1.addActionListener(new tjstFrom_jButton1_actionAdapter(this));
        jLabel6.setHorizontalAlignment(SwingConstants.CENTER);
        jLabel6.setText("D：");
        jLabel6.setBounds(new Rectangle(43, 237, 48, 26));
        jLabel5.setHorizontalAlignment(SwingConstants.CENTER);
        jLabel5.setText("C：");
        jLabel5.setBounds(new Rectangle(43, 200, 49, 26));
        jLabel4.setHorizontalAlignment(SwingConstants.CENTER);
        jLabel4.setText("B：");
        jLabel4.setBounds(new Rectangle(43, 164, 46, 27));
        jt4.setBounds(new Rectangle(93, 238, 235, 26));
        jt3.setBounds(new Rectangle(93, 199, 236, 28));
        jt2.setToolTipText("");
        jt2.setBounds(new Rectangle(92, 163, 238, 27));
        jLabel3.setHorizontalAlignment(SwingConstants.CENTER);
        jLabel3.setText("A：");
        jLabel3.setBounds(new Rectangle(37, 127, 56, 23));
        jt1.setBounds(new Rectangle(93, 126, 237, 26));
        jLabel2.setHorizontalAlignment(SwingConstants.CENTER);
        jLabel2.setText("題目：");
        jLabel2.setBounds(new Rectangle(38, 82, 58, 29));
        txtnum.setBounds(new Rectangle(93, 36, 80, 24));
        jLabel8.setHorizontalAlignment(SwingConstants.CENTER);
        jLabel8.setText("編號：");
        jLabel8.setBounds(new Rectangle(46, 37, 42, 24));
        jLabel9.setForeground(Color.red);
        jLabel9.setText("*必須為：A，B，C，D");
        jLabel9.setBounds(new Rectangle(197, 276, 132, 24));
        ja1.setLineWrap(true);
        this.getContentPane().add(jt1);
        this.getContentPane().add(jLabel3);
        this.getContentPane().add(jt3);
        this.getContentPane().add(jt4);
        this.getContentPane().add(jLabel5);
        this.getContentPane().add(jLabel6);
        this.getContentPane().add(jt2);
        this.getContentPane().add(jLabel4);
        this.getContentPane().add(jt5);
        this.getContentPane().add(jLabel7);
        this.getContentPane().add(jButton1);
        this.getContentPane().add(jLabel1);
        this.getContentPane().add(jScrollPane1);
        jScrollPane1.getViewport().add(ja1);
        this.getContentPane().add(txtnum);
        this.getContentPane().add(jLabel8);
        this.getContentPane().add(jLabel2);
        this.getContentPane().add(jLabel9);
        jScrollPane1.setBounds(new Rectangle(93, 63, 240, 54));
    }

    public static void main(String[] args) {
        tjstFrom tjstfrom = new tjstFrom();
    }

    JLabel jLabel1 = new JLabel();
    JScrollPane jScrollPane1 = new JScrollPane();
    JTextArea ja1 = new JTextArea();
    JLabel jLabel2 = new JLabel();
    JTextField jt1 = new JTextField();
    JLabel jLabel3 = new JLabel();
    JTextField jt2 = new JTextField();
    JTextField jt3 = new JTextField();
    JTextField jt4 = new JTextField();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JLabel jLabel6 = new JLabel();
    JButton jButton1 = new JButton();
    JTextField jt5 = new JTextField();
    JLabel jLabel7 = new JLabel();
    JTextField txtnum = new JTextField();
    JLabel jLabel8 = new JLabel();
    JLabel jLabel9 = new JLabel();
    public void jButton1_actionPerformed(ActionEvent e) {
        String  num=txtnum.getText().trim();
        String timu=ja1.getText().trim();
        String A=jt1.getText().trim();
        String B=jt2.getText().trim();
        String C=jt3.getText().trim();
        String D=jt4.getText().trim();
        String answer=jt5.getText().trim();
        Connection con=null;
        Statement s1=null;
        if(num.length()!=0&&timu.length()!=0&&A.length()!=0&&B.length()!=0&&C.length()!=0&&D.length()!=0&&answer.length()!=0)
        {
            try
            {
                try
                {
                    Integer num1=Integer.parseInt(num);
                }
                catch(Exception ce)
                {
                    JOptionPane.showMessageDialog(null,"編號必須是數字！"+ce.getMessage());
                }
                con=DBcon.link();
                s1=con.createStatement();
                s1.executeUpdate("insert into Question values('"+num+"','"+timu+"','"+A+"','"+B+"','"+C+"','"+D+"','"+answer+"')");
                JOptionPane.showMessageDialog(null,"OK，添加成功！");
                int p=JOptionPane.showConfirmDialog(null,"您是否還要添加？","提示",JOptionPane.YES_NO_OPTION);
                if(p!=0)
                {
                    this.setVisible(false);
                }
                else
                {
                    txtnum.setText("");
                    ja1.setText("");
                    jt1.setText("");
                    jt2.setText("");
                    jt3.setText("");
                    jt4.setText("");
                    jt5.setText("");
                    txtnum.requestFocus();
                    return;
                }
            }
            catch(SQLException co)
            {
                co.getMessage();
            }
        }
        else
        {
            JOptionPane.showMessageDialog(null,"信息未填完整，無法添加！");
        }
    }
}


class tjstFrom_jButton1_actionAdapter implements ActionListener {
    private tjstFrom adaptee;
    tjstFrom_jButton1_actionAdapter(tjstFrom adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jButton1_actionPerformed(e);
    }
}