dbtest6.java

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

import javax.swing.*;
import java.awt.event.*;
import java.sql.*;
import java.awt.*;
class ResultWin extends JFrame implements ActionListener
{  Object a[][];Panel panel;TextField keyword;Label label;
   Object columnName[]={"学号","姓名","语文","数学","英语"}; 
   JTable table;JButton button;
   Container container; 
   String name,xuehao; int math,Chinese,english;
   Connection con;Statement sql; ResultSet rs; 
   JProgressBar p_bar; 
   ResultWin()
   { super("数据查询");
     a=new Object[30][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);
     keyword=new TextField(16);
     label=new Label("输入被查询的学生的姓名");
     panel=new Panel();
     panel.add(label);
     panel.add(keyword);pack();
     p_bar=new JProgressBar(JProgressBar.VERTICAL,0,50);
     p_bar.setStringPainted(true) ; 
     container=getContentPane();
     container.add(panel,BorderLayout.NORTH);
     container.add(button,BorderLayout.SOUTH);
     container.add(new JScrollPane(table),BorderLayout.CENTER);
     container.add(p_bar,BorderLayout.WEST);  
    }
 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();
       String str=keyword.getText();
       rs=sql.executeQuery("SELECT * FROM grade WHERE 姓名 LIKE '%" + str + "%'");
       while(rs.next())
       {
       	xuehao=rs.getString(1);   name=rs.getString(2); 
        math=rs.getInt("数学");    Chinese=rs.getInt("语文");   english=rs.getInt("英语");
        a[i][0]=xuehao;a[i][1]=name;     a[i][2]=String.valueOf(math);
       a[i][3]=String.valueOf(Chinese);   a[i][4]=String.valueOf(english);
        i++;
        p_bar.setValue(i);p_bar.setString("查询了"+i+"条记录");
       } pack();
      con.close();
     }
    catch(SQLException e1) {}
   }   
  } 
}
public class DbTest6
{ public static void main(String args[])
  {ResultWin win=new ResultWin(); win.pack();
 }
}