?? preparedstatement.java
字號:
// 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);
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -