java 中sql语句_java项目中sql语句的问题

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