package latihan;

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

public class dbKoneksi {
    public static void main(String[] args) {
        try {
            //mendefinisikan driver konektor database
            Class.forName("com.mysql.jdbc.Driver");

            //memulai koneksi database dgn memanggil url
            Connection con = DriverManager.getConnection(url:"jdbc:mysql://localhost/ketarunaan", "root","root");
            //perintah SQL untuk menampilkan seluruh isi tabel
            String sql = "SELECT * FROM  datataruna";
            Statement statement = connection.createStatement();
            ResultSet resultSet = statement.executeQuery(sql);

            if (resultSet.next()) {
                System.out.println("ID :" + resultSet.getString(columnLabel:"id_taruna"));
                System.out.println("nama:" + resultSet.getString(columnLabel:"nama"));
                System.out.println("pengarang" + resultSet.getString(columnLabel:"pengarang"));
            } else {
                System.out.println("data tidak ditemukan");
            }

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