mysql 创建连接报错_用myeclipse连接mysql创建数据表报错？请教各位如何解决？谢谢！...

出错信息：Exceptioninthread"main"java.lang.NullPointerExceptionatjava.lang.Class.forName0(NativeMethod)atjava.lang.Class.forName(Class.java:169)atOurwis.ExecuteDDL.create...

出错信息：

Exception in thread "main" java.lang.NullPointerException

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Class.java:169)

at Ourwis.ExecuteDDL.createTable(ExecuteDDL.java:33)

at Ourwis.ExecuteDDL.main(ExecuteDDL.java:60)

代码如下：

import java.sql.*;

import java.util.*;

import java.io.*;

public class ExecuteDDL

{

private String driver;

private String url;

private String user;

private String pass;

Connection conn;

Statement stmt;

public void initParam(String paramFile)throws Exception

{

//使用Properties类来加载属性文件

Properties props = new Properties();

props.load(new FileInputStream(paramFile));

//driver = props.getProperty("driver");

//url = props.getProperty("url");

//user = props.getProperty("user");

//pass = props.getProperty("pass");

driver = props.getProperty("com.jdbc.mysql.Driver");

url = props.getProperty("jdbc:mysql://localhost:3306/ourwisDB");

user = props.getProperty("root");

pass = props.getProperty("golden18");

}

public void createTable(String sql)throws Exception

{

try

{

//加载驱动

Class.forName(driver);

//获取数据库连接

conn = DriverManager.getConnection(url,user,pass);

//使用Connection来创建一个Statement对象

stmt = conn.createStatement();

//执行DDL,创建数据表

stmt.executeUpdate(sql);

}

//使用finally块来关闭数据库资源

finally

{

if (stmt != null)

{

stmt.close();

}

if (conn != null)

{

conn.close();

}

}

}

展开