jdbc mysql 偶发空指针_JDBC 进阶:使用封装通用DML DQL 和结构分层以及at com.mysql.jdbc.PreparedStatement.setTimestamp空指针异常解...

准备：

数据表

CREATE TABLE `t_user` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`username` varchar(10) DEFAULT NULL,

`pwd` varchar(10) DEFAULT NULL,

`regTime` date DEFAULT NULL,

`lastLoginTime` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=20227 DEFAULT CHARSET=utf8;

jar包：

注意！ 我这里使用的驱动包时5.1.48

如果使用了5.1.47会有个setTimestamp的空指针异常，网上有大神建议回退到5.1.46；

不过新版本出来了，我这边就使用新版本了。

这个bug MySQL官网有说明

[6 Jul 2019 0:44] Daniel So

Posted by developer:

Added the following entry to the Connector/J 5.1.48 changelog:

"PreparedStatement.setTimestamp threw a NullPointerException if getParameterMetaData() was called before the statement was executed. This fix adds the missing null checks to getParameterMetaData() to avoid the exception."

搭建分层结构

编写配置文件

driver = com.mysql.jdbc.Driver

jdbcUrl = jdbc:mysql://localhost:3306/testjdbc?useSSL=false

username = root

userpassword = 123456

编写工具类

package com.xzlf.commons;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.ResourceBundle;

public class JdbcUtil {

private static String driver;

private static String jdbcUrl;

private static String username;

private static String userpassword;

static {

// 读取properties 文件

ResourceBundle bundle = ResourceBundle.getBundle("jdbc");

driver = bundle.getString("driver");

jdbcUrl = bundle.getString("jdbcUrl");

username = bundle.getString("username");

userpassword = bundle.getString("userpassword");

try {

Class.forName(driver);

} catch (ClassNotFoundException e) {

e.printStackTrace();

}

}

/**

* 获取connection 对象

* @return