带有预准备语句的java.sql.SQLSyntaxErrorException

Question

我刚刚开始学习MySQL，现在我正在尝试学习准备好的语句。当我使用它们时，我得到这个错误java.sql.SQLSyntaxErrorException。谁能告诉我我在哪里搞错了语法？谢谢。下面是我的代码：

public class DBConnector {
    
    private Statement statement;
    private ResultSet result;
    private PreparedStatement preparedStatement;

    public void createDB() { 
            try {
                sql = "CREATE DATABASE IF NOT EXISTS ?";
                tableName = "test_name";
                preparedStatement = connection.prepareStatement(sql);
                preparedStatement.setString(1, tableName);
                int myResult = preparedStatement.executeUpdate();
    
                if(myResult == 1){
                    System.out.println("Database successfully created.");
                }else{
                    System.out.println("Database with that name already exists. Please try again with different name.");
                    createDB();
                }
            }catch (SQLException e) {
                System.out.println("Database creation failed.");

            e.printStackTrace();
        }
    }
}

Answer 1

无法在查询参数中绑定数据库名称。

Statement stmt=con.createStatement(); 

int rs=stmt.executeUpdate("CREATE DATABASE dbname");

这样试试看，数据库会创建。