From: Mark Matthews
Date: April 29 1999 5:06pm
Subject: RE: insert variables
List-Archive: http://lists.mysql.com/java/75
Message-Id: <000001be9262$ae847840$82892e80@ecn.purdue.edu>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

> -----Original Message-----
> From: or36@stripped [mailto:or36@stripped]
> Sent: Thursday, April 29, 1999 12:01 PM
> To: java@stripped
> Subject: insert variables
>
>
>
> Hi!
>
> I am having difficulty creating an insert statement in Java that would
> use variable values as the values parameters.
>
> None of the following worked -- I would get either the name of the
> variable instead of the value or nothing at all:
>
> String value1 = new String("blah");
>
> insert into table values (value1);
>  or
> insert into table values ('value1');
>  or
> insert into table values ("value1");
>  or
> insert into table values (\'value1\');
>  or
> insert into table values (\"value1\");
>
> The context in which I need to use this is more complex than building an
> object string from a known value.

There are two ways to do this. You can do:

	String SQL = "insert into table values ('" + value1 + "')";
	Stmt.executeUpdate(SQL);

or
	PreparedStatement PStmt = Connex.prepareStatement("insert into table values
(?)";
	PStmt.setString(1, "Some Value");
	PStmt.executeUpdate();

Java and JDBC do not do inline variable expansion like some variants of
embedded SQL, or Perl, so you have to use one of the above two methods.

	-Mark