DatabaseOperation.java

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

/**
 *
 * @author @FgroupIndonesia.com
 */
public class DatabaseOperation {

    private static String namaDB = "latihan_java";
    private static String namaUser = "?user=root";
    private static String lokasiDB = "//localhost/" + namaDB + namaUser;
    private static Connection conn = null;

    private static Connection connect() {

        String url = "jdbc:mysql:" + lokasiDB;

        try {
            Class.forName("com.mysql.jdbc.Driver");
            conn = DriverManager.getConnection(url);
        } catch (Exception e) {
            System.out.println(e.getMessage());
        }
        return conn;
    }

    public static void akhiri() {

        try {
            conn.close();
        } catch (SQLException e) {
            System.out.println(e.getMessage());
        }

    }

    public static ResultSet getAllDataBarang() {
        PreparedStatement statement = null;
        ResultSet hasil = null;
        try {
            statement = connect().prepareStatement("SELECT * FROM barang");
            hasil = statement.executeQuery();
        } catch (Exception ex) {
            ex.printStackTrace();
        }

        return hasil;
    }
}