新建 文本文档.txt

来自「学生成绩管理」· 文本 代码 · 共 466 行 · 第 1/2 页

import javax.swing.UIManager;
import java.awt.*;
import java.awt.event.*;
import java.lang.*;
import java.lang.Object.*;
import java.sql.*;
import java.util.*;
import javax.swing.*;
import javax.swing.event.*;
import javax.swing.table.*;
public class StuAddQuerySysApp{
    private boolean packFrame=false;
    public StuAddQuerySysApp(){
        StuAddQuerySysFrame frame=new StuAddQuerySysFrame();
        if(packFrame){
            frame.pack();
        }
        else{
            frame.validate();
        }
        Dimension screenSize=Toolkit.getDefaultToolkit().getScreenSize();
        Dimension frameSize=frame.getSize();
        if(frameSize.height>screenSize.height){
            frameSize.height=screenSize.height-100;
        }
        if(frameSize.width>screenSize.width){
            frameSize.width=screenSize.width;
        }
        frame.setLocation((screenSize.width-frameSize.width)/2,(screenSize.height-frameSize.height)/2);
        frame.setVisible(true);
    }
    public static void main(String[] args){
        try{
            UIManager.setLookAndFeel(UIManager.getSystemLookAndFeelClassName());
        }
        catch(Exception e){
            e.printStackTrace();
        }
        new StuAddQuerySysApp();
    }
}

class StuAddQuerySysFrame extends JFrame{
    private JPanel contentPane;
    private FlowLayout xYLayout1=new FlowLayout();
    private Label label1=new Label();
    private TextField stunumField=new TextField(10);
    private TextField nameField=new TextField(15);
    private Label label2=new Label();
    private TextField ageField=new TextField(8);
    private Label label3=new Label();
    private TextField sexField=new TextField(8);
    private Label label4=new Label();
    private TextField departmentField=new TextField(18);
    private Label label5=new Label();
    private TextField teleField=new TextField(12);
    private Label label6=new Label();
    private TextField emailField=new TextField(18);
    private Label label7=new Label();
    private Button addrecordButton=new Button();
    private Button deleteButton=new Button();
    private Button refreshButton=new Button();
    private Button stunumqueryButton=new Button();
    private Button allrecordButton=new Button();
    Vector vector;
    String title[]={"学号","姓名","年龄","性别","系名","电话","email地址"};
    Connection connection=null;
    ResultSet rSet=null;
    Statement statement=null;
    AbstractTableModel tm;
    public StuAddQuerySysFrame(){
        enableEvents(AWTEvent.WINDOW_EVENT_MASK);
        try{
            jbInit();
        }
        catch(Exception e){
            e.printStackTrace();
        }
    }
private void jbInit() throws Exception{
    contentPane=(JPanel) this.getContentPane();
    label1.setText("");
    contentPane.setLayout(xYLayout1);
    this.setSize(new Dimension(550,350));
    this.setTitle("");
    label2.setText("");
    label3.setText("");
    label4.setText("");
    label5.setText("");
    label6.setText("");
    label7.setText("");
    addrecordButton.setLabel("");
    deleteButton.setLabel("");
    refreshButton.setLabel("");
    stunumqueryButton.setLabel("");
    allrecordButton.setLabel("");
    addrecordButton.addActionListener(new java.awt.event.ActionListener(){
        public void actionPerformed(ActionEvent e){
            addrecordButton_actionPerformed(e);
        }
    });
    deleteButton.addActionListener(new java.awt.event.ActionListener(){
        public void actionPerformed(ActionEvent e){
            deleteButton_actionPerformed(e);
        }
    });
    refreshButton.addActionListener(new java.awt.event.ActionListener(){
        public void actionPerformed(ActionEvent e){
            refreshButton_actionPerformed(e);
        }
    });
    stunumqueryButton.addActionListener(new java.awt.event.ActionListener(){
        public void actionPerformed(ActionEvent e){
            stunumqueryButton_actionPerformed(e);
        }
    });
    allrecordButton.addActionListener(new java.awt.event.ActionListener(){
        public void actionPerformed(ActionEvent e){
            allrecordButton_actionPerformed(e);
        }
    });
    contentPane.add(label1);
    contentPane.add(stunumField);
    contentPane.add(label2);
    contentPane.add(nameField);
    contentPane.add(label3);
    contentPane.add(ageField);
    contentPane.add(label4);
    contentPane.add(sexField);
    contentPane.add(label5);
    contentPane.add(departmentField);
    contentPane.add(label6);
    contentPane.add(teleField);
    contentPane.add(label7);
    contentPane.add(emailField);
    contentPane.add(addrecordButton);
    contentPane.add(deleteButton);
    contentPane.add(refreshButton);
    contentPane.add(stunumqueryButton);
    contentPane.add(allrecordButton);
    createtable();
} 

void createtable(){
    JTable table;
    JScrollPane scroll;
    vector=new Vector();
    tm=new AbstractTableModel(){
        public int getColumnCount(){
            return title.length;
        }
        public int getRowCount(){
            return vector.size();
        }
        public Object getValaueAt(int row,int column){
            if(!vector.isEmpty()){
                return ((Vector)vector.elementAt(row)).elementAt(column);
            }
            else{
                return null;
            }
        }
        public void setValueAt(Object value,int row,int colum){
            }
        public String getColumnName(int column){
            return title[column];
        }
        public Class getColumnClass(int c){
            return getValueAt(0,c).getClass();
        }
        public boolean isCellEditable(int row,int column){
                return false;
    }
};
table=new JTable(tm);
table.setToolTipText("Display Query Result");
table.setAutoResizeMode(table.AUTO_RESIZE_OFF);
table.setCellSelectionEnabled(false);
table.setShowHorizontalLines(true);
table.setShowVerticalLines(true);
scroll=new JScrollPane(table);
scroll.setPreferredSize(new Dimension(530,200));
contentPane.add(scroll);
}
protected void processWindowEvent(WindowEvent e){
    super.processWindowEvent(e);
    if(e.getID()==WindowEvent.WINDOW_CLOSING){
        System.exit(0);
    }
}

void addrecordButoon_actionPerformed(ActionEvent e){
    try{
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        String url="jdbc:odbc:student";
        connection=DriverManager.getConnection(url);
        statement=connection.createStatement();
        String sql1="insert into studentbase()values("+Integer.parseInt(stunumField.getText())+
                ", '"+nameField.getText()+"',"+Integer.parseInt(ageField.getText())+",'"+sexField.getText()
                +"','"+departmentField.getText()+"')";
        String sql2="insert into studentbase()values('"+teleField.getText()+"','"+
                emailField.getText()+"',"+Integer.parseInt(stunumField.getText())+")";
        statement.executeUpdate(sql2);
        statement.executeUpdate(sql1);
        stunumField.setText("");
        nameField.setText("");
        ageField.setText("");
        sexField.setText("");
        departmentField.setText("");
        teleField.setText("");
        emailField.setText("");
    }
    catch(SQLException ex){
        System.out.println("\nERROR:-----SQLException-----\n");
        while(ex!=null){
            System.out.println("Message: "+ex.getMessage());
            System.out.println("SQLState: "+ex.getSQLState());
            System.out.println("ErrorCode: "+ex.getErrorCode());
            ex=ex.getNextException();
        }        
    }
    catch(Exception ex){
        ex.printStackTrace();
    }
    finally{
        try{
            if(statement !=null){
                statement.close();
            }
            if(connection !=null){
                connection.close();
            }
        }