function.java

图书管管理系统是基于JAVA的 很好的

        DataBase db = new DataBase();
     
        if (!ShareSubprogram.IDExistInRecommend(ID))
            deleteSuccess = -1;
        else if (db.delete("recommend","ID='" + ID + "'"))
            deleteSuccess = 1;
      
        db.closeConnection();
        return deleteSuccess;
    }
    
    /**
     *该方法实现了意见簿的删除
     *@param ID 请求注销帐号
     *@return 如果该ID不存在，返回-1
     *@return 如果删除失败，返回0
     *@return 如果删除成功，返回1
     */
    public static int deleteReaderIdea(String ID)throws SQLException{
        int deleteSuccess = 0;
        DataBase db = new DataBase();
        
        if (!ShareSubprogram.IDExistInAdvice(ID))
            deleteSuccess = -1;
        else if (db.delete("advise","ID='"+ID+"'"))
            deleteSuccess = 1;
        
        db.closeConnection();
        return deleteSuccess;
    }
    
    /**
     *该方法实现了暂存篮的删除
     *@param ID 请求注销帐号
     *@如果该ReaderID不存在，返回-1
     *如果删除失败，返回0
     *如果删除成功，返回1
     */ 
    public static int deleteTempbasket (String ReaderID,String ISBN)throws SQLException{
        int deleteSuccess=0;
        DataBase db = new DataBase();
     
        if (!ShareSubprogram.readerExist(ReaderID))
            deleteSuccess = -1;
        else if (db.delete("tempbasket ","reader_ID='" + ReaderID + "'and ISBN='" + ISBN + "'"))
            deleteSuccess = 1;
        
        db.closeConnection();
        return deleteSuccess;
    }
    
    /**
     *该方法实现了管理员帐户的添加
     *@param userName 管理员的用户名
     *@param password 密码
     *@param popedom 权限
     *@return 如果userName已存在，返回-1
     *@return 如果插入失败，返回0
     *@return 如果插入成功，返回1
     */  
    public static int addAdministrator(String userName,String popedom,String password)throws SQLException{
        int addSuccess = 0;
        DataBase db = new DataBase();
        
        if (ShareSubprogram.administratorExist(userName))
            addSuccess =  -1;
        else if (db.insert("administrator","'" + userName + "','" + popedom + "','" + Filter.toMd5(password) + "'"))
            addSuccess = 1;
        
        db.closeConnection(); 
        return addSuccess;
    }
    
    /**
     *如果userName不存在，返回-2
     *如果NewUserName已存在，返回-1
     *如果更新失败，返回0
     *如果更新成功，返回1
     *参数说明：
     *userName 要更新的帐户的用户名
     *newUserName 更新后的用户名
     *newPassword 更新后的密码
     *newPopedom 更新后的权限
     */
    public static int updateAdministrator(String userName,String newUserName,String newPopedom,
            String newPassword)throws SQLException{    
        int updataSuccess = 0;
        DataBase db = new DataBase();
        String [] info = {"","",""};
        
        if (!ShareSubprogram.administratorExist(userName))
            updataSuccess = -2;
        else if (ShareSubprogram.administratorExist(newUserName))
            updataSuccess = -1;
        else{
            if(newUserName.compareTo("") != 0)
                info[0] = "name='" + newUserName + "'";
            if(newPopedom.compareTo("") != 0)
                info[1] = ",popedom='" + newPopedom + "'";
            if(newPassword.compareTo("") != 0)
                info[2] = ",password='" + newPassword + "'";
            if (db.update("administrator",info[0] + info[1] + info[2],"name='" + userName + "'"))
                updataSuccess=1;
        }
        
        db.closeConnection();
        return updataSuccess;
        
    }
    
    /**
     *该方法实现了管理员帐户的删除
     *@param userName 要被删除的帐户的用户名
     *@return 如果userName不存在，返回-1
     *@return 如果删除失败，返回0
     *@return 如果删除成功，返回1
     */
    public static int deleteAdministrator(String userName)throws SQLException{ 
        int deleteSuccess = 0;
        DataBase db = new DataBase();
        
        if (!ShareSubprogram.administratorExist(userName))
            deleteSuccess = -1;
        else if (db.delete("administrator","name='" + userName + "'"))
            deleteSuccess = 1;
        
        db.closeConnection();
        return deleteSuccess;
    }
    
    /**
     *该方法实现了书籍检索的功能
     *@param request[] 检索时的关键字数组
     *@param start 查询时从哪行元组返回数据
     *@return 返回含有书籍信息的向量
     */
    public static Vector searchBook(String request[],int start) throws SQLException{
        Vector info =  new Vector();
        DataBase db = new DataBase();
        String []s = {"*"};
        
        ResultSet rs = db.search("book",s," " + ShareSubprogram.analyseRequest(request).concat("LIMIT " + start + ",10"));
        while (rs.next()){
            Vector v = new Vector();
            for (int count = 1;count <= 10;count ++)
                v.add(rs.getString(count));
            info.add(v); 
        }
        
        rs.close();
        db.closeConnection();
        return info;
    }
    
    /**
     *该方法实现了读者信息的查询
     *@param readerID 要查询的读者的读者证号
     *@return 返回含有读者信息的向量
     */
    public static Vector searchReader(String readerID) throws SQLException{
        Vector info = new Vector();
        DataBase db = new DataBase();
        String []s = {"*"};
        
        ResultSet rs =  db.search("reader",s,"reader_ID = '" + readerID + "'");
        if (rs.next())
            for (int count = 1;count <= 11;count ++)
                info.add(rs.getString(count));
        
        rs.close();
        db.closeConnection();
        return info;
    }
    
    /**
     *该方法实现了读者意见的查询
     *@param startDate 要查询的起始日期
     *@param endDate 要查询的中止日期
     *@return 返回含有意见信息的向量
     */
    public static Vector searchAdvise(String startDate,String endDate) throws SQLException{
        Vector info = new Vector();
        DataBase db = new DataBase();
        String []s = {"*"};
        
        ResultSet rs =  db.search("advise",s,"date  between '" + startDate + "'and '" + endDate + "'order by ID");
        while(rs.next()){
            Vector v = new Vector();
            for (int count = 1;count <= 5;count ++)
                v.add(rs.getString(count));
            info.add(v);
        }
        
        rs.close();
        db.closeConnection();
        return info;
    }
    
    /**
     *该方法实现了读者荐购的查询
     *@param startDate 要查询的起始日期
     *@param endDate 要查询的中止日期
     *@return 返回含有荐购信息的向量
     */
    public static Vector searchRecommend(String startDate,String endDate) throws SQLException{
        Vector info = new Vector();
        DataBase db = new DataBase();
        String []s = {"*"};
        
        ResultSet rs =  db.search("Recommend",s,"date  between '" + startDate + "'and '" + endDate + "' order by ID");
        while(rs.next()){
            Vector v = new Vector();
            for (int count = 1;count <= 7;count++)
                v.add(rs.getString(count));
            info.add(v);
        }
        
        rs.close();
        db.closeConnection();
        return info;
    }
    
    /**
     *该方法实现了读者借阅信息的查询
     *@param readerID 要查询的读者的读者证号
     *@return 返回含有借阅信息的向量
     */
    public static Vector searchReaderLoanBookInfomatiom(String readerID) throws SQLException{
        Vector info = new Vector();
        DataBase db = new DataBase();
        String []s = {"ISBN","deadline","number"};
        
        ResultSet rs = db.search("loan",s,"reader_ID = '" + readerID + "' order by deadline");
        while(rs.next()){
            Vector v = new Vector();
            String []attr = {"*"};
            ResultSet sr = db.search("book",attr,"ISBN='" + rs.getString("ISBN") + "'");
            if(sr.next()){
                for (int count = 1;count <= 10;count++)
                    v.add(sr.getString(count));
                v.add(rs.getString("number"));
                v.add(rs.getString("deadline"));
                info.add(v);
            }
            sr.close();
        }
        
        rs.close();
        db.closeConnection();
        return info;
    }
    
    /**
     *该方法实现了新进书籍信息的查询
     *@return 返回含有借阅信息的向量
     */
    public static Vector searchNewBook() throws SQLException{
        Vector info = new Vector();
        DataBase db = new DataBase();
        String []s = {"*"};
        
        ResultSet rs =  db.search("newbook",s,"");
        while(rs.next()){
            Vector v = new Vector();
            for (int count = 1;count <= 5;count ++)
                v.add(rs.getString(count));
            info.add(v);
        }
        
        rs.close();
        db.closeConnection();
        return info;
    }
    
    /**
     *该方法实现了暂存篮书籍信息的查询
     *@param readerID 要查询的读者的读者证号
     *@return 返回含有暂存篮书籍信息的向量
     */
    public static Vector searchTempbasket (String readerID) throws SQLException{
        Vector info = new Vector();
        DataBase db = new DataBase();
        String []s = {"ISBN"};
        
        ResultSet rs =  db.search("tempbasket ",s,"reader_ID= '" + readerID + "'");
        while(rs.next()){
            Vector v = new Vector();
            String []attr = {"*"};
            ResultSet sr = db.search("book",attr,"ISBN='" + rs.getString("ISBN") + "'");
            if(sr.next()){
                for (int count = 1;count <= 10;count ++)
                    v.add(sr.getString(count));
                info.add(v);
            }
            sr.close();
        }
        
        rs.close();
        db.closeConnection();
        return info;
    }
    
    /**
     *该方法实现了根据书籍的ISBN号和编号查询借阅该书的读者的读者证号
     *@param ISBN 被借阅的书籍的ISBN号
     *@param number 被借阅的书籍的编号
     *@return 借阅了该书的读者的读者证号
     */
    public static String getReaderIDFromLoan(String ISBN,String number)throws SQLException{
        DataBase db = new DataBase();
        String readerID = "";
        String []s = {"reader_ID"};
        
        ResultSet rs =  db.search("loan ",s,"ISBN= '" + ISBN + "'and number='" + number + "'");
        if(rs.next())
            readerID =  rs.getString("reader_ID");
        
        rs.close();
        db.closeConnection();
        return readerID;
    }
}