import?javax.swing.*;

import?java.awt.*;
import?java.awt.event.*;
import?java.sql.*;?

public?class?Count1?extends?JDialog?implements?ActionListener{

????object?name[]={“考號““姓名““總成績““平均成績“};
????String?[][]?a;
????JTable?table;
????JButton?show;?
????Connection?con;
????Statement?sql;?
????ResultSet?rs1rs2rs3;
	Count1（String?s）{
		settitle（s）;
		show=new?JButton（“顯示統計信息“）;

	????show.addActionListener（this）;
	????add（showBorderLayout.NORTH）;

		setBounds（120160600200）;
	}
	????public?void?actionPerformed（ActionEvent?e）{
		try{
	????	???con=DriverManager.getConnection（“jdbc:odbc:hello““system““q1234“）;
	????	???con.setAutoCommit（false）;
	????????????sql=con.createStatement
	????????????（ResultSet.TYPE_SCROLL_SENSITIVEResultSet.CONCUR_READ_ONLY）;
	????????????rs1=sql.executeQuery（“select?考號姓名（外語成績+政治成績+專業基礎成績+專業成績）總成績?from?計算機初試“）;?
	????????????rs1.last（）;
	????????????int?lastNumber1=rs1.getRow（）;
	????????????rs1.beforeFirst（）;??
	????????????rs2=sql.executeQuery（“select?考號姓名（外語成績+政治成績+專業基礎成績+專業成績）總成績??from?生物工程初試“）;?
	????????????rs2.last（）;
	????????????int?lastNumber2=rs2.getRow（）;
	????????????rs2.beforeFirst（）;
	????????????rs3=sql.executeQuery（“select?考號姓名（外語成績+政治成績+專業基礎成績+專業成績）總成績??from?經管初試“）;?
	????????????rs3.last（）;
	????????????int?lastNumber3=rs3.getRow（）;
	????????????rs3.beforeFirst（）;

	????????????int?lastNumber=lastNumber1+lastNumber2+lastNumber3;
	????????????a=new?String[lastNumber][4];
	????????????int?k=0;
	????????????rs1=sql.executeQuery（“select?考號姓名（外語成績+政治成績+專業基礎成績+專業成績）總成績??from?計算機初試“）;?
	????????????while（rs1.next（））{
	????????????	a[k][0]=rs1.getString（1）;
	????????????	a[k][1]=rs1.getString（2）;
	????????????	a[k][2]=rs1.getString（3）;
	????????????	double?h=rs1.getDouble（3）/4;
	????????????	a[k][3]=String.valueOf（h）;
	????????????	k++;
	????????????}
	????????????rs2=sql.executeQuery（“select?考號姓名（外語成績+政治成績+專業基礎成績+專業成績）總成績??from?生物工程初試“）;?
	????????????while（rs2.next（））{
	????????????	a[k][0]=rs2.getString（1）;
	????????????	a[k][1]=rs2.getString（2）;
	????????????	a[k][2]=rs2.getString（3）;
	????????????	double?h=rs2.getDouble（3）/4;
	????????????	a[k][3]=String.valueOf（h）;
	????????????	k++;
	????????????}
	????????????rs3=sql.executeQuery（“select?考號姓名（外語成績+政治成績+專業基礎成績+專業成績）總成績?from?經管初試“）;
	????????????while（rs3.next（））{
	????????????	a[k][0]=rs3.getString（1）;
	????????????	a[k][1]=rs3.getString（2）;
	????????????	a[k][2]=rs3.getString（3）;
	????????????	double?h=rs3.getDouble（3）/4;
	????????????	a[k][3]=String.valueOf（h）;
	????????????	k++;
	????????????}
	????????????con.commit（）;
	????????????con.close（）;
	}
		catch（SQLException?ee）{?
	???????????System.out.println（ee）;
	???????}?
		???table=new?JTable（aname）;
	???????getContentPane（）.removeAll（）;
	???????add（new?JScrollPane（table）BorderLayout.CENTER）;
	???????
		???validate（）;
	}
	
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????281??2009-06-23?10:37??yanjiusheng\專業字典.sql

?????文件????????849??2009-06-30?17:03??yanjiusheng\初試成績.sql

?????文件????????253??2009-07-01?08:11??yanjiusheng\復試成績.sql

?????文件???????1854??2009-07-02?12:41??yanjiusheng\存儲過程.sql

?????文件????????255??2009-06-26?19:37??yanjiusheng\錄取名單.sql

?????文件????????297??2009-07-01?08:35??yanjiusheng\總錄取名單.sql

?????文件???????7802??2009-06-30?17:09??yanjiusheng\插成績.sql

?????文件???????7904??2009-06-23?10:47??yanjiusheng\考生檔案.sql

?????文件????????239??2009-06-24?22:47??yanjiusheng\視圖.sql

?????文件???????3127??2010-07-05?10:11??yanjiusheng\代碼\Count1.java

?????文件???????4091??2010-07-05?10:11??yanjiusheng\代碼\Count2.java

?????文件???????1185??2009-07-01?21:32??yanjiusheng\代碼\Count3.java

?????文件???????2347??2010-07-05?10:11??yanjiusheng\代碼\Count31.java

?????文件???????2365??2010-07-05?10:11??yanjiusheng\代碼\Count32.java

?????文件???????2329??2010-07-05?10:12??yanjiusheng\代碼\Count33.java

?????文件???????2465??2010-07-05?10:12??yanjiusheng\代碼\InsertRecord.java

?????文件???????1423??2009-07-01?21:32??yanjiusheng\代碼\InsertScore1.java

?????文件???????2826??2010-07-05?19:39??yanjiusheng\代碼\InsertScore11.java

?????文件???????2853??2010-07-05?19:40??yanjiusheng\代碼\InsertScore12.java

?????文件???????2825??2010-07-05?19:41??yanjiusheng\代碼\InsertScore13.java

?????文件???????1420??2009-07-01?21:32??yanjiusheng\代碼\InsertScore2.java

?????文件???????2520??2010-07-05?19:41??yanjiusheng\代碼\InsertScore21.java

?????文件???????2513??2010-07-05?19:42??yanjiusheng\代碼\InsertScore22.java

?????文件???????2494??2010-07-05?19:42??yanjiusheng\代碼\InsertScore23.java

?????文件???????4851??2009-07-01?21:32??yanjiusheng\代碼\Manage.java

?????文件???????3275??2010-07-05?10:14??yanjiusheng\代碼\ModifyRecord.java

?????文件???????2016??2010-07-05?10:14??yanjiusheng\代碼\ShowRecord.java

?????文件???????1342??2009-07-01?21:32??yanjiusheng\代碼\ShowScore1.java

?????文件???????1516??2010-07-05?10:15??yanjiusheng\代碼\ShowScore11.java

?????文件???????1520??2010-07-05?10:15??yanjiusheng\代碼\ShowScore12.java

............此處省略15個文件信息