SqlWarning.java Source code

Introduction

Here is the source code for SqlWarning.java

Source

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.SQLWarning;
import java.sql.Statement;

public class SqlWarning {
    public static void main(String[] args) {
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();

            String jdbcUrl = "jdbc:oracle:thin:@localhost:1521:ORCL";
            Connection conn = DriverManager.getConnection(jdbcUrl, "yourName", "mypwd");

            Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
            SQLWarning sw = null;

            ResultSet rs = stmt.executeQuery("Select * from employees");
            sw = stmt.getWarnings();
            System.out.println(sw.getMessage());

            while (rs.next()) {
                System.out.println("Employee name: " + rs.getString(2));
            }
            rs.previous();
            rs.updateString("name", "Jon");

        } catch (SQLException se) {
            System.out.println("SQLException occurred: " + se.getMessage());

        } catch (Exception e) {
            e.printStackTrace();

        }
    }
}