classeschoiceinput.java~42~

学生信息管理系统,包括成绩查询,成绩排序,用ACCESS做数据库连接

/*     选课信息有待解决，如何表示选课信息较好*/
package Chapter1;
import java.io.*;
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.awt.Rectangle;
import java.sql.*;
public class ClassesChoiceInput extends JFrame implements ActionListener
{
   public static final int WIDTH=400;
   public static final int HEIGHT=400;
  JLabel jLabel2 = new JLabel();
  JTextField jTextField1 = new JTextField();
  JLabel jLabel3 = new JLabel();
  JTextField jTextField2 = new JTextField();
  JLabel jLabel5 = new JLabel();
  JTextField jTextField3 = new JTextField();
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();
  JButton jButton3 = new JButton();
  public ClassesChoiceInput()
   {
       setTitle("选课信息录入");
       setSize(WIDTH,HEIGHT);
       Container contentPane=getContentPane();
       contentPane.setBackground(Color.orange);
       contentPane.setLayout(new FlowLayout());
    try
    {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
   }
  public void actionPerformed(ActionEvent e)
  {
     if(e.getActionCommand().equals("提交"))
     {
         try
         {
           String url="jdbc:odbc:MySecondAccess";
           Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
           Connection con=DriverManager.getConnection(url,"","");
           Statement stmt=con.createStatement();
           System.out.println(jTextField3.getText());
           System.out.println(Login.ID);

           String SQLOrder="UPDATE ClassesChoicesInformation SET "+jTextField3.getText()+"=1 WHERE 学号='"+Login.ID+"'";
           String SQLOrder1="SELECT * FROM ClassesInformation WHERE 课程号='"+jTextField1.getText()+"' AND 课序号='"+jTextField2.getText()+"' AND 课程名='"+jTextField3.getText()+"'";
           ResultSet rs=stmt.executeQuery(SQLOrder1);
           if(/*所填内容属实*/rs.next())
           {
             ResultSet resultSet=stmt.executeQuery(SQLOrder);
             JOptionPane.showMessageDialog(null,"选课信息录入成功！","提示信息",JOptionPane.INFORMATION_MESSAGE);
           }
          else
            JOptionPane.showMessageDialog(null,"不存在此课程或输入错误！","警告信息",JOptionPane.WARNING_MESSAGE);           stmt.executeUpdate(SQLOrder);
           stmt.close();
           con.close();
         }
         catch(Exception ex)
         {
           System.out.println("Failure in connecting with the database!");
           System.out.println(ex.getMessage());
         }
     }
    else if(e.getActionCommand().equals("重置"))
    {
      jTextField1.setText("");
      jTextField2.setText("");
      jTextField3.setText("");
    }
    else if(e.getActionCommand().equals("返回"))
    {
          this.setVisible(false);
          ManagerInterface n1= new ManagerInterface();
          StudentInterface n2=new  StudentInterface();
          if(Login.jComboBox1.getSelectedIndex()==0)
                {  n1.setVisible(true);  n2.setVisible(false);}
          else if(Login.jComboBox1.getSelectedIndex()==1)
                {  n2.setVisible(true);  n1.setVisible(false); }
    }
  }
  public static void main(String[] args)
  {
        ClassesChoiceInput n = new ClassesChoiceInput();
        n.setVisible(true);
  }
  private void jbInit() throws Exception {
    this.getContentPane().setLayout(null);
    jLabel2.setRequestFocusEnabled(true);
    jLabel2.setText("课程号:");
    jLabel2.setBounds(new Rectangle(76, 55, 49, 21));
    jTextField1.setText("");
    jTextField1.setBounds(new Rectangle(123, 56, 69, 23));
    jLabel3.setText("课序号:");
    jLabel3.setBounds(new Rectangle(211, 62, 52, 17));
    jTextField2.setText("");
    jTextField2.setBounds(new Rectangle(262, 56, 70, 22));
    jLabel5.setText("课程名:");
    jLabel5.setBounds(new Rectangle(75, 136, 47, 16));
    jTextField3.setText("");
    jTextField3.setBounds(new Rectangle(122, 130, 70, 23));
    jButton1.setBounds(new Rectangle(73, 198, 69, 32));
    jButton1.setText("提交");
    jButton2.setBounds(new Rectangle(188, 199, 75, 32));
    jButton2.setText("重置");
    jButton3.setBounds(new Rectangle(305, 198, 75, 31));
    jButton3.setText("返回");
    this.getContentPane().add(jButton1, null);
    this.getContentPane().add(jButton2, null);
    this.getContentPane().add(jButton3);
    this.getContentPane().add(jTextField1, null);
    this.getContentPane().add(jLabel3, null);
    this.getContentPane().add(jLabel5, null);
    this.getContentPane().add(jLabel2, null);
    this.getContentPane().add(jTextField2, null);
    this.getContentPane().add(jTextField3, null);
    jButton1.addActionListener(this);
    jButton2.addActionListener(this);
    jButton3.addActionListener(this);
  }

}