Senin, 31 Maret 2008

KONEKSI KE DATABASE

import java.sql.*;
public class MySQLDemo
{
public static void main(String[] args)
{
try {
Class.forName(“com.mysql.jdbc.Driver”).newInstance();
String cs = “jdbc:mysql://localhost:3306/shop?user=test&password=test”;
Connection cn = DriverManager.getConnection(cs);
String qry = “INSERT INTO Customer ”;
qry += “VALUES (null, 'Endy', 'Surabaya', 'endy@artivisi.com')”;
Statement stm = cn.createStatement();
int result = stm.executeUpdate(qry);

if (result == 0) {
System.out.println(“Insert Gagal”);
}
else
{
System.out.println(“Insert Sukses”);
}

}
catch (Exception err) {err.printStackTrace();}
}
}

Tidak ada komentar: