programming error

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

Connection con=null;
ResultSet rs=null;
Statement stmt=null;

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=s.executeQuery("select OrderNo from OrderTab");
while(rs.last())
{
int Ono=Integer.parseInt(rs.getInt(1));
int No=Ono+1;
}
}
catch(SQLException se)
{out.println("Database error="+se.getMessage());
}

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

%>

<HTML>
<HEAD>
<TITLE> Place Order </TITLE>
<script type="text/javascript">
function Validate()
{
var valid=true;
if(document.forms.OrderNo.value=="")
{ alert("Please enter valid OrderNo");
valid=false;
}
if(document.forms.Name.value=="")
{ alert("Please enter valid Client's Name");
valid=false;
}
if(document.forms.Address.value=="")
{ alert("Please enter valid Client's Address");
valid=false;
}
if(document.forms.Email.value=="")
{ alert("Please enter valid Email Id");
valid=false;
}
if(document.forms.PhoneNo.value=="")
{ alert("Please enter valid PhoneNo");
valid=false;
}
return valid;
}
</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="forms" action="http://localhost:8080/ProjectAd/Orders">
<p align=center><b>Order No:   <input type=text enabled=false name="OrderNo" size=25 value<%="No"%></b>
<p align=center><b>       Name:   <input type=text name="Name" size=25 ></b>
<p align=center><b>      Address:  <textarea name="Address" rows=5 cols=25 size=25></textarea></b>
<p align=center><b>        Email:  <input type=text name="Email" size=25></b>
<p align=center><b>PhoneNo:  <input type=text name="PhoneNo" size=25></b><br><br>
<p align=center><b><input type=submit name=submit value="InsertOrder"></b>

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

I want to get the last orderno from the database and display it in the orderno textbox in jsppage and it shouldn't get edidable and this details should get inserted in the database. then how to it. please reply me.ThankYou Sir.

View Answers

January 23, 2010 at 11:45 AM

Hi Friend,

Try the following code:

<%@ page language="java" import="java.sql.*" %>
<%@ 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 Validate()
{
if(document.form.OrderNo.value=="")
{ alert("Please enter valid OrderNo");
return false;
}
if(document.form.Name.value=="")
{ alert("Please enter valid Client's Name");
return false;

}
if(document.form.Address.value=="")
{ alert("Please enter valid Client's Address");
return false;
}
if(document.form.Email.value=="")
{ alert("Please enter valid Email Id");
return false;
}
if(document.form.PhoneNo.value=="")
{ alert("Please enter valid PhoneNo");
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 name="form" method="post" action="http://localhost:8080/ProjectAd/Orders"; onsubmit="return Validate();">
<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>
<tr><td><input type=submit name=submit value="InsertOrder"></td></tr>
</table>
</center>
</form>
<hr color="green">
</BODY>
</HTML>

Thanks