seachstringtokenizers.java

jdo开发实例,一个功能全面的oa系统

// 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:   SeachStringToKenizers.java

package com.gzrealmap.oa.upload;

import com.gzrealmap.lib.jdbc.JDBCUtil;
import java.sql.*;
import java.util.ArrayList;
import java.util.StringTokenizer;

public class SeachStringToKenizers
{

    private JDBCUtil util;

    public SeachStringToKenizers()
    {
        util = JDBCUtil.getInstance();
    }

    public ArrayList ints(String id, String name)
    {
        ArrayList al = new ArrayList();
        try
        {
            util.connect();
            Connection conn = util.getConnection();
            Statement sta = conn.createStatement();
            ResultSet rs;
            for(rs = sta.executeQuery("select * from lawsInfos where Pname like '%" + name + "%'"); rs.next();)
            {
                int i = rs.getInt(1);
                Integer integer = new Integer(i);
                for(StringTokenizer st = new StringTokenizer(rs.getString(2), ",", false); st.hasMoreTokens();)
                {
                    String token = st.nextToken();
                    if(token.equals(id) || token == id)
                        al.add(integer);
                }

            }

            rs.close();
            sta.close();
            conn.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        return al;
    }
}