为什么我的SQL查询不起作用?

我正在尝试从通过主键链接的两个不同的表中删除.

我的表格如下..

表格名称:StudentCourse

PK:StudentID
学生姓名
StudentPassword
CourseCode


表名称:StudentModuleResult

PK:StudentID
ModuleCode
ResultCode


我具有以下功能:

I am trying to delete from two different tables which are linked by the primary key.

My tables are as follows..

Table Name: StudentCourse

PK: StudentID
StudentName
StudentPassword
CourseCode


Table Name: StudentModuleResult

PK: StudentID
ModuleCode
ResultCode


I have the following function:

public String deleteStudent(String studentid) {
        int noOfUpdates = 0;
        String message = "";
        try {
            String strQuery = "DELETE FROM StudentCourse WHERE StudentID = " + studentid
                            + " DELETE FROM StudentModuleResult WHERE StudentID = " + studentid;

            PreparedStatement stmt = conn.prepareStatement(strQuery);
            stmt.setString(1, studentid);
            noOfUpdates = stmt.executeUpdate();
        }
        catch (SQLException e) {
            message = "SQL Exception: " + e.getMessage();
        }
        if (message.length() ==0 && noOfUpdates == 0)
            message = "Record was not updated";

        return message;
    }

但是，我收到以下错误:

SQL异常:查询表达式"StudentID = 10198765 DELETE FROM StudentModuleResult WHERE StudentID = 10198765"中的[Microsoft] [ODBC Microsoft Access Driver]语法错误(缺少运算符).

However I am receiving the following error:

SQL Exception: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression ''StudentID = 10198765 DELETE FROM StudentModuleResult WHERE StudentID = 10198765''.