package com.jm;

import java.awt.*;
import java.awt.event.*;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.swing.*;

import com.lj.LianJie;


//定義報名界面
public class Bmframe {
	
	JFrame frame;
	JPanel p1,p2,p3,p4,p5,p6,p7;
	JLabel l1,l2,l3,l4,l5,l6;
	JTextField t1,t2,t3;
	JComboBox ch;
	JButton b1,b2;
	
	public void setbmframe() {
		
		CheckboxGroup radioGroup = new CheckboxGroup();

		frame = new JFrame();
		frame.setLocation(300,300);
		frame.setSize(300, 400);
		frame.setTitle("報名窗口");
		frame.setLayout(new GridLayout(8,1));
	
		p1 = new JPanel();
		p2 = new JPanel();
		p3 = new JPanel();
		p4 = new JPanel();
		p5 = new JPanel();
		p6 = new JPanel();
		p7 = new JPanel();
		p1.setBackground(Color.white);
		p2.setBackground(Color.white);
		p3.setBackground(Color.white);
		p4.setBackground(Color.white);
		p5.setBackground(Color.white);
		p6.setBackground(Color.white);
		p7.setBackground(Color.white);
		frame.add(p1);
		frame.add(p2);
		frame.add(p3);
		frame.add(p4);
		frame.add(p5);
		frame.add(p6);
		frame.add(p7);

		l1 = new JLabel("請填入相關內容:");
		l2 = new JLabel("學號:");
		t1 = new JTextField(10);
		l3 = new JLabel("姓名:");
		t2 = new JTextField(10);
		l4 = new JLabel("性別:");
		
		l5 = new JLabel("班級:");
		t3 = new JTextField(10);
		l6 = new JLabel("選擇課程:");
		
		p1.add(l1);
		p2.add(l2);
		p2.add(t1);
		p3.add(l3);
		p3.add(t2);
		p4.add(l4);
		p4.add(new Checkbox("男",radioGroup,true));
		p4.add(new Checkbox("女",radioGroup,false));
		p5.add(l5);
		p5.add(t3);
		p6.add(l6);
		ch = new JComboBox();
		LianJie lj=new LianJie();
		ResultSet rs=lj.select("select *from kc");
		try {
			while(rs.next()){
				ch.addItem(rs.getString("kcmc"));
			}
		} catch (SQLException e1) {
			e1.printStackTrace();
		}
		lj.closeConn();
		p6.add(ch);

		b1 = new JButton("登錄");
		b1.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				LianJie lj = new LianJie();
				String sql = "insert into xs (xh,xm,bj) values ('"+t1.getText()+"','"+t2.getText()+"','"+t3.getText()+"')";
				lj.Update(sql);
				frame.dispose();
			}
		});
		
		b2 = new JButton("取消");
		b2.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				frame.dispose();
			}
		});
		p7.add(b1);
		p7.add(b2);
		
		
		frame.setDefaultCloseOperation(JFrame.HIDE_ON_CLOSE);
		frame.setResizable(false);
		frame.setVisible(true);
	}
}