import?java.awt.*;
import?javax.swing.*;
import?javax.swing.table.*;
import?java.awt.event.*;
import?java.sql.*;

public?class?Scores?{
	public?static?void?main（String?[]?args）{
		new?ScoresWindow（“成績查詢系統(tǒng)“）;
	}
}

class?ScoresWindow?extends?Jframe{
	private?static?final?long?serialVersionUID?=?-6924196421756933199L;
	Statement?statement;
	Connection?connection;
	String?commandString;
	ResultSet?resultSet;
	
	JButton?addJButton=new?JButton（“確認(rèn)“）;
	JTextField?noJTextField=new?JTextField（9）;
	JTextField?scoresJTextField=new?JTextField（5）;
	JPanel?inputPanel=new?JPanel（false）;
	
	JButton?queryJButton=new?JButton（“查詢“）;
	JTextField?queryNOJTextField=new?JTextField（9）;
	JTextArea?queryJTextArea=new?JTextArea（）;
	JPanel?queryJPanel=new?JPanel（false）;
	
	JButton?sortJButton=new?JButton（“排序“）;
	object?clonameobject[]={“學(xué)號““成績“};
	Integer?rows=0;
	DefaultTableModel?tableModel=new?DefaultTableModel（clonameobjectrows）;
	JTable?table=new?JTable（tableModel）;
	
	JPanel?sortJPanel=new?JPanel（false）;
	
	Dimension?dimension=new?Dimension（10025）;
	
	public?ScoresWindow（String?titleString）?{
		super（titleString）;
		JTabbedPane?jTabbedPane=new?JTabbedPane（）;
		JComponent?inputPanel=inputJComponent（）;
		JComponent?queryPanel=queryJComponent（）;
		JComponent?sortPanel=sortJComponent（）;
		jTabbedPane.addTab（“輸入成績“?inputPanel）;
		
		jTabbedPane.addTab（“查詢成績“?queryPanel）;
		
		jTabbedPane.addTab（“成績排序“?sortPanel）;
		
		setLayout（new?GridLayout（11））;
		add（jTabbedPane）;
		jTabbedPane.setTabLayoutPolicy（JTabbedPane.SCROLL_TAB_LAYOUT）;
		setBounds（100?100?300?400）;
		setVisible（true）;
		validate（）;
		
		addJButton.addActionListener（new?AddAction（））;
		queryJButton.addActionListener（new?QueryAction（））;
		sortJButton.addActionListener（new?SortAction（））;
		
		getConnectDatabase（）;
		setDefaultCloseOperation（EXIT_ON_CLOSE）;
	}
	
	protected?class?AddAction?implements?ActionListener{
		public?void?actionPerformed（ActionEvent?e）{
			String?noString;
			try?{
				noString=noJTextField.getText（0?9）;
				commandString=“INSERT?INTO?scores?VALUES（‘“+noString+“‘‘“+scoresJTextField.getText（）+“‘）“;
				statement=connection.createStatement（）;
				statement.execute（commandString）;
				statement.closeOnCompletion（）;
				alterJComponent（inputPanel?“添加成功！“）;
				statement.closeOnCompletion（）;
				}?catch?（Exception?e2）?{
					alterJComponent（inputPanel?“學(xué)號為9位！請重新輸入！\n“+e2.toString（）+““）;
			}
		}
	}
	
	protected?class?QueryAction?implements?ActionListener{
		public?void?actionPerformed（ActionEvent?e）{
			try?{
				statement=connection.createStatement（）;
				String?noString=queryNOJTextField.getText（0?9）;
				commandString=“SELECT?*?FROM?SCORES?WHERE?NUMBER=‘“+noString+“‘“;
				resultSet=statement.executeQuery（commandString）;
				resultSet.first（）;
				queryJTextArea.append（“您查詢的學(xué)號為?“+resultSet.getString（1）+“?的成績?yōu)?“+resultSet.getString（2）+“\n“）;
				statement.closeOnCompletion（）;
			}?catch?（Exception?e2）?{
				alterJComponent（queryJPanel?“學(xué)號為9位！請重新輸入！\n“+e2.toString（）+““）;
			}
	

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2012-10-27?15:30??java3-master\
?????文件?????????483??2012-10-27?15:30??java3-master\.gitattributes
?????文件????????1970??2012-10-27?15:30??java3-master\.gitignore
?????目錄???????????0??2012-10-27?15:30??java3-master\src\
?????文件????????6542??2012-10-27?15:30??java3-master\src\Scores.java