NEOMUSHLIH

Assalamu'alaykum,
langsung aja ke materi. caranya menghubungkan database di mysql ke java cukup simpel :). sebelumnya peralatan "perang" yang saya gunakan terdiri dari :
- netbeans 6.8, klo mau download di sini untuk versi terbaru.
- buat databasenya dulu di phpmyadmin, pakai xampp. download di sana.

langkah2nya sebagai berikut :
1. download mysql-connector-java, klik di situ. dalam uji coba ini saya menggunakan JDBC.
2. pasang library tambahan dengan klik kanan libraries di project, add .jar/folder dan cari file .jar yang sudah didownload.
3. di project, import library ini :
import java.sql.*;
import com.mysql.jdbc.Driver;/**
4. deklarasi fungsi berikut :

private Connection connection;
private PreparedStatement addRecord, getRecords;
5. langsung saja. info lengkap baca bawah(males nulis... :p)

/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/

package com.deitel.advjhtp1.jsp.beans;

// import com.deitel.advjhtp1.jsp.beans.GuestBean;
import java.io.*;
import java.sql.*;
import java.util.*;
import com.mysql.jdbc.Driver;/**
*
* @author KHAWARIZMI
*/
public class GuestDataBean {

private Connection connection;
private PreparedStatement addRecord, getRecords;

// construct TitlesBean object
public GuestDataBean() throws Exception
{
// load the Cloudscape driver
Class.forName("com.mysql.jdbc.Driver");

connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/j2ee","root",""); //url, username, password

getRecords =
connection.prepareStatement(
"SELECT firstName, lastName, email FROM guests"
);
}

// return an ArrayList of GuestBeans
public List getGuestList() throws SQLException
{
List guestList = new ArrayList();

// obtain list of titles
ResultSet results = getRecords.executeQuery();

// get row data
while ( results.next() ) {
GuestBean guest = new GuestBean();

guest.setFirstName( results.getString( 1 ) );
guest.setLastName( results.getString( 2 ) );
guest.setEmail( results.getString( 3 ) );

guestList.add( guest );
}

return guestList;
}

// insert a guest in guestbook database
public void addGuest( GuestBean guest ) throws SQLException
{
addRecord.setString( 1, guest.getFirstName() );
addRecord.setString( 2, guest.getLastName() );
addRecord.setString( 3, guest.getEmail() );

addRecord.executeUpdate();
}
// @Override
protected void finalize()
{
// attempt to close database connection
try {
getRecords.close();
addRecord.close();
connection.close();
}

// process SQLException on close operation
catch ( SQLException sqlException ) {
sqlException.printStackTrace();
}
}
}