stat.java

图书管理设计文档

                {
                rs=null;
                rs=stmt.executeQuery("SELECT state,BookId,UserId,date,MaxDate,return from Borrow where BookId="+val);
                int i=0;
                while(rs.next())
                    {
                    ob[i][0]=(rs.getInt("state")==0)?"借":"还";
                    ob[i][1]=new Integer(rs.getInt("BookId"));
                   ob[i][2]=new Integer(rs.getInt("UserId"));
                    ob[i][3]=rs.getString("date");
                    ob[i][4]=rs.getString("MaxDate");
                    ob[i][5]=(rs.getInt("return")==0)?"未还":"已";
                    i++;
                    }
                }     
            mytable=new MyTable(ob);
            statTable.setModel(mytable);
            stmt=null;rs=null;
            }
        catch(java.sql.SQLException sqle)
            {
            javax.swing.JOptionPane.showMessageDialog(this,"sql出错");
            }      
    }//GEN-LAST:event_jButton5ActionPerformed

    private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton4ActionPerformed
        String strSql;
        String val = JOptionPane.showInputDialog("输入用户Id");
        //用户统计(按UserId排序)
        try
            {
            java.sql.Statement stmt=dc.getStatement();
            strSql=new String(new String("SELECT count(state) from Borrow where UserId=").concat(val));
            java.sql.ResultSet rs=stmt.executeQuery(strSql);
            rs.next();
            rowCount=rs.getInt(1)==0?1:rs.getInt(1);
            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 state,BookId,UserId,date,MaxDate,return from Borrow where UserId="+val);
                int i=0;
                while(rs.next())
                    {
                    ob[i][0]=(rs.getInt("state")==0)?"借":"还";
                    ob[i][1]=new Integer(rs.getInt("BookId"));
                    ob[i][2]=new Integer(rs.getInt("UserId"));
                    ob[i][3]=rs.getString("date");
                    ob[i][4]=rs.getString("MaxDate");
                    ob[i][5]=(rs.getInt("return")==0)?"未还":"已还";
                    i++;
                    }
                }     
            mytable=new MyTable(ob);
            statTable.setModel(mytable);
            stmt=null;rs=null;
            }
        catch(java.sql.SQLException sqle)
            {
            javax.swing.JOptionPane.showMessageDialog(this,"sql出错");
            }      
    }//GEN-LAST:event_jButton4ActionPerformed

    private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton3ActionPerformed
        //借还分析
        try
            {
            java.sql.Statement stmt=dc.getStatement();
            String strSql="SELECT count(state) from Borrow";
            java.sql.ResultSet rs=stmt.executeQuery(strSql);
            rs.next();
            rowCount=rs.getInt(1)==0?1:rs.getInt(1);
            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 state,BookId,UserId,date,MaxDate,return from Borrow order by state");
                int i=0;
                while(rs.next())
                    {
                    ob[i][0]=(rs.getInt("state")==0)?"借":"还";
                    ob[i][1]=new Integer(rs.getInt("BookId"));
                    ob[i][2]=new Integer(rs.getInt("UserId"));
                    ob[i][3]=rs.getString("date");
                    ob[i][4]=rs.getString("MaxDate");
                    ob[i][5]=(rs.getInt("return")==0)?"未还":"已还";
                    i++;
                    }
                }     
            mytable=new MyTable(ob);
            statTable.setModel(mytable);
            stmt=null;rs=null;
            }
        catch(java.sql.SQLException sqle)
            {
            javax.swing.JOptionPane.showMessageDialog(this,"sql出错");
            }                    
    }//GEN-LAST:event_jButton3ActionPerformed

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed
        //借书统计
        try
            {
            java.sql.Statement stmt=dc.getStatement();
            String strSql="SELECT count(state) from Borrow where state=0";
            java.sql.ResultSet rs=stmt.executeQuery(strSql);
            rs.next();
            rowCount=rs.getInt(1)==0?1:rs.getInt(1);
            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 state,BookId,UserId,date,MaxDate,return from Borrow where state=0");
                int i=0;
                while(rs.next())
                    {
                    ob[i][0]=(rs.getInt("state")==0)?"借":"还";
                    ob[i][1]=new Integer(rs.getInt("BookId"));
                    ob[i][2]=new Integer(rs.getInt("UserId"));
                    ob[i][3]=rs.getString("date");
                    ob[i][4]=rs.getString("MaxDate");
                    ob[i][5]=(rs.getInt("return")==0)?"未还":"已还";
                    i++;
                    }
                }     
            mytable=new MyTable(ob);
            statTable.setModel(mytable);
            stmt=null;rs=null;
            }
        catch(java.sql.SQLException sqle)
            {
            javax.swing.JOptionPane.showMessageDialog(this,"sql出错");
            }            
    }//GEN-LAST:event_jButton1ActionPerformed

    private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton2ActionPerformed
        //还书统计
        try
            {
            java.sql.Statement stmt=dc.getStatement();
            String strSql="SELECT count(state) from Borrow where state=1";
            java.sql.ResultSet rs=stmt.executeQuery(strSql);
            rs.next();
            rowCount=rs.getInt(1)==0?1:rs.getInt(1);
            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 state,BookId,UserId,date,MaxDate,return from Borrow where state=1");
                int i=0;
                while(rs.next())
                    {
                    ob[i][0]=(rs.getInt("state")==0)?"借":"还";
                    ob[i][1]=new Integer( rs.getInt("BookId"));
                    ob[i][2]=new Integer(rs.getInt("UserId"));
                    ob[i][3]=rs.getString("date");
                    ob[i][4]=rs.getString("MaxDate");
                    ob[i][5]=(rs.getInt("return")==0)?"未还":"已还";
                    i++;
                    }
                }     
            mytable=new MyTable(ob);
            statTable.setModel(mytable);
            stmt=null;rs=null;
            }
        catch(java.sql.SQLException sqle)
            {
            javax.swing.JOptionPane.showMessageDialog(this,"sql出错");
            }                    
    }//GEN-LAST:event_jButton2ActionPerformed
    
    
    // 变量声明 - 不进行修改//GEN-BEGIN:variables
    private javax.swing.JButton jButton1;
    private javax.swing.JButton jButton2;
    private javax.swing.JButton jButton3;
    private javax.swing.JButton jButton4;
    private javax.swing.JButton jButton5;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JTable statTable;
    // 变量声明结束//GEN-END:variables
    
}