Java 和 MSSQL 从数据库获取数据时出现问题

Question

好吧，我有点困惑 atm，我正在尝试使用 java 和 mssql 从数据库中检索一些数据。

在sql中我这样写:

use MyChamp SELECT * 
FROM [GROUP]
 JOIN Team on [Group].GroupID = Team.GroupID
 JOIN Match on Team.TeamID = HomeTeamID
WHERE [GROUP].GroupID = 9

并且它有效。

在 java 中，我要执行的字符串如下所示:

String sql = "SELECT * FROM [GROUP]"
                + "JOIN Team on [Group].GroupID = Team.GroupID"
                + "JOIN Match on Team.TeamID = HomeTeamID"
                + "WHERE [GROUP].GroupID = 9"
                + "ORDER BY MatchRound:";

它不起作用，我收到 sql 错误消息说:

Error: S0001Incorrect syntax near 'Match'.

但我找不到错误:(

Answer 1

在字符串终止引号后添加空格“

String sql = "SELECT * FROM [GROUP] "
                + "JOIN Team on [Group].GroupID = Team.GroupID "
                + "JOIN Match on Team.TeamID = HomeTeamID "
                + "WHERE [GROUP].GroupID = 9 "
                + "ORDER BY MatchRound "

如果你不这样做，你的字符串将像这样生成。

SELECT * FROM [GROUP]JOIN Team on [Group].GroupID = Team.GroupIDJOIN Match on Team.TeamID = HomeTeamIDWHERE [GROUP].GroupID = 9ORDER BY MatchRound