Java的此SQL查询正确吗?

本文介绍了Java的此SQL查询正确吗?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

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...

推荐答案

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查询正确吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！

gettext