java课程设计案例源码_ArtAcn.java

package infomanagement;

//download by http://www.codefans.net

import java.awt.*;

import javax.swing.*;

import com.borland.jbcl.layout.*;

import java.awt.event.*;

import com.borland.dx.sql.dataset.*;

import java.sql.* ;

/**

*

Title:

*

Description:

*

Copyright: Copyright (c) 2003

*

Company:

* @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){}

}

}