毕业论文论文范文课程设计实践报告法律论文英语论文教学论文医学论文农学论文艺术论文行政论文管理论文计算机安全
您现在的位置: 毕业论文 >> 课程设计 >> 正文

软件图书管理系统+CDM图+PDM图+表间关系图 第7页

更新时间:2008-7-8:  来源:毕业论文

软件图书管理系统,关联图+DFD图+实体属性图+ER图

return false;

          else

                 return true;

   }

  

   //判断某书是否可以被借

   public boolean ifCanBorrow(String sqh)

   {

          String sql="";

          sql="select * from KJB2_KJXX_STORE where ZT='可借'";

          Vector vect=(Vector)searchData(sql);

          if(vect.isEmpty())

                 return false;

          else

                 return true;

   }

 

   //还书,参数为索取号

   public int[] backBorrow(String sqh)

   {

          System.out.println("批量处理还书。。。。。");

          String sql="";

          String strBOOKID=ds.toString((String)toName("KJB2_KJXX_STORE","SQH","BOOKID",sqh));

 

          String strNow = ds.getDateTime();

          strNow = strNow.substring(0,10);

 

          createStatement();

          clearBatch();

          sql="update KJB2_KJXX_JYB set ZT='"+strOne+"',GHRQ='"+strNow+"' where BOOKID="+strBOOKID+" and ZT='"+strZero+"'";

          System.out.println("sql1:"+sql);

          addBatch(sql);   

          sql="update KJB2_KJXX_STORE set ZT='可借' where BOOKID="+strBOOKID;

          System.out.println("sql2:"+sql);

          addBatch(sql);   

          int result[]=executeBatch();    

          closeStm();

          return result;

   }

 

   //根据所还书的索取号取得,此书的信息和是否过期等信息

   public Hashtable checkBook(String sqh)

   {

          String sql="";

          String strBOOKID=ds.toString((String)toName("KJB2_KJXX_STORE","SQH","BOOKID",sqh));

          if(strBOOKID.equals("")) strBOOKID="-1";

          String strBOOKCLASSID=ds.toString((String)toName("KJB2_KJXX_STORE","SQH","BOOKCLASSID",sqh));

          if(strBOOKCLASSID.equals("")) strBOOKCLASSID="-1";

          sql="select TITLE,AUTHOR,ISBN,CBSJ,DJ,PCJE,READERID,JYSJ,DQSJ "

                 +" from KJB2_KJXX_BOOK,KJB2_KJXX_JYB "

                 +" where KJB2_KJXX_BOOK.BOOKCLASSID="+strBOOKCLASSID+" and KJB2_KJXX_JYB.BOOKID="+strBOOKID+" and KJB2_KJXX_JYB.ZT='"+strZero+"'";

          return searchOneData(sql);

   }

 

   //............................................................................................//

   //个人信息

 

   //取得书籍

   public Vector getBorBooks(String zgbh,String type)

   {    

          String sql="";

          String strNow = ds.getDateTime();

          strNow = strNow.substring(0,10);

          sql="select READERID from KJB2_KJXX_READER where GH='"+zgbh+"' and(ZT='注册' or ZT='挂失')";

          Hashtable hash = (Hashtable)searchOneData(sql);

          String strREADERID=ds.toString((String)hash.get("READERID"));

         

          //在借的所有书籍

          if(type.equals("0"))

          {

                 sql="select * from KJB2_KJXX_JYB where READERID="+strREADERID+" and ZT='"+strZero+"'";

          }

 

          //借阅历史

          if(type.equals("1"))

          {

                 sql="select * from KJB2_KJXX_JYB where READERID="+strREADERID+" and ZT='"+strOne+"'";

          }

 

          //所有有效预约书

          if(type.equals("2"))

          {

                 sql=" select * from KJB2_KJXX_YYB "

                    +" where READERID="+strREADERID+" and ZT='生效' and DQSJ>='"+strNow+"'";

          }

 

          return searchData(sql);

   }

 

   //分页取得书籍

   public Vector getPageBorBooks(String zgbh,String type,int page)

   {    

          String sql="";

          String strNow = ds.getDateTime();

          strNow = strNow.substring(0,10);

          sql="select READERID from KJB2_KJXX_READER where GH='"+zgbh+"' and(ZT='注册' or ZT='挂失')";

          Hashtable hash = (Hashtable)searchOneData(sql);

          String strREADERID=ds.toString((String)hash.get("READERID"));

          if(strREADERID.equals("")) strREADERID="-1";

          //在借的所有书籍

          if(type.equals("0"))

          {

                 sql="select * from KJB2_KJXX_JYB where READERID="+strREADERID+" and ZT='"+strZero+"' order by JYSJ";

                 System.out.println(sql);

          }

 

          //借阅历史

          if(type.equals("1"))

          {

                 sql="select * from KJB2_KJXX_JYB where READERID="+strREADERID+" and ZT='"+strOne+"' order by GHRQ";

          }

 

          //所有有效预约书

          if(type.equals("2"))

          {

                 sql=" select * from KJB2_KJXX_YYB "

                    +" where READERID="+strREADERID+" and ZT='生效' and DQSJ>='"+strNow+"'";

          }

          return getOnePage(sql,page,20);

   }

 

   //续借

   public int[] setContinue(String zgbh,String jyid)

   {

          String sql="";

          sql="select KXJSJ from KJB2_KJXX_RULE,KJB2_KJXX_READER "

                 +" where KJB2_KJXX_READER.GH='"+zgbh+"' and KJB2_KJXX_READER.RULEID=KJB2_KJXX_RULE.RULEID ";

          Hashtable hash = (Hashtable)searchOneData(sql);

          String strKXJSJ=ds.toString((String)hash.get("KXJSJ"));

 

          sql=" update KJB2_KJXX_JYB set XJCS=XJCS+1,DQSJ=to_char((to_date(DQSJ,'yyyy-MM-dd')+"+strKXJSJ+"),'yyyy-MM-dd') "

                 +" where JYID="+jyid+"";

          System.out.println("sqlsql:"+sql);

          /*return deleteRecord(sql);*/

 

          createStatement();

          clearBatch();

          addBatch(sql);   

          int result[]=executeBatch();    

          closeStm();

          return result;

   }

  

   //取消预约

   public int setConcel(String yyid)

   {

          String sql="";

          sql="update KJB2_KJXX_YYB set ZT='取消' where YYID="+yyid;

          return deleteRecord(sql);

   }

  

 

   //查找所有的统一函数

   private Vector searchData(String sql)

   {

          Vector vect = new Vector();

          ResultSet rs = selectRecord(sql);

 

          //取得列数和列名

          Statement stmt = null;

          try{

                 ResultSetMetaData rsmd = rs.getMetaData();

                 int cols = rsmd.getColumnCount();

需要完整内容的请联系QQ752018766,本文免费,转发请注明源于www.751com.cn

                        }

                        vect.add(hash);

                 }

          }catch(Exception e){System.out.println("运行时出错:"+e);}

          finally{

                 if(rs!=null)try{ stmt = rs.getStatement(); rs.close();}catch(Exception e){System.out.println("关闭记录集rs时出错"+e);}

                 if(stmt!=null) try{stmt.close();}catch(Exception e){System.out.println("关闭声明时statement出错"+e);}          

          }

          return vect;  

   }

上一页  [1] [2] [3] [4] [5] [6] [7] [8] [9] [10]  ... 下一页  >> 

软件图书管理系统+CDM图+PDM图+表间关系图 第7页下载如图片无法显示或论文不完整,请联系qq752018766
设为首页 | 联系站长 | 友情链接 | 网站地图 |

copyright©751com.cn 辣文论文网 严禁转载
如果本毕业论文网损害了您的利益或者侵犯了您的权利,请及时联系,我们一定会及时改正。