package com.jm;

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

import javax.swing.*;

import com.lj.LianJie;


public class Sckcframe {

	JFrame frame;
	JPanel p1,p2,p3;
	JLabel l1,l2;
	JComboBox c1;
	JButton b1,b2;
	
	public void setsckcframe() {
		frame = new JFrame();
		frame.setLocation(300,300);
		frame.setSize(400, 200);
		frame.setTitle("刪除課程窗口");
		frame.setLayout(new GridLayout(3,1));
		
		p1 = new JPanel();
		p2 = new JPanel();
		p3 = new JPanel();
		p1.setBackground(Color.white);
		p2.setBackground(Color.white);
		p3.setBackground(Color.white);
		frame.add(p1);
		frame.add(p2);
		frame.add(p3);
		l1 = new JLabel("請慎重選擇你想刪除的課程項:");
		c1 = new JComboBox();
		LianJie lj=new LianJie();
		ResultSet rs=lj.select("select *from kc");
		try {
			while(rs.next()){
				c1.addItem(rs.getString("kcmc"));
			}
		} catch (SQLException e1) {
			e1.printStackTrace();
		}
		lj.closeConn();
		p1.add(l1);
		p1.add(c1);
		b1 = new JButton("確定");
		b1.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				LianJie lj = new LianJie();
				String sql = "delete from kc where kcmc = ''";
				lj.Update(sql);
				frame.dispose();
			}
		});
		b2 = new JButton("取消");
		b2.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				frame.dispose();
			}
		});
		p2.add(b1);
		p2.add(b2);
		l2 = new JLabel("提示:你的操作將不可更改!");
		p3.add(l2);
		
		frame.setDefaultCloseOperation(JFrame.HIDE_ON_CLOSE);
		frame.setResizable(false);
		frame.setVisible(true);
		
	}
	
}