List of prepareStatement() Examples

Examples of prepareStatement()

com.alibaba.druid.pool.DruidPooledConnection.prepareStatement()
com.cloud.utils.db.Transaction.prepareStatement()
com.cloud.utils.db.TransactionLegacy.prepareStatement()
com.fathomdb.jdbc.JdbcConnection.prepareStatement()
com.knowgate.jdc.JDCConnection.prepareStatement()
com.mysql.jdbc.Connection.prepareStatement()
A SQL statement with or without IN parameters can be pre-compiled and stored in a PreparedStatement object. This object can then be used to efficiently execute this statement multiple times.
Note: This method is optimized for handling parametric SQL statements that benefit from precompilation if the driver supports precompilation. In this case, the statement is not sent to the database until the PreparedStatement is executed. This has no direct effect on users; however it does affect which method throws certain java.sql.SQLExceptions

MySQL does not support precompilation of statements, so they are handled by the driver.
@param sql a SQL statement that may contain one or more '?' IN parameter placeholders @return a new PreparedStatement object containing the pre-compiledstatement. @exception SQLException if a database access error occurs.
com.salesforce.phoenix.jdbc.PhoenixConnection.prepareStatement()
com.sun.star.sdbc.XConnection.prepareStatement()
connectivity.tools.sdb.Connection.prepareStatement()
de.kilobyte22.app.kibibyte.Database.prepareStatement()
fi.luomus.commons.db.connectivity.PreparedStatementStoringAndClosingTransactionConnection.prepareStatement()
fi.luomus.commons.db.connectivity.TransactionConnection.prepareStatement()
java.sql.Connection.prepareStatement()
A SQL statement with or without IN parameters can be pre-compiled and stored in a PreparedStatement object. This object can then be used to efficiently execute this statement multiple times.
Note: This method is optimized for handling parametric SQL statements that benefit from precompilation. If the driver supports precompilation, prepareStatement will send the statement to the database for precompilation. Some drivers may not support precompilation. In this case, the statement may not be sent to the database until the PreparedStatement is executed. This has no direct affect on users; however, it does affect which method throws certain SQLExceptions. @param sql a SQL statement that may contain one or more '?' INparameter placeholders @return a new PreparedStatement object containing thepre-compiled statement @exception SQLException if a database-access error occurs.
l2p.database.ThreadConnection.prepareStatement()
liquibase.database.jvm.JdbcConnection.prepareStatement()
marauroa.server.db.DBTransaction.prepareStatement()
Prepares a statement for a batch operation. @param query SQL statement @param params parameter values @return PreparedStatement @throws SQLException in case of an database error
net.sourceforge.squirrel_sql.fw.sql.ISQLConnection.prepareStatement()
org.apache.derby.iapi.jdbc.EngineConnection.prepareStatement()
Prepare a statement with holdability. Identical to JDBC 3.0 method, to allow holdabilty to be supported in JDK 1.3 by the network server, e.g. when the client is jdk 1.4 or above. Can be removed once JDK 1.3 is no longer supported.
org.apache.hadoop.hbase.hbql.client.HConnection.prepareStatement()
org.apache.jena.jdbc.connections.JenaConnection.prepareStatement()
org.apache.olio.workload.loader.framework.ThreadConnection.prepareStatement()
org.apache.openjpa.jdbc.sql.SQLBuffer.prepareStatement()
Create and populate the parameters of a prepared statement using the SQL in this buffer.
org.apache.phoenix.jdbc.PhoenixConnection.prepareStatement()
org.conserve.connection.ConnectionWrapper.prepareStatement()
@param statement @return a new PreparedStatement, ready to fill in values and execute. @throws SQLException
org.exoplatform.services.jcr.impl.checker.InspectionQuery.prepareStatement()
Creates a PreparedStatement object for sending parameterized SQL statements to the database. @param connection connection to workspace storage @return a new default PreparedStatement object containing the pre-compiled SQL statement @throws SQLException if a database access error occurs or this method is called on a closed connection
org.jboss.soa.esb.helpers.persist.JdbcCleanConn.prepareStatement()
org.mule.module.db.internal.domain.connection.DbConnection.prepareStatement()
org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement()
Prepare a statement. In case no connection has been given, allocate a new one. @param sql The SQL statement to be executed @throws GenericDataSourceException @throws GenericEntityException
org.opensolaris.opengrok.jdbc.ConnectionResource.prepareStatement()
Prepare a statement. This method should only be used to prepare statements that are used infrequently. If a statement is likely to be used frequently, a {@code StatementCreator} object should becreated for it, and the method {@link #getStatement(StatementCreator)}should be used instead. @param sql the SQL text to compile @return a prepared statement @throws SQLException if a database error occurs
se.rupy.pool.Connection.prepareStatement()

Examples of com.alibaba.druid.pool.DruidPooledConnection.prepareStatement()

        PreparedStatementHolder stmtHoler_3;
        PreparedStatementHolder stmtHoler_4;
        
        // sql_0连续执行两次
        {
            DruidPooledPreparedStatement stmt_0 = (DruidPooledPreparedStatement) conn.prepareStatement(sql_0);


            Assert.assertFalse(stmt_0.getPreparedStatementHolder().isPooling());


            stmt_0.close();
            Assert.assertEquals(1, stmtPool.size());

View Full Code Here

Examples of com.cloud.utils.db.Transaction.prepareStatement()

    //Use update method with category instead
    @Override @Deprecated
    public boolean update(String name, String value) {
      Transaction txn = Transaction.currentTxn();
    try {
      PreparedStatement stmt = txn.prepareStatement(UPDATE_CONFIGURATION_SQL);
      stmt.setString(1, value);
      stmt.setString(2, name);
      stmt.executeUpdate();
      return true;
    } catch (Exception e) {

View Full Code Here

Examples of com.cloud.utils.db.TransactionLegacy.prepareStatement()

        ResultSet rs = null;
        HostVO host = null;
        TransactionLegacy txn = TransactionLegacy.currentTxn();


        try {
            pstmt = txn.prepareStatement(sql);
            pstmt.setLong(1, poolId);
            rs = pstmt.executeQuery();
            while (rs.next()) {
                long id = rs.getLong(1);
                host = hostDao.findById(id);

View Full Code Here

Examples of com.fathomdb.jdbc.JdbcConnection.prepareStatement()


      String sql = "SELECT data FROM service_authorizations WHERE service=? and project=?";


      List<ServiceAuthorization> items = Lists.newArrayList();


      PreparedStatement ps = connection.prepareStatement(sql);
      ResultSet rs = null;
      try {
        ps.setInt(1, serviceId);
        ps.setInt(2, projectId);
        rs = ps.executeQuery();

View Full Code Here

Examples of com.knowgate.jdc.JDCConnection.prepareStatement()

      switch (IdType) {
        case 1:
          sSQL = "SELECT "+sColList+" FROM " + DB.k_mime_msgs + " WHERE " + DB.gu_mimemsg + "=?";
          if (DebugFile.trace) DebugFile.writeln("Connection.prepareStatement("+sSQL+")");


          oStmt = oConn.prepareStatement(sSQL, ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
          oStmt.setString(1, sMsgId);
          break;
        case 2:
          sSQL = "SELECT "+sColList+" FROM " + DB.k_mime_msgs + " WHERE " + DB.id_message + "=?";
          if (DebugFile.trace) DebugFile.writeln("Connection.prepareStatement("+sSQL+")");

View Full Code Here

Examples of com.mysql.jdbc.Connection.prepareStatement()

    connex = getConnection();
    String insert = "INSERT INTO `user`(`id`, `pseudo`, `nom`, `prenom`, `solde`, `psswd`) VALUES ( ?, ?, ?, ?, ?, ?) ";


    try {
      // inscription
      PreparedStatement preStat = (PreparedStatement) connex
          .prepareStatement(insert);


      preStat.setInt(1, 0);
      preStat.setString(2, utilisateur.getPseudo());
      preStat.setString(3, utilisateur.getNom());

View Full Code Here

Examples of com.salesforce.phoenix.jdbc.PhoenixConnection.prepareStatement()

        assertTrue(descriptor.hasCoprocessor(ServerCachingEndpointImpl.class.getName()));
        admin.close();
         
        int rowCount = 5;
        String upsert = "UPSERT INTO " + tableName + "(id,col1,col2) VALUES(?,?,?)";
        PreparedStatement ps = conn1.prepareStatement(upsert);
        for (int i = 0; i < rowCount; i++) {
            ps.setString(1, Integer.toString(i));
            ps.setInt(2, i+1);
            ps.setInt(3, i+2);
            ps.execute();

View Full Code Here

Examples of com.sun.star.sdbc.XConnection.prepareStatement()

    {
        m_database.executeSQL("DROP TABLE \"TEST1\" IF EXISTS");
        m_database.executeSQL("CREATE TABLE \"TEST1\" (\"ID\" integer not null primary key, \"col2\" varchar(50) )");


        final XConnection connection = m_database.defaultConnection();
        final XPreparedStatement prep = connection.prepareStatement("INSERT INTO \"TEST1\" values (?,?)");
        final XParameters para = (XParameters) UnoRuntime.queryInterface(XParameters.class, prep);
        for (int i = 1; i <= MAX_TABLE_ROWS; ++i)
        {
            para.setInt(1, i);
            para.setString(2, "Test" + i);

View Full Code Here

Examples of connectivity.tools.sdb.Connection.prepareStatement()

    {
        m_database.executeSQL("DROP TABLE \"TEST1\" IF EXISTS");
        m_database.executeSQL("CREATE TABLE \"TEST1\" (\"ID\" integer not null primary key, \"col2\" varchar(50) )");


        final Connection connection = m_database.defaultConnection();
        final XPreparedStatement prep = connection.prepareStatement("INSERT INTO \"TEST1\" values (?,?)");
        final XParameters para = UnoRuntime.queryInterface( XParameters.class, prep );
        for (int i = 1; i <= MAX_TABLE_ROWS; ++i)
        {
            para.setInt(1, i);
            para.setString(2, "Test" + i);

View Full Code Here

Examples of de.kilobyte22.app.kibibyte.Database.prepareStatement()

            if (bot.useYaml) {
                HashMap<String, String> perms_ = bot.yamlEngine.load(new File("permissions.yaml"));
                perms_.put(nick, tmpperms);
                bot.yamlEngine.writeYaml(new File("permissions.yaml"), perms_);
            } else {
                PreparedStatement s = database.prepareStatement("SELECT * FROM permissions WHERE server = ? AND nickserv = ?");
                s.setString(1, bot.getServer());
                s.setString(2, nick);
                try {
                    //s.executeQuery().next();
                    s = database.prepareStatement("UPDATE permissions SET permissions=? WHERE server = ? AND nickserv = ?");

View Full Code Here

0 1 2 3 4 5 6 7

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.