[ask] servlet+cendol
 

gan ane lg bikin halaman jsp pk servlet, database ms access 2007, server tomcat 6



kok pas mao input data ke access, tablenya ga keisi ya?(bukan null)



nih codingnya


Spoiler for connect:







Code:

import java.sql.*;

public class KonekDatabase
{
private Connection con;
private Statement stmt;
private ResultSet rs;

KonekDatabase(String tempat)
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:driver={Mic rosoft Access Driver (*.mdb, *.accdb)};DBQ=" + tempat);
stmt = con.createStatement(1004,1008);
} catch (Exception e)
{ }
}

public void update(String query)
{
try
{
stmt.executeUpdate(query);
} catch (Exception e)
{ }
}

public ResultSet view(String query)
{
try
{
rs = stmt.executeQuery(query);
} catch (Exception e)
{ }
return rs;
}

}











<div style="margin:20px; margin-top:5px">
Spoiler for registrasi:


<div class="alt2" style="margin: 0px; padding: 6px; border: 1px inset;">
<div style="display: none;">


<div style="margin:20px; margin-top:5px">
Code:

import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;


public class DoRegis extends HttpServlet
{

protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException
{
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
ServletContext aplikasi = getServletContext();
KonekDatabase con = new KonekDatabase(aplikasi.getRealPath("WEB-INF/database.accdb"));

String email = request.getParameter("txtemail");
String username = request.getParameter("nama");
String password = request.getParameter("pass");
String password2 = request.getParameter("pass2");
String address = request.getParameter("alamat");
String phone = request.getParameter("telpon");
int at = 0, titik = 0, at2 = 0, titik2 = 0;

try
{
try
{
for(int i=0;i