Programming Error

<%@ page language="java" import="java.sql.*" %>

<%

Connection con=null;
ResultSet rs=null;
Statement stmt=null;
int No=0;

try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:Advdsn");
stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery("select OrderNo from OrderTab ");
while(rs.next())
{
int Ono=rs.getInt(1);
No=Ono+1;
}

}
catch(SQLException se)
{out.println("Database error="+se.getMessage());
}

catch(Exception e)
{out.println("Error="+e.getMessage());
}
System.out.println(No);

%>

<HTML>
<HEAD>
<TITLE> Place Order </TITLE>
<script type="text/javascript">
function checkName(text)
{
if(isNaN(text)){ return 1;}
else{alert("Invalid Name! The only charachters accepted are A - Z and a - z");return 0;}
}
function checkPhoneNumber(num) {
if(isNaN(num)){alert("Invalid Phone Number! The only characters permitted are 0 to 9"); return 0;}
else{return 1;}
}

function Validate()
{
var name=document.form.Name;
var phone=document.form.PhoneNo;
var email=document.form.Email;
if(document.form.OrderNo.value=="")
{ alert("Please enter valid OrderNo");
return false;
}
if(name.value=="")
{ alert("Please enter valid Client's Name");
return false;

}
if (checkName(name.value)==false){
name.value="";
name.focus();
return false;
}
if(document.form.Address.value=="")
{ alert("Please enter valid Client's Address");
return false;
}
if(email.value=="")
{ alert("Please enter valid Email Id");
return false;
}
apos=email.value.indexOf("@")
dotpos=email.value.lastIndexOf(".")
if (apos<1 || dotpos-apos<2)
{
alert("Invalid Email Id")
email.value=="";
email.focus();
return false;
}

if(phone.value=="")
{ alert("Please enter valid PhoneNo");
return false;
}
if (checkPhoneNumber(phone.value)==false){
phone.value="";
phone.focus();
return false;
}
return true;
}
</script>

</HEAD>

<BODY BGCOLOR="lightblue">
<marquee behavior="alternate" scrollamount=5 scrolldelay=10>
<h1><font size=4 face="Stroustroup" color="#993355">Advertisement Management System</h1></font></marquee><br>

<hr color="green">
<form method="post" onsubmit="return Validate();" name="form" action="http://localhost:8080/ProjectAd/Orders">
<center>
<table>
<tr><td>Order No:</td><td><input type="text" disabled="true" name="OrderNo" size=25 value="<%=No%>"></td></tr>
<tr><td>Name:</td><td><input type=text name="Name" size=25 ></td></tr>
<tr><td>Address:</td><td><textarea name="Address" rows=5 cols=25 size=25></textarea></td></tr>
<tr><td>Email:</td><td><input type=text name="Email" size=25></td></tr>
<tr><td>PhoneNo:</td><td><input type=text name="PhoneNo" size=25></td></tr>
</table>
<a href="http://localhost:8080/ProjectAd/Orders"><input type=submit name=submit value="InsertOrder"></a>

<input type=reset name=reset value="Reset">

</center>
<a href="http://localhost:8080/ProjectAd/Update.jsp"><b><h4 align=center>Update Orders</h4></b></a>
<a href="http://localhost:8080/ProjectAd/Delete.jsp"><b><h4 align=center>Delete Orders</h4></b></a>
<a href="http://localhost:8080/ProjectAd/View.jsp"><b><h4 align=center>View Orders</h4></b></a>
<a href="http://localhost:8080/ProjectAd/PlaceOrd.jsp"><b><h4 align=center>Back </h4></b></a></p>
<p align=center><a href="http://localhost:8080/ProjectAd/MainPage.html"><img src="images/home_ap.jpg" height=20 width=20></a>

</form>
<hr color="green">
</BODY>
</HTML>

Jdbc code:
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;

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

int Num=Integer.parseInt(req.getParameter("OrderNo"));
String s1=req.getParameter("Name");
String s2=req.getParameter("Address");
String s3=req.getParameter("Email");
String s4=req.getParameter("PhoneNo");
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:Advdsn");
Statement s=con.createStatement();
s.execute("insert into OrderTab values('"+Num+"','"+s1+"','"+s2+"','"+s3+"','"+s4+"')");
out.println("<html><body bgcolor=\"#CCCCFF\">");
out.println("<b>1 Row Affected </b><br><br>");
//out.println("<p align=\"center\"><a href=\"http://localhost:8080/ProjectAd/Update.jsp\"><b><h4 align=center>Update Orders</h4></b></a><br><br>");
//out.println("<p align=\"center\"><a href=\"http://localhost:8080/ProjectAd/Delete.jsp\"><b><h4 align=center>Delete Orders</h4></b></a><br><br>");
//out.println("<p align=\"center\"><a href=\"http://localhost:8080/ProjectAd/ViewAllOrd\"><b><h4 align=center>View Orders</h4></b></a><br><br>");
out.println("<p align=\"center\"><a href=\"http://localhost:8080/ProjectAd/PlaceOrd.jsp\"><b><h4 align=center>BackToPlaceOrder</h4></b></a><br><br>");
out.println("</body></html>");

}
catch(SQLException se)
{
out.println("Database Error :"+se.getMessage());
}
catch(Exception e)
{
out.println("General Error :"+e.getMessage());
}
}
public void doGet(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException
{doPost(req,res);}
}

