Java Oh Java

[budak 0]

akum...kat sini adik nak tanya sikit ler pasal java ni.adik kena buat projek ATM.alahai mesin keluar duit tu. ni lebih kurang assg ler. so kat sini adik bukan nak suruh abang2 suapkan info2 pasal ni.cuma adik nak tau pasal bagaimana nak connect antara java dan mySQL. kalau ada url ker atau apa2 jer ler tunjuk ajar adik alu2kan.dan jugak adik nak tanya ok ker kalau pakai mySQL ni. atau ada alternatif lain? sebab database ini nak simpan nama,password dan lain2 ler.ok tima kasih.

[DevGuy 0]

kena guna JDBC leh check macam mana nak buat kat mysql.org gi kat tutorial.. and dont forget to download java connecter daripada mysql..

[putra 1]

Rasanye pakai Mc Acess pun dah ok dah..

Kalau rasa nak pakai Java + Mc Access, try pi cni

http://planetsourcecode.com/vb/scripts/Sho...620042345536416

[vectorzx 0]

rasenya ko nye assg dh anta so aku leh reveal sket camne nk connect ngan mysql. ni antara kodnya mase aku buat assg dulu. enjoy!

* snip *

public void jdbcConnect(String dsn)
{
	Connection con;
	String url = "jdbc:mysql://localhost:3306/" + dsn;

	try
	{
		Class.forName ("com.mysql.jdbc.Driver");
		con = DriverManager.getConnection(url, "root", "");

		DatabaseMetaData dma = con.getMetaData ();

		System.out.println("\nConnected to " + dma.getURL());
		System.out.println("Driver       " + dma.getDriverName());
		System.out.println("Version      " + dma.getDriverVersion());
		System.out.println("");
	}
	catch (SQLException ex)
	{
		while (ex != null)
		{
			System.out.println ("SQLState: " + ex.getSQLState ());
			System.out.println ("Message:  " + ex.getMessage ());
			System.out.println ("Vendor:   " + ex.getErrorCode ());
			ex = ex.getNextException ();
			System.out.println ("");
		}
		System.out.println("Connection to the database error");
	}
	catch (java.lang.Exception ex)
	{
		ex.printStackTrace ();
	}
}
[/codebox]

*snip*

tapi ko jgn lupa plak donlod dia nye java connector bak kata DevGuy kite.