java - 从html插入数据到数据库，查询错误

Question

从 html 页面将数据插入数据库，我已成功将数据传递给 jsp，然后传递给 java 文件，但在将数据插入数据库时​​出现错误。

这是查询:

String ResultQuery = "INSERT INTO Results (homeTeam, awayTeam, homeScore, awayScore)" +
    "VALUES (+HomeTeam+','+AwayTeam+','+HomeScore+','+AwayScore+)";

这是错误:

javax.servlet.ServletException: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '+HomeTeam+','+AwayTeam+','+HomeScore+','+AwayScore+'.

Answer 1

您的查询是错误的，如果所有 [HomeTeam,AwayTeam,HomeScore,AwayScore] 都是变量，您应该以这种形式重写查询:

String ResultQuery = "INSERT INTO Results (homeTeam, awayTeam, homeScore, awayScore)" +
    "VALUES ('"+HomeTeam+"','"+AwayTeam+"','"+HomeScore+"','"+AwayScore+"')";

但是如果那些不是变量你应该写成这种形式:

String ResultQuery = "INSERT INTO Results (homeTeam, awayTeam, homeScore, awayScore)" +
    "VALUES ('HomeTeam','AwayTeam','HomeScore','AwayScore')";