mysql没有发生错误_在MySQL工作台中运行我的查询时发生JDBC错误但没有错误

我正在MySQL数据库上运行查询，我正在使用JDBC，并且正在使用MySQL工作台来运行查询。

当我在MySQL工作台上运行它时，我得到了我期待的，但是当我在我的代码中运行它时，我会得到它。

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException：您的SQL语法有错误;检查与您的MySQL服务器版本相对应的手册，以找到在第1行'SELECT Character.CharacterID，Character.CharacterName，Characte'附近使用的正确语法

这是Java：

for (int i = 0; i < 3; i++) {

try {

result = s.executeQuery("USE `arbitrary-hero`; SELECT `Character`.CharacterID, `Character`.CharacterName, `Character`.CharacterLevel, SUM(ItemAttack), SUM(ItemHealth), SUM(ItemAgility), "

+ "SUM(ItemStrength), SUM(ItemSource) FROM `arbitrary-hero`.`Character` INNER JOIN `arbitrary-hero`.Character_Items ON `Character`.CharacterID = Character_Items.CharacterID INNER JOIN "

+ "Items ON Character_Items.ItemID = Items.ItemID WHERE Character_Items.Equiped = 1 and `Character`.CharacterName = "+ name[i] +" GROUP BY `Character`.CharacterName;;");

}

catch(Exception e) {

System.out.println(e);

}

}

s.close();这里是SQL：

SELECT `Character`.CharacterID, `Character`.CharacterName, `Character`.CharacterLevel, SUM(ItemAttack), SUM(ItemHealth), SUM(ItemAgility), SUM(ItemStrength),

SUM(ItemSource) FROM `arbitrary-hero`.`Character` INNER JOIN `arbitrary-hero`.Character_Items ON

`Character`.CharacterID = Character_Items.CharacterID INNER JOIN Items ON

Character_Items.ItemID= Items.ItemID WHERE Character_Items.Equiped = 1 and `Character`.CharacterName = "Maxinfet" GROUP BY `Character`.CharacterName;