gradeframe.java

java程序 学生信息管理系统 数据库采用acce

import java.awt.*;
import java.awt.event.*;
import javax.swing.border.*;
import javax.swing.JPanel;
import javax.swing.JFrame;

/*成绩管理窗口*/ 

public class GradeFrame extends JFrame implements ActionListener,ItemListener //成绩信息窗口
  {
	  Button inquire;
	  Label lb1,lb2,mark;
	  Choice cterm,cproperty;
//	  TextField tf;
	  JPanel p1,p2;
	  String term ="",property ="";
//	  ArrayList  marks;*/
	  String studentid ;
	 GradeFrame(String studentid)
	 {
		 Container c = getContentPane();
		 this.studentid = studentid;
		 lb1 = new Label("查询学期");
		 lb2 = new Label("课程性质");
		 mark = new Label("");
	     cterm = new Choice();
		 cterm.add("");
		 cterm.add("2005-1");
		 cterm.add("2005-2");
		 cterm.add("2006-1");
	     cterm.add("2006-2"); 
	     cproperty = new Choice();
	     cproperty.add("专业课");
	     cproperty.add("公共基础课");
	     inquire = new Button("查询");
	     p1 = new JPanel();
	     p1.setLayout(new FlowLayout());
	     p1.add(lb1);
	     p1.add(cterm);
	     p1.add(lb2);
	     p1.add(cproperty);
	     p1.add(inquire);
	     c.add(p1,BorderLayout.NORTH);
	     p2 = new JPanel();
	     p2.setLayout(null);
	     mark.setBounds(10,20,100,30);
	     p2.add(mark);
	     p2.setBorder(new TitledBorder("成绩"));
         c.add(p2,BorderLayout.CENTER);
         inquire.addActionListener(this);
         cterm.addItemListener(this);
         cproperty.addItemListener(this);
		 setSize(400,400);
		 setVisible(true);
		 // setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);*/
	}
	public void actionPerformed(ActionEvent e)
	{
		 if(property.equals(""))
		 {
			 inquireMark(term);
			 mark.setText(term);    //测试
		  }
		  else
		  {
		  inquireMark(term,property);
		   mark.setText(term + property);     //测试
	      }
	}
	public void itemStateChanged(ItemEvent e1)
	{
		Choice temp;
		if(e1.getItemSelectable() instanceof Choice)
		 {
		 	if(e1.getSource() == cterm)
		 	{
			temp = (Choice)(e1.getItemSelectable());
			  term = temp.getSelectedItem();
			}
			 else {
			 temp = (Choice)(e1.getItemSelectable());
			  property = temp.getSelectedItem();	
			 }
		  }
	}
	public void inquireMark(String s)        //成绩查询方法重载
	{
		/*	Statement stmt = con.createStatement();
				stmt.executeQuery("select * from Mark where Mark.studentid = studentid and term =s ");
				ResultSet rs = stmt.getResultSet();
				while(rs.next())
				{
					GradeInfo gi = new GradeInfo();
					gi.setMark(rs.getString("mark"));
					gi.setCoursename(rs.getString("coursrname"));
					gi.setStudentname(rs.getString("studentname"));
					marks.add(gi);
				}
				Iterator i = marks.iterator();
				while(i.hasNext())
				{
					MarkInfo mark = (MarkInfo)i.next();
					....
		}*/
            return;
	}
	public void inquireMark(String s1,String s2)
	{
		/*	Statement stmt = con.createStatement();
				stmt.executeQuery("select * from Mark where Mark.studentid = studentid and term =s1 and property = s2 ");
				ResultSet rs = stmt.getResultSet();
				while(rs.next())
				{
					GradeInfo gi = new GradeInfo();
					gi.setMark(rs.getString("mark"));
					gi.setCoursename(rs.getString("coursrname"));
					gi.setStudentname(rs.getString("studentname"));
					marks.add(gi);
				}
				Iterator i = marks.iterator();
				while(i.hasNext())
				{
					MarkInfo mark = (MarkInfo)i.next();
					....
		}*/
		return;
	}
}