frmmanager.java~43~

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

package bookmanager;

import java.awt.BorderLayout;
import javax.swing.JFrame;
import javax.swing.JPanel;
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 {//这个界面实现管理员的设置
    JTable tblname = new JTable();
    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));
                }
                dt=new DefaultTableModel(vt,vtColName);
                tblname.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(7, 109, 50, 25));
        txti.setBorder(BorderFactory.createEtchedBorder());
        txti.setText("");
        txti.setBounds(new Rectangle(62, 108, 108, 23));
        lbly.setText("密码：");
        lbly.setBounds(new Rectangle(12, 143, 41, 18));
        txth.setBorder(BorderFactory.createEtchedBorder());
        txth.setText("");
        txth.setBounds(new Rectangle(62, 141, 108, 21));
        tblname.setToolTipText("");
        tblname.setBounds(new Rectangle(5, 22, 166, 83));
        radadd.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        radadd.setText("添加");
        radadd.setBounds(new Rectangle(15, 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(94, 175, 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(13, 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(93, 206, 61, 23));
        radexit.addActionListener(new frmmanager_radexit_actionAdapter(this));
        jTableHeader1.setBounds(new Rectangle(5, 0, 173, 21));
        jTableHeader1.setReorderingAllowed(false);
        jTableHeader1.setResizingAllowed(false);
        this.getContentPane().add(lblx);
        this.getContentPane().add(txti);
        this.getContentPane().add(txth);
        this.getContentPane().add(tblname);
        this.getContentPane().add(lbly);
        this.getContentPane().add(radinsert);
        this.getContentPane().add(radexit);
        this.getContentPane().add(raddelete);
        this.getContentPane().add(radadd);
        this.getContentPane().add(jTableHeader1);
        btngrp.add(radadd);
        btngrp.add(radinsert);
        btngrp.add(raddelete);
        btngrp.add(radexit);
    }

    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();
    Color color1 = tblname.getSelectionForeground();
    FlowLayout flowLayout1 = new FlowLayout();
    JTableHeader jTableHeader1 = tblname.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,j,i;
        String un;
         r=tblname.getSelectedRow();
         j=tblname.getSelectedColumn();
         un=(String) tblname.getValueAt(r,j);
        if(r>=0)
        {
            vt.remove(r);
            try {
            dbconnection h = new dbconnection();
            Statement st =h.getconnection().createStatement();
                    String a="delete from userinfo where username='" +
                           un + "'";
                   System.out.println(a);
                   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);
    }
}