checkstudentpane.java

自己写的一个JAVA实现的学生成绩管理系统

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());
      getContentPane().add(label1);
      getContentPane().add(textField1);
      getContentPane().add(label2);
      getContentPane().add(textField2);
      getContentPane().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
   }
}