dbtest7.java

来自「这是一张java应用教程的随书光盘」· Java 代码 · 共 53 行

import javax.swing.*;
import java.awt.event.*;
import java.sql.*;
import java.awt.*;
class ResultWin extends JFrame implements ActionListener
{  Object a[][];
   Object columnName[]={"学号","姓名","语文","数学","英语"}; 
   JTable table;JButton button;
   Container container; 
   String name,xuehao; int math,Chinese,english;
   Connection con;Statement sql; ResultSet rs; 
   ResultWin()
   { super("输出指定行信息");
     a=new Object[5][6];
     table=new JTable(a,columnName);
     setSize(300,300);setVisible(true);
     button=new JButton("确定");
     addWindowListener(new WindowAdapter()
     {public void windowClosing(WindowEvent e)
       { System.exit(0);}} ); 
     button.addActionListener(this);
     container=getContentPane();
     container.add(button,BorderLayout.SOUTH);
     container.add(new JScrollPane(table),BorderLayout.CENTER);
    }
   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:grade");
            sql=con.createStatement(
		    ResultSet.TYPE_SCROLL_INSENSITIVE,
		    ResultSet.CONCUR_READ_ONLY);
	        rs=sql.executeQuery("SELECT * FROM grade");
            rs.absolute(5);
            xuehao=rs.getString(1);name=rs.getString(2);math=rs.getInt("数学"); 
            Chinese=rs.getInt("语文"); english=rs.getInt("英语");
            a[0][0]=xuehao;a[0][1]=name; a[0][2]=String.valueOf(math);
            a[0][3]=String.valueOf(Chinese); a[0][4]=String.valueOf(english);
            con.close();
            }
        catch(SQLException e1) {}
      }   
   } 
}
public class DbTest7
{ public static void main(String args[])
  {ResultWin win=new ResultWin(); win.pack();
  }
}