jdbc创建一个mysql库_jdbc怎么动态的创建一个数据库?

使用jdbc动态的创建一个数据库(不是创建数据表),一个用户,然后赋予这个用户访问这个数据库的权限这是我用C3P0数据源+DBUtils写的，报错，求解..java.sql.SQLException:Youhaveanerror...

使用jdbc动态的创建一个数据库(不是创建数据表),一个用户,然后赋予这个用户访问这个数据库的权限

这是我用C3P0数据源+DBUtils写的，报错，求解..

java.sql.SQLException: 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 ''db_giraffe' DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci' at line 1 Query: CREATE DATABASE ? DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci Parameters: [db_giraffe]

at org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:320)

at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:489)

at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:389)

at com.giraffe.dao.UserDao.createDataBaseByUserID(UserDao.java:130)

at com.giraffe.service.UserService.createDataBase(UserService.java:75)

at com.giraffe.action.CreateDBAction.doPost(CreateDBAction.java:34)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:643)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)

at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:879)

at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:617)

at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1774)

at java.lang.Thread.run(Unknown Source)

展开