Examples of java.sql.PreparedStatement.clearParameters()

java.sql.PreparedStatement.clearParameters()
Clear the current parameter values.
Typically, parameter values are retained for multiple executions of the Statement. Setting a parameter value replaces the previous value. This method clears the values for all parameters, releasing all resources used by those parameters. @throws SQLException if a database error happens

    ps.setString(1, val1);
    ps.execute();
    verifyConfValue(key, val1);


    // executeUpdate() of Prepared statement
    ps.clearParameters();
    ps.setString(1, val2);
    ps.executeUpdate();
    verifyConfValue(key, val2);
  }

View Full Code Here

            ps.setString(2, s);
            ps.setString(3, s);
            ps.setString(4, s);
            ps.setString(5, s);
            ps.addBatch();
            ps.clearParameters();
            if ((i+1) % 1000 == 0) {
                System.out.print(".");
            }
            if ((i+1) % 10000 == 0) {
                System.out.print("\n"+(i+1));

View Full Code Here

        while (next()) {
            for (int i = 1; i <= size(); i++) {
                ps.setObject(i, getObject(i));
            }
            ps.execute();
            ps.clearParameters();
        }
        ps.close();
    }


    // Utilities

View Full Code Here

        while (next()) {
            for (int i = 1; i <= size(); i++) {
                ps.setObject(i, getObject(i), getSqlType(i));
            }
            ps.execute();
            ps.clearParameters();
        }
    }


}

View Full Code Here

            retrieveParent.clearParameters();


            updateChild.setObject(1, parentID);
            updateChild.setObject(2, data[currentRow][1]);
            updateChild.execute();
            updateChild.clearParameters();
        }
    }
}

View Full Code Here

            updateCommentsContentType.executeUpdate();


            // set plugins for all existing comments
            PreparedStatement updateCommentsPlugins = 
                    con.prepareStatement("update roller_comment set posttime=posttime, plugins = ?");
            updateCommentsPlugins.clearParameters();
            updateCommentsPlugins.setString(1, plugins);
            updateCommentsPlugins.executeUpdate();
            
            if (!con.getAutoCommit()) con.commit();

View Full Code Here

                entryUpdate.setBoolean(3, false);
                entryUpdate.setString( 4, websiteid);
                entryUpdate.executeUpdate();
                
                // add  permission for user in website
                permsInsert.clearParameters();
                permsInsert.setString( 1, websiteid+"p");
                permsInsert.setString( 2, websiteid);
                permsInsert.setString( 3, userid);
                permsInsert.setShort(    4,WeblogPermission.ADMIN);
                permsInsert.setBoolean(5, false);

View Full Code Here

                    // set the new default page id
                    defaultpageid = websiteid+"q";
                }
                
                // update defaultpageid value
                updateDefaultPage.clearParameters();
                updateDefaultPage.setString( 1, defaultpageid);
                updateDefaultPage.setString( 2, websiteid);
                updateDefaultPage.executeUpdate();
            }

View Full Code Here

            while (websiteSet.next()) {
                String entryid = websiteSet.getString(1);
                String entrylocale = websiteSet.getString(2);
                
                // update entry locale
                updateWeblogLocale.clearParameters();
                updateWeblogLocale.setString( 1, entrylocale);
                updateWeblogLocale.setString( 2, entryid);
                updateWeblogLocale.executeUpdate();
            }

View Full Code Here

                "update weblogcategory set parentid=? where id=?");            
            ResultSet parentSet = selectParents.executeQuery();
            while (parentSet.next()) {
                String categoryid = parentSet.getString(1);
                String parentid = parentSet.getString(2);                
                updateParent.clearParameters();
                updateParent.setString( 1, parentid);
                updateParent.setString( 2, categoryid);
                updateParent.executeUpdate();
            }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.