addscore.java

关于学生成绩管理系统的,是比较好的.估计适合比较多的学校的

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;

class AddScore extends JFrame implements ActionListener{
	private String elesson[]=new String[200];
	private String estudent[]=new String[200];
	private JComboBox clesson;
	private JComboBox cstudent;
	private JTextField ascore=new JTextField();
	private JButton jsok=new JButton("提交");
	private JButton cancle=new JButton("返回");
	
	
	AddScore(){
		access aso=new access();
		int n=aso.requir("lessonname","lesson",elesson);
		clesson=new JComboBox(elesson);
		getContentPane().setLayout(new BorderLayout());
		getContentPane().add(new JLabel("添加成绩单",SwingConstants.CENTER),		
		BorderLayout.NORTH);
		//getContentPane().add(new JLabel("z"),BorderLayout.WEST);
		n=aso.requir("stname","student",estudent);
		cstudent=new JComboBox(estudent);
		aso.close();
		
		JPanel jcobpanel=new JPanel();
		JPanel jcobpanel2=new JPanel();
		jcobpanel.setBackground(Color.pink);
		jcobpanel2.setBackground(Color.pink);
		
		jcobpanel.setLayout(new GridLayout(0,4));
		jcobpanel.add(new JLabel(""));
		jcobpanel.add(new JLabel(""));
		jcobpanel.add(new JLabel(""));
		jcobpanel.add(new JLabel(""));
		//jcobpanel.add(new JLabel(""));
		jcobpanel.add(new JLabel("请选择课程"));
		jcobpanel.add(clesson);
		//jcobpanel.add(new JLabel(""));
		//jcobpanel.add(new JLabel(""));
		//jcobpanel.add(new JLabel(""));
		//jcobpanel.add(new JLabel(""));
		//jcobpanel.add(new JLabel(""));
		//jcobpanel.add(new JLabel(""));
		jcobpanel.add(new JLabel("请选择学生姓名"));
		jcobpanel.add(cstudent);
		jcobpanel.add(new JLabel(""));
		jcobpanel.add(new JLabel(""));
		jcobpanel.add(new JLabel(""));
		jcobpanel.add(new JLabel(""));
		jcobpanel.add(new JLabel(""));
		//jcobpanel.add(new JLabel(""));
		jcobpanel.add(new JLabel("请输入分数"));
		jcobpanel.add(ascore);
		jcobpanel2.setLayout(new BorderLayout());
		jcobpanel2.add(jcobpanel,BorderLayout.NORTH);
		getContentPane().add(jcobpanel2,BorderLayout.CENTER);
		JPanel okpanel=new JPanel();
		getContentPane().add(okpanel,BorderLayout.SOUTH);
		okpanel.add(jsok);
		okpanel.add(cancle);
		
		jsok.addActionListener(this);
		ascore.addActionListener(this);
		clesson.addActionListener(this);
		cstudent.addActionListener(this);
		cancle.addActionListener(this);	
	}
	
	public void actionPerformed(ActionEvent e){
		if(jsok==e.getSource()){
			int s=Integer.parseInt(ascore.getText());
			cstudent.getSelectedIndex();
			access ass=new access();
			ass.insert(estudent[cstudent.getSelectedIndex()],s,
			elesson[clesson.getSelectedIndex()],"score");
			ass.close();
			ascore.setText("");
			JOptionPane.showMessageDialog(null,"添加成功","",
			JOptionPane.INFORMATION_MESSAGE);
		}
		else if(cancle==e.getSource()){
			this.dispose();
		}
	}
	
	/*public static void main(String[] args){
		AddScore frame=new AddScore();
		frame.setSize(400,400);
		frame.setVisible(true);
		frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
	}*/
}