package Process;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import com.sqldata;
public class ChangeNumber {
public static void Changeusernumber(String userid,int newnumber)
{
Connection conn=sqldata.SQLConn();
try {
if(conn!=null){
System.out.println("数据库链接成功!");
Statement state=conn.createStatement();
String sql = "update 用户 set 用户积分="+newnumber+" where 用户ID="+"'"+userid+"'";
state.executeUpdate(sql);
System.out.println("用户积分更新");
}else
{
System.out.println("数据库链接失败!");
}
}
catch (SQLException e) {
e.printStackTrace();
}
}
}
运行后出现这这样的错误提示,麻烦大家看看上面的sql语句哪里出现了问题?
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 '用户ID='13831880053'' at line 1
————————————————————————————————————————
第一次修改
各位大佬们,我把所有的表名、用户名都修改为了英文的,但是依然出现这个错误。下面是修改后的代码:
package Process;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import com.sqldata;
public class ChangeNumber {
public static void Changeusernumber(String userid,int newnumber)
{
Connection conn=sqldata.SQLConn();
try {
if(conn!=null){
System.out.println("数据库链接成功!");
Statement state=conn.createStatement();
String sql = "update user set usernumber="+newnumber+"where userID='"+userid+"'";
state.executeUpdate(sql);
System.out.println("用户积分更新");
}else
{
System.out.println("数据库链接失败!");
}
}
catch (SQLException e) {
e.printStackTrace();
}
}
}
——————错误提示
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 'userID='13831880053'' at line 1