grade_search.java

这是一个教学管理代码

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


public class Grade_search extends JFrame implements ActionListener
{
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JTextField jTextField1 = new JTextField();
    JTextField jTextField2 = new JTextField();
    JLabel jLabel3 = new JLabel();
    JTextField jTextField3 = new JTextField();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JLabel jLabel6 = new JLabel();
    JLabel jLabel7 = new JLabel();
    JLabel jLabel8 = new JLabel();
    JLabel jLabel9 = new JLabel();
    JLabel jLabel10 = new JLabel();
    JLabel jLabel11 = new JLabel();
    JLabel jLabel12 = new JLabel();
    JLabel jLabel13 = new JLabel();
    JLabel jLabel14 = new JLabel();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();

    public Grade_search()
    {
        Container c=this.getContentPane();
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }


    private void jbInit() throws Exception {
        this.getContentPane().setLayout(null);
       jLabel1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 21));
       jLabel1.setText("请输入学号 ");
       jLabel1.setBounds(new Rectangle(31, 31, 126, 30));
       jLabel4.setFont(new java.awt.Font("Dialog", Font.PLAIN, 16));
       jLabel5.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
       jLabel5.setText("课程号");
       jLabel5.setBounds(new Rectangle(24, 189, 74, 28));
       jLabel6.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
       jLabel6.setText("1");
       jLabel6.setBounds(new Rectangle(28, 216, 36, 21));
       jLabel7.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
       jLabel7.setText("2");
       jLabel7.setBounds(new Rectangle(28, 232, 35, 21));
       jLabel8.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
       jLabel8.setText("3");
       jLabel8.setBounds(new Rectangle(28, 250, 36, 21));
       jLabel9.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
       jLabel9.setText("4");
       jLabel9.setBounds(new Rectangle(28, 271, 34, 16));
       jLabel10.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
       jLabel10.setText("课程名称");
       jLabel10.setBounds(new Rectangle(153, 195, 66, 16));
       jLabel11.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
       jLabel11.setText("操作系统  ");
       jLabel11.setBounds(new Rectangle(151, 218, 69, 16));
       jLabel12.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
       jLabel12.setText("计算机网络");
       jLabel12.setBounds(new Rectangle(151, 234, 66, 16));
       jLabel13.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
       jLabel13.setText("数据库原理");
       jLabel13.setBounds(new Rectangle(151, 252, 82, 16));
       jLabel14.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
       jLabel14.setText("编译原理 ");
       jLabel14.setBounds(new Rectangle(151, 271, 60, 16));
       jButton1.setBounds(new Rectangle(263, 178, 87, 42));
       jButton1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 21));
       jButton1.setText("查询");
        jButton2.setBounds(new Rectangle(264, 242, 87, 37));
        jButton2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
        jButton2.setText("重置");
        this.getContentPane().add(jLabel1);
       jLabel4.setText("温馨提示： ");
       jLabel4.setBounds(new Rectangle(31, 157, 97, 31));
       jTextField3.setText("");
       jTextField3.setBounds(new Rectangle(220, 114, 133, 33));
       jLabel3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 21));
       jLabel3.setText("该门课程的分数");
       jLabel3.setBounds(new Rectangle(28, 114, 155, 33));
       this.getContentPane().setBackground(new Color(201, 201, 208));
       this.setForeground(SystemColor.menu);
       jTextField2.setText("");
       jTextField2.setBounds(new Rectangle(220, 74, 131, 31));
       jTextField1.setText("");
       jTextField1.setBounds(new Rectangle(220, 32, 131, 31));
       this.getContentPane().add(jLabel2);
       this.getContentPane().add(jLabel3);
       this.getContentPane().add(jTextField2);
       this.getContentPane().add(jTextField1);
       this.getContentPane().add(jTextField3);
       this.getContentPane().add(jLabel4);
       this.getContentPane().add(jLabel12);
       this.getContentPane().add(jLabel5);
       this.getContentPane().add(jLabel10);
       this.getContentPane().add(jLabel11);
       this.getContentPane().add(jLabel13);
       this.getContentPane().add(jLabel14);
       this.getContentPane().add(jLabel6);
       this.getContentPane().add(jLabel7);
       this.getContentPane().add(jLabel8);
       this.getContentPane().add(jLabel9);
       this.getContentPane().add(jButton1);
        this.getContentPane().add(jButton2);
        jLabel2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 21));
       jLabel2.setText("请输入课程号");
       jLabel2.setBounds(new Rectangle(29, 76, 155, 31));

       jButton1.addActionListener(this);
       jButton2.addActionListener(this);

       setTitle("成绩查询");
       setSize(380,350);
       show();

    }

    public void actionPerformed(ActionEvent e)
   {
       if(e.getSource()==jButton1)
       {
           try
           {
               connection c=new connection();
               Connection con=c.createConnection();
               String str1=jTextField1.getText();
               String str2=jTextField2.getText();
               String str3=null;
               String sql="select * from SC where Student_No='"+str1+"' and Course_No='"+str2+"'";
               PreparedStatement ptmt=con.prepareStatement(sql);
               ResultSet rs=ptmt.executeQuery();
               while(rs.next())
             {
               str3=rs.getString(3);
               jTextField3.setText(str3);
             }

               String sql1="select Course_Name from Course where Course_No='"+str2+"'";
               PreparedStatement ptmt1=con.prepareStatement(sql1);
               ResultSet rs1=ptmt1.executeQuery();

               while(rs1.next())
               {
                  jTextField2.setText(rs1.getString(2));
               }
               c.close(rs,ptmt,con);
               c.close(rs1,ptmt1,con);
           }
           catch(Exception ee){}
       }
       else if(e.getSource()==jButton2)
       {
           jTextField1.setText("");
           jTextField2.setText("");
           jTextField3.setText("");

       }

   }



}