mysql statement_mysql创建statement对象

packagecom.yxq.toolsbean;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;publicclassD...

package com.yxq.toolsbean;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class DB {

private final String url = "jdbc:mysql://localhost:3306/mysql";

private final String userName = "root";

private final String password = "";

private Connection conn = null;

private Statement stm=null;

/* 通过构造方法加载数据库驱动 */

public DB(){

try {

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

System.out.println("加载数据库成功！");

} catch (Exception e) {

e.printStackTrace();

System.out.println("加载数据库驱动失败！");

}

}

/* 创建数据库连接 */

public void createCon() {

try {

Connection conn = DriverManager.getConnection(url, userName, password);

System.out.println("获取数据库连接成功！");

} catch (Exception e) {

e.printStackTrace();

System.out.println("获取数据库连接失败！");

}

}

/* 获取Statement对象 */

public void getStm(){

createCon();

try {

Statement stm=conn.createStatement();

System.out.println("创建Statement对象成功！");

} catch (SQLException e) {

e.printStackTrace();

System.out.println("创建Statement对象失败！");

}

}

我用测试类test测试以上代码

package com.yxq.toolsbean;

public class Test {

public static void main(

String[] args) {

DB db=new DB();

db.createCon();

db.getStm();

}

}

报错为

加载数据库成功！

获取数据库连接成功！

获取数据库连接成功！

Exception in thread "main" java.lang.NullPointerException

at com.yxq.toolsbean.DB.getStm(DB.java:40)

at com.yxq.toolsbean.Test.main(Test.java:10)

有空你们自己把代码粘贴到myeclipse看一下

展开