classeschoicesdelete.java~2~

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

package Chapter1;
import java.io.*;
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.awt.Rectangle;
import java.awt.Font;
public class ClassesChoicesDelete extends JFrame implements ActionListener
{
  public static final int WIDTH=400;
  public static final int HEIGHT=400;
  JLabel jLabel1 = new JLabel();
  JTextField jTextField1 = new JTextField(5);
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();
  public ClassesChoicesDelete()
  {
    setSize(WIDTH,HEIGHT);
    setTitle("已选课删除");
    Container contentPane=getContentPane();
    contentPane.setBackground(Color.green);
    try {
      jbInit();
    }
    catch (Exception ex) {
      ex.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();
//            String  ID=jTextField1.getText();
//            String  name=jTextField2.getText();
//            String  sex=jTextField3.getText();
//            int  age=Integer.parseInt(jTextField4.getText()) ;
//            String  department=jTextField5.getText();
//            String  major=jTextField6.getText();
//            String  homeplace=jTextField7.getText();
//            String  timeOfEntering=jTextField8.getText();
//            String  addition=jTextField9.getText();

         //   String  SQLOrder="INSERT INTO BasicInformation VALUES('"+ID+"','"+name+"','"+sex+"',"+age+",'"+department+"','"+ major+"','"+ homeplace+"','"+timeOfEntering+"','"+addition+"')";
         //   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("");
//        jTextField4.setText("");
//        jTextField5.setText("");
//        jTextField6.setText("");
//        jTextField7.setText("");
//        jTextField8.setText("");

     }
     else if  (e.getActionCommand().equals("返回"))
     { this.setVisible(false);
       ManagerInterface n=new ManagerInterface();
       n.setVisible(true);
     }
}
  public static void main(String[] args)
  {
    ClassesChoicesDelete n = new ClassesChoicesDelete();
    n.setVisible(true);
  }

  private void jbInit() throws Exception {
    this.getContentPane().setLayout(new FlowLayout());
    jLabel1.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
    jLabel1.setText("请输入您要删除的课程名:");
    jLabel1.setBounds(new Rectangle(12, 46, 173, 29));
    this.getContentPane().add(jLabel1);
    jButton2.setBounds(new Rectangle(220, 168, 71, 30));
    jButton2.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
    jButton2.setText("返回");
    jButton1.setBounds(new Rectangle(68, 167, 74, 33));
    jButton1.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
    jButton1.setText("删除");
    this.getContentPane().add(jTextField1,-1);
    this.getContentPane().add(jButton1,-1);
    this.getContentPane().add(jButton2,-1);
    jTextField1.setBounds(new Rectangle(190, 48, 80, 24));
    jButton1.addActionListener(this);
    jButton2.addActionListener(this);
  }
}