frmmanager.java

此程序是用Java实现的一个图书管理系统,再加以可以做毕业设计用而,而且实现的工能相对效全.

package bookmanager;

import javax.swing.JFrame;
import java.awt.*;
import javax.swing.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.table.JTableHeader;
import javax.swing.table.DefaultTableModel;
import java.util.Vector;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.*;

public class frmmanager extends JFrame {//这个界面实现管理员的设置
    Vector vt;
    DefaultTableModel dt;
    Statement st;
    ResultSet rs;
     Vector tempvt;
    public frmmanager() {
        dbconnection h = new dbconnection();
        try {
            jbInit();
            st = h.getconnection().createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
            rs = st.executeQuery("select * from userinfo");
                vt = new Vector();
                while (rs.next()) {
                    tempvt = new Vector();
                    for (int i = 1; i <= rs.getMetaData().getColumnCount(); i++) {//从数据库中循环取记录数
                        tempvt.add(rs.getString(i));
                    }
                    vt.add(tempvt);
                }
                Vector vtColName = new Vector();
              /*  for (int i = 1; i <= rs.getMetaData().getColumnCount(); i++) {//从数据库中取数据表头的一种方法
                    vtColName.add(rs.getMetaData().getColumnName(i));
                }*/
              vtColName.add("用户名");vtColName.add("密码");
                dt=new DefaultTableModel(vt,vtColName);
                jTable1.setModel(dt);
        } catch (SQLException ex) {
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }
    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        this.setTitle("管理员设置");
        lblx.setText("用户名:");
        lblx.setBounds(new Rectangle(0, 109, 50, 25));
        txti.setBorder(BorderFactory.createEtchedBorder());
        txti.setText("");
        txti.setBounds(new Rectangle(55, 108, 111, 23));
        lbly.setText("密码：");
        lbly.setBounds(new Rectangle(0, 143, 41, 18));
        txth.setBorder(BorderFactory.createEtchedBorder());
        txth.setText("");
        txth.setBounds(new Rectangle(54, 141, 113, 21));
        radadd.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        radadd.setText("添加");
        radadd.setBounds(new Rectangle(0, 180, 57, 21));
        radadd.addActionListener(new frmmanager_radadd_actionAdapter(this));
        radinsert.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        radinsert.setText("保存");
        radinsert.setBounds(new Rectangle(95, 180, 65, 20));
        radinsert.addActionListener(new frmmanager_radinsert_actionAdapter(this));
        raddelete.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        raddelete.setText("删除");
        raddelete.setBounds(new Rectangle(0, 207, 60, 20));
        raddelete.addActionListener(new frmmanager_raddelete_actionAdapter(this));
        radexit.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        radexit.setText("退出");
        radexit.setBounds(new Rectangle(95, 207, 61, 23));
        radexit.addActionListener(new frmmanager_radexit_actionAdapter(this));
        jScrollPane1.getViewport().setBackground(Color.lightGray);
        jScrollPane1.setBorder(BorderFactory.createEtchedBorder());
        jScrollPane1.setBounds(new Rectangle(0, 0, 166, 103));
        jTableHeader1.setBounds(new Rectangle(0, 0, 166, 21));
        jTableHeader1.setReorderingAllowed(false);//设置表头不可移动
        jTableHeader1.setResizingAllowed(false);
        this.getContentPane().add(lblx);
        this.getContentPane().add(txti);
        this.getContentPane().add(txth);
        this.getContentPane().add(lbly);
        this.getContentPane().add(radinsert);
        this.getContentPane().add(radexit);
        this.getContentPane().add(raddelete);
        this.getContentPane().add(radadd);
        this.getContentPane().add(jScrollPane1);
        jScrollPane1.getViewport().add(jTable1);
        btngrp.add(radadd);
        btngrp.add(radinsert);
        btngrp.add(raddelete);
        btngrp.add(radexit);
        jTable1.setAutoResizeMode(jTable1.AUTO_RESIZE_OFF);
    }

    JLabel lblx = new JLabel();
    JTextField txti = new JTextField();
    JLabel lbly = new JLabel();
    JTextField txth = new JTextField();
    JRadioButton radadd = new JRadioButton();
    JRadioButton radinsert = new JRadioButton();
    JRadioButton raddelete = new JRadioButton();
    JRadioButton radexit = new JRadioButton();
    ButtonGroup btngrp = new ButtonGroup();
    FlowLayout flowLayout1 = new FlowLayout();
    JScrollPane jScrollPane1 = new JScrollPane();
    JTable jTable1 = new JTable();
    JTableHeader jTableHeader1 = jTable1.getTableHeader();
    public void radexit_actionPerformed(ActionEvent e) {
        this.dispose();
    }

    public void radadd_actionPerformed(ActionEvent e) {//实现添加功能
        Vector t=new Vector();
        t.add(txti.getText());
        t.add(txth.getText());
        vt.add(t);
        dt.fireTableStructureChanged();
    }

    public void radinsert_actionPerformed(ActionEvent e) {//实现保存功能
        try {
            dbconnection h = new dbconnection();
            Statement st =h.getconnection().createStatement();
                    String a="insert into userinfo(username,pwd) values('" +
                            txti.getText() + "'," + txth.getText() + ")";
                   st.executeUpdate(a);
        } catch (SQLException ex) {
        }
    }

    public void raddelete_actionPerformed(ActionEvent e) {//实现删除功能
       int r;
        String un;
        r = jTable1.getSelectedRow();
        if (r != -1) {
            un = (String) jTable1.getValueAt(r, 0);
            if (r >= 0) {
                vt.remove(r);
                try {
                    dbconnection h = new dbconnection();
                    Statement st = h.getconnection().createStatement();
                    String a = "delete from userinfo where username='" +
                               un + "'";
                    st.executeUpdate(a);
                } catch (SQLException ex) {
                }
            } else
                JOptionPane.showMessageDialog(this, "没有选中任何一项", "",
                                              JOptionPane.ERROR_MESSAGE);
            dt.fireTableStructureChanged();
        }
    }
}
class frmmanager_radinsert_actionAdapter implements ActionListener {
    private frmmanager adaptee;
    frmmanager_radinsert_actionAdapter(frmmanager adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.radinsert_actionPerformed(e);
    }
}


class frmmanager_raddelete_actionAdapter implements ActionListener {
    private frmmanager adaptee;
    frmmanager_raddelete_actionAdapter(frmmanager adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.raddelete_actionPerformed(e);
    }
}


class frmmanager_radadd_actionAdapter implements ActionListener {
    private frmmanager adaptee;
    frmmanager_radadd_actionAdapter(frmmanager adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.radadd_actionPerformed(e);
    }
}


class frmmanager_radexit_actionAdapter implements ActionListener {
    private frmmanager adaptee;
    frmmanager_radexit_actionAdapter(frmmanager adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {

        adaptee.radexit_actionPerformed(e);
    }
}