xxbkdj_q.java

一个JAVA源程式 一个JAVA源程式

// Decompiled by Jad v1.5.7g. Copyright 2000 Pavel Kouznetsov.
// Jad home page: http://www.geocities.com/SiliconValley/Bridge/8617/jad.html
// Decompiler options: packimports(3) fieldsfirst ansi 
// Source File Name:   Xxbkdj_q.java

package xiangyc;

import hzyl.dbconn2;
import hzyl.pagebean;
import java.sql.*;
import java.util.Vector;

public class Xxbkdj_q
{

    private static dbconn2 sql = new dbconn2();
    private static pagebean page = new pagebean();

    public Xxbkdj_q()
    {
    }

    public long totalNum(String str_townno, String str_date)
    {
        if(str_townno == null || str_townno.equals(""))
            str_townno = "";
        if(str_date == null || str_date.equals(""))
            str_date = "";
        String sql_temp = "select count(*)  from shouyu where shouyubsm='县下拨款' and townno='" + str_townno + "'";
        if(!str_date.equals(""))
            sql_temp = sql_temp + " and ymd like '" + str_date + "'";
        return page.getTotalnum(sql_temp);
    }

    public Vector query(int i_pageNum, long l_end, String str_townno, String str_date)
        throws SQLException
    {
        long l_rowstart = page.getCurend(i_pageNum, l_end);
        long l_rowend = l_rowstart + (long)i_pageNum;
        String sql_temp = "SELECT * FROM  (SELECT A.*, rownum r FROM( SELECT townno,hosno,seqno,ymd,ddate,shouruname,shouru,changedt,zy,shouyubsm FROM shouyu WHERE shouyubsm='县下拨款' and townno='" + str_townno;
        String sql_temp2 = "' order by SEQNO desc )A  WHERE rownum <= " + l_rowend + ") B WHERE r > " + l_rowstart;
        if(str_date == null || str_date.equals(""))
            str_date = "";
        if(!str_date.equals(""))
            sql_temp = sql_temp + "' and ymd like '" + str_date;
        sql_temp = sql_temp + sql_temp2;
        ResultSet rs = sql.exequery(sql_temp);
        Vector vResult = new Vector();
        ResultSetMetaData rmeta = rs.getMetaData();
        int numColumns = rmeta.getColumnCount();
        rs.beforeFirst();
        Vector vTemp;
        for(; rs.next(); vResult.addElement(vTemp))
        {
            vTemp = new Vector();
            for(int i = 0; i < numColumns; i++)
            {
                String sTemp = rs.getString(i + 1);
                vTemp.addElement(sTemp);
            }

        }

        sql.close();
        return vResult;
    }

    public String setcn(String s)
    {
        String s1 = s;
        String s2;
        byte abyte0[] = s1.getBytes("ISO8859-1");
        s2 = new String(abyte0);
        return s2;
        Exception exception;
        exception;
        return null;
    }

    public void close()
    {
        sql.close();
    }

}