Servlet使用tomcat执行时显示unknown database 'bookstore'

Question

最近在看孙鑫的javaweb,在本机上安装好mysql后，将工程导入了tomcat，打开了mysql服务器,运行了tomcat，输入http://localhost:8080/ch08/createdb后无法显示sucesss，发现出错，显示unknown database 'bookstore'
本人代码
package org.sunxin.lesson.jsp.bookstore;import javax.servlet.*;
import java.io.*;
import javax.servlet.http.*;
import java.sql.*;public class CreateDBServlet extends HttpServlet
{
    private String url;
    private String user;
    private String password;
    
    public void init() throws ServletException
    {
        String driverClass=getServletContext().getInitParameter("driverClass");
        url=getServletContext().getInitParameter("url");
        user=getServletContext().getInitParameter("user");
        password=getServletContext().getInitParameter("password");
        try
        {
            Class.forName(driverClass);
        }
        catch(ClassNotFoundException ce)
        {
            throw new UnavailableException("加载数据库驱动失败！");
        }
    }
    
    public void doGet(HttpServletRequest req, HttpServletResponse resp)
               throws ServletException,IOException
    {
        Connection conn=null;
        Statement stmt=null;
        try
        {
            conn=DriverManager.getConnection(url,user,password);
            stmt=conn.createStatement();
            stmt.executeUpdate("create database bookstore");
            stmt.executeUpdate("use bookstore");
            stmt.executeUpdate("create table bookinfo(id INT not null primary key,title VARCHAR(50) not null,author VARCHAR(50) not null,bookconcern VARCHAR(100) not null,publish_date DATE not null,price FLOAT(4,2) not null,amount SMALLINT,re VARCHAR(200)) ENGINE=InnoDB");
            stmt.addBatch("insert into bookinfo values(1,'Java从入门到精通','张三','张三出版社','2004-6-1',34.00,35,null)");
            stmt.addBatch("insert into bookinfo values(2,'JSP深入编程','李四','李四出版社','2004-10-1',56.00,20,null)");
            stmt.addBatch("insert into bookinfo values(3,'J2EE高级编程','王五','王五出版社','2005-3-1',78.00,10,null)");
            stmt.executeBatch();
            
            PrintWriter out=resp.getWriter();
            out.println("success!");
            out.close();
        }
        catch(SQLException se)
        {
            se.printStackTrace();
        }
        finally
        {
            if(stmt!=null)
            {
                try
                {
                    stmt.close();
                }
                catch(SQLException se)
                {
                    se.printStackTrace();
                }
                stmt=null;
            }
            if(conn!=null)
            {
                try
                {
                    conn.close();
                }
                catch(SQLException se)
                {
                    se.printStackTrace();
                }
                conn=null;
            }
        }
    }
}数据库TomcatServlet

Answer 1

在mysql中使用命令建表都没问题，很奇怪，用Servlet建表就是会显示unknown database bookstore

Answer 2

getServletContext().getInitParameter("url");你xml里配置的url是什么？
一般建database和建表语句不写在后台的。

Answer 3

是说你没有这个bookstore数据库，你是不是换了环境然后数据库没建或是名字不一致了啊

Answer 4

url写的是jdbc:mysql://localhost:3306/bookstore
不写到后台那是直接写死到Servlet中？

Answer 5

看看你mysql创建的表名称是不是正确的