statement.java

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

// 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;

// Statement us used to invoke a simple query
public class Statement
{
  protected Connection c;
  protected int maxRows = 0;
  protected String query;

  Statement(Connection c)
  {
    this.c = c;
  }

  Statement(Connection c, String query)
  {
    this.c = c;
    this.query = query;
  }

  // will invoke a simple query
  public void executeQuery(String sql)
  {
    if (sql.toLowerCase().startsWith("select"))
    {
      c.sendSimpleQuery(sql, maxRows, null);
    }
    else
    {
      c.sendUpdate(sql, null);
    }
  }

  // will invoke an update
  public void executeUpdate(String sql)
  {
    c.sendUpdate(sql, null);
  }

  public Connection getConnection()
  {
    return c;
  }

  public void setMaxRows(int max)
  {
    this.maxRows = max;
  }
}