preparedstatement.java

来自「J2ME MIDP_Example_Applications」· Java 代码 · 共 139 行

// Copyright 2003 Nokia Corporation.
//
// THIS SOURCE CODE IS PROVIDED 'AS IS', WITH NO WARRANTIES WHATSOEVER,
// EXPRESS OR IMPLIED, INCLUDING ANY WARRANTY OF MERCHANTABILITY, FITNESS
// FOR ANY PARTICULAR PURPOSE, OR ARISING FROM A COURSE OF DEALING, USAGE
// OR TRADE PRACTICE, RELATING TO THE SOURCE CODE OR ANY WARRANTY OTHERWISE
// ARISING OUT OF ANY PROPOSAL, SPECIFICATION, OR SAMPLE AND WITH NO
// OBLIGATION OF NOKIA TO PROVIDE THE LICENSEE WITH ANY MAINTENANCE OR
// SUPPORT. FURTHERMORE, NOKIA MAKES NO WARRANTY THAT EXERCISE OF THE
// RIGHTS GRANTED HEREUNDER DOES NOT INFRINGE OR MAY NOT CAUSE INFRINGEMENT
// OF ANY PATENT OR OTHER INTELLECTUAL PROPERTY RIGHTS OWNED OR CONTROLLED
// BY THIRD PARTIES
//
// Furthermore, information provided in this source code is preliminary,
// and may be changed substantially prior to final release. Nokia Corporation
// retains the right to make changes to this source code at
// any time, without notice. This source code is provided for informational
// purposes only.
//
// Nokia and Nokia Connecting People are registered trademarks of Nokia
// Corporation.
// Java and all Java-based marks are trademarks or registered trademarks of
// Sun Microsystems, Inc.
// Other product and company names mentioned herein may be trademarks or
// trade names of their respective owners.
//
// A non-exclusive, non-transferable, worldwide, limited license is hereby
// granted to the Licensee to download, print, reproduce and modify the
// source code. The licensee has the right to market, sell, distribute and
// make available the source code in original or modified form only when
// incorporated into the programs developed by the Licensee. No other
// license, express or implied, by estoppel or otherwise, to any other
// intellectual property rights is granted herein.
package example.mesql;

import java.util.*;

// extension to Statement which supports
// parameters
public class PreparedStatement extends Statement
{
  private final Vector values = new Vector();


  public PreparedStatement(Connection c, String query)
  {
    super(c, query);
  }

  public void clearParameters()
  {
    values.removeAllElements();
  }

  public void executeQuery()
  {
    c.sendSimpleQuery(query, maxRows, values);
  }

  public void executeUpdate()
  {
    c.sendUpdate(query, values);
  }

  // the methods below sets the value of parameter
  // of a given type
  
  public void setBoolean(int parameterIndex, boolean x)
  {
    Parameter param = new Parameter();
    param.index = parameterIndex;
    param.content = new Boolean(x);
    param.type = SQLConstants.BOOLEAN;
    values.addElement(param);
  }


  public void setByte(int parameterIndex, byte x)
  {
    Parameter param = new Parameter();
    param.index = parameterIndex;
    param.content = new Byte(x);
    param.type = SQLConstants.TINYINT;
    values.addElement(param);
  }


  public void setInt(int parameterIndex, int x)
  {
    Parameter param = new Parameter();
    param.index = parameterIndex;
    param.content = new Integer(x);
    param.type = SQLConstants.INTEGER;
    values.addElement(param);
  }



  public void setLong(int parameterIndex, long x)
  {
    Parameter param = new Parameter();
    param.index = parameterIndex;
    param.content = new Long(x);
    param.type = SQLConstants.NUMERIC;
    values.addElement(param);
  }


  public void setNull(int parameterIndex, int sqlType)
  {
    Parameter param = new Parameter();
    param.index = parameterIndex;
    param.type = sqlType;
    values.addElement(param);
  }


  public void setShort(int parameterIndex, short x)
  {
    Parameter param = new Parameter();
    param.index = parameterIndex;
    param.content = new Short(x);
    param.type = SQLConstants.SMALLINT;
    values.addElement(param);
  }


  public void setString(int parameterIndex, String x)
  {
    Parameter param = new Parameter();
    param.index = parameterIndex;
    param.content = x;
    param.type = SQLConstants.VARCHAR;
    values.addElement(param);
  }

}