artacn.java

这是一个用java编写的小小的高校学生成绩管理小,可以实现简单的学生考试管理!

package infomanagement;

import java.awt.*;
import javax.swing.*;
import com.borland.jbcl.layout.*;
import java.awt.event.*;
import com.borland.dx.sql.dataset.*;
import java.sql.* ;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: </p>
 * @author unascribed
 * @version 1.0
 */

public class ArtAcn extends JDialog {
  private JPanel jPanel1 = new JPanel();
  private XYLayout xYLayout1 = new XYLayout();
  private JLabel jLabel1 = new JLabel();
  private JLabel jLabel2 = new JLabel();
  private JLabel jLabel3 = new JLabel();
  private JTextField jTextField1 = new JTextField();
  private JLabel jLabel4 = new JLabel();
  private JTextField jTextField2 = new JTextField();
  private JLabel jLabel5 = new JLabel();
  private JTextField jTextField3 = new JTextField();
  private JLabel jLabel6 = new JLabel();
  private JTextField jTextField4 = new JTextField();
  private JLabel jLabel7 = new JLabel();
  private JTextField jTextField5 = new JTextField();
  private JLabel jLabel8 = new JLabel();
  private JButton jButton1 = new JButton();
  private JButton jButton2 = new JButton();
  private Database database1 = new Database();

  public ArtAcn(Frame frame, String title, boolean modal) {
    super(frame, title, modal);
    try {
      jbInit();
      pack();
    }
    catch(Exception ex) {
      ex.printStackTrace();
    }
  }

  public ArtAcn() {
    this(null, "", false);
  }
  private void jbInit() throws Exception {
    jPanel1.setLayout(xYLayout1);
    jLabel1.setForeground(Color.red);
    jLabel1.setBorder(BorderFactory.createEtchedBorder());
    jLabel1.setText("          文科科成绩录入");
    jLabel2.setBorder(BorderFactory.createEtchedBorder());
    jLabel3.setForeground(Color.red);
    jLabel3.setText("     数学");
    jLabel4.setForeground(Color.red);
    jLabel4.setText("     英语");
    jLabel5.setForeground(Color.red);
    jLabel5.setText("     语文");
    jLabel6.setForeground(Color.red);
    jLabel6.setText("     政治");
    jLabel7.setForeground(Color.red);
    jLabel7.setText("     历史");
    jLabel8.setBorder(BorderFactory.createEtchedBorder());
    jButton1.setText("确定");
    jButton1.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        jButton1_actionPerformed(e);
      }
    });
    jButton2.setText("取消");
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:local", "sa", "", false, "sun.jdbc.odbc.JdbcOdbcDriver"));
    this.getContentPane().add(jPanel1, BorderLayout.CENTER);
    jPanel1.add(jLabel1,       new XYConstraints(0, 1, 400, 26));
    jPanel1.add(jLabel3,  new XYConstraints(20, 45, 90, 20));
    jPanel1.add(jTextField1,    new XYConstraints(140, 45, 120, 20));
    jPanel1.add(jLabel4,   new XYConstraints(20, 90, 90, 20));
    jPanel1.add(jTextField2,   new XYConstraints(140, 90, 120, 20));
    jPanel1.add(jLabel5,    new XYConstraints(20, 135, 90, 20));
    jPanel1.add(jTextField3,    new XYConstraints(140, 135, 120, 20));
    jPanel1.add(jLabel6,   new XYConstraints(20, 180, 90, 20));
    jPanel1.add(jTextField4,   new XYConstraints(140, 180, 120, 20));
    jPanel1.add(jLabel7,   new XYConstraints(20, 225, 90, 20));
    jPanel1.add(jTextField5,      new XYConstraints(140, 225, 120, 20));
    jPanel1.add(jLabel2, new XYConstraints(1, 26, 399, 275));
    jPanel1.add(jLabel8,    new XYConstraints(1, 255, 397, 44));
    jPanel1.add(jButton1,        new XYConstraints(200, 265, 90, 30));
    jPanel1.add(jButton2,      new XYConstraints(300, 265, 90, 30));
  }
  public int Math(){
    return Integer.parseInt(jTextField1.getText().trim()) ;
  }
  public int English(){
   return Integer.parseInt(jTextField2.getText().trim()) ;
  }
  public int Chinese(){
    return Integer.parseInt(jTextField3.getText().trim()) ;
  }
  public int Polity(){
    return Integer.parseInt(jTextField4.getText().trim()) ;
  }
  public int History(){
    return Integer.parseInt(jTextField5.getText().trim()) ;
  }
  void cancel(){
    dispose() ;
  }


  void jButton1_actionPerformed(ActionEvent e) {
    ScienceAchievement scienceAchievement = new ScienceAchievement() ;
    int cardID = scienceAchievement.cardID() ;
    String studentName = scienceAchievement.studentName() ;
    String studentBefore = scienceAchievement.studentBefore() ;
    int Math = Math() ;
    int English = English() ;
    int Chinese = Chinese() ;
    int Polity = Polity() ;
    int History = History() ;

    int MathID = 1 ;
    int EnglishID = 2 ;
    int ChineseID = 3 ;
    int PolityID = 4 ;
    int HistoryID = 5 ;

    String MathName = "数学" ;
    String EnglishName = "英语" ;
    String ChineseName = "语文" ;
    String PolityName = "政治" ;
    String HistoryName = "化学" ;

    Statement sql = database1.createStatement() ;
    String stmt = "INSERT INTO [info].[dbo].[art](cardID,studentName,studentBefore)"+
                 "VALUES('"+cardID+"', '"+studentName+"' , '"+studentBefore+"')" ;
    String stmt1 = "INSERT INTO [info].[dbo].[art2](cardID,subjectID,subject,achievement)"+
                  "VALUES('"+cardID+"','"+MathID+"','"+MathName+"','"+Math+"')" ;
    String stmt2 = "INSERT INTO [info].[dbo].[art2](cardID,subjectID,subject,achievement)"+
                   "VALUES('"+cardID+"','"+EnglishID+"','"+EnglishName+"','"+English+"')" ;
    String stmt3 = "INSERT INTO [info].[dbo].[art2](cardID,subjectID,subject,achievement)" +
                   "VALUES('"+cardID+"','"+ChineseID+"','"+ChineseName+"','"+Chinese+"')" ;
    String stmt4 = "INSERT INTO [info].[dbo].[art2](cardID,subjectID,subject,achievement)" +
                   "VALUES('"+cardID+"','"+PolityID+"','"+PolityName+"','"+Polity+"')" ;
    String stmt5 = "INSERT INTO [info].[dbo].[art2](cardID,subjectID,subject,achievement)" +
                   "VALUES('"+cardID+"','"+HistoryID+"','"+HistoryName+"','"+History+"')" ;
    try{
      sql.executeUpdate(stmt) ;
      sql.executeUpdate(stmt1) ;
      sql.executeUpdate(stmt2) ;
      sql.executeUpdate(stmt3) ;
      sql.executeUpdate(stmt4) ;
      sql.executeUpdate(stmt5) ;
    }
    catch(Exception www){}
  }
}