newstudent.java

使用java编写的一个学生选课系统

package Srs;

import java.awt.Color;
import java.awt.ComponentOrientation;
import java.awt.Font;
import java.awt.TextField;
import java.awt.event.ActionEvent;
import java.awt.event.ItemListener; 
import java.awt.event.ItemEvent;
import java.awt.event.ActionListener;
import javax.swing.*;
import java.net.*;
import Srs.LinkDatabase;
import Srs.MajorSrs;
import java.sql.*;


public class NewStudent extends JFrame implements ActionListener,ItemListener{

	private JComboBox comboBox_3;
	private JComboBox comboBox_2;
	private JComboBox comboBox_1;
	private JComboBox comboBox;
	private JTextField textField_4;
	private JTextField textField_1;
	private JTextField textField;
	private JButton button;
	private JButton button_1;
	private JButton button_2;
	private String string_sex,string_year,string_month,string_date;
	private String Id_0;
	/**
	 * Launch the application
	 * @param args
	 */

	/**
	 * Create the frame
	 */
	public NewStudent(String Id){
		super();
		Id_0 = Id;
		this.setLocationRelativeTo(null);
		this.init();
	}
	public void init() {
		getContentPane().setLayout(null);
		setBounds(100, 100, 500, 375);
		this.setLocationRelativeTo(null);
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

		JLabel label = new JLabel();
		label.setFont(new Font("楷体_GB2312", Font.BOLD, 36));
		label.setText("个人信息修改");
		label.setBounds(135, 23, 235, 36);
		getContentPane().add(label);

		JLabel label_1 = new JLabel();
		label_1.setFont(new Font("楷体_GB2312", Font.BOLD, 18));
		label_1.setText("学号：");
		label_1.setBounds(100, 114, 66, 18);
		getContentPane().add(label_1);

		JLabel label_2 = new JLabel();
		label_2.setFont(new Font("楷体_GB2312", Font.BOLD, 18));
		label_2.setText("出生日期：");
		label_2.setBounds(100, 186, 95, 18);
		getContentPane().add(label_2);

	    JLabel label_4 = new JLabel();
		label_4.setFont(new Font("楷体_GB2312", Font.BOLD, 18));
		label_4.setText("姓名：");
		label_4.setBounds(100, 138, 66, 18);
		getContentPane().add(label_4);

		JLabel label_5 = new JLabel();
		label_5.setFont(new Font("楷体_GB2312", Font.BOLD, 18));
		label_5.setText("性别：");
		label_5.setBounds(100, 162, 66, 18);
		getContentPane().add(label_5);

		JLabel label_7 = new JLabel();
		label_7.setFont(new Font("楷体_GB2312", Font.BOLD, 18));
		label_7.setText("家庭住址：");
		label_7.setBounds(100, 210, 95, 18);
		getContentPane().add(label_7);

		textField = new JTextField();
		textField.setBounds(222, 110, 228, 22);
		textField.setEditable(false);
		textField.setText(Id_0);
		getContentPane().add(textField);

		textField_1 = new JTextField();
		textField_1.setBounds(222, 134, 228, 22);
		getContentPane().add(textField_1);

		textField_4 = new JTextField();
		textField_4.setBounds(222, 211, 228, 22);
		getContentPane().add(textField_4);

		comboBox = new JComboBox();
		comboBox.setModel(new DefaultComboBoxModel(new String[] {"", "Man", "Woman"}));
		comboBox.setBounds(222, 158, 228, 22);
		getContentPane().add(comboBox);
		comboBox.addItemListener(this);

		comboBox_1 = new JComboBox();
		comboBox_1.setKeySelectionManager(null);
		comboBox_1.setInputVerifier(null);
		comboBox_1.setEditor(null);
		comboBox_1.setComponentPopupMenu(null);
		comboBox_1.setModel(new DefaultComboBoxModel(new String[] {"", "1978", "1979", "1980", "1981", "1982", "1983", "1984", "1985", "1986", "1987", "1988", "1989", "1990", "1991", "1992", "1993", "1994", "1995", "1996", "1997", "1998"}));
		comboBox_1.setBounds(222, 184, 66, 22);
		getContentPane().add(comboBox_1);
		comboBox_1.addItemListener(this);

		comboBox_2 = new JComboBox();
		comboBox_2.setModel(new DefaultComboBoxModel(new String[] {"", "1", "2", "3", "4", "5", "6", "7", "8", "9", "10", "11", "12"}));
		comboBox_2.setBounds(313, 184, 43, 22);
		getContentPane().add(comboBox_2);
		comboBox_2.addItemListener(this);

		comboBox_3 = new JComboBox();
		comboBox_3.setModel(new DefaultComboBoxModel(new String[] {"", "1", "2", "3", "4", "5", "6", "7", "8", "9", "10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20", "21", "22", "23", "24", "25", "26", "27", "28", "29", "30", "31"}));
		comboBox_3.setBounds(382, 184, 43, 22);
		getContentPane().add(comboBox_3);
		comboBox_3.addItemListener(this);

		JLabel label_8 = new JLabel();
		label_8.setFont(new Font("楷体_GB2312", Font.BOLD, 18));
		label_8.setText("年");
		label_8.setBounds(294, 184, 19, 22);
		getContentPane().add(label_8);

		JLabel label_9 = new JLabel();
		label_9.setFont(new Font("楷体_GB2312", Font.BOLD, 18));
		label_9.setText("月");
		label_9.setBounds(362, 184, 19, 22);
		getContentPane().add(label_9);

		JLabel label_10 = new JLabel();
		label_10.setFont(new Font("楷体_GB2312", Font.BOLD, 18));
		label_10.setText("日");
		label_10.setBounds(431, 184, 19, 22);
		getContentPane().add(label_10);

		
		button = new JButton();	
		button.setFont(new Font("楷体_GB2312", Font.BOLD, 18));
		button.setText("确认");
		button.setBounds(159, 290, 86, 28);
		getContentPane().add(button);
		button.addActionListener(this);

		button_1 = new JButton();
		button_1.setFont(new Font("楷体_GB2312", Font.BOLD, 18));
		button_1.setText("取消");
		button_1.setBounds(301, 290, 86, 28);
		getContentPane().add(button_1);
		button_1.addActionListener(this);

		final JLabel label_12 = new JLabel();
		label_12.setForeground(new Color(255, 0, 0));
		label_12.setComponentOrientation(ComponentOrientation.RIGHT_TO_LEFT);
		label_12.setText("*");
		label_12.setBounds(28, 117, 66, 18);
		getContentPane().add(label_12);

		final JLabel label_13 = new JLabel();
		label_13.setForeground(new Color(255, 0, 0));
		label_13.setComponentOrientation(ComponentOrientation.RIGHT_TO_LEFT);
		label_13.setText("*");
		label_13.setBounds(28, 141, 66, 18);
		getContentPane().add(label_13);

		final JLabel label_14 = new JLabel();
		label_14.setForeground(new Color(255, 0, 0));
		label_14.setComponentOrientation(ComponentOrientation.RIGHT_TO_LEFT);
		label_14.setText("*");
		label_14.setBounds(28, 165, 66, 18);
		getContentPane().add(label_14);

		final JLabel label_15 = new JLabel();
		label_15.setForeground(new Color(255, 0, 0));
		label_15.setComponentOrientation(ComponentOrientation.RIGHT_TO_LEFT);
		label_15.setText("*");
		label_15.setBounds(28, 189, 66, 18);
		getContentPane().add(label_15);

		button_2 = new JButton();
		button_2.setText("返回");
		button_2.setBounds(421, 315, 61, 18);
		getContentPane().add(button_2);
		button_2.addActionListener(this);
		//
	}
	public String getId(){
		return textField.getText();
	}
	public String getName(){
		return textField_1.getText();
	}
	public String getAddress(){
		return textField_4.getText();
	}
	public void itemStateChanged(ItemEvent e){
		if(e.getSource() == comboBox){
			string_sex = ((String)e.getItem());
		}
		else if(e.getSource() == comboBox_1){
			string_year = ((String)e.getItem());
		}
		else if(e.getSource() == comboBox_2){
			string_month = ((String)e.getItem());
		}
		else if(e.getSource() == comboBox_3){
			string_date = ((String)e.getItem());
		}
	}
	public String getstring_sex(){
		return string_sex;
	}
	public String getstring_year(){
		return string_year;
	}
	public String getstring_month(){
		return string_month;
	}
	public String getstring_date(){
		return string_date;
	}
	public String quotate(String content){
        return "'"+content+"'";
    }
public void actionPerformed(ActionEvent e){
		if(e.getSource() == button){
			if(this.getId()==null||this.getName() == null||
					string_sex == null|| string_year == null||
					string_month == null||string_date == null){
				JOptionPane newone = new JOptionPane();
				newone.showMessageDialog(null, "‘*’为必填项，请将信息补充完整");
			}
			else{
				try{
					LinkDatabase linkDatabase = new LinkDatabase();
				    Connection connection = linkDatabase.getlink();
				    Statement statement = connection.createStatement();
				    String sql_1 = "update students set name = " +
				    		quotate(this.getName())+"where id = '"+Id_0+"'";
				    
				    
				    String sql_2 = "update students set sex = " +
		    		quotate(this.getstring_sex())+"where id = '"+Id_0+"'";
				    String sql_3 = "update students set address = " +
		    		quotate(this.getAddress())+"where id = '"+Id_0+"'";
                    statement.execute(sql_1);
				    statement.execute(sql_2);
				    statement.execute(sql_3);
				    JOptionPane newone = new JOptionPane();
					newone.showMessageDialog(null, "注册成功");
				    }catch(SQLException e1){
						e1.printStackTrace();
					}
			}
				
	}
		else if(e.getSource() == button_1){
			textField_1.setText("");
			textField_4.setText("");
		}
		else if(e.getSource() == button_2){
			this.dispose();
			MajorSrs majorSrs = new MajorSrs();
			majorSrs.setVisible(true);
		}
		

}
}