addstudialog.java

学生管理系统

package stu;

import java.awt.BorderLayout;
import java.awt.FlowLayout;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.SQLException;

import javax.swing.ButtonGroup;
import javax.swing.JButton;
import javax.swing.JDialog;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JRadioButton;
import javax.swing.JTextField;

public class AddStuDialog extends JDialog {

	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;

	JLabel jLabel1 = new JLabel("学号");

	JLabel jLabel2 = new JLabel("姓名");

	JLabel jLabel3 = new JLabel("语文");

	JLabel jLabel4 = new JLabel("数学");

	JLabel jLabel5 = new JLabel("英语");

	JLabel jLabel6 = new JLabel("综合");

	JTextField t1 = new JTextField(15);

	JTextField t2 = new JTextField(15);

	JTextField t3 = new JTextField(15);

	JTextField t4 = new JTextField(15);

	JTextField t5 = new JTextField(15);

	JTextField t6 = new JTextField(15);

	JRadioButton jrol = new JRadioButton("理科");

	JRadioButton jrow = new JRadioButton("文科");

	JButton jButton1 = new JButton("添加");

	JButton jButton2 = new JButton("取消");

	// jpanel
	JPanel jpanel = new JPanel();

	JPanel jpanel1 = new JPanel();

	public AddStuDialog() {
		ButtonGroup buttonGroup = new ButtonGroup();
		jpanel.setLayout(new GridLayout(7, 2));
		jpanel.add(jLabel1);
		jpanel.add(t1);
		jpanel.add(jLabel2);
		jpanel.add(t2);
		jpanel.add(jLabel3);
		jpanel.add(t3);
		jpanel.add(jLabel4);
		jpanel.add(t4);
		jpanel.add(jLabel5);
		jpanel.add(t5);
		jpanel.add(jLabel6);
		jpanel.add(t6);
		jpanel.add(jrol);
		jpanel.add(jrow);
		jrol.setSelected(true);
		buttonGroup.add(jrol);
		buttonGroup.add(jrow);

		jpanel1.add(jButton1);
		jpanel1.add(jButton2);
		jpanel1.setLayout(new FlowLayout(FlowLayout.CENTER));

		add(jpanel,BorderLayout.CENTER);
		add(jpanel1, BorderLayout.SOUTH);

		jButton1.addActionListener(new ActionListener() {

			public void actionPerformed(ActionEvent e) {
				adddata();
			}
		});
		jButton2.addActionListener(new ActionListener() {

			public void actionPerformed(ActionEvent e) {
				dispose();
			}
		});
		setTitle("添加学生信息");
	}

	public void adddata() {

		try {

			String s1 = t1.getText();
			String s2 = t2.getText();
			String s3 = t3.getText();
			String s4 = t4.getText();
			String s5 = t5.getText();
			String s6 = t6.getText();
			int f1 = Integer.parseInt(s3);
			int f2 = Integer.parseInt(s4);
			int f3 = Integer.parseInt(s5);
			int f4 = Integer.parseInt(s6);
			String s7 = (true == jrol.isSelected()) ? "l" : "w";
			ServiceFactory
					.getService()
					.executeUpdate(
							"insert into students values('"
									+ s1
									+ "','"
									+ s2
									+ "','"
									+ f1
									+ "','"
									+ f2
									+ "','"
									+ f3
									+ "','"
									+ f4
									+ "','" + s7 + "')");
			t1.setText("");
			t2.setText("");
			t3.setText("");
			t4.setText("");
			t5.setText("");
			t6.setText("");
		} catch (SQLException e) {
			System.out.println("SQLException:" + e.getMessage());
		}
		JOptionPane.showMessageDialog(null, "添加成功!", "添加成功!",
				JOptionPane.INFORMATION_MESSAGE);
	}
}