databean.java

struts实现的图书管理系统,借书

         {
        	 UserBean user = new UserBean();
        	
             System.out.println("UserID:"+res.getInt("Users_ID"));
             System.out.println("Username:"+res.getString("Users_Name"));
             user.setUsers_ID(res.getInt("Users_ID"));
             user.setUsers_Name(res.getString("Users_Name"));
             user.setUsers_Pwd(res.getString("Users_Pwd"));
             user.setUsers_Adds(res.getString("Users_Adds"));
             user.setUsers_Class(res.getString("Users_Class"));
             user.setUsers_Count(res.getInt("Users_Count"));
             user.setUsers_Phone(res.getString("Users_Phone"));
             user.setUsers_Sex(res.getString("Users_Sex"));
             list.add(user);
                 j++;
         }
         }
         catch (SQLException ex)
         {
            System.out.println("服务器异常发生在 getUsersList()");
            ex.printStackTrace();
        }
        return list;
    }

/////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////User删除方法/////////////////////////////////////////////////
    public boolean deleteUsers(int users_ID) {
        try {
            prepar = conn.prepareStatement(
                    "delete Users where Users_ID=?");
            prepar.setInt(1, users_ID);
            int flag = prepar.executeUpdate();
            if (flag == 0) {
                return false;
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
            return false;
        }
        return true;
    }

    /////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////Books获取BookType方法/////////////////////////////////////////////////
    public ArrayList<BooksTypeBean> getBooksType() {
        ArrayList<BooksTypeBean> list = new ArrayList<BooksTypeBean>();
        try {
            String sql =
                    "select * from BookType";
            prepar = conn.prepareStatement(sql);
            res = prepar.executeQuery();
            while (res.next()) {
                BooksTypeBean btb = new BooksTypeBean();
                btb.setBookType_ID(res.getInt(1));
                btb.setBookType_Name(res.getString(2));
                list.add(btb);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        return list;
    }
////////////////////////////////////////////////////////////////
//////////////////////获得满足条件的总图书数////////////////////////
    public int getBooksMaxcount(int count,String sqlStr)
{
	try { 
		
    	String sql="select count(*) as count  from Books";
    	sql=sql+sqlStr;
    	System.out.println(sql);
    	 statement = conn.createStatement();
        res = statement.executeQuery(sql);
        while(res.next())
        {
        pagecount=res.getInt("count");
        }
        System.out.println("总信息条数为："+pagecount);
        if(pagecount%count==0)
        {Pagecount=pagecount/count;}
        else
        {
        	Pagecount1=pagecount%count;
        	Pagecount=(pagecount-Pagecount1)/count+1;
        }
        System.out.println(Pagecount);
        }
	catch (SQLException ex) 
	{
        System.out.println("服务器异常发生在 getBooksList()");
        ex.printStackTrace();
        }
	return Pagecount;
	
}
  ////////////////////////////////////////////////////////////////////////
    //////////////////////求用户借书记录最大页数//////////////////////////////
    public int getLendBookMaxcount(int count,int Users_ID)
    {
    	try { 
    		
        	//String sql="select count(*) as count  from BookLend where ";
    		String sql =
                "select count(*) as count from BookLend where Users_ID=?";
        prepar = conn.prepareStatement(sql);
        prepar.setInt(1, Users_ID);
        res = prepar.executeQuery();
        	//System.out.println(sql);
        	 //statement = conn.createStatement();
           // res = statement.executeQuery(sql);
            while(res.next())
            {
            pagecount=res.getInt("count");
            }
            System.out.println("总信息条数为："+pagecount);
            if(pagecount%count==0)
            {Pagecount=pagecount/count;}
            else
            {
            	Pagecount1=pagecount%count;
            	Pagecount=(pagecount-Pagecount1)/count+1;
            }
            System.out.println(Pagecount);
            }
    	catch (SQLException ex) 
    	{
            System.out.println("服务器异常发生在 getBooksList()");
            ex.printStackTrace();
            }
    	return Pagecount;
    	
    }
////////////////////////////////////////////////////////////////////////
    //////////////////////求用户借书记录最大页数//////////////////////////////
    public int AdmingetLendBookMaxcount(int count)
    {
    	try { 
    		
        	//String sql="select count(*) as count  from BookLend where ";
    		String sql =
                "select count(*) as count from BookLend ";
        prepar = conn.prepareStatement(sql);
        res = prepar.executeQuery();
        	//System.out.println(sql);
        	 //statement = conn.createStatement();
           // res = statement.executeQuery(sql);
            while(res.next())
            {
            pagecount=res.getInt("count");
            }
            System.out.println("总信息条数为："+pagecount);
            if(pagecount%count==0)
            {Pagecount=pagecount/count;}
            else
            {
            	Pagecount1=pagecount%count;
            	Pagecount=(pagecount-Pagecount1)/count+1;
            }
            System.out.println(Pagecount);
            }
    	catch (SQLException ex) 
    	{
            System.out.println("服务器异常发生在 getBooksList()");
            ex.printStackTrace();
            }
    	return Pagecount;
    	
    }
    ///////////////////////////////////////////////////////////////////////////
    ///////////////////////////////////求用户被罚款记录最大页数////////////////////
    public int getPunishMaxcount(int count,int Users_ID)
    {
    	try { 
    		
        	//String sql="select count(*) as count  from BookLend where ";
    		String sql =
                "select count(*) as count from Punish where Users_ID=?";
        prepar = conn.prepareStatement(sql);
        prepar.setInt(1, Users_ID);
        res = prepar.executeQuery();
        	//System.out.println(sql);
        	 //statement = conn.createStatement();
           // res = statement.executeQuery(sql);
            while(res.next())
            {
            pagecount=res.getInt("count");
            }
            System.out.println("总信息条数为："+pagecount);
            if(pagecount%count==0)
            {Pagecount=pagecount/count;}
            else
            {
            	Pagecount1=pagecount%count;
            	Pagecount=(pagecount-Pagecount1)/count+1;
            }
            System.out.println(Pagecount);
            }
    	catch (SQLException ex) 
    	{
            System.out.println("服务器异常发生在 getBooksList()");
            ex.printStackTrace();
            }
    	return Pagecount;
    	
    }
    ///////////////////////////////////////////////////////////////////////////
    ///////////////////////////////////求用户记录最大页数////////////////////
    public int getUserMaxcount(int count)
    {
    	try { 
    		
        	//String sql="select count(*) as count  from BookLend where ";
    		String sql =
                "select count(*) as count from Users";
        prepar = conn.prepareStatement(sql);
       
        res = prepar.executeQuery();
        	//System.out.println(sql);
        	 //statement = conn.createStatement();
           // res = statement.executeQuery(sql);
            while(res.next())
            {
            pagecount=res.getInt("count");
            }
            System.out.println("总信息条数为："+pagecount);
            if(pagecount%count==0)
            {Pagecount=pagecount/count;}
            else
            {
            	Pagecount1=pagecount%count;
            	Pagecount=(pagecount-Pagecount1)/count+1;
            }
            System.out.println(Pagecount);
            }
    	catch (SQLException ex) 
    	{
            System.out.println("服务器异常发生在 getBooksList()");
            ex.printStackTrace();
            }
    	return Pagecount;
    	
    }
    
///////////////////////////////////////////////////////////////////////////
    ///////////////////////////////////求所有被罚款记录最大页数////////////////////
    public int getPunishMaxcount(int count)
    {
    	try { 
    		
        	//String sql="select count(*) as count  from BookLend where ";
    		String sql =
                "select count(*) as count from Punish";
        prepar = conn.prepareStatement(sql);
       
        res = prepar.executeQuery();
        	//System.out.println(sql);
        	 //statement = conn.createStatement();
           // res = statement.executeQuery(sql);
            while(res.next())
            {
            pagecount=res.getInt("count");
            }
            System.out.println("总信息条数为："+pagecount);
            if(pagecount%count==0)
            {Pagecount=pagecount/count;}
            else
            {
            	Pagecount1=pagecount%count;
            	Pagecount=(pagecount-Pagecount1)/count+1;
            }
            System.out.println(Pagecount);
            }
    	catch (SQLException ex) 
    	{
            System.out.println("服务器异常发生在 getBooksList()");
            ex.printStackTrace();
            }
    	return Pagecount;
    	
    }
    /////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////Books获取列表方法/////////////////////////////////////////////////
    public ArrayList<BooksBean> getBooksList(int count, int page, String sqlstr) {
    	ArrayList<BooksBean> list = new ArrayList<BooksBean>();
        try { 
        	int i,j=0;
        	String sql="select * from Books"+sqlstr;
        	 prepar = conn.prepareStatement(sql);
            res = prepar.executeQuery();
         for(i=0;i<count*(page-1);i++)
                     {res.next();}
            while (res.next()&&j<5) {
                BooksBean bsb = new BooksBean();
                bsb.setBooks_Amount(res.getInt("Books_Amount"));
                bsb.setBooks_Company(res.getString("Books_Company"));
                bsb.setBooks_Count(res.getInt("Books_Count"));
                bsb.setBooks_ID(res.getInt("Books_ID"));
                bsb.setBooks_Name(res.getString("Books_Name"));
                bsb.setBooks_Time(res.getString("Books_Time"));
                bsb.setBookType_ID(res.getInt("BookType_ID"));
                list.add(bsb);
                j++;
            }
        } catch (SQLException ex) {