Insert statement with variables

[kkastner]

Hi guys

I have a problem...............
I established a database connection and that works well. The only problem is to execute the INSERT statement. Here you can see my code:

stat.executeUpdate("INSERT INTO users(email, username, password, role)VALUES('"email+"','"+username"',"+password+",'"+role"); );

password is a MessageDigest(MD5) which should be saved in a MySQL-field (BLOB).

Perhaps or hopefully you can show me the error, because I don't know how to go on.


Thanks a lot

karo