bookborrow.java

图书管理设计文档

        jScrollPane1.setViewportView(jTable1);

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

       chaxuntable.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 [] {
                "图书号", "图书名", "作者", "出版社", "条码"
            }
        ));
        jScrollPane2.setViewportView(chaxuntable);

        getContentPane().add(jScrollPane2, java.awt.BorderLayout.CENTER);
        
        this.setClosable(true);
        this.setRequestFocusEnabled(true);
        pack();
       //initComponents()
    }
    
    /* This method is called from within the constructor to
     * initializ the form.
    WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
private void jB_j_exitActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jB_j_exitActionPerformed
// 程序退出
    
}//GEN-LAST:event_jB_j_exitActionPerformed

private void jB_j_chakanActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jB_j_chakanActionPerformed
// 查看当前用户的借书信息
      try
            {
            java.sql.Statement stmt=dc.getStatement();
            String strSql="SELECT count(BookId) from Borrow";
            java.sql.ResultSet set=stmt.executeQuery(strSql);set.next();
            rowCount=set.getInt(1)==0?1:set.getInt(1);
            //System.out.println(rowCount);
            ob=new Object[rowCount][colCount];
             if(set.getInt(1)==0)
                {
                javax.swing.JOptionPane.showMessageDialog
                    (this,"无数据，请新增数据！","",
                        javax.swing.JOptionPane.ERROR_MESSAGE);
                }
            else
                {
               set=null;
               set=stmt.executeQuery("SELECT state,BookId,date,MaxDate,return from Borrow where state=0 and Userid=1");
                int i=0;
                while(set.next())
                    {
                    ob[i][0]=(set.getInt("state")==0)?"借":"还";
                    ob[i][1]=new Integer(set.getInt("BookId"));
                    ob[i][2]=set.getString("date");
                    ob[i][3]=set.getString("MaxDate");
                    ob[i][4]=(set.getInt("return")==0)?"未还":"已还";
                    //System.out.println(set.getString(1));
                    //System.out.println(set.getString(2));
                    
                    //System.out.println(set.getString(3));
                    //System.out.println(set.getString(4));
                    //System.out.println(set.getString(5));
                    i++;
                    }
                }     
            mytable=new JieshuTable(ob);
            jTable1.setModel(mytable);
            stmt=null;set=null;
            }
        catch(java.sql.SQLException sqle)
            {
            javax.swing.JOptionPane.showMessageDialog(this,"sql出错");
            }            
         
}//GEN-LAST:event_jB_j_chakanActionPerformed

private void jB_j_cleanActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jB_j_cleanActionPerformed
// 清空文本框
     jTF_j_id.setText("");
     jTF_j_rq.setText("");
     jTF_j_hrq.setText("");
}//GEN-LAST:event_jB_j_cleanActionPerformed


 
private void jB_j_okActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jB_j_okActionPerformed
//向数据库中插入借书信息
            String state = "0";
            String userid = "1";
            String guihuan ="0";
            String date,maxdate,bookid;
            bookid = jTF_j_id.getText();
            date= jTF_j_rq.getText();
            maxdate= jTF_j_hrq.getText();
            if((jTF_j_id.getText() == "") && (jTF_j_rq.getText() == "") && (jTF_j_hrq.getText() == "")) 
            {   
                
               JOptionPane.showMessageDialog(this,"请把所有数据正确填写!谢谢", "Message", JOptionPane.ERROR_MESSAGE);
            }
            else
            {
              try
              {
                  
              Statement stmt= dc.getStatement();
              stmt.executeUpdate("INSERT INTO Borrow(state,BookId,UserId,date,MaxDate,return) VALUES ("+state+","+bookid+","+userid+",'"+date+"','"+maxdate+"',"+guihuan+")");
             this.showdlg3();
             jTF_j_id.setText("");
             jTF_j_rq.setText("");
             jTF_j_hrq.setText("");
              }
              catch(SQLException e)
                {
                JOptionPane.showMessageDialog(this,"借书失败!!");
                }
            }
          
}//GEN-LAST:event_jB_j_okActionPerformed

private void jcb_j_zlActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jcb_j_zlActionPerformed
// 按图书种类查找书籍

    //System.out.println(jcb_j_zl.getSelectedItem());
    String chaxun = jcb_j_zl.getSelectedItem().toString();
  
           try
            {
            java.sql.Statement stmt=dc.getStatement();
            String sql = "select id from BookSort where name ='"+chaxun+"'";
            java.sql.ResultSet rs=stmt.executeQuery(sql);
            rs.next();
            zl = rs.getInt(1);
            rs =null;
            String strSql="SELECT count(id) from Book where sortId="+zl+" ";
            rs=stmt.executeQuery(strSql);  
            rs.next();
            rowCount=rs.getInt(1)==0?1:rs.getInt(1);             
             if(rs.getInt(1)==0)
                {
                javax.swing.JOptionPane.showMessageDialog
                    (this,"无数据，请新增数据！","",
                        javax.swing.JOptionPane.ERROR_MESSAGE);
                }
               else
                {
                rs=null;
                rs=stmt.executeQuery("select id, name, author, book_concern, tm from Book where sortId ="+zl+"");
                int i=0;
                ob=new Object[rowCount][colCount];
                while( rs.next())
                    {
                    ob[i][0]=new Integer(rs.getInt("id"));
                    ob[i][1]=rs.getString("name");
                    ob[i][2]=rs.getString("author");
                    ob[i][3]=rs.getString("book_concern");
                    ob[i][4]=rs.getString("tm");    
                    //System.out.println(rs.getString(1));
                    //System.out.println(rs.getString(2));
                    //System.out.println(rs.getString(3));
               //     System.outprintln(rs.getString(4));
                    //System.out.println(rs.getString(5));
                    i++;                       
                    }
                }
             mychaxuntable=new ChaxunTable(ob);
             chaxuntable.setModel(mychaxuntable);
             stmt=null;rs=null;
            }
           
            catch(java.sql.SQLException sqle)
            {
            javax.swing.JOptionPane.showMessageDialog(this,"sql出错");
            }
}//GEN-LAST:event_jcb_j_zlActionPerformed

private void jTable1AncestorAdded(javax.swing.event.AncestorEvent evt) {//GEN-FIRST:event_jTable1AncestorAdded
// TODO 将在此处增加您的处理代码：
}//GEN-LAST:event_jTable1AncestorAdded

    public void showdlg3()
{
        JOptionPane.showMessageDialog(this,"借书成功,要记得归还,谢谢!", "Message", JOptionPane.ERROR_MESSAGE);
}
    
    // 变量声明 - 不进行修改//GEN-BEGIN:variables
    private javax.swing.JTable chaxuntable;
    private javax.swing.JButton jB_j_chakan;
    private javax.swing.JButton jB_j_clean;
    private javax.swing.JButton jB_j_exit;
    private javax.swing.JButton jB_j_ok;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JScrollPane jScrollPane2;
    private javax.swing.JTextField jTF_j_hrq;
    private javax.swing.JTextField jTF_j_id;
    private javax.swing.JTextField jTF_j_rq;
    private javax.swing.JTable jTable1;
    private javax.swing.JComboBox jcb_j_zl;
    // 变量声明结束//GEN-END:variables
}