mybatisplus自动生成的delete语句在sqlserver中说语法错误
具体是这样的
==> Preparing: DELETE FROM MISSION_TYPE_STATUS t WHERE (t.mission_type_id = ?)
==> Parameters: a3e29f264dea4be9e983739def7829de(String)
报错是这样的
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: “t”附近有语法错误。
; uncategorized SQLException; SQL state [S0001]; error code [102]; “t”附近有语法错误。; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: “t”附近有语法错误。
我用oracle的时候没问题，切换过来就这样了

试试 改为as t

package com.hz.servlet;
import com.hz.pojo.Employee;
import com.hz.service.EmployeeService;
import com.hz.service.EmployeeServiceImpl;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
@WebServlet("/AddEmployeeServlet")
public class AddEmployeeServlet extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
String uid= request.getParameter("id");
Integer id=Integer.parseInt(uid);
String uage= request.getParameter("age");
Integer age=Integer.parseInt(uage);
String name= request.getParameter("name");
String position= request.getParameter("position");
EmployeeService employeeService=new EmployeeServiceImpl();
Employee employee=new Employee();
employee.setId(id);
employee.setName(name);
employee.setAge(age);
employee.setPosition(position);
try {
int i= employeeService.addEmployee(employee);
if(i==1){
request.getRequestDispatcher("/FindAllEmployeesServlet") .forward(request,response);
}else{
response.sendRedirect("addEmployee.jsp");
}
} catch (Exception e) {
e.printStackTrace();
}
}
}