delstringtokenizers.java

来自「jdo开发实例,一个功能全面的oa系统」· Java 代码 · 共 58 行

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

package com.gzrealmap.oa.upload;

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

public class DelStringToKenizers
{

    private JDBCUtil util;

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

    public void Kenizers(String id, String ids)
    {
        StringBuffer bu = new StringBuffer();
        try
        {
            util.connect();
            Connection conn = util.getConnection();
            Statement sta = conn.createStatement();
            ResultSet rs;
            for(rs = sta.executeQuery("select Lname as names from lawsInfos where Lid=" + id); rs.next();)
            {
                String s = rs.getString("names");
                for(StringTokenizer st = new StringTokenizer(s, ",", false); st.hasMoreTokens();)
                {
                    String ss = st.nextToken();
                    if(!ids.equals(ss))
                    {
                        bu.append(ss);
                        if(st.hasMoreTokens())
                            bu.append(",");
                    }
                }

            }

            sta.executeUpdate("update lawsInfos set Lname='" + bu.toString() + "'where Lid='" + id + "'");
            sta.close();
            rs.close();
            conn.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
    }
}