checkstudentpane.java~1~

来自「自己写的一个JAVA实现的学生成绩管理系统」· JAVA~1~ 代码 · 共 55 行

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.event.*;

class CheckStudentPane extends JFrame 
{
   JTextField textField1 = new JTextField(10);
   JTextField textField2 = new JTextField(10);
   CheckStudentPane () 
   {
      setTitle("查询窗口");
      setSize(500, 100);
      JLabel label1 = new JLabel("要查询的学生姓名：");
      JLabel label2 = new JLabel("学号：");
      JButton b1 = new JButton("确定");
      getContentPane().setLayout(new FlowLayout());
      add(label1);
      add(textField1);
      add(label2);
      add(textField2);
      add(b1);
      b1.addActionListener(new ButtonAction());
      setVisible(true);
      show();
   }
   class ButtonAction implements ActionListener 
   {
      public void actionPerformed(ActionEvent e) 
      {
         String name = textField1.getText().trim();
         String id = textField1.getText().trim();
         try 
         {
            DBClass a = new DBClass();
            a.executeSQL("select * from student where name like '%" + name + "%'", "studentdatabase");
            while(a.rs.next()) 
            {
               System.out.println(a.rs.getString("id") + "\t" + a.rs.getString("name") + " " + "\t" + a.rs.getString("age") + "\t" + a.rs.getString("sex") + "\t" + a.rs.getString("grade") + "\n");
               FirstPane.ta.append(a.rs.getString("id") + "\t" + a.rs.getString("name") + " " + "\t" + a.rs.getString("age") + "\t" + a.rs.getString("sex") + "\t" + a.rs.getString("grade") + "\n");
            }
         }
         catch(Exception e9) 
         {
            e9.printStackTrace();
         }
      }
   }
   public static void main(String[] args) 
   {
   // TODO: Add your code here
   }
}