signalcount.java

Java大作业+学生成绩管理系统,采用access数据库连接。

//个人的成绩统计
//package grade;

import javax.swing.*;

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

public class SignalCount {

	/**
	 * @param args
	 */
	//	定义主框架
	private JFrame frame = new JFrame("个人成绩");
	
	//定义标签
	private JLabel JLsno = new JLabel("学号");
	private JLabel JLnet = new JLabel("网络工程");
	private JLabel JLos = new JLabel("操作系统");
	private JLabel JLcom = new JLabel("编译原理");
	private JLabel JLsoft = new JLabel("软件工程");
	private JLabel JLeng = new JLabel("专业英语");
	private JLabel JLall = new JLabel("总    分");
	private JLabel JL1 = new JLabel("排名");
	private JLabel JL2 = new JLabel("排名");
	private JLabel JL3 = new JLabel("排名");
	private JLabel JL4 = new JLabel("排名");
	private JLabel JL5 = new JLabel("排名");
	private JLabel JL6 = new JLabel("排名");
	//	定义文本框
	private JTextField JTFsno = new JTextField(10);
	private JTextField JTF1 = new JTextField(10);
	private JTextField JTF2 = new JTextField(10);
	private JTextField JTF3 = new JTextField(10);
	private JTextField JTF4 = new JTextField(10);
	private JTextField JTF5 = new JTextField(10);
	private JTextField JTF6 = new JTextField(10);
	private JTextField JTFnet = new JTextField(10);
	private JTextField JTFos = new JTextField(10);
	private JTextField JTFcom = new JTextField(10);
	private JTextField JTFsoft = new JTextField(10);
	private JTextField JTFeng = new JTextField(10);
	private JTextField JTFall= new JTextField(10);
	
	//定义按纽
	private JButton JBsearch= new JButton("查询");
	
	//	定义面板
	private Container con = frame.getContentPane();
	private JPanel panel1 = new JPanel();
	private JPanel panel2 = new JPanel();
	private JPanel panel3 = new JPanel();
	private JPanel panel4 = new JPanel();
	private JPanel panel5 = new JPanel();
	private JPanel panel6 = new JPanel();
	
//	定义数据库操作对象
	private DataManager manager = new DataManager();
	
	//构造函数
	public SignalCount(){
		
		//把组件加入面板
		panel1.setLayout(new FlowLayout());
		panel1.add(JLsno);
		panel1.add(JTFsno);
		panel1.add(JBsearch);
		//把各个科目的标签加入面板
		panel2.setLayout(new GridLayout(6,1));
		panel2.add(JLnet);
		panel2.add(JLos);
		panel2.add(JLcom);
		panel2.add(JLsoft);
		panel2.add(JLeng);
		panel2.add(JLall);
		//把文本框加入面板
		panel3.setLayout(new GridLayout(6,1));
		panel3.add(JTFnet);
		panel3.add(JTFos);
		panel3.add(JTFcom);
		panel3.add(JTFsoft);
		panel3.add(JTFeng);
		panel3.add(JTFall);
		//把排名标签加入面板
		panel4.setLayout(new GridLayout(6,1));
		panel4.add(JL1);
		panel4.add(JL2);
		panel4.add(JL3);
		panel4.add(JL4);
		panel4.add(JL5);
		panel4.add(JL6);
		//把排名文本框加入面板
		panel5.setLayout(new GridLayout(6,1));
		panel5.add(JTF1);
		panel5.add(JTF2);
		panel5.add(JTF3);
		panel5.add(JTF4);
		panel5.add(JTF5);
		panel5.add(JTF6);
		
		panel6.setLayout(new FlowLayout());
		panel6.add(panel2);
		panel6.add(panel3);
		panel6.add(panel4);
		panel6.add(panel5);
		//把面板加入主框架面板
		con.setLayout(new BorderLayout());
		con.add(panel1,BorderLayout.NORTH);
		con.add(panel6,BorderLayout.CENTER);
		
		frame.setLocation(250,250);
		frame.setSize(400,400);
		frame.setVisible(true);
		frame.setDefaultCloseOperation(frame.DISPOSE_ON_CLOSE);
		
		//增加监听器
		JBsearch.addActionListener(new ActionListener(){

			public void actionPerformed(ActionEvent arg0) {
				// TODO 自动生成方法存根
				String no = JTFsno .getText();
				manager.Search(no);
				JTFnet.setText(manager.net);
				JTFos.setText(manager.os);
				JTFcom.setText(manager.com);
				JTFsoft.setText(manager.soft);
				JTFeng.setText(manager.eng);
				JTF1.setText(manager.signalCount(no, JLnet.getText()));
				JTF2.setText(manager.signalCount(no, JLos.getText()));
				JTF3.setText(manager.signalCount(no, JLcom.getText()));
				JTF4.setText(manager.signalCount(no, JLsoft.getText()));
				JTF5.setText(manager.signalCount(no, JLeng.getText()));
				//设置总分的文本框
				int sum = 0;
				sum = Integer.parseInt(manager.net) + Integer.parseInt(manager.os) + Integer.parseInt(manager.com)
						+Integer.parseInt(manager.soft)+Integer.parseInt(manager.eng);
				JTFall.setText(Integer.toString(sum));
			}});
		
	}
	
	public static void main(String[] args) {
		// TODO 自动生成方法存根
		SignalCount a = new SignalCount();
	}

}