java mysql get null_JDBC连接mysql数据库出现java.lang.NullPointerException

JSP文件内容：

JSP文件内容：

String sql=null;

String url=null;

Statement st=null;

try{

out.print("创建开始...
");

sql="CREATE DATABASE whm";

url="jdbc:MySQL://localhost:3306/test?user=root&password=aa&characterEncoding=gb2312";

st=getStatement(url);//通过指定的url获得Statement对象，此函数将在步骤(2)中实现

st.execute(sql);

out.print("数据库whm创建成功...
");

sql="CREATE TABLE `table` (`field1` int(11),`field2` char(20),`field3` char(10))";

url="jdbc:MySQL://localhost:3306/whm?user=root&password=aa&characterEncoding=gb2312";

st=getStatement(url);

st.execute(sql);

out.print("表table创建成功...
");

out.print("创建结束...
");

}

catch(Exception e){out.print("创建失败原因："+e.toString());}

%>

public Statement getStatement(String url){

try{

Class.forName("com.mysql.jdbc.Driver");

Connection con=DriverManager.getConnection(url);

return con.createStatement();

}catch(Exception e){return null;}

}

%>

web.xml文件内容：<?xml version="1.0" encoding="UTF-8"?>

xmlns="http://java.sun.com/xml/ns/j2ee"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee

http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">

jdbc/DBPool

javax.sql.DataSource

Container

Shareable

index.jsp

JAR包为：mysql-connector-java-5.0.4-bin.jar

运行结果为：创建开始...

创建失败原因：java.lang.NullPointerException

哪位大侠帮我看看我的问题出现在哪里？

展开