student.java

实现奖学金的评定

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.util.*;
import java.sql.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.table.*;
import java.sql.ResultSet;
import java.io.*;
////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////
//学生基本信息
class student extends JFrame implements ActionListener
{  
   Object columnName[]={"学号","姓名","专业班级","民族","籍贯"};
   JTable table;
   Object body[][]=new Object[50][5];
   JButton button;
   Connection con;
   Statement sql; 
   ResultSet rs;
   JProgressBar p_bar;
  student()
  {  
     super("学生基本信息");
     getContentPane().setLayout(null);
     table=new JTable(body,columnName);
     Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
     setBounds((screenSize.width-403)/2, (screenSize.height-329)/2, 400,330);
     //setBounds(200, 250, 600, 500);
     //setSize(300,300);
     setVisible(true);
     button=new JButton("显示");
     button.addActionListener(this);
     button.setBounds(145,250,80,30);
     getContentPane().add(button);
    
     JScrollPane sl = new JScrollPane(table);
     sl.setBounds(0, 0, 395, 240);
     getContentPane().add(sl);
  
    }
 public void actionPerformed(ActionEvent evt)
  {if(evt.getSource()==button)
   {int i=0;
    try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  }
    catch(ClassNotFoundException e){}
    try{
       con=DriverManager.getConnection("jdbc:odbc:studentscore");
       sql=con.createStatement();
       rs=sql.executeQuery("SELECT * FROM studentscore");
       while(rs.next())
       {
        
  	      
	        body[i][0]=rs.getInt(1);
            body[i][1]=rs.getString(2);
            body[i][2]=rs.getString(3);
            body[i][3]=rs.getString("民族");
            body[i][4]=rs.getString("籍贯");
            
        i++;
      }
       table.repaint();                                                //表格刷新
      con.close();
     }
    catch(SQLException e1) {}
   }
  }
}