sim_search.java

这是一个教学管理代码

package sims;

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

public class SIM_search extends JFrame implements ActionListener
{
    JLabel jLabel1 = new JLabel();
    JLabel 输入学号 = new JLabel();
    JTextField 学号输入 = new JTextField();
    JButton 确定 = new JButton();
    JLabel 学号 = new JLabel();
    JLabel 姓名 = new JLabel();
    JLabel 班级 = new JLabel();
    JLabel 民族 = new JLabel();
    JLabel 籍贯 = new JLabel();
    JLabel 性别 = new JLabel();
    JLabel 生日 = new JLabel();
    JLabel 电话 = new JLabel();
    JLabel 家庭地址 = new JLabel();
    JTextField T学号 = new JTextField();
    JTextField T姓名 = new JTextField();
    JTextField T班级 = new JTextField();
    JTextField T民族 = new JTextField();
    JTextField T籍贯 = new JTextField();
    JTextField T性别 = new JTextField();
    JTextField T生日 = new JTextField();
    JTextField T电话 = new JTextField();
    JTextField T家庭地址 = new JTextField();

    public SIM_search()
    {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }

    }


    private void jbInit() throws Exception
    {
        this.getContentPane().setLayout(null);
        this.getContentPane().setBackground(new Color(240, 170, 200));
        jLabel1.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 26));
        jLabel1.setForeground(Color.green);
        jLabel1.setText("学生信息查询");
        jLabel1.setBounds(new Rectangle(118, 4, 175, 36));
        学号.setFont(new java.awt.Font("宋体", Font.BOLD, 18));
        学号.setForeground(Color.blue);
        学号.setText("学号");
        学号.setBounds(new Rectangle(30, 100, 70, 30));
        输入学号.setFont(new java.awt.Font("宋体", Font.BOLD, 20));
        姓名.setFont(new java.awt.Font("宋体", Font.BOLD, 18));
        姓名.setForeground(Color.blue);
        姓名.setText("姓名");
        姓名.setBounds(new Rectangle(230, 100, 70, 30));
        班级.setFont(new java.awt.Font("宋体", Font.BOLD, 18));
        班级.setForeground(Color.blue);
        班级.setText("班级");
        班级.setBounds(new Rectangle(30, 160, 70, 30));
        民族.setFont(new java.awt.Font("宋体", Font.BOLD, 18));
        民族.setForeground(Color.blue);
        民族.setText("民族");
        民族.setBounds(new Rectangle(230, 160, 70, 30));
        籍贯.setFont(new java.awt.Font("宋体", Font.BOLD, 18));
        籍贯.setForeground(Color.blue);
        籍贯.setText("籍贯");
        籍贯.setBounds(new Rectangle(30, 220, 70, 30));
        性别.setFont(new java.awt.Font("宋体", Font.BOLD, 18));
        性别.setForeground(Color.blue);
        性别.setText("性别");
        性别.setBounds(new Rectangle(230, 220, 70, 30));
        生日.setFont(new java.awt.Font("宋体", Font.BOLD, 18));
        生日.setForeground(Color.blue);
        生日.setText("生日");
        生日.setBounds(new Rectangle(30, 280, 70, 30));
        电话.setFont(new java.awt.Font("宋体", Font.BOLD, 18));
        电话.setForeground(Color.blue);
        电话.setText("电话");
        电话.setBounds(new Rectangle(230, 280, 90, 30));
        家庭地址.setFont(new java.awt.Font("宋体", Font.BOLD, 18));
        家庭地址.setForeground(Color.blue);
        家庭地址.setText("家庭地址");
        家庭地址.setBounds(new Rectangle(30, 340, 100, 30));
        T学号.setBounds(new Rectangle(80, 100, 120, 30));
        T姓名.setBounds(new Rectangle(276, 100, 120, 30));
        T班级.setBounds(new Rectangle(80, 160, 120, 30));
        T民族.setBounds(new Rectangle(276, 160, 120, 30));
        T籍贯.setBounds(new Rectangle(80, 220, 120, 30));
        T性别.setBounds(new Rectangle(276, 220, 120, 30));
        T生日.setBounds(new Rectangle(80, 280, 120, 30));
        T电话.setBounds(new Rectangle(276, 280, 120, 30));
        T家庭地址.setBounds(new Rectangle(112, 340, 310, 30));
        this.getContentPane().add(jLabel1);
        确定.setBounds(new Rectangle(323, 49, 74, 36));
        确定.setFont(new java.awt.Font("宋体", Font.BOLD, 18));
        确定.setForeground(new Color(235, 255, 0));
        确定.setText("确定");
        学号输入.setBounds(new Rectangle(155, 52, 126, 31));
        this.getContentPane().add(输入学号);
        this.getContentPane().add(学号输入);
        this.getContentPane().add(确定);
        this.getContentPane().add(学号);
        this.getContentPane().add(班级);
        this.getContentPane().add(籍贯);
        this.getContentPane().add(姓名);
        this.getContentPane().add(性别);
        this.getContentPane().add(民族);
        this.getContentPane().add(生日);
        this.getContentPane().add(电话);
        this.getContentPane().add(家庭地址);
        this.getContentPane().add(T学号);
        this.getContentPane().add(T姓名);
        this.getContentPane().add(T班级);
        this.getContentPane().add(T民族);
        this.getContentPane().add(T籍贯);
        this.getContentPane().add(T性别);
        this.getContentPane().add(T电话);
        this.getContentPane().add(T生日);
        this.getContentPane().add(T家庭地址);
        输入学号.setForeground(Color.yellow);
        输入学号.setText("请输入学号");
        输入学号.setBounds(new Rectangle(31, 51, 123, 34));

        确定.addActionListener(this);

        setVisible(true);
        setSize(430,430);
        setTitle("学生信息查询");
        show();
    }

    public void actionPerformed(ActionEvent e)
  {
      if(e.getSource()==确定)
      {
          try
          {
              connection c=new connection();
              Connection con=c.createConnection();
              String str=学号输入.getText();
              String sql="select * from Student where ID='"+str+"'";
              PreparedStatement ptmt=con.prepareStatement(sql);
              ResultSet rs=ptmt.executeQuery();
              while(rs.next())
              {
                  T学号.setText(rs.getString(1));
                  T姓名.setText(rs.getString(2));
                  T班级.setText(rs.getString(3));
                  T民族.setText(rs.getString(4));
                  T籍贯.setText(rs.getString(5));
                  T性别.setText(rs.getString(6));
                  T生日.setText(rs.getString(7));
                  T电话.setText(rs.getString(8));
                  T家庭地址.setText(rs.getString(9));
              }

              c.close(rs,ptmt,con);
          }catch (Exception ee){}
      }

  }

/*
    public static void main(String[]args)
    {
        new SIM_search();
    }
*/

}