lend.java

图书管理设计文档

/*
 * Lend.java
 * 说明：还书管理
 * 编写：郑涛
 * Created on 2001年2月8日, 上午3:53
 */
import javax.swing.*;
import java.sql.*;
/**
 *
 * @author  root
 */
public class Lend extends javax.swing.JInternalFrame {
    private int rowCount=1;//行数
    private final int colCount=5;//列数
    private Object[][] ob=null;
    private DataConnect dc=null;
    
    private class HuanshuTable extends javax.swing.table.DefaultTableModel 
    {
        private Class[] types =null;
        public HuanshuTable(Object[][] ob)
            {
            super(ob,new String[]
                {"用户ID", "图书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.String");
                }
            catch(ClassNotFoundException e)
                {
                System.out.println("类路径安装错误");
                }
            }
        public Class getColumnClass(int columnIndex) 
            {
            return types [columnIndex];
            }
        };
        private HuanshuTable mytable;
        
    
    /** Creates new form Lend */
    public Lend(DataConnect dc) {
        this.dc = dc;
        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.
     */
    private void initComponents() {//GEN-BEGIN:initComponents
        jToolBar1 = new javax.swing.JToolBar();
        jLabel1 = new javax.swing.JLabel();
        jTF_tsid = new javax.swing.JTextField();
        jB_hs = new javax.swing.JButton();
        jB_ck = new javax.swing.JButton();
        jScrollPane1 = new javax.swing.JScrollPane();
        jTable1 = new javax.swing.JTable();

        jToolBar1.setMaximumSize(new java.awt.Dimension(95, 25));
        jToolBar1.setMinimumSize(new java.awt.Dimension(95, 25));
        jToolBar1.setPreferredSize(new java.awt.Dimension(95, 25));
        jLabel1.setText("\u56fe\u4e66ID");
        jToolBar1.add(jLabel1);

        jTF_tsid.setHorizontalAlignment(javax.swing.JTextField.CENTER);
        jTF_tsid.setMaximumSize(new java.awt.Dimension(80, 2147483647));
        jTF_tsid.setMinimumSize(new java.awt.Dimension(15, 25));
        jTF_tsid.setPreferredSize(new java.awt.Dimension(4, 25));
        jToolBar1.add(jTF_tsid);

        jB_hs.setText("\u8fd8\u4e66");
        jB_hs.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jB_hsActionPerformed(evt);
            }
        });

        jToolBar1.add(jB_hs);

        jB_ck.setText("\u67e5\u770b");
        jB_ck.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jB_ckActionPerformed(evt);
            }
        });

        jToolBar1.add(jB_ck);

        getContentPane().add(jToolBar1, java.awt.BorderLayout.NORTH);

        jTable1.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null, null}
            },
            new String [] {
                "借还标志", "图书ID", "图书名", "借书日期", "还书日期"
            }
        ) {
            Class[] types = new Class [] {
                java.lang.Integer.class, java.lang.Integer.class, java.lang.String.class, java.lang.String.class, java.lang.String.class
            };

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

        getContentPane().add(jScrollPane1, java.awt.BorderLayout.CENTER);

        pack();
    }//GEN-END:initComponents

public void showdlg1()
{
        JOptionPane.showMessageDialog(this,"请写入图书号！", "Message", JOptionPane.ERROR_MESSAGE);
}
public void showdlg2()
{
        JOptionPane.showMessageDialog(this,"还书成功，谢谢!", "Message", JOptionPane.ERROR_MESSAGE);
}
    private void jB_hsActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jB_hsActionPerformed
        // TODO 将在此处增加您的处理代码：
            String state = "0";
            String userid = "1";
            String guihuan ="0";
            String date,maxdate,bookid;
            bookid = jTF_tsid.getText();
            if(bookid == null){
                this.showdlg1();
            }
            else
            {
                try
                {
                    Statement stmt= dc.getStatement();
                    stmt.executeUpdate
                            ("UPDATE Borrow SET state=1,date='00000000',MaxDate='00000000',return=1 WHERE UserId=1 and BookId="+bookid+"");
                    //UPDATE Borrow SET state=0,date='20041231',MaxDate='20050129',return=0 WHERE UserId=1 and BookId=1
                    //stmt.executeUpdate("INSERT INTO Borrow(state,BookId,UserId,date,MaxDate,return) VALUES ("+state+","+bookid+","+userid+",'"+date+"','"+maxdate+"',"+guihuan+")");
                    this.showdlg2();
                    jTF_tsid.setText("");
                }
                catch(SQLException e)
                {
                    JOptionPane.showMessageDialog(this,"还书失败!!");
                }
            }
            
    }//GEN-LAST:event_jB_hsActionPerformed

    private void jB_ckActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jB_ckActionPerformed
        // TODO 将在此处增加您的处理代码：
          try
            {
            java.sql.Statement stmt=dc.getStatement();
            String strSql="SELECT count(BookId) from Borrow WHERE UserId=1";//UserId=1//cs
            java.sql.ResultSet rs=stmt.executeQuery(strSql);
            rs.next();
            //System.out.println(rs.getInt(1));//cs
            rowCount=rs.getInt(1)==0?1:rs.getInt(1);
            System.out.println(rowCount);//cs
            ob=new Object[rowCount][colCount];
             if(rs.getInt(1)==0)
                {
                javax.swing.JOptionPane.showMessageDialog
                    (this,"该用户没有借书！","",
                        javax.swing.JOptionPane.ERROR_MESSAGE);
                }
            else
                {
                rs=null;
                rs=stmt.executeQuery
                    ("SELECT Borrow.state,Borrow.BookId,Book.name,Borrow.date,Borrow.MaxDate from Borrow,Book where Borrow.state=0 and Borrow.Userid=1 and Borrow.Bookid=Book.id");
               //java.sql.ResultSet rs1 = stmt.executeQuery("SELECT name FROM Book WHERE id="+new Integer(rs.getInt("BookId"))+"");
                int i=0;
                while(rs.next())
                {
                    ob[i][0]=(rs.getInt(1)==0)?"借":"还";
                    ob[i][1]=new Integer(rs.getInt(2));
                    /*while(rs1.next())
                    {
                        ob[i][2]=rs1.getString("name");
                        System.out.println(rs1.getString("name"));
                    }*/ob[i][2]=rs.getString(3);//(rs.getInt("return")==0)?"未还":"已还";
                    ob[i][3]=rs.getString(4);
                    ob[i][4]=rs.getString(5);
                    i++;
                 }
                 /*
                 while(rs1.next())
                 {
                     ob[i][2]=new String(rs1.getString("name"));
                 }*/
                 }
                     
            mytable=new HuanshuTable(ob);
            jTable1.setModel(mytable);
            stmt=null;rs=null;
            }
        catch(java.sql.SQLException sqle)
            {
            javax.swing.JOptionPane.showMessageDialog(this,"sql出错");
            System.out.println(sqle);
            }           
    }//GEN-LAST:event_jB_ckActionPerformed
    
    /*
    // 变量声明 - 不进行修改//GEN-BEGIN:variables
    private javax.swing.JButton jB_ck;    private javax.swing.JButton jB_hs;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JTextField jTF_tsid;
    private javax.swing.JTable jTable1;
    private javax.swing.JToolBar jToolBar1;
    // 变量声明结束//GEN-END:variables
    */
    // 变量声明 - 不进行修改
    private javax.swing.JButton jB_ck;
    private javax.swing.JButton jB_hs;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JTextField jTF_tsid;
    private javax.swing.JTable jTable1;
    private javax.swing.JToolBar jToolBar1;
    // 变量声明结束
}