There is some error the no say 6 automatically comes from database but it does not get stored in database along with other details at no:6 in access database.
what to do??Please reply me thank you sir.

View Answers

January 25, 2010 at 12:06 PM

Hi Friend,

We have modified your jsp file.Your servlet Orders.java works fine.

<%@ page language="java" import="java.sql.*" %>
<%
Connection con=null;
ResultSet rs=null;
Statement stmt=null;
int No=0;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:access");
stmt=con.createStatement();
rs=stmt.executeQuery("select TOP 1 OrderNo from OrderTab ORDER BY OrderNo DESC");
while(rs.next())
{
int Ono=rs.getInt(1);
No=Ono+1;

}
}
catch(SQLException se)
{out.println("Database error="+se.getMessage());
}

catch(Exception e)
{out.println("Error="+e.getMessage());
}
System.out.println(No);
%>

<HTML>
<HEAD>
<TITLE> Place Order </TITLE>
<script type="text/javascript">
function checkName(text) {
if(isNaN(text)){ return 1;}
else{alert("Invalid Name! The only charachters accepted are A - Z and a - z");return 0;}
}
function checkPhoneNumber(num) {
if(isNaN(num)){alert("Invalid Phone Number! The only characters permitted are 0 to 9"); return 0;}
else{return 1;}
}

function Validate()
{
var name=document.form.Name;
var phone=document.form.PhoneNo;
var email=document.form.Email;
if(document.form.OrderNo.value=="")
{ alert("Please enter valid OrderNo");
return false;
}
if(name.value=="")
{ alert("Please enter valid Client's Name");
return false;

}
if (checkName(name.value)==false){
name.value="";
name.focus();
return false;
}
if(document.form.Address.value=="")
{ alert("Please enter valid Client's Address");
return false;
}
if(email.value=="")
{ alert("Please enter valid Email Id");
return false;
}
apos=email.value.indexOf("@")
dotpos=email.value.lastIndexOf(".")
if (apos<1 || dotpos-apos<2)
{
alert("Invalid Email Id")
email.value=="";
email.focus();
return false;
}

if(phone.value=="")
{ alert("Please enter valid PhoneNo");
return false;
}
if (checkPhoneNumber(phone.value)==false){
phone.value="";
phone.focus();
return false;
}
return true;
}
</script>
</HEAD>

<BODY BGCOLOR="lightblue">
<marquee behavior="alternate" scrollamount=5 scrolldelay=10>
<h1><font size=4 face="Stroustroup" color="#993355">Advertisement Management System</h1></font></marquee><br>

<hr color="green">

January 25, 2010 at 12:07 PM

continue....

<form name="form" method="post" action="../Orders" onsubmit="return Validate();">
<center>
<table>
<tr><td>Order No:</td><td><input type="text" disabled="true" size=25 value="<%=No%>"></td></tr>
<tr><td>Name:</td><td><input type=text name="Name" size=25 ></td></tr>
<tr><td>Address:</td><td><textarea name="Address" rows=5 cols=25 size=25></textarea></td></tr>
<tr><td>Email:</td><td><input type=text name="Email" size=25></td></tr>
<tr><td>PhoneNo:</td><td><input type=text name="PhoneNo" size=25></td></tr>
<tr><td><input type=submit name=submit value="InsertOrder"></td><td><input type=reset name=reset value="Reset"></td></tr>
<tr><td><input type=hidden name="OrderNo" value="<%=No%>"></td></tr>
</table>
<a href="http://localhost:8080/ProjectAd/Update.jsp"><b><h4 align=center>Update Orders</h4></b></a>
<a href="http://localhost:8080/ProjectAd/Delete.jsp"><b><h4 align=center>Delete Orders</h4></b></a>
<a href="http://localhost:8080/ProjectAd/View.jsp"><b><h4 align=center>View Orders</h4></b></a>
<a href="http://localhost:8080/ProjectAd/PlaceOrd.jsp"><b><h4 align=center>Back </h4></b></a></p>
<p align=center><a href="http://localhost:8080/ProjectAd/MainPage.html"><img src="images/home_ap.jpg" height=20 width=20>MainPage</a>
</center>
</form>
<hr color="green">
</BODY>
</HTML>

Thanks