bookborrow.java

图书管理设计文档

/*
 * BookBorrow.java
 * 说明：还书管理
 * 编写：刘勇
 * Created on 2005年1月2日, 下午2:26
 */
import java.sql.*;
import javax.swing.*;
import java.awt.event.*;
import javax.swing.JOptionPane.*;

public class BookBorrow extends javax.swing.JInternalFrame {
    private static int zl;
    private int rowCount=1;//行数
    private final int colCount=5;//列数
    private Object[][] ob=null;
    private DataConnect dc=null;
   
    
       private class JieshuTable extends javax.swing.table.DefaultTableModel 
        {
        private Class[] types =null;
        public JieshuTable(Object[][] ob)
            {
            super(ob,new String[]
                {"借还标志", "图书ID",  "日期", "最大归还日期","归还标志"});
            types= new Class[5]; 
            try
                {
                types[0]=Class.forName("java.lang.Integer");
                types[1]=Class.forName("java.lang.Integer");
                types[2]=Class.forName("java.lang.String");
                types[3]=Class.forName("java.lang.String");
                types[4]=Class.forName("java.lang.Integer");
                }
            catch(ClassNotFoundException e)
                {
                System.out.println("类路径安装错误");
                }
            }
        public Class getColumnClass(int columnIndex) 
            {
            return types [columnIndex];
            }
        };
    private JieshuTable mytable;
    
      private class ChaxunTable extends javax.swing.table.DefaultTableModel 
        {
        private Class[] types =null;
        public ChaxunTable(Object[][] ob)
            {
            super(ob,new String[]
                { "图书号", "图书名", "作者", "出版社", "条码"});
            types= new Class[6]; 
            try
                {
                types[0]=Class.forName("java.lang.Integer");
                types[1]=Class.forName("java.lang.String");
                types[2]=Class.forName("java.lang.String");
                types[3]=Class.forName("java.lang.String");
                types[4]=Class.forName("java.lang.String");
               // types[5]=Class.forName("java.lang.String");
                }
            catch(ClassNotFoundException e)
                {
                System.out.println("类路径安装错误");
                }
            }
        public Class getColumnClass(int columnIndex) 
            {
            return types [columnIndex];
            }
        };
    private ChaxunTable mychaxuntable;
    
    
    
    /** Creates new form BookBorrow */
    public BookBorrow(DataConnect dc) {
        this.dc=dc;
        jPanel1 = new javax.swing.JPanel();
        jLabel1 = new javax.swing.JLabel();
        jcb_j_zl = new javax.swing.JComboBox();
        jB_j_ok = new javax.swing.JButton();
        jLabel2 = new javax.swing.JLabel();
        jTF_j_id = new javax.swing.JTextField();
        jB_j_clean = new javax.swing.JButton();
        jLabel3 = new javax.swing.JLabel();
        jTF_j_rq = new javax.swing.JTextField();
        jB_j_chakan = new javax.swing.JButton();
        jLabel4 = new javax.swing.JLabel();
        jTF_j_hrq = new javax.swing.JTextField();
        //jB_j_exit = new javax.swing.JButton();
        jScrollPane1 = new javax.swing.JScrollPane();
        jTable1 = new javax.swing.JTable();
        jScrollPane2 = new javax.swing.JScrollPane();
        chaxuntable = new javax.swing.JTable();
        
        try
        {

             java.sql.Statement stmt=dc.getStatement();
            String sql = "Select name from BookSort";
            ResultSet rs = stmt.executeQuery( sql );
            String name,i;
            while( rs.next())
            {
                name = rs.getString(1);             
             jcb_j_zl.addItem(name);
                
            }
        }
    
        catch(SQLException e)
		{
		    System.out.println("错误：" + e);
		}

        jPanel1.setLayout(new java.awt.GridLayout(4, 3, 0, 10));

        jLabel1.setFont(new java.awt.Font("Dialog", 1, 16));
        jLabel1.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
        jLabel1.setText("\u56fe\u4e66\u79cd\u7c7b  ");
        jPanel1.add(jLabel1);

        jcb_j_zl.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jcb_j_zlActionPerformed(evt);
            }
        });

        jPanel1.add(jcb_j_zl);

        jB_j_ok.setFont(new java.awt.Font("Dialog", 1, 14));
        jB_j_ok.setText("\u786e\u5b9a");
        jB_j_ok.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
              jB_j_okActionPerformed(evt);
            }
        });

        jPanel1.add(jB_j_ok);

        jLabel2.setFont(new java.awt.Font("Dialog", 1, 16));
        jLabel2.setText("\u56fe\u4e66\u53f7");
        jPanel1.add(jLabel2);

        jPanel1.add(jTF_j_id);

        jB_j_clean.setFont(new java.awt.Font("Dialog", 1, 14));
        jB_j_clean.setText("\u53d6\u6d88");
        jB_j_clean.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jB_j_cleanActionPerformed(evt);
            }
        });

        jPanel1.add(jB_j_clean);

        jLabel3.setFont(new java.awt.Font("Dialog", 1, 16));
        jLabel3.setHorizontalAlignment(javax.swing.SwingConstants.LEFT);
        jLabel3.setText("\u501f\u4e66\u65f6\u95f4");
        jPanel1.add(jLabel3);

        jPanel1.add(jTF_j_rq);

        jB_j_chakan.setFont(new java.awt.Font("Dialog", 1, 14));
        jB_j_chakan.setText("\u67e5\u770b");
        jB_j_chakan.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jB_j_chakanActionPerformed(evt);
            }
        });

        jPanel1.add(jB_j_chakan);

        jLabel4.setFont(new java.awt.Font("Dialog", 1, 16));
        jLabel4.setText("\u6700\u5927\u8fd8\u4e66\u65f6\u95f4");
        jPanel1.add(jLabel4);

        jPanel1.add(jTF_j_hrq);
/*
        jB_j_exit.setFont(new java.awt.Font("Dialog", 1, 14));
        jB_j_exit.setText("\u9000\u51fa");
        jB_j_exit.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jB_j_exitActionPerformed(evt);
            }
        });

        jPanel1.add(jB_j_exit);
*/
        getContentPane().add(jPanel1, java.awt.BorderLayout.NORTH);

         jTable1.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null, null},
                {null, null, null, null, null},
                {null, null, null, null, null},
                {null, null, null, null, null}
            },
            new String [] {
             "借还标志", "图书ID", "日期", "最大归还日期","归还标志"
            }
        ));
        jTable1.addAncestorListener(new javax.swing.event.AncestorListener() {
            public void ancestorMoved(javax.swing.event.AncestorEvent evt) {
            }
            public void ancestorAdded(javax.swing.event.AncestorEvent evt) {
                jTable1AncestorAdded(evt);
            }
            public void ancestorRemoved(javax.swing.event.AncestorEvent evt) {
            }
        });