java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306
我想在jsp中链接上数据库直接可以执行创建数据库的语句,原来做的只是在链接到已经创建好的数据库,然后在数据库里面进行诸如增加删除或者是穿件表的操作。现在我想直接用jsp语句创建一个数据库,写了一个jsp,高手们帮帮忙,看看什么问题
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>
<%!
String password = null;
String username = null;
String DBDRIVER = "org.gjt.mm.mysql.Driver";
String DBURL = "jdbc:mysql://localhost:3306";
String DBUSER = username;
String DBPASSWORD = password;
Connection conn = null;
PreparedStatement pstmt = null;
String name = null;
%>
<%
username = request.getParameter("sqlname");
password = request.getParameter("sqlpass");
%>
<%
try
{
Class.forName(DBDRIVER);
conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);
String sql = "create database" + username;
pstmt= conn.prepareStatement(sql);
pstmt.executeUpdate();
}
catch(Exception e){
out.println(e);
} finally{
if(pstmt!=null) pstmt.close();
if(conn!=null) conn.close();
}
%>