Java的此SQL查询正确吗? [英] is this SQL query for java correct.

问题描述

statement.execute("INSERT INTO tablename" +"VALUES(field1.getText()，field2.getText()，field3.getText())");

或

stmt.execute("INSERT INTO" + tableName +"VALUES(" + field1.getText()+，""+ field2.getText()+"''，" + field3.getText()+' '));



我们可以将这样的参数提供给sql查询还是仅使用数字或使用字符串" ...

statement.execute("INSERT INTO tablename " + "VALUES (field1.getText(),field2.getText(),field3.getText())");

or

stmt.execute("INSERT INTO " + tableName + " VALUES (" + field1.getText() + ",''" + field2.getText() + "'',''" + field3.getText() +"'')");



can we give such arguments to sql query or only number or "string" is used...

推荐答案

您是否尝试过任何方法?

Did you have tried anything?

UPDATE your_table
SET password = value
WHERE email = "xyz@" AND pass = "asdfg"

我不知道你在哪里坚持.请查看以下内容以获取更多详细信息.

http://www.w3schools.com/sql/sql_update.asp [

I don''t know where you stuck with. Have a look at the following for more details.

http://www.w3schools.com/sql/sql_update.asp[^]

这篇关于Java的此SQL查询正确吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！