determiningsqlwarning.java

一些数据库操作可能会导致一个警告而不是由一个例外。这些警告必须明确检查。一个例子警告是一个数据截断误差在读操作（见DataTruncation 类） 。

//Determining If a SQL Warning Occurred

class DeterminingSQLWarning{
	public static void main(String[] args){
	
	    try {
        // Get warnings on Connection object
        SQLWarning warning = connection.getWarnings();
        while (warning != null) {
            // Process connection warning
           
            String message = warning.getMessage();
            String sqlState = warning.getSQLState();
            int errorCode = warning.getErrorCode();
            warning = warning.getNextWarning();
        }
    
        // Create a statement
        Statement stmt = connection.createStatement();
    
        // Use the statement...
    
        // Get warnings on Statement object
        warning = stmt.getWarnings();
        if (warning != null) {
            // Process statement warnings...
        }
    
        // Get a result set
        ResultSet resultSet = stmt.executeQuery("SELECT * FROM my_table");
        while (resultSet.next()) {
            // Use result set
    
            // Get warnings on the current row of the ResultSet object
            warning = resultSet.getWarnings();
            if (warning != null) {
                // Process result set warnings...
            }
        }
    } catch (SQLException e) {
    }


	
	}
}