Programming Error

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

public class UpdateOrd extends HttpServlet
{

public void doPost(HttpServletRequest req,
HttpServletResponse res) throws ServletException,
IOException
{
res.setContentType("text/html");
PrintWriter out=res.getWriter();

int OrderNo2=Integer.parseInt(req.getParameter("OrderNo1"));
String Date2=req.getParameter("Date1");
String Month2=req.getParameter("Month1");
String Year2=req.getParameter("Year1");
String Desig2=req.getParameter("Desig1");
String Qualify2=req.getParameter("Qualify1");
String Status2=req.getParameter("Status1");
String Name2=req.getParameter("Name1");
String Address2=req.getParameter("Address1");
String Email2=req.getParameter("Email1");
String PhoneNo2=req.getParameter("PhoneNo1");
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:Advdsn");
Statement s=con.createStatement();
int x=s.executeUpdate("Update OrderTab set Date='"+Date2+"', Month='"+Month2+"', Year='"+Year2+"', Designation='"+Desig2+"', Qualification='"+Qualify2+"', Status='"+Status2+"', Name='"+Name2+"', Address='"+Address2+"', Email='"+Email2+"', PhoneNo='"+PhoneNo2+"' where OrderNo='"+OrderNo2+"'");

if(x>0)
{
out.println("<html><body bgcolor=\"lightblue\">");
out.println("<b><h1>Your order has been Updated</h1></b><br><br>");}
else

out.println("<b><h1>Sorry your order has Not been Updated</h1></b><br><br>");
out.println("<a href=\"http://localhost:8080/ProjectAd/ViewAllOrd\"><b>View<b></a><br><br>");
out.println("<a href=\"http://localhost:8080/ProjectAd/Update.jsp\">Back</a><br><br>");
out.println("<a href=\"http://localhost:8080/ProjectAd/PlaceOrd.jsp\">BackToPlaceOrder</a>");
out.println("</body></html>");

}
catch(SQLException se)
{
out.println(se.getMessage());
}
catch(Exception e)
{
out.println(e.toString());
}
}
public void doGet(HttpServletRequest req,
HttpServletResponse res) throws ServletException,
IOException
{doPost(req,res);}
}

Database Fields are:
OrderNo=Primary Key
Date
Month
Year
Designation
Qualification
Status=Open,Closed,Cancelled,Working
Name
Address
Email
PhoneNo

There some problem in update statement its not getting updated what to do ??
And i want to validate phone number field in which i can add only 8 digits or 10 digits only then how to validate??
Please reply me??
Thankyou Sir .

View Answers

February 2, 2010 at 2:54 PM

Hi Friend,

1) Change your field name Date to Day as it contradicts and try the following code:

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

public class UpdOrders extends HttpServlet{

public void doPost(HttpServletRequest req,HttpServletResponse res) throws ServletException,IOException{
res.setContentType("text/html");
PrintWriter out=res.getWriter();
String OrderNo2=req.getParameter("OrderNo1");
String Date2=req.getParameter("Date1");
String Month2=req.getParameter("Month1");
String Year2=req.getParameter("Year1");
String Desig2=req.getParameter("Desig1");
String Qualify2=req.getParameter("Qualify1");
String Status2=req.getParameter("Status1");
String Name2=req.getParameter("Name1");
String Address2=req.getParameter("Address1");
String Email2=req.getParameter("Email1");
String PhoneNo2=req.getParameter("PhoneNo1");
int ono=Integer.parseInt(OrderNo2);
int date=Integer.parseInt(Date2);
int month=Integer.parseInt(Month2);
int year=Integer.parseInt(Year2);
int no=Integer.parseInt(PhoneNo2);
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:access");
Statement s=con.createStatement();
int x=s.executeUpdate("update OrderTab set Day="+date+",Month="+month+",Year="+year+", Designation='"+Desig2+"', Qualification='"+Qualify2+"', Status='"+Status2+"', Name='"+Name2+"', Address='"+Address2+"', Email='"+Email2+"', PhoneNo="+no+" where OrderNo="+ono+"");

if(x>0)
{
out.println("<html><body bgcolor=\"lightblue\">");
out.println("<b><h1>Your order has been Updated</h1></b><br><br>");}
else{

out.println("<b><h1>Sorry your order has Not been Updated</h1></b><br><br>");
out.println("<a href=\"http://localhost:8080/ProjectAd/ViewAllOrd\"><b>View<b></a><br><br>";);
out.println("<a href=\"http://localhost:8080/ProjectAd/Update.jsp\">Back</a><br><br>";);
out.println("<a href=\"http://localhost:8080/ProjectAd/PlaceOrd.jsp\">BackToPlaceOrder</a>";);
out.println("</body></html>");
}
}
catch(Exception se)
{
out.println(se);
System.out.println(se);
}

}
public void doGet(HttpServletRequest req,
HttpServletResponse res) throws ServletException,
IOException
{doPost(req,res);}
}

2)Phone Number Validation:

<script>
function checkPhoneNo(num){
if(isNaN(num)){alert("Invalid Phone Number. The only characters permitted are 0 to 9"); return 0;}
else{return 1;}
}
function validate(){
var pno=document.form.PhoneNo1;
if ((pno.value==null)||(pno.value=="")){
alert("Please Enter your Phone Number")
pno.focus()
return false;
}
if (checkPhoneNo(pno.value)==false){
pno.value=""
pno.focus()
return false;
}
if ((pno.value.length==8)||(pno.value.length==10)){

return true;
}
else{
alert("Phone Number must be of 8 numbers or 10 numbers");
return false;
}
return true;
}
</script>
Thanks