scoresinput.java~14~

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

//还为调试成功，报错：参数不足，期待为1
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 ScoresInput  extends JFrame implements ActionListener
{
  public static final int WIDTH=400;
  public static final int HEIGHT=400;
  JLabel jLabel1 = new JLabel();
  JTextField jTextField1 = new JTextField();
  JLabel jLabel2 = new JLabel();
  JTextField jTextField2 = new JTextField();
  JLabel jLabel3 = new JLabel();
  JTextField jTextField3 = new JTextField();
  JLabel jLabel4 = new JLabel();
  JTextField jTextField4 = new JTextField();
  JLabel jLabel5 = new JLabel();
  JTextField jTextField5 = new JTextField();
  JLabel jLabel6 = new JLabel();
  JTextField jTextField6 = new JTextField();
  JLabel jLabel7 = new JLabel();
  JTextField jTextField7 = new JTextField();
  JLabel jLabel8 = new JLabel();
  JTextField jTextField8 = new JTextField();
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();
  JButton jButton3 = new JButton();

  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();
          double  gaoshu=Double.parseDouble(jTextField3.getText());
          double  java=Double.parseDouble(jTextField4.getText()) ;
          double  computer=Double.parseDouble(jTextField5.getText());
          double  psp=Double.parseDouble(jTextField6.getText());
          double  English=Double.parseDouble(jTextField7.getText());
          double  militry=Double.parseDouble(jTextField8.getText());
          double  sum=gaoshu+java+computer+psp+English+militry;
          double  ave=sum/6;
          double  GPA=(gaoshu*5+java*2+computer*4+psp*2+English*4+militry*3)/(5+2+4+2+4+3);
          String  beizhu="无";
          String  SQLOrder="INSERT INTO Scores VALUES('"+ID+"','"+name+"',"+gaoshu+","+java+","+computer+","+ psp+","+ English+","+militry+","+sum+","+GPA+","+beizhu+")";
          SQLOrder="INSERT INTO Scores VALUES('20053001163','张斯亮','99.12','99.12','99.12','99.12','99.12','99.12','99.12','99.12','无')";
          stmt.executeUpdate(SQLOrder);
          stmt.close();
          con.close();
        }
        catch(Exception ex)
        {
          JOptionPane.showMessageDialog(null,ex.getMessage(),"警告信息",JOptionPane.WARNING_MESSAGE);
          JOptionPane.showMessageDialog(null,ex.getStackTrace(),"警告信息",JOptionPane.WARNING_MESSAGE);
        }
     }
   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 ScoresInput()
  {
    setSize(WIDTH,HEIGHT);
    setTitle("学生成绩录入");
    Container contentPane=getContentPane();
    contentPane.setBackground(Color.green);
    try
    {
      jbInit();
    }//执行方法jbInit()
    catch(Exception e)
    {
      e.printStackTrace();
    }
  }
  public static void main(String[] args)
  {
    ScoresInput n = new ScoresInput();
    n.setVisible(true);
  }
  private void jbInit() throws Exception
  {
   jLabel1.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
   jLabel1.setText("学号");
   jLabel1.setBounds(new Rectangle(37, 36, 36, 20));
   this.getContentPane().setLayout(null);
   jTextField1.setText("");
   jTextField1.setBounds(new Rectangle(89, 37, 80, 21));
   jLabel2.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
   jLabel2.setRequestFocusEnabled(true);
   jLabel2.setText("姓名");
   jLabel2.setBounds(new Rectangle(38, 79, 30, 16));
   jTextField2.setText("");
   jTextField2.setBounds(new Rectangle(89, 81, 80, 19));
   jLabel3.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
   jLabel3.setToolTipText("");
   jLabel3.setText("高等数学");
   jLabel3.setBounds(new Rectangle(15, 121, 60, 18));
   jTextField3.setText("");
   jTextField3.setBounds(new Rectangle(90, 119, 80, 19));
   jLabel4.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
   jLabel4.setText("JAVA");
   jLabel4.setBounds(new Rectangle(37, 161, 41, 21));
   jTextField4.setText("");
   jTextField4.setBounds(new Rectangle(90, 162, 82, 19));
   jLabel5.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
   jLabel5.setText("计算机组成原理");
   jLabel5.setBounds(new Rectangle(183, 36, 99, 20));
   jTextField5.setText("");
   jTextField5.setBounds(new Rectangle(283, 35, 81, 21));
   jLabel6.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
   jLabel6.setText("个体软件过程 ");
   jLabel6.setBounds(new Rectangle(190, 75, 93, 21));
   jTextField6.setText("");
   jTextField6.setBounds(new Rectangle(283, 77, 82, 21));
   jLabel7.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
   jLabel7.setText("大学英语");
   jLabel7.setBounds(new Rectangle(197, 120, 74, 17));
   jTextField7.setText("");
   jTextField7.setBounds(new Rectangle(283, 121, 83, 21));
   jLabel8.setFont(new java.awt.Font("宋体", Font.BOLD, 13));
   jLabel8.setText("军事理论");
   jLabel8.setBounds(new Rectangle(198, 159, 82, 25));
   jTextField8.setText("");
   jTextField8.setBounds(new Rectangle(282, 165, 84, 20));
   jButton1.setBounds(new Rectangle(63, 234, 71, 31));
   jButton1.setText("提交");
   jButton2.setBounds(new Rectangle(171, 235, 77, 30));
   jButton2.setText("重置");
   jButton3.setBounds(new Rectangle(295, 235, 75, 30));
   jButton3.setText("返回");
   this.getContentPane().add(jLabel1, null);
   this.getContentPane().add(jTextField1, null);
   this.getContentPane().add(jLabel2, null);
   this.getContentPane().add(jTextField2, null);
   this.getContentPane().add(jTextField3, null);
   this.getContentPane().add(jTextField4, null);
   this.getContentPane().add(jLabel5, null);
   this.getContentPane().add(jLabel8, null);
   this.getContentPane().add(jButton1, null);
   this.getContentPane().add(jButton2, null);
   this.getContentPane().add(jButton3, null);
   this.getContentPane().add(jLabel6, null);
   this.getContentPane().add(jLabel7, null);
   this.getContentPane().add(jLabel3, null);
   this.getContentPane().add(jLabel4, null);
   this.getContentPane().add(jTextField6, null);
   this.getContentPane().add(jTextField5, null);
    this.getContentPane().add(jTextField7, null);
    this.getContentPane().add(jTextField8, null);
   jButton1.addActionListener(this);
   jButton2.addActionListener(this);
   jButton3.addActionListener(this);
 }
}