求助mysql Update语句总是报错

2018-07-08 07:23:07 1.2k 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

【gateway nc adapter虚拟网卡 win11 联想】问题的解决由于需要登录公司内网，于是启用奇安信VPN。但启动后报出网关未连接的问题，于是我检查了我的网络适配器，并尝试解决，以下给出几种我实践过程中的行动，并附带最后成功的解决方法。阅读详情

package text;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class text {

public static void main(String[] args){
text a=new text();
try {
a.text();
} catch (ClassNotFoundException | SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}

public void text() throws ClassNotFoundException, SQLException{

Class.forName("com.mysql.jdbc.Driver");

String url="jdbc:mysql://localhost:3306/user1?user=root&password=";

Connection conn=DriverManager.getConnection(url);

String sql2="Update parking set Condition='ee' where Condition='qq' ";

Statement stmt=(Statement) conn.createStatement();

stmt.executeUpdate(sql2);
}
}

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Condition='ee' where Condition='qq'' at line 1

...全文