pertemuan10SelectApp

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package pert10;

import java.sql.Connection;
import java.sql.DriverManager;
import java.io.*;
import java.sql.*;
/**
 *
 * @author LK09NU17UTY
 */
public class selectApp {

    public static void  tampilkan()
    {
        Connection com = null;




        try
        {
            String jdboDriver = "com.mysql.jdbc.Driver";
            Class.forName(jdboDriver);

            String url ="jdbc:mysql://localhost:3306/mahasiswa";
            String user="root";
            String pswd="";

            System.out.println("Mencoba menmabngun koneksi ke"+url+"'dengan user'"+user+"'password'"+pswd+"'...'");
            com= DriverManager.getConnection(url,user,pswd);
            System.out.println("Sukses");

            String sqlSelect="select *from test";
            Statement stmt =com.createStatement();
            ResultSet rs=stmt.executeQuery(sqlSelect);

            int i=1;
            while (rs.next()) {
                String nim=rs.getString("nim");
                String nama=rs.getString("nama");
                String alamat=rs.getString("alamat");

                System.out.println("Mahasiswa No. "+i);
                System.out.println("nim"+nim);
                System.out.println("nama"+nama);
                System.out.println("Alamat"+alamat);
                i++;
            }
        }
        catch(Exception e)
                {
                   e.printStackTrace();
                }
    }
}