cxxj.java

java+SQLServer2005编写的学生学籍管理系统

/*
 * cxxj.java
 *
 * Created on 2007年11月5日, 下午2:50
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package studentsystem;

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2006</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class cxxj extends JFrame {
    Statement ps;
    ResultSet rs;
    Connection con;
    String url;
    JScrollPane jScrollPane1 = new JScrollPane();
    Object[][] rowData = new Object[10][9];
    String[] columnNames = {"学号", "姓名", "性别", "出生日期", "班号", "联系电话", "入校日期", "家庭住址", "备注"};      
    JTable jTable1 = new JTable(rowData, columnNames);
    JButton cancel = new JButton();
    JButton ok = new JButton();
    JTextField input = new JTextField();
    ButtonGroup buttonGroup2 = new ButtonGroup();
    JRadioButton xh = new JRadioButton();
    JRadioButton xm = new JRadioButton();
    JRadioButton bh = new JRadioButton();
    public cxxj() {
        try {
            jbInit();
        }
        catch (Exception e) {
            e.printStackTrace();
        }
    }

    public static void main(String[] args) {
        cxxj cxxj = new cxxj();
    }

    private void jbInit() throws Exception {
        this.setLocale(java.util.Locale.getDefault());
        this.getContentPane().setLayout(null);
        jScrollPane1.setBounds(new Rectangle(6, 0, 780, 400));
        ok.setToolTipText("直接点击确定，可查询全部学生信息");
        cancel.setBounds(new Rectangle(578, 412, 85, 30));
        cancel.setFont(new java.awt.Font("Dialog", 0, 15));
        cancel.setText("取   消");
        cancel.addActionListener(new cxxj_cancel_actionAdapter(this));
        ok.setBounds(new Rectangle(465, 412, 85, 34));
        ok.setFont(new java.awt.Font("Dialog", 0, 15));
        ok.setText("确   定");
        ok.addActionListener(new cxxj_ok_actionAdapter(this));
        input.setFont(new java.awt.Font("Dialog", 0, 15));
        input.setText("");
        input.setBounds(new Rectangle(291, 410, 124, 31));
        xh.setFont(new java.awt.Font("Dialog", 0, 15));
        xh.setRolloverEnabled(false);
        xh.setText("按学号");
        xh.setBounds(new Rectangle(20, 417, 74, 34));
        xm.setBounds(new Rectangle(95, 417, 74, 34));
        xm.setText("按姓名");
        xm.setRolloverEnabled(false);
        xm.setFont(new java.awt.Font("Dialog", 0, 15));
        bh.setBounds(new Rectangle(174, 418, 74, 34));
        bh.setText("按班号");
        bh.setRolloverEnabled(false);
        bh.setFont(new java.awt.Font("Dialog", 0, 15));
        this.getContentPane().add(jScrollPane1, null);
        this.getContentPane().add(input, null);
        this.getContentPane().add(ok, null);
        this.getContentPane().add(cancel, null);
        this.getContentPane().add(bh, null);
        this.getContentPane().add(xm, null);
        this.getContentPane().add(xh, null);
        jScrollPane1.getViewport().add(jTable1, null);
        this.setBounds(100, 100, 800, 500);
        this.setVisible(true);
        buttonGroup2.add(xh);
        buttonGroup2.add(bh);
        buttonGroup2.add(xm);
    }

    void cancel_actionPerformed(ActionEvent e) {
        this.dispose();
    }

    void ok_actionPerformed(ActionEvent e) {
        try { //连接数据库
            String name = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
            String url ="jdbc:sqlserver://localhost:1433; DatabaseName=student";                
            Class.forName(name);
            Connection con = DriverManager.getConnection(url, "ss", "123");
            ps = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
            int i = 0;
            try {
                if (xh.isSelected()) {
                    rs = ps.executeQuery("select * from student where student_ID='" +input.getText().trim() + "'");                            
                }
                else if (xm.isSelected()) {
                    rs = ps.executeQuery("select * from student where student_Name='" + input.getText().trim() + "'");                               
                }
                else if (bh.isSelected()) {
                    rs = ps.executeQuery("select * from student where class_NO='" + input.getText().trim() + "'");                          
                }
                else
                    rs = ps.executeQuery("select * from student");
                }

            catch (Exception err) {
                String err1 = err.getMessage();
                JOptionPane.showMessageDialog(null, err);
            }
            while (rs.next()) {
                rowData[i][0] = rs.getString("student_ID");
                rowData[i][1] = rs.getString("student_Name");
                rowData[i][2] = rs.getString("student_Sex");
                rowData[i][3] = rs.getString("born_Date").substring(0, 10);
                rowData[i][4] = rs.getString("class_NO");
                rowData[i][5] = rs.getString("tele_Number");
                rowData[i][6] = rs.getString("ru_Date").substring(0, 10);
                rowData[i][7] = rs.getString("address");
                rowData[i][8] = rs.getString("comment");
                i = i + 1;
            }
        }
        catch (Exception err) {
            String err1 = err.getMessage();
            JOptionPane.showMessageDialog(null, err);
        }
    }
}

class cxxj_cancel_actionAdapter implements java.awt.event.ActionListener {   
    cxxj adaptee;
    cxxj_cancel_actionAdapter(cxxj adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.cancel_actionPerformed(e);
    }
}

class cxxj_ok_actionAdapter implements java.awt.event.ActionListener {   
    cxxj adaptee;
    cxxj_ok_actionAdapter(cxxj adaptee) {
        this.adaptee = adaptee;
    }
    public void actionPerformed(ActionEvent e) {
        adaptee.ok_actionPerformed(e);
    }
}