jdbcutils.java_空指针异常错误哪个地方错了Exception in thread "main" (JdbcUtils.java:62) main(JdbcUtils.java:87)...

展开全部

导入mysql的驱动包就可以32313133353236313431303231363533e59b9ee7ad9431333335333163了啊 我复制了你的代码执行完全没有问题

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.List;

public class text {

private final String USERNAME = "root";

private final String PASSWORD = "123456";

private final String DRIVER = "com.mysql.jdbc.Driver";

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

private Connection connection;

private PreparedStatement pstmt;

private ResultSet resultSet;

public text() {

try {

Class.forName(DRIVER);

System.out.println("注册驱动成功！！");

} catch (Exception e) { // TODO:

}

}

// handle

public Connection getConnection() {

try {

connection = DriverManager.getConnection(URL, USERNAME, PASSWORD);

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

} catch (Exception e) {

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

}

return connection;

} // exception

// } }

public boolean updateByPreparedStatement(String sql, List params)

throws SQLException {

boolean flag = false;

int result = -1;// 表示当用户执行添加删除修改的操作的时候所影响数据库的行数

pstmt = connection.prepareStatement(sql);

int index = 1;

if (params != null && !params.isEmpty()) {

for (int i = 0; i < params.size(); i++) {

pstmt.setObject(index++, params.get(i));

}

}

result = pstmt.executeUpdate();

flag = result > 0 ? true : false;

return flag;

}

public static void main(String[] args) {

text jdbcUtils = new text();

jdbcUtils.getConnection();

String sql = "insert into userinfo(username,psword) values(?,?)";

List params = new ArrayList();

params.add("rainkey");

params.add("admin");

try {

boolean flag = jdbcUtils.updateByPreparedStatement(sql, params);

System.out.println(flag);

} catch (SQLException e) {

e.printStackTrace();

}

}

}