borrow.java

JAVA图书管理系统有很多代码这只是很小的一部分

/*
 * Borrow.java
 *
 * Created on 2004年1月4日, 下午6:09
 */

package library;
import java.sql.*;
import javax.swing.JOptionPane;
/**
 *
 * @author  Administrator
 */
public class Borrow extends javax.swing.JFrame {
    
    /** Creates new form Borrow */
    public Borrow() {
        initComponents();
    }
    
    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    // <editor-fold defaultstate="collapsed" desc=" 生成的代码 ">//GEN-BEGIN:initComponents
    private void initComponents() {
        jLabel1 = new javax.swing.JLabel();
        readTextField = new javax.swing.JTextField();
        jLabel2 = new javax.swing.JLabel();
        jScrollPane1 = new javax.swing.JScrollPane();
        readTable = new javax.swing.JTable();
        jLabel3 = new javax.swing.JLabel();
        bookTextField = new javax.swing.JTextField();
        bookLabel = new javax.swing.JLabel();
        jScrollPane2 = new javax.swing.JScrollPane();
        bookTable = new javax.swing.JTable();
        jButton1 = new javax.swing.JButton();
        jButton2 = new javax.swing.JButton();

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
        setTitle("\u501f\u4e66\u7cfb\u7edf");
        jLabel1.setText("\u8bfb\u8005\u7f16\u53f7\uff1a");

        readTextField.addKeyListener(new java.awt.event.KeyAdapter() {
            public void keyReleased(java.awt.event.KeyEvent evt) {
                readTextFieldKeyReleased(evt);
            }
        });

        jLabel2.setText("\u4f8b\u5982\uff1a001");

        readTable.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null, null}
            },
            new String [] {
                "编号", "姓名", "性别", "类型", "部门"
            }
        ) {
            Class[] types = new Class [] {
                java.lang.String.class, java.lang.String.class, java.lang.String.class, java.lang.String.class, java.lang.String.class
            };

            public Class getColumnClass(int columnIndex) {
                return types [columnIndex];
            }
        });
        jScrollPane1.setViewportView(readTable);

        jLabel3.setText("\u56fe\u4e66\u7f16\u53f7\uff1a");

        bookTextField.addKeyListener(new java.awt.event.KeyAdapter() {
            public void keyReleased(java.awt.event.KeyEvent evt) {
                bookTextFieldKeyReleased(evt);
            }
        });

        bookLabel.setText("\u4f8b\u5982\uff1a1001");

        bookTable.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null, null, null, null},
                {null, null, null, null, null, null, null}
            },
            new String [] {
                "编号", "书名", "是否借出", "类别", "出版社", "作者", "借阅"
            }
        ) {
            Class[] types = new Class [] {
                java.lang.String.class, java.lang.String.class, java.lang.Boolean.class, java.lang.String.class, java.lang.String.class, java.lang.String.class, java.lang.String.class
            };

            public Class getColumnClass(int columnIndex) {
                return types [columnIndex];
            }
        });
        jScrollPane2.setViewportView(bookTable);

        jButton1.setText("\u501f\u51fa");
        jButton1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton1ActionPerformed(evt);
            }
        });

        jButton2.setText("\u8fd4\u56de");
        jButton2.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton2ActionPerformed(evt);
            }
        });

        org.jdesktop.layout.GroupLayout layout = new org.jdesktop.layout.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(layout.createSequentialGroup()
                .add(layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                    .add(layout.createSequentialGroup()
                        .add(31, 31, 31)
                        .add(jLabel1)
                        .add(22, 22, 22)
                        .add(readTextField, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 55, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                        .add(49, 49, 49)
                        .add(jLabel2))
                    .add(layout.createSequentialGroup()
                        .add(30, 30, 30)
                        .add(jLabel3)
                        .add(27, 27, 27)
                        .add(bookTextField, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 57, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                        .add(46, 46, 46)
                        .add(bookLabel)
                        .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED, 186, Short.MAX_VALUE))
                    .add(layout.createSequentialGroup()
                        .addContainerGap()
                        .add(jScrollPane1, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 456, Short.MAX_VALUE))
                    .add(layout.createSequentialGroup()
                        .addContainerGap()
                        .add(jScrollPane2, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 456, Short.MAX_VALUE)))
                .addContainerGap())
            .add(layout.createSequentialGroup()
                .add(60, 60, 60)
                .add(jButton1)
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED, 187, Short.MAX_VALUE)
                .add(jButton2)
                .add(115, 115, 115))
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(layout.createSequentialGroup()
                .addContainerGap()
                .add(layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(jLabel2)
                    .add(readTextField, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                    .add(jLabel1))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                .add(jScrollPane1, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 58, Short.MAX_VALUE)
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                .add(layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(jLabel3)
                    .add(bookTextField, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                    .add(bookLabel))
                .add(25, 25, 25)
                .add(jScrollPane2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 62, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                .add(28, 28, 28)
                .add(layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                    .add(jButton1)
                    .add(jButton2))
                .add(41, 41, 41))
        );
        pack();
    }// </editor-fold>//GEN-END:initComponents

    private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton2ActionPerformed
// TODO 将在此处添加您的处理代码：
       this.hide();
              MainFrame mf=new MainFrame();
              mf.show();
        
    }//GEN-LAST:event_jButton2ActionPerformed

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed
// TODO 将在此处添加您的处理代码：
        read=readTextField.getText().trim();
        book=bookTextField.getText().trim();
     if (read!="" && book!="" ){
          ResultSet rs;
          int result;
          try{  
             Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
             Connection con=DriverManager.getConnection("jdbc:odbc:library","","");      
             Statement st=con.createStatement(); 
             String s1="Select isBorrow from bookInfo where code='"+book+"'";
             rs=st.executeQuery(s1);  
             rs.next();
             if(rs.getString("isBorrow").trim().equals("0")){
                String s2="update bookInfo set isBorrow=True,reader_code='"+ read+"' where code='"+book+"'";
                result=st.executeUpdate(s2);  
                bookTable.setValueAt(true,0,2);
               bookTable.setValueAt(read,0,6);
             }else{
                   JOptionPane.showMessageDialog(this,"此书不在");
             }
                 st.close();
                 con.close();   
        }catch(Exception e){
            System.out.println(e.getMessage());
        }
          }else{
             JOptionPane.showMessageDialog(this,"请输入用户号和书号！"); 
          }
     
    }//GEN-LAST:event_jButton1ActionPerformed

    private void bookTextFieldKeyReleased(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_bookTextFieldKeyReleased
// TODO 将在此处添加您的处理代码：
        try{
            String code=bookTextField.getText().trim();
           Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
             Connection con =DriverManager.getConnection("jdbc:odbc:library","","");
             Statement st= con.createStatement();
             if(!"".equalsIgnoreCase(code)){
              String s1="select * from bookInfo where code='"+code+"'";
             ResultSet rs=st.executeQuery(s1);
           
            if(rs.next()){
                 String name=rs.getString(2);
                 String type=rs.getString(3);
                 String press=rs.getString(4);
                 String writer=rs.getString(5);
                   boolean isBorrow=rs.getBoolean(6);
                 String reader_code=rs.getString(7);
                 bookTable.setValueAt(code,0,0);
                 bookTable.setValueAt(name,0,1);
                 bookTable.setValueAt(new Boolean(isBorrow),0,2);
                 bookTable.setValueAt(type,0,3);
                 bookTable.setValueAt(press,0,4);
                 bookTable.setValueAt(writer,0,5);
                 bookTable.setValueAt(reader_code,0,6);
             }
             
               rs.close();
             st.close();
             con.close();
        }
          else{
               JOptionPane.showMessageDialog(null,"重新输入");;  
             }
              }catch(Exception e){
            e.getMessage();
        }
    }//GEN-LAST:event_bookTextFieldKeyReleased

    private void readTextFieldKeyReleased(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_readTextFieldKeyReleased
// TODO 将在此处添加您的处理代码：
        try{
            String code=readTextField.getText().trim();
             Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
             Connection con =DriverManager.getConnection("jdbc:odbc:library","","");
             Statement st= con.createStatement();
              String s1="select * from readerInfo where code='"+code+"'";
             ResultSet rs=st.executeQuery(s1);
             if(!"".equalsIgnoreCase(code)){
            if(rs.next()){
                 String name=rs.getString(2);
                 String sex=rs.getString(3);
                 String type=rs.getString(4);
                 String dept=rs.getString(5);
                 readTable.setValueAt(code,0,0);
                 readTable.setValueAt(name,0,1);
                 readTable.setValueAt(sex,0,2);
                 readTable.setValueAt(type,0,3);
                 readTable.setValueAt(dept,0,4);
             }
             
             rs.close();
             st.close();
             con.close();
        }
          else{
               JOptionPane.showMessageDialog(null,"重新输入");;  
             }
        }catch(Exception e){
            e.getMessage();
        }
    }//GEN-LAST:event_readTextFieldKeyReleased
    
    /**
     * @param args the command line arguments
     */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new Borrow().setVisible(true);
            }
        });
    }
    
    // 变量声明 - 不进行修改//GEN-BEGIN:variables
    private javax.swing.JLabel bookLabel;
    private javax.swing.JTable bookTable;
    private javax.swing.JTextField bookTextField;
    private javax.swing.JButton jButton1;
    private javax.swing.JButton jButton2;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JScrollPane jScrollPane2;
    private javax.swing.JTable readTable;
    private javax.swing.JTextField readTextField;
    // 变量声明结束//GEN-END:variables
       String read;
       String book;
}