Script_P5_Koneksi

package koneksi;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import javax.ejb.Stateless;

@Stateless
public class Koneksi
{
	/* Ini awal Script Koneksi */
	public List mahasiswaMethod()
	{
		List list = new ArrayList();

		String JDBC_DRIVER="com.mysql.jdbc.Driver";
		String JDBC_URL="jdbc:mysql://localhost:3306/mahasiswa";
		String USR="root";
		String PASS="";

		try
		{
			Class.forName(JDBC_DRIVER);
			Connection con =
			DriverManager.getConnection(JDBC_URL,USR,PASS);
			Statement stmt=con.createStatement();
			ResultSet rs=stmt.executeQuery("select * from mahasiswa");
			while(rs.next())
			list.add(rs.getString(1)+"-"+rs.getString(2));
			con.close();
		}
		catch (Exception ex)
		{
			System.out.println(ex.getMessage());
		}
		return list;
	}
	/* Ini akhir Script Koneksi */
}