package com.jm;

import java.awt.*;
import java.awt.event.*;

import javax.swing.*;

import com.lj.LianJie;


//定義成績錄入界面
public class Cjlrframe {
	JFrame frame;
	JPanel p1,p2,p3,p4;
	JTextField t1,t2;
	JButton b1,b2;
	
	public void setcjlrframe() {
		frame = new JFrame();
		frame.setLocation(200,300);
		frame.setSize(300, 200);
		frame.setTitle("成績錄入");
		frame.setLayout(new GridLayout(4,1));
		
		p1 = new JPanel();
		p2 = new JPanel();
		p3 = new JPanel();
		p4 = new JPanel();
		
		p1.setBackground(Color.white);
		p2.setBackground(Color.white);
		p3.setBackground(Color.white);
		p4.setBackground(Color.white);
		
		frame.add(p1);
		frame.add(p2);
		frame.add(p3);
		frame.add(p4);
		
		p1.add(new JLabel("請輸入成績信息:"));
		t1 = new JTextField(10);
		p2.add(new JLabel("姓名:"));
		p2.add(t1);
		
		t2 = new JTextField(10);
		p3.add(new JLabel("成績:"));
		p3.add(t2);
		
		b1 = new JButton("提交");
		b1.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				LianJie lj = new LianJie();
//				String sql = "insert into xs (fs) values ('"+t2.getText()+"') where xm = '"+t1.getText()+"'";
				String sql = "insert into cj (xm,fs) values ('"+t1.getText()+"','"+t2.getText()+"')";
				lj.Update(sql);
				frame.dispose();
			}
		});
		b2 = new JButton("取消");
		b2.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				frame.dispose();
			}
		});
		p4.add(b1);
		p4.add(b2);
		
		frame.setDefaultCloseOperation(JFrame.HIDE_ON_CLOSE);
		frame.setResizable(false);
		frame.setVisible(true);
	}
}