// Java Program: Guest Book Application Using Servlets //

import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class guestbk extends httpservlet
{
	Connection con;
	public void doPost(HttpServletRequest req,HttpServletResponse res) 
throws
IOException,ServletException
	{
		PrintWriter out=new PrintWriter(res.getOutputStream());
		int ctr=0;
		res.setContentType("text/html");
	try
	{
   		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
   		con=DriverManager.getConnection("jdbc:odbc:booksrc","","");
   		Statement stmt=con.createStatement();
   		ResultSet rs=stmt.executeQuery("select * from gbook");
   		out.println("");
		out.println("");
	   	out.println("");
	   	out.println("");
	   	out.println("");
   		out.println("
GUEST BOOK DETAILS

");
   		out.println("");
   	while(rs.next())
   	{
    		ctr++;
    		String email=rs.getString("emailid");
    		String cmt=rs.getString("comment");
    		out.println("");
	}
    		out.println("
E-Mail
Address
Comment
"+email+"
"+cmt+"
");
	if(ctr==0)
      	out.println("
No Records Found
");
	stmt.close();
    	con.close();
  	}
   		catch(SQLException SQLExcep)
   	{
    		System.out.println("error");
   	}
   		catch(ClassNotFoundException CNFE)
   	{
    		System.out.println("error");
   	}
   		out.println("");
   		out.close();
  	}
 }

// submit.java //
import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class submit extends HttpServlet
{
	Connection con;
	public void doPost(HttpServletRequest req,HttpServletResponse res) 
throws
IOException,ServletException
{
	String str1,str2;
	str1=req.getParameter("emailid");
	str2=req.getParameter("comment");
	System.out.println(str1);
	System.out.println(str2);
	res.setContentType("text/html");
	PrintWriter out=res.getWriter();
	out.println("
Guest Book is Successfully 
Updated
");
	try
  	{
   		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		con=DriverManager.getConnection("jdbc:odbc:booksrc","","");
		Statement stmt=con.createStatement();
		ResultSet rs;
		int i= stmt.executeUpdate("insert into gbook
values('"+str1+"','"+str2+"')");
        if(i==1)
   	{
   		System.out.println("ok");
   	}
		stmt.close();
		con.close();
   	}
   		catch(SQLException SQLExcep)
  	{
   	        System.out.println("error");
   	}
   		catch(ClassNotFoundException CNFE)
   	{
    		System.out.println("error");
   	}}
 }

//guestbk.htm//













ENTER YOUR EMAIL ADDRESS



COMMENTS ARE ALWAYS WELCOME