Statement JDBC

PHOTO EMBED

Sun Nov 03 2024 15:51:24 GMT+0000 (Coordinated Universal Time)

Saved by @signup_returns #html 

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

public class StatementDemo {
    public static void main(String[] args) {
        String DB_URL = "jdbc:oracle:thin:@//localhost:1521/XE";
        String user = "system";
        String pass = "1234";

        try (Connection conn = DriverManager.getConnection(DB_URL, user, pass)) {
            Statement stmt = conn.createStatement();
            String insertQuery = "INSERT INTO employee(name, salary) VALUES ('Alice', 500000)";
            stmt.executeUpdate(insertQuery);
            System.out.println("Sucessfully Inserted a record");

            String getQuery = "SELECT * FROM employee";

            ResultSet rs = stmt.executeQuery(getQuery);
            while (rs.next()) {
                String str = rs.getString("name");
                double sal = rs.getDouble("salary");

                System.out.println("Employee Name: " + str + ", Salary is: " + sal);

            }

        } catch (SQLException se) {
            System.out.println("An error occured");
            se.printStackTrace();
        }
    }
}
content_copyCOPY