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].[science](cardID,studentName,studentBefore)"+                 "VALUES('"+cardID+"', '"+studentName+"' , '"+studentBefore+"')" ;    String stmt1 = "INSERT INTO [info].[dbo].[science2](cardID,subjectID,subject,achievement)"+                  "VALUES('"+cardID+"','"+MathID+"','"+MathName+"','"+Math+"')" ;    String stmt2 = "INSERT INTO [info].[dbo].[science2](cardID,subjectID,subject,achievement)"+                   "VALUES('"+cardID+"','"+EnglishID+"','"+EnglishName+"','"+English+"')" ;    String stmt3 = "INSERT INTO [info].[dbo].[science2](cardID,subjectID,subject,achievement)" +                   "VALUES('"+cardID+"','"+ChineseID+"','"+ChineseName+"','"+Chinese+"')" ;    String stmt4 = "INSERT INTO [info].[dbo].[science2](cardID,subjectID,subject,achievement)" +                   "VALUES('"+cardID+"','"+PolityID+"','"+PolityName+"','"+Polity+"')" ;    String stmt5 = "INSERT INTO [info].[dbo].[science2](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){}  }}