// uji koneksi ke database mysql
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class UjiKoneksi {

    private static Connection koneksi = null;

    public static void main(String args[]) {
        //panggil driver jdbc
        try {
            Class.forName("com.mysql.jdbc.Driver");
            System.out.println("Berhasil!");
        } catch (ClassNotFoundException c) {
            System.out.println("Gagal! " + c);
        }
        //koneksi db
        if (koneksi == null) {
            try {
                String url = "jdbc:mysql://127.0.0.1:3306/sms";
                String user = "root";
                String passw = "myroot";
                koneksi = DriverManager.getConnection(url, user, passw);
                System.out.println("Koneksi ke mysql sukses!");
            } catch (SQLException s) {
                System.out.println("Koneksi ke mysql gagal!");
                System.exit(0);
            }
        }
        //ambil data
        String sql = "SELECT * FROM data_pelanggan";
        try {
            Statement st = koneksi.createStatement();
            ResultSet rs = st.executeQuery(sql);
            while (rs.next()) {
                //ambil data dgn nama field 
                System.out.print(rs.getString("id_pelanggan") + " | ");
                System.out.print(rs.getString("nama_pelanggan") + " | ");
                System.out.print(rs.getString("alamat_pelanggan") + " | ");
                System.out.println(rs.getString("daya"));
            }
            //tutup statement
            st.close();
        } catch (SQLException s) {
            System.out.println("Data tak dapat diambil. "+s);
        }
        //tutup koneksi
        try {
            koneksi.close();
            System.out.println("Koneksi ke mysql berhasil diputus!");
        } catch (SQLException s) {
            System.out.println("Koneksi ke mysql tidak dapat diputus. "+s);
        }
    }
}