Coding insert - 4 Februari 2008

mencuba coding yang diberikan dalam forum : http://www.daniweb.com

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<%@ page import="java.util.*" %>
<%!
String firstname= request.getParameter("FIRSTNAME");
String lastname = request.getParameter("LASTNAME");
String address1 = request.getParameter("ADDRESS");
String address2= request.getParameter("ADDRESS2");
String address3 = request.getParameter("ADDRESS3");
String city = request.getParameter("CITY");
String province = request.getParameter("PROVINCE");
String memo = request.getParameter("MEMO");
%>
<%

Class.forName("com.mysql.jdbc.Driver");

Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/funeral", "root", "abc123");
PreparedStatement ps=conn.prepareStatement("INSERT INTO memory VALUES (?,?,?,?,?,?,?,?)");
ps.setString(1,firstname );
ps.setString(2,lastname );
ps.setString(3,address1 );
ps.setString(4,address2 );
ps.setString(5,address3 );
ps.setString(6,postalcode );
ps.setString(7,province );
ps.setString(8,memo );
ps.execute();

conn.close();
}catch(Exception e)
{
out.println(e);
}
%>-------------------------------------------

mengubahsuai aturcara ini bagi sesuai dengan aturcara yang dibangunkan...