import com.work.site.web.*;

import java.sql.*;

 /**
 * author:  aurhor
 * package: PACKAGE_NAME
 * date:    28.07.2004
 */ 
public class ttt {
  public static void main(String[] args) throws ClassNotFoundException, SQLException {
    Class.forName("com.jnetdirect.jsql.JSQLDriver");
    Connection con = DriverManager.getConnection("jdbc:JSQLConnect://xxx", "user", "pwd");

    String[] aaa = {
      "%25458",
      "%25465",
      "%25467",
      "%25468",
      "%25472",
      "%25485",
      "%25488",
      "%25495",
      "%25496",
      "%25502",
      "%25503",
      "%25506",
      "%25507",
      "%25508",
      "%25509",
      "%25511",
      "%25522",
      "%25523",
      "%25551",
      "%25552",
      "%25553",
      "%25554",
      "%25569",
      "%25570",
      "%25572",
      "%25573",
      "%25574",
      "%25576"};

    int aid = 99;
    int did = 135;

    String q = "select * from uc where c like ? and a = ?";
    PreparedStatement st = con.prepareStatement(q);

    q = "insert into uc (c, a, u) values (?, ?, ?)";
    PreparedStatement st1 = con.prepareStatement(q);

    for (int i = 0; i < aaa.length; i++) {
      String c = aaa[i];
      st.setString(1, c);
      st.setInt(2, aid);

      ResultSet rs = st.executeQuery();

      while (rs.next()) {
        String code = rs.getString("c");
        String uguid = rs.getString("u");
        int icode = Integer.parseInt(code);
        icode += 10000;
        code = "" + icode;

        st1.setString(1, code);
        st1.setInt(2, did);
        st1.setString(3, uguid);

        st1.executeUpdate();
      }
      rs.close();

    }


    st.close();

    con.close();
  }
}