ask cara koneksiin java netbean ke sqlyog (mysql)

[Badguy13]

agan2 programmer yg baik lontongin ane donk

ane ada tugas dsuruh koneksiin java ke mysql

javanya ane pke netbeans IDE 6.8 dan sqlna pke sqlyog



importna ane pke :

import java.sql.*;

import java.sql.Connection;

import java.sql.DriverManager;



programnya kyk gni:

public static void main(String[] args) {

Connection koneksi = null;

Statement st1 = null;

ResultSet rs1;

String kode="", npm="", nama="";

int tgs=0, uts=0, uas=0;

double akhir=0.0;

char hrf=' ';

try{

Class.forName("com.mysql.jdbc.Driver");

koneksi = DriverManager.getConnection("jdbc:mysql://localhost/mahasiswa", "root", " ");

st1 = koneksi.createStatement();

rs1 = st1.executeQuery("SELECT * from nilai;");

System.out.println("Kode MK\tNPM\tNama\tTugas\tUTS\tUAS\tHuruf");

while(rs1.next()){

kode = rs1.getString("Kode_MK");

npm = rs1.getString("NPM");

nama = rs1.getString("Nama");

tgs = rs1.getInt("Tugas");

uts = rs1.getInt("UTS");

uas = rs1.getInt("UAS");



akhir = 0.2*tgs + 0.3*uts + 0.5*uas;

if(akhir>=80.00) hrf='A';

else if(akhir