java - Hibernate setParameter 向字符串添加单引号

Question

我正在尝试使用 hibernate 准备好的语句创建新表。看起来 "setparameter("values", value)" 添加了额外的引号来查询。我的代码:

String hql = "create table :values " + "(name VARCHAR(50))";
        Query my = session.createSQLQuery(hql);
        my.setParameter("values", value);
        my.executeUpdate();
        session.close();

错误:

SEVERE: Servlet.service() for servlet [contextServlet] in context with path [/SpringSafeHouseService2.0] threw exception [Request processing failed; nested exception is org.hibernate.exception.SQLGrammarException: could not execute statement] with root cause
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''merkurijuss' (name VARCHAR(50))' at line 1

Answer 1

您不能在准备好的语句中使用表名称作为参数。你必须把它放入刺中:

    String hql = "create table "+ value+ " (name VARCHAR(50))";
    Query my = session.createSQLQuery(hql);
    my.executeUpdate();
    session.close();