how can i prevent duplicate records using servlets and MVC model?

Ads
 

how can i prevent duplicate records using servlets and MVC model?

hai,

I need a program to insert values into database at the same time it shows error msg on response page while we are giving duplicate entry of a primary key.i want this program in MVC model.can anyone help me...

Thanks&Regards P.Divya

View Answers

April 27, 2011 at 5:21 PM

1)form4.jsp:

<html>
<form method="post" action="../InsertServlet">
<table>
<tr><td>Id:</td><td><input type="text" name="id"></td></tr>
<tr><td>Name:</td><td><input type="text" name="name"></td></tr>
<tr><td>Address:</td><td><input type="text" name="address"></td></tr>
<tr><td>Contact No:</td><td><input type="text" name="contact"></td></tr>
<tr><td>Email:</td><td><input type="text" name="email"></td></tr>
<tr><td></td><td><input type="submit" value="Submit"></td></tr>
</table>
</form>
</html>

2)InsertServlet.java:

import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class InsertServlet extends HttpServlet{ 
    public void doPost(HttpServletRequest req,HttpServletResponse res) throws ServletException,IOException {
        res.setContentType("text/html");
        int count=0;
        PrintWriter out = res.getWriter();
        int id=Integer.parseInt(req.getParameter("id"));
        String name=req.getParameter("name");
        String address=req.getParameter("address");
        int phone=Integer.parseInt(req.getParameter("contact"));
        String email=req.getParameter("email");
        try{
        Class.forName("com.mysql.jdbc.Driver");
        Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
        Statement st=con.createStatement();
        ResultSet rs=st.executeQuery("select * from employee where id='"+id+"'");
        while(rs.next()){
        count++;
        }
        if(count>0){
        out.println("<font color=red>Error: Id already exists</font>");

        }
        else{
         int i=st.executeUpdate("insert into employee(id,name,address,contactNo,email) values("+id+",'"+name+"','"+address+"',"+phone+",'"+email+"')");
        out.println("<font color=green>Data is successfully inserted!</font>");
        }
        }
        catch(Exception e){
        System.out.print(e);
                }       
            }
        }

Ads









Related Tutorials/Questions & Answers:
how can i prevent duplicate records using servlets and MVC model?
how to validate duplicate records in struts1
Advertisements
how to validate duplicate records in struts1
How to prevent adding duplicate items to the shopping cart
How a simple "Hello World" can be displayed using Spring 3.2 MVC?
how can we prevent back option after log out.
how can i run tomcat server and my home page come when i double click on an icon in servlets
how can i run tomcat server and my home page come when i double click on an icon in servlets
how can i run tomcat server and my home page come when i double click on an icon in servlets
how can i run tomcat server and my home page come when i double click on an icon in servlets
How can I execute a PHP script using command line?
how can manages records in jsp
duplicate records inserting
using jsp and servlets andin Mvc architecture
how can i achieve multiple inheritance in java without using inheritance ?
JDBC : Duplicate records in a table
How i can send testing mail on my id using java?
How can i draw a line using java swings
How can i draw a line using java swings
How can I generate diff image using Jmagick?
How i can send mail by using jsp.............. - JavaMail
How I can filling pdf file that crated by livecycle using itext
how do i provide down a pdf document fecility on my web page using jsp and servlets?
how can i draw a table using applet or swings - Java Beginners
How can I access databse through JSP. I am using postgresql-8.4.4-1-windows as database and jboss-4.0.5.GA as server.
how can i create a discussion forum?
how to display duplicate elements with out using collection Frame work?
Mysql Find Duplicate Records
User Registration Form Using JSP(JspBeans) after that how i can insert in database
How to export web page to excel using java or jsp or servlets
Need to Remove Duplicate Records from Excel Sheet

Ads