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

            p.setInt(1, 10);


            p.setBytes(2, b1);
            p.executeUpdate();


            p.clearParameters();
            p.setInt(1, 20);


            p.setBytes(2, b2);
            p.executeUpdate();

View Full Code Here

                1, 2, 3
            };


            p.setObject(2, ia1);
            p.executeUpdate();
            p.clearParameters();
            p.setInt(1, 2);


            java.awt.Rectangle r1 = new java.awt.Rectangle(10, 11, 12, 13);


            p.setObject(2, r1);

View Full Code Here

     */
    public PreparedStatement create(Connection conn, String sql, StatementContext ctx) throws SQLException
    {
        if (cache.containsKey(sql)) {
            PreparedStatement cached = cache.get(sql);
            cached.clearParameters();
            return cached;
        }


        PreparedStatement stmt = builder.create(conn, sql, ctx);
        cache.put(sql, stmt);

View Full Code Here

      _rs = new ResultSetImpl();


    PreparedStatement pstmt;
    pstmt = aConn.prepareStatement(_query.getSQL());


    pstmt.clearParameters();
    
    for (int i = 0; i < _argLength; i++) {
      if (_argValues[i] != null)
        _argTypes[i].setParameter(pstmt, i + 1, _argValues[i]);
    }

View Full Code Here


    PreparedStatement pstmt = _aConn.prepareStatement(sql);
    ArgExpr []args = _query.getArgList();


    if (args.length > 0)
      pstmt.clearParameters();


    for (int i = 0; i < args.length; i++) {
      args[i].setParameter(pstmt, i + 1, _argTypes, _argValues);
    }

View Full Code Here


    PreparedStatement pstmt = _aConn.prepareStatement(sql);
    ArgExpr []args = _query.getArgList();


    if (args.length > 0)
      pstmt.clearParameters();


    for (int i = 0; i < args.length; i++) {
      args[i].setParameter(pstmt, i + 1, _argTypes, _argValues);
    }

View Full Code Here

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

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

        pstmt.setString(2, CatalogUtil.extractSimpleName(col.getName()));
        pstmt.setInt(3, i);
        pstmt.setString(4, col.getDataType().getType().name());
        pstmt.setInt(5, (col.getDataType().hasLength() ? col.getDataType().getLength() : 0));
        pstmt.addBatch();
        pstmt.clearParameters();
      }
      pstmt.executeBatch();
      pstmt.close();


      if (table.getMeta().hasParams()) {

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.