sql reading from file

Thread view:

mistral - 12 Mar 2004 09:54 GMT

Hello,

I have a file with all SQL statements e.g :

sql_createuser = INSERT INTO users VALUES(username,password,email)
sql_removeuser = ...

I read the sql statements with the properties get method. But how do I
exchange the username , password sql variables with the correct ones?

kind regards,

V.

Reply to this Message

Lothar Kimmeringer - 12 Mar 2004 20:03 GMT

> sql_createuser = INSERT INTO users VALUES(username,password,email)
> sql_removeuser = ...
>
> I read the sql statements with the properties get method. But how do I
> exchange the username , password sql variables with the correct ones?

Search and replace. Better attempt would be to change username
by ? and use PreparedStatement.

Regards, Lothar

Signature

Lothar Kimmeringer E-Mail: spamfang@kimmeringer.de
PGP-encrypted mails preferred (Key-ID: 0x8BC3CD81)

Always remember: The answer is forty-two, there can only be wrong
questions!

Reply to this Message

mistral - 13 Mar 2004 10:00 GMT

>> sql_createuser = INSERT INTO users VALUES(username,password,email)
>> sql_removeuser = ...
[quoted text clipped - 6 lines]
>
> Regards, Lothar

Thank you,

I used a PreparedStatement and filled in the ? values ;)

V.

Reply to this Message

sql reading from file

Free Magazines