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

Terkait:

Menu