programming error

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:&nbsp;&nbsp;&nbsp;<input type=text enabled=false name="OrderNo" size=25 value<%="No"%></b>
<p align=center><b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Name:&nbsp;&nbsp;&nbsp;<input type=text name="Name" size=25 ></b>
<p align=center><b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Address:&nbsp;&nbsp;<textarea name="Address" rows=5 cols=25 size=25></textarea></b>
<p align=center><b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Email:&nbsp;&nbsp;<input type=text name="Email" size=25></b>
<p align=center><b>PhoneNo:&nbsp;&nbsp;<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









Related Tutorials/Questions & Answers:
programming error
programming error  I got an error when i did the following program the prg. is to "select the name from database when the age is given for the respective name" error i got is:SQL exception please give me the solution by providing
error at programming
error at programming  import javax.servlet.http.*; import javax.servlet.*; import java.io.*; import java.sql.*; public class Login extends HttpServlet { public void doPost(HttpServletRequest req,HttpServletResponse res
Advertisements
error at programming
error at programming  import javax.servlet.http.*; import javax.servlet.*; import java.io.*; import java.sql.*; public class Login extends HttpServlet { public void doPost(HttpServletRequest req,HttpServletResponse res
error at programming
error at programming  import javax.servlet.http.*; import javax.servlet.*; import java.io.*; import java.sql.*; public class Login extends HttpServlet { public void doPost(HttpServletRequest req,HttpServletResponse res
error at programming
error at programming  import javax.servlet.http.*; import javax.servlet.*; import java.io.*; import java.sql.*; public class Login extends HttpServlet { public void doPost(HttpServletRequest req,HttpServletResponse res
error at programming
error at programming  import javax.servlet.http.*; import javax.servlet.*; import java.io.*; import java.sql.*; public class Login extends HttpServlet { public void doPost(HttpServletRequest req,HttpServletResponse res
error at programming
error at programming  import javax.servlet.http.*; import javax.servlet.*; import java.io.*; import java.sql.*; public class Login extends HttpServlet { public void doPost(HttpServletRequest req,HttpServletResponse res
error at programming
error at programming  import javax.servlet.http.*; import javax.servlet.*; import java.io.*; import java.sql.*; public class Login extends HttpServlet { public void doPost(HttpServletRequest req,HttpServletResponse res
error at programming
error at programming  import javax.servlet.http.*; import javax.servlet.*; import java.io.*; import java.sql.*; public class Login extends HttpServlet { public void doPost(HttpServletRequest req,HttpServletResponse res
error at programming
error at programming  <p>import javax.servlet.http.*; import javax.servlet.*; import java.io.*; import java.sql.*;</p> <p>public class Login extends HttpServlet { public void doPost(HttpServletRequest
Programming Error - JSP-Servlet
Programming Error  Hello Sir, how to convert a txt written in textarea of html must get converted to integers and should get displayed... integer.parseInt but its giving error. Please Reply me . Thank you
Programming Error - JSP-Servlet
Programming Error   Place Ad function funct(){ if(document.form.DraftAd.value=="" || document.form.DraftAd.value==null... ??? And when i tried its giving me error than cannot find variable.In
Programming Error - JSP-Servlet
Programming Error  Hello Sir, import java.util.*; import...(); } } }//End of class m geeting error in this can u please tell me whats the error nd how to solve
Programming error - JDBC
Programming error  import javax.servlet.*; import...) { out.println("Database Error :"+se.getMessage()); } catch(Exception e) { out.println(e.toString()); } } } Please reply me the error in this program because i
programming error - Java Beginners
programming error  how can we statically implement linked list????????  Hi Friend, Please visit the following links: http://www.roseindia.net/java/jdk6/LinkedListExample.shtml http://www.roseindia.net/java
Programming error - JSP-Servlet
Programming error  Actually there is an error in placeorder.jsp file where there are 5 fields OrderNo ,Name , Address, Email, PhoneNo where if I delete an order of client based on orderno then suppose in database if there are 5
Programming Error - JSP-Servlet
Programming Error   Place Order function checkName...(""); } catch(SQLException se) { out.println("Database Error :"+se.getMessage()); } catch(Exception e) { out.println("General Error :"+e.getMessage
Programming error - JSP-Servlet
Programming error  Register.jsp Registration..."); } catch(SQLException se) { out.println("Database Error :"+se.getMessage()); } catch(Exception e) { out.println("General Error :"+e.getMessage()); } %>
programming error - Java Beginners
programming error  import java.io.*; import javax.servlet.*; import javax.servlet.http.*; import java.sql.*; public class Place_Ad extends...(SQLException se) { out.println("Database Error :"+se.getMessage()); } catch(Exception e
programming error - Java Beginners
programming error  What is error in this page and how to use RequestDispatcher in servlet to validate it please do reply?? import javax.servlet.*; import javax.servlet.http.*; import java.io.*; import java.sql.*; import
Programming error - JSP-Servlet
Programming error   --%> Place Order function Validate() { var valid=true; if(document.forms.OrderNo.value=="") { alert... where if @ is not given or (dot). is not given etc then it should display error
Programming error - JSP-Servlet
Programming error  Hello Sir, Can u please reply me the code for javamail please actually i watch the javamail.net but i dint understood it. Actually i want to send a mail to my clients with a small text message. Please
Programming Error - JSP-Servlet
Programming Error  Image: I want that when user clicks on browse button then a folder of images should get open and when user clicks one image from it (only one not more than that)then it should get displayed on next page
Programming Error - JSP-Servlet
Programming Error   Place Ad function funct(){ if(document.form.DraftAd.value=="" || document.form.DraftAd.value==null) { document.form.cnt.value=0;} else {document.form.cnt.value
Programming Error - JSP-Servlet
Programming Error   Payment Advertisement Management System Payment Premium Position FrontPage BackPage Other Premium Pages Page 2 Page 3 Page 5 Page 7 Total Cost: How to use switch
Programming Error - JSP-Servlet
Programming Error  Image: Browse When user clicks on Browse Button then a folder of images should get open and when user clicks one of them then the path of that should get saved in Access Database and on next page
Programming error - JSP-Servlet
Programming error   Payment Advertisement Management System Payment Premium Position FrontPage BackPage Other Premium Pages Page 2 Page 3 Page 5 Page 7 Total Cost: I want that the no of characters
Programming Error - JSP-Servlet
Programming Error   function Draft() { if(document.form.Count.value==""||document.form.Count.value==null) document.form.Count.value=0; else document.form.Count.value = document.form.DraftAd.value.split(' ').length
Programming Error - JSP-Servlet
Programming Error  How to validate login page using jsp where it checks for username whether it is empty or not or is it including number or not if it is the paste alert message.   Hi Friend, Try the following
Programming Error - JSP-Servlet
Programming Error   Place Ad Advertisement Management System Create Ad State: City: Main Category: Sub Category: Title: Draft Your Ad Here
Programming Error - JSP-Servlet
Programming Error  Ya States and cities and maincategory and subcategory are combobox and maincategory contains suppose matrimonial then sub category will contain groom and bride, if main category contains vehicals then sub
Programming Error - JSP-Servlet
Programming Error   MainPage body { font-family:arial,helvitica,serif; color:purple; background-color:#717D7D; } ul { list-style-type:none; margin:0; padding:4px; } li { list-style-type:none; padding
Programming Error - JSP-Servlet
Programming Error  Domain Table:-- Rfcdkey DomainName DomainValue DepDomainValue Statcd 1 StateCd Maharashtra Mumbai A 2 StateCd Maharashtra Pune A 3 StateCd Maharashtra Nashik A 4
Programming Error - JSP-Servlet
Programming Error  Place.jsp function func(){ var filename = document.form.img.value; var st=document.form.State.value; var ci=document.form.City.value; var main=document.form.mainCat.value; var sub
Programming error - JSP-Servlet
Programming error   Place Order 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
programming error - JSP-Servlet
programming error   Place Order function Validate() { var valid=true; if(document.forms.OrderNo.value=="") { alert("Please enter valid OrderNo"); valid=false; } if(document.forms.Name.value
Programming Error - JSP-Servlet
Programming Error   Place Ad Advertisement Management System State: City: Main Category: Sub Category: Title: Draft Your Ad Here: Count: Image Another Image Email: Phone No: Select Newspaper
Programming Error - JSP-Servlet
Programming Error  import java.util.*; import javax.mail.*; import javax.mail.internet.*; public class SendMail { public static void main(String args[]) throws Exception { String host = "192.168.10.205
Programming Error - JSP-Servlet
Programming Error   Place Ad function func() { var filename = document.form.img.value; window.location.href=("http://localhost:8080/ProjectAd/Preview? filename="+filename); } function Draft
Programming error - Java Beginners
Programming error  import javax.servlet.RequestDispatcher; import javax.servlet.*; import javax.servlet.http.*; import java.io.*; public class ModuleServlet extends HttpServlet { public void doGet(HttpServletRequest
Programming error - JSP-Servlet
Programming error  Place.jsp code function func(){ var filename = document.form.img.value; var st=document.form.State.value; var ci=document.form.City.value; var main=document.form.mainCat.value; var sub
Programming Error - JSP-Servlet
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
Programming
Programming  Given a number n, write a programming to determine its square root if it is possible, in the contraly case print an appropriate massege on the screen
programming
Java Constructor programming for single and double constructor  write a program which have no argument constructor ,single parameter constructor constructor,double parameter constor,and the now when we create a object
error
error  while iam compiling iam getting expected error
Error-
Error-   Hello, I would like to know about XSD file. I try to print XML file but I am getting error SAXException-- says Content is not allowed in prolog. Please help me
error
error  i have 404 error in my program plz tell me yhe solution about
error
error  i have 404 error in my program plz tell me yhe solution about
error
/ServletUserEnquiryForm.shtml getting an error given below SQLException caught: [Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error please suggest
Error
Error  I have created ajax with php for state and city. When I change state then city will not come in dropdown list and it give me error as 'Unknown Runtime Error'. This error come only in IE browser, but in other brower

Ads