page.java

一个不错的留言系统

// Decompiled by DJ v2.9.9.60 Copyright 2000 Atanas Neshkov  Date: 2002-6-14 16:28:28
// Home Page : http://members.fortunecity.com/neshkov/dj.html  - Check often for new version!
// Decompiler options: packimports(3) 
// Source File Name:   page.java

package com.shlt.dbconnection;

import java.sql.*;

// Referenced classes of package com.shlt.dbconnection:
//            DBConnection

public class page extends DBConnection
{

    public page()
    {
        sql = "";
        sql2 = "";
        tablename = "";
        getPam = "";
        innerjoin = "";
        where = "";
        orderby = "";
        id = "";
        page_count = 0;
        page = 1;
        page_size = 20;
        page_desc = "";
    }

    public ResultSet display()
        throws SQLException
    {
        boolean flag = setSql();
        if(!flag && sql == "")
            return null;
        try
        {
            super.db_stmt = super.db_conn.createStatement(1004, 1007);
            int i = sql.indexOf("from");
            if(i < 0)
                i = sql.indexOf("FROM");
            String s = sql.substring(i);
            s = "select count(*) " + s;
            super.db_rset = super.db_stmt.executeQuery(s);
            if(super.db_rset.next())
                super.record_count = super.db_rset.getInt(1);
            if(super.record_count != 0)
            {
                if(sql2.equals("") || page_size == 0)
                {
                    ret_rset = super.db_stmt.executeQuery(sql);
                    return ret_rset;
                }
                page_count = super.record_count / page_size + 1;
                if(page < 1)
                    page = 1;
                if(page > page_count)
                    page = page_count;
                super.db_rset = super.db_stmt.executeQuery(sql2);
                String as[] = new String[page_size];
                super.db_rset.absolute((page - 1) * page_size + 1);
                for(int j = 0; j < page_size; j++)
                {
                    as[j] = super.db_rset.getString(1);
                    if(!super.db_rset.isLast())
                        super.db_rset.next();
                }

                String s1 = " " + id + " in  ('" + as[0] + "'";
                for(int k = 1; k < page_size; k++)
                    s1 = s1 + " ,'" + as[k] + "'";

                s1 = s1 + " ) ";
                where = " where " + s1;
                setSql();
                ret_rset = super.db_stmt.executeQuery(sql);
                return ret_rset;
            } else
            {
                return null;
            }
        }
        catch(SQLException sqlexception)
        {
            sqlexception.printStackTrace();
        }
        return null;
    }

    public boolean setSql()
    {
        if(tablename == "")
            return false;
        if(id == "")
            return false;
        sql = "select";
        sql2 = "select";
        if(getPam == "")
            sql = sql + " * from ";
        else
            sql = sql + " " + getPam + " from ";
        sql2 = sql2 + " " + id + " from ";
        sql = sql + " " + tablename;
        sql2 = sql2 + " " + tablename;
        if(innerjoin != "")
        {
            sql = sql + " " + innerjoin;
            sql2 = sql2 + " " + innerjoin;
        }
        if(where != "")
        {
            sql = " " + sql + " " + where;
            sql2 = " " + sql2 + " " + where;
        }
        if(orderby != "")
        {
            sql = " " + sql + " " + orderby;
            sql2 = " " + sql2 + " " + orderby;
        }
        return true;
    }

    public boolean setSql(String s)
    {
        sql = s;
        return true;
    }

    public boolean setSql2(String s)
    {
        sql2 = s;
        return true;
    }

    public void setId(String s)
    {
        id = s;
    }

    public void setTablename(String s)
    {
        tablename = s;
    }

    public void setGetPam(String s)
    {
        getPam = s;
    }

    public void setInnerjoin(String s)
    {
        innerjoin = s;
    }

    public void setWhere(String s)
    {
        where = s;
    }

    public void setOrderby(String s)
    {
        orderby = s;
    }

    public String getSql()
    {
        return sql;
    }

    public String getSql2()
    {
        return sql2;
    }

    public void setPage(int i)
    {
        page = i;
    }

    public int getPage_count()
    {
        return page_count;
    }

    public void setPage_size(int i)
    {
        page_size = i;
    }

    private void setPage_desc(String s)
    {
        page_desc = s;
    }

    public String getPage_desc()
    {
        return page_desc;
    }

    private String sql;
    private String sql2;
    private String tablename;
    private String getPam;
    private String innerjoin;
    private String where;
    private String orderby;
    private String id;
    private int page_count;
    private int page;
    private int page_size;
    private ResultSet ret_rset;
    private String page_desc;
}