Question

com.microsoft.sqlserver.jdbc.SQLServerException: '.' 附近有语法错误。

com.microsoft.sqlserver.jdbc.SQLServerException: '.' 附近有语法错误。
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(Unknown Source)
..................
代码
String sql = "select ustudent.sid,sname,score1,score2 from usc, ucourse,ustudent"

+"where usc.cid=uCourse.cid and uStudent.Sid=usc.sid and cname=?";

stmt = conn.prepareStatement(sql);
stmt.setString(1,cname);

rs = stmt.executeQuery();

Answer 1

"SELECT s.sid,sname,score1,score2  
FROM usc
INNER JOIN uStudent s ON
usc.cid = s.sid  
INNER JOIN ucourse ON  
usc.cid=uCourse.cid 
WHERE  cname=?"