java resultset wasnull_Java JDBC ResultSet的接口方法wasNULL()方法来判断接受到的SQL查询值是否为NULL，该方法返回值为Boolean类型...

import java.sql.Connection;

import java.sql.Date;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class ResultSet_wasNull {

public static void main(String args[]) throws SQLException {

//Registering the Driver

DriverManager.registerDriver(new com.mysql.jdbc.Driver());

//Getting the connection

String mysqlUrl = "jdbc:mysql://localhost/mydatabase";

Connection con = DriverManager.getConnection(mysqlUrl, "root", "password");

System.out.println("Connection established......");

//Creating the Statement

Statement stmt = con.createStatement();

//Insert a row into the MyPlayers table

PreparedStatement pstmt = con.prepareStatement("INSERT INTO MyPlayers values (?, ?, ?, ?, ?, ? )");

pstmt.setInt(1, 8);

pstmt.setString(2, "Ryan");

pstmt.setString(3, "McLaren");

pstmt.setDate(4, new Date(413596800000L));

pstmt.setString(5, "Kumberly");

pstmt.setNull(6, java.sql.Types.VARCHAR);

pstmt.executeUpdate();

//Query to retrieve records

String query = "Select * from MyPlayers";

//Executing the query

ResultSet rs = stmt.executeQuery(query);

//Verifying whether last row read was null

while(rs.next()) {

int id = rs.getInt("ID");

String first_name = rs.getString("First_Name");

String last_name = rs.getString("Last_Name");

Date date_of_birth = rs.getDate("Date_Of_Birth");

String place_of_birth = rs.getString("Place_Of_Birth");

String country = rs.getString("Country");

boolean bool = rs.wasNull();

if(bool) {

System.out.print("Id: "+id+", ");

System.out.print("First Name: "+first_name+", ");

System.out.print("Last Name: "+last_name+", ");

System.out.print("Date Of Birth: "+date_of_birth+", ");

System.out.print("Place Of Birth: "+place_of_birth+", ");

System.out.print("Country: "+country);

System.out.println(" ");

}

}

}

}