scoresystem.java

学生成绩管理系统,主要统计和查询学生的成绩

			TextScore.setText("");
			stmt.close();
			con.close();
		}
		catch(SQLException ex)
		{
			System.out.println("\nERROR:-----SQLEXCEPTION------\n");
			while(ex!=null)
			{
				System.out.println("Message:"+ ex.getMessage());
				System.out.println("SQLState:"+ ex.getSQLState());
				System.out.println("ErrorCode:"+ ex.getErrorCode());
				ex = ex.getNextException();
			}
		}
	}
	public void FindAccess()              //查找Table
	{
		LinkAccess();
		try{
			Connection con = DriverManager.getConnection("jdbc:odbc:Student");
			Statement stmt = con.createStatement();
			String sql;
			if(FindList.getSelectedItem()=="学号")
			     sql="select * from "+Scourse+" where ID='"+TextFind.getText()+"'order by ID ;";
			  else
			     sql="select * from "+Scourse+" where Name='"+TextFind.getText()+"'order by Score desc;";
			ResultSet rSet=stmt.executeQuery(sql);//将查询得到的结果集给rs
			vector.removeAllElements();              //初始化向量对象
			tm.fireTableStructureChanged();          //更新表格内容
			while(rSet.next())
			{
				Vector rec_vector = new Vector();
				rec_vector.addElement(rSet.getString(1));
				rec_vector.addElement(rSet.getString(2));
				rec_vector.addElement(String.valueOf(rSet.getString(3)));
				vector.addElement(rec_vector);
			}
			tm.fireTableStructureChanged();
			System.out.println("查找成功!");
			State.setText("查找成功");
			stmt.close();
			con.close();
			}
		catch(SQLException ex)
		{
			System.out.println("\nERROR:-----SQLEXCEPTION------\n");
			System.out.println("查找不成功!");
			State.setText("查找不成功");
			while(ex!=null)
			{
				System.out.println("Message:"+ ex.getMessage());
				System.out.println("SQLState:"+ ex.getSQLState());
				System.out.println("ErrorCode:"+ ex.getErrorCode());
				ex = ex.getNextException();
			}
		}
	}
	
	public void ReworkAccess()                  //修改table
	{
		LinkAccess();
		try
		{
			Connection con = DriverManager.getConnection("jdbc:odbc:Student");
			Statement stmt = con.createStatement();
			String sql="update "+Scourse+" set ID='"+TextNO.getText()+"',Name='"+TextName.getText()+"',Score="+Integer.parseInt(TextScore.getText())+" where ID='"+no+"'";
			stmt.executeUpdate(sql);
			System.out.println("修改成功!");
			State.setText("修改成功!");
			no = TextNO.getText();
			name = TextName.getText();
			score = TextScore.getText();
			stmt.close();
			con.close();
		}
		catch(SQLException ex)
		{
			System.out.println("\nERROR:-----SQLEXCEPTION------\n");
			while(ex!=null)
			{
				System.out.println("Message:"+ ex.getMessage());
				System.out.println("SQLState:"+ ex.getSQLState());
				System.out.println("ErrorCode:"+ ex.getErrorCode());
				ex = ex.getNextException();
			}
		}
	}
	
	public void DelAccess()
	{
		LinkAccess();
		try
		{
			Connection con = DriverManager.getConnection("jdbc:odbc:Student");
			Statement stmt = con.createStatement();
			String sql="delete from "+Scourse+" where ID='"+TextNO.getText()+"'and Name='"+TextName.getText()+"';";
			stmt.executeUpdate(sql);
			stmt.close();
			con.close();
		}
		catch(SQLException ex)
		{
			System.out.println("\nERROR:-----SQLEXCEPTION------\n");
			while(ex!=null)
			{
				System.out.println("Message:"+ ex.getMessage());
				System.out.println("SQLState:"+ ex.getSQLState());
				System.out.println("ErrorCode:"+ ex.getErrorCode());
				ex = ex.getNextException();
			}
		}
	}
	
	
	public void setPanelRecord()          //设计录入板块视图
	{
		PanelRecord.setBorder(BorderFactory.createTitledBorder(BorderFactory.createEtchedBorder(),"录入"));
		PanelRecord.setLayout(new FlowLayout());
		
		PanelRecord.add(LaNO);
		PanelRecord.add(TextNO);
		PanelRecord.add(LaName);
		PanelRecord.add(TextName);
		PanelRecord.add(LaScore);
		PanelRecord.add(TextScore);
		PanelRecord.add(BRecord);
		
		PanelRecord.setVisible(false);
	}
	
	public void setPanelFind()     //设计查找板块视图
	{
		PanelFind.setBorder(BorderFactory.createTitledBorder(BorderFactory.createEtchedBorder(),"查找"));
		PanelFind.setLayout(new FlowLayout());
		
		PanelFind.add(new JLabel("按照"));
		PanelFind.add(FindList);
		PanelFind.add(TextFind);
		PanelFind.add(BFind);

		PanelFind.setVisible(false);
	}
	
	public void setPanelRework()     //设计修改板块视图
	{
		PanelRework.setBorder(BorderFactory.createTitledBorder(BorderFactory.createEtchedBorder(),"修改"));
		PanelRework.setLayout(new FlowLayout());
		
		PanelRework.add(LaNO);
		PanelRework.add(TextNO);
		PanelRework.add(LaName);
		PanelRework.add(TextName);
		PanelRework.add(LaScore);
		PanelRework.add(TextScore);
		PanelRework.add(BRework);

		PanelRework.setVisible(false);
	}
	
	public void setPanelDel()     //设计删除板块视图
	{
		PanelDel.setBorder(BorderFactory.createTitledBorder(BorderFactory.createEtchedBorder(),"删除"));
		PanelDel.setLayout(new FlowLayout());
		
		PanelDel.add(LaNO);
		PanelDel.add(TextNO);
		PanelDel.add(LaName);
		PanelDel.add(TextName);
		PanelDel.add(LaScore);
		PanelDel.add(TextScore);
		PanelDel.add(BDel);

		PanelDel.setVisible(false);
	}
	
	public void HidePanel()
	{
		PanelRecord.setVisible(false);
		PanelFind.setVisible(false);
		PanelRework.setVisible(false);
		PanelDel.setVisible(false);
	}
	
	class FileActionListener implements ActionListener  //事件处理内部类
	{
		int fileType=RECORD;         //File菜单项
		
		FileActionListener(int type)    //构造方法：设置菜单项
		{
			fileType=type;
		}
		
		public void actionPerformed(ActionEvent e)  //事件处理方法
		{
			switch (fileType)
			{
				case RECORD:
					HidePanel();
					setPanelRecord();
					PanelRecord.setVisible(true);
					break;
					
				case FIND:
				    HidePanel();
					PanelFind.setVisible(true);
					break;
					
				case REWORK:
				    HidePanel();
				    setPanelRework();
					PanelRework.setVisible(true);
					break;
					
				case DEL:
				    HidePanel();
				    setPanelDel();
					PanelDel.setVisible(true);
					break;
					
				case RESET:
				    HidePanel();
				    ReSetTable();
				    State.setText("刷新"+Scourse+"课程的数据成功!");
					break;	
				
				case ABOUT:
				    HidePanel();
				    setPanelDel();
					PanelDel.setVisible(true);
					break;
					
				case EXIT:
				    myWindow.setVisible(false);
					break;
					
				case BRECORD:
				    RecordAccess();
				    ReSetTable();
				    State.setText("录入到"+Scourse+"课程的数据成功!");
					break;
				
				case BFIND:
				    FindAccess();
				    State.setText("查找指定"+Scourse+"课程的数据成功!");
					break;
					
				case BREWORK:
				    ReworkAccess();
				    ReSetTable();
				    State.setText("修改"+Scourse+"课程的数据成功!");
					break;
				
				case BDEL:
				    DelAccess();
				    ReSetTable();
				    State.setText("删除"+Scourse+"课程的数据成功!");
					break;
					
				case CBC:
				    Scourse = "C";
				    System.out.println(Scourse);
				    ReSetTable();
				    State.setText("刷新"+Scourse+"课程的数据成功!");
					break;
					
				case CBJAVA:
				    Scourse = "Java";
				    System.out.println(Scourse);
				    ReSetTable();
				    State.setText("刷新"+Scourse+"课程的数据成功!");
					break;
					
				case CBMATH:
				    Scourse = "Math";
				    System.out.println(Scourse);
				    ReSetTable();
				    State.setText("刷新"+Scourse+"课程的数据成功!");
					break;
			}
		}
	}
	
	
	public final static ScoreSystem myWindow = new ScoreSystem("学生成绩管理系统");
	
	public static void main(String args[])
	{
		myWindow.setFont(new Font("楷体",Font.PLAIN,12));
		
		myWindow.setBounds(10,10,500,500);
		
		myWindow.setVisible(true);
	}
}