Hi There.. I am building a JSP web application in which I need to write data into MySQL database, but I need a code to check if data entered has not been entered before, to avoid duplicates....
This is what I have so far, but it is not working, it is writing data into the database even when I am intentionally using data already in the database....
<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<html>
<head><title>Create Data</title></head>
<body bgcolor=#F5F5F5>
<%-- <jsp:useBean id="beanInstanceName" scope="session"
class="beanPackage.BeanClassName"/> --%>
<%-- <jsp:getProperty name="beanInstanceName" property="propertyName"/> --%>
<%@page import="java.sql.*"%>
<%
String REF=request.getParameter("d_ref");
String DATE=request.getParameter("i_date");
String UBC=request.getParameter("i_ubc");
%>
<%
try
{
//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//Connection connection=DriverManager.getConnection("jdbc:odbc:db1","","");
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection connection=DriverManager.getConnection("jdbc:mysql://localhost/labacacias?user=root&password=letmein");
Statement statement=connection.createStatement();
String query;
query="SELECT referencia FROM enero";
boolean b=false;
ResultSet resultSet=statement.executeQuery(query);
while (resultSet.next())
{
if (REF.compareTo(resultSet.getString(1))==0)
{
b=true;
}
if (b)
{
out.println("Datos ya han sido adjuntados anteriormente!");
out.println("<a href=\"EneroU.jsp\">Click Aqui para Adjuntar nuevos Resultados</a>");
}
else
{
pageContext.forward("InsertE.jsp");
}
}
}
catch (Exception e)
{
//e.printStackTrace();
out.println(e.toString());
}
%>
</body>
</html>
Could you please help????
Hi There.. I am building a JSP web application in which I need to write data into MySQL database, but I need a code to check if data entered has not been entered before, to avoid duplicates....
This is what I have so far, but it is not working, it is writing data into the database even when I am intentionally using data already in the database....
<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<html>
<head><title>Create Data</title></head>
<body bgcolor=#F5F5F5>
<%-- <jsp:useBean id="beanInstanceName" scope="session"
class="beanPackage.BeanClassName"/> --%>
<%-- <jsp:getProperty name="beanInstanceName" property="propertyName"/> --%>
<%@page import="java.sql.*"%>
<%
String REF=request.getParameter("d_ref");
String DATE=request.getParameter("i_date");
String UBC=request.getParameter("i_ubc");
%>
<%
try
{
//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//Connection connection=DriverManager.getConnection("jdbc:odbc:db1","","");
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection connection=DriverManager.getConnection("jdbc:mysql://localhost/labacacias?user=root&password=letmein");
Statement statement=connection.createStatement();
String query;
query="SELECT referencia FROM enero";
boolean b=false;
ResultSet resultSet=statement.executeQuery(query);
while (resultSet.next())
{
if (REF.compareTo(resultSet.getString(1))==0)
{
b=true;
}
if (b)
{
out.println("Datos ya han sido adjuntados anteriormente!");
out.println("<a href=\"EneroU.jsp\">Click Aqui para Adjuntar nuevos Resultados</a>");
}
else
{
pageContext.forward("InsertE.jsp");
}
}
}
catch (Exception e)
{
//e.printStackTrace();
out.println(e.toString());
}
%>
</body>
</html>
Could you please help????
Duplicates on a JSP webpageHi Sheeyla Marrero April 18, 2011 at 9:42 PM
Hi There.. I am building a JSP web application in which I need to write data into MySQL database, but I need a code to check if data entered has not been entered before, to avoid duplicates.... This is what I have so far, but it is not working, it is writing data into the database even when I am intentionally using data already in the database.... <%@page contentType="text/html"%> <%@page pageEncoding="UTF-8"%> <html> <head><title>Create Data</title></head> <body bgcolor=#F5F5F5> <%-- <jsp:useBean id="beanInstanceName" scope="session" class="beanPackage.BeanClassName"/> --%> <%-- <jsp:getProperty name="beanInstanceName" property="propertyName"/> --%> <%@page import="java.sql.*"%> <% String REF=request.getParameter("d_ref"); String DATE=request.getParameter("i_date"); String UBC=request.getParameter("i_ubc"); %> <% try { //Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //Connection connection=DriverManager.getConnection("jdbc:odbc:db1","",""); Class.forName("com.mysql.jdbc.Driver").newInstance(); Connection connection=DriverManager.getConnection("jdbc:mysql://localhost/labacacias?user=root&password=letmein"); Statement statement=connection.createStatement(); String query; query="SELECT referencia FROM enero"; boolean b=false; ResultSet resultSet=statement.executeQuery(query); while (resultSet.next()) { if (REF.compareTo(resultSet.getString(1))==0) { b=true; } if (b) { out.println("Datos ya han sido adjuntados anteriormente!"); out.println("<a href=\"EneroU.jsp\">Click Aqui para Adjuntar nuevos Resultados</a>"); } else { pageContext.forward("InsertE.jsp"); } } } catch (Exception e) { //e.printStackTrace(); out.println(e.toString()); } %> </body> </html> Could you please help????
Duplicates on a JSP webpageHi Sheeyla Marrero April 18, 2011 at 9:42 PM
Hi There.. I am building a JSP web application in which I need to write data into MySQL database, but I need a code to check if data entered has not been entered before, to avoid duplicates.... This is what I have so far, but it is not working, it is writing data into the database even when I am intentionally using data already in the database.... <%@page contentType="text/html"%> <%@page pageEncoding="UTF-8"%> <html> <head><title>Create Data</title></head> <body bgcolor=#F5F5F5> <%-- <jsp:useBean id="beanInstanceName" scope="session" class="beanPackage.BeanClassName"/> --%> <%-- <jsp:getProperty name="beanInstanceName" property="propertyName"/> --%> <%@page import="java.sql.*"%> <% String REF=request.getParameter("d_ref"); String DATE=request.getParameter("i_date"); String UBC=request.getParameter("i_ubc"); %> <% try { //Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //Connection connection=DriverManager.getConnection("jdbc:odbc:db1","",""); Class.forName("com.mysql.jdbc.Driver").newInstance(); Connection connection=DriverManager.getConnection("jdbc:mysql://localhost/labacacias?user=root&password=letmein"); Statement statement=connection.createStatement(); String query; query="SELECT referencia FROM enero"; boolean b=false; ResultSet resultSet=statement.executeQuery(query); while (resultSet.next()) { if (REF.compareTo(resultSet.getString(1))==0) { b=true; } if (b) { out.println("Datos ya han sido adjuntados anteriormente!"); out.println("<a href=\"EneroU.jsp\">Click Aqui para Adjuntar nuevos Resultados</a>"); } else { pageContext.forward("InsertE.jsp"); } } } catch (Exception e) { //e.printStackTrace(); out.println(e.toString()); } %> </body> </html> Could you please help????
studentkarthik June 16, 2011 at 3:17 PM
no comments
JavaAnseri November 11, 2012 at 9:10 PM
this service is good.
Post your Comment