shoping items billng source code
Hi, I am doing a project on invoice making, I am unable to make code for the billing, I have a n jsp page "invc.jsp", here in this page i need to get the items from the data base with respect to the item code, I am taking item code in a drop down list, and the item codes should be sorted by the most selected items order, I want to add two or more items for the billing, and the select items are added to the "bill.jsp" page with total amount to be payable,and the selected item quantity should be updated in the data base, so please help me in this,
<%@page import="java.util.Iterator"%>
<%@page import="java.util.List"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>;
<script type="text/javascript>
function generatenew(){
document.abc.code1.style.visibility="visible";
document.abc.type1.style.visibility="visible";
document.abc.quantity1.style.visibility="visible";
}
</script>
<%
String data1 = request.getParameter("code1");
String data2 = request.getParameter("type1");
String data3 = request.getParameter("quantity1");
%>
<form method="post" name='invcform' action="invoice.do">;
<table cellpadding='2' cellspacing='2' border="0" bgcolor="#E9E9E9" colspan="0" width="500" align="center">
<tr><td></td></tr>
<tr><td>Customer Name:</td><td><input type="text" name="name" value="" size=25></td>
<td>Number:</td><td><input type="text" name="no" value="" size=20></td></tr>;
<tr><td>Address</td><td><textarea rows="2" cols="20" name="add"></textarea></td></tr>
<tr><td><br></td></tr>
<tr><td>Item Code:</td><td><select name='code' onchange="showState(this.value)"><br>
<option value="none">Select</option>
<option value="code"></option></select> <input type="text" style="visibility:hidden" name="code1" size="10"></td></tr>
</table>
View Answers
September 10, 2012 at 4:39 PM
Here is a jsp application, where user is allowed to select the item code from the dropdown whose values have been retrieved from the database. On selecting particular item code, the name and price linked with that code will get displayed into the textboxes.
1)items.jsp:
<%@page import="java.sql.*"%>
<%@page import="java.util.*"%>
<html>
<head>
<script type="text/javascript">
function showData(){
xmlHttp=GetXmlHttpObject()
var code=document.getElementById("code").value;
var url="price.jsp";
url=url+"?code="+code;
xmlHttp.onreadystatechange=stateChanged
xmlHttp.open("GET",url,true)
xmlHttp.send(null)
}
function stateChanged(){
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete") {
var showdata = xmlHttp.responseText;
var strar = showdata.split(":");
if(strar.length>1)
{
var strname = strar[1];
document.getElementById("name").value= strar[1];
document.getElementById("price").value= strar[2];
}
}
}
function GetXmlHttpObject(){
var xmlHttp=null;
try{
xmlHttp=new XMLHttpRequest();
}
catch(e){
try{
xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
}
catch(e){
xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
}
}
return xmlHttp;
}
</script>
</head>
<body>
<select id='code' onchange="showData()">
<option value="none">Select</option>
<%
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/register","root","root");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("Select * from item");
while(rs.next()){
%>
<option value="<%=rs.getString("itemCode")%>"><%=rs.getString("itemCode")%></option>
<%
}
%>
</select>
<br>
<div id='item'>
<table>
<tr><td>Item Name:</td><td><input type="text" id="name" name="name"></td></tr>
<tr><td>Price:</td><td><input type="text" id="price" name="price"></td></tr>
</table
</div>
</body>
</html>
2)price.jsp:
<%@page language="java" import ="java.sql.*" %>
<%
String code=request.getParameter("code");
String buffer="";
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/register","root","root");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("Select * from item where code='"+code+"' ");
while(rs.next()){
buffer=":"+rs.getString("itemName")+":"+rs.getString("itemPrice");
}
out.println(buffer);
%>
Related Tutorials/Questions & Answers:
shoping items billng source codeshoping items billng source code Hi, I am doing a project on invoice making, I am unable to make
code for the billing, I have a n jsp page "invc.jsp", here in this page i need to get the
items from the data base with respect
shoping items billng source codeshoping items billng source code Hi, I am doing a project on invoice making, I am unable to make
code for the billing, I have a n jsp page "invc.jsp", here in this page i need to get the
items from the data base with respect
Advertisements
shoping items billng source codeshoping items billng source code Hi, I am doing a project on invoice making, I am unable to make
code for the billing, I have a n jsp page "invc.jsp", here in this page i need to get the
items from the data base with respect
shoping items billng source codeshoping items billng source code Hi, I am doing a project on invoice making, I am unable to make
code for the billing, I have a n jsp page "invc.jsp", here in this page i need to get the
items from the data base with respect
shoping items billng source codeshoping items billng source code Hi, I am doing a project on invoice making, I am unable to make
code for the billing, I have a n jsp page "invc.jsp", here in this page i need to get the
items from the data base with respect
Source codeSource code
source code of html to create a user login page
source codesource code sir...i need an online shopping web application on struts and jdbc....could u pls send me the
source code source codesource code sir...i need an online shopping web application on struts and jdbc....could u pls send me the
source code source codesource code hellow!i am developing a web portal in which i need to set dialy,weekly,monthly reminers so please give me
source code in jsp
source codesource code how to use nested for to print char in java language?
Hello Friend,
Try the following
code:ADS_TO_REPLACE_1
class UseNestedLoops{
public static void main(String[] args){
char[][] letters
source codesource code how to get the fields from one page to another page in struts by using JSTL
source code - JSP-Servletsource code I want
source code for Online shopping Cart... Rakesh,
I am sending a link where u will found complete
source code... of the operations such as:
Choose
Items
View Cart
View Bill
1.Choose
Items Shoping CardShoping Card Complete coding for online
shoping card
java/j2ee source codejava/j2ee
source code java/j2ee
source code for online food purchasing service with my sql database
java source codejava
source code java
source code to create mail server using struts2
source code - Swing AWTsource code
source code for a program to shutdown, restart, log off the pc after clicking jbutton on jpanel or a jframe by user.
thanks in advance
source code - JSP-Servletsource code please i want
source code for online examination project (web technologies) Hi Friend,
Send some details of your project.
Thanks
request for java source coderequest for java
source code I need
source code for graphical password using cued-click points enabled with sound signature in java and oracle 9i as soon as possible... Plz send to my mail
source code securitysource code security how to obfuscate the
code?
please answer as soon as possible
source code in jspsource code in jsp how to insert multiple images in jsp page of product catalog
source code wantedsource code wanted
""how? to" search[or]display" the particular data in MS-ACCESS database please
explain the problem and to give the
source code... data in MS-ACCESS database please explain the problem and to give the
source code source code - JSP-Servletsource code for webcam chat application I want
source code for this webcam chat application. I like the concept of XAWARE ORG regarding web cam chat. So that i want the
code through this XAWARE only.pls send the
code as soon
Java Source codeJava
Source Code for text chat application using jsp and servlets
Code for text chat application using jsp and servlets
source code - JDBCsource code give me a
source code to connect from java to mysql that can run on eclipsed
i am using mysql-essential-5.0.41-win32_1. also give procedure how can i connect from eclipsed to mysql-essential-5.0.41-win32_1.
thanks
source code - JSP-Servletsource code i need
source code for client server application in jsp to access multiple clients Hi Friend,
Please visit the following link:
http://www.roseindia.net/jsp/
Here you will get lot of examples
Project source codeProject
source code i want
source code for contact finder just like facebook provides or linkedin website on der home page just similar to dat...i m working on jsp project ..its a web based project which stores information
source code - EJB-of-StatelessBean.shtml", it is written that "The
source code for CalculatorBean is in ?net...
Simply u download the complete
source code from download link...
source code
I am new to EJB. I am reading tutorial from http
reg : the want of source codereg : the want of
source code Front End -JAVA
Back End - MS Access
Hello Sir, I want College Student Admission Project in Java with
Source code...) Available Seats
and etc.
plz Give Me Full
Source code with Database
source code in jspsource code in jsp sir...i need the
code for inserting images into the product catalog page and
code to display it to the customers when they login to site..pls help me
source code - JSP-Servletsource code i want
source code for my project online examination it includes two modules user and administrator so if user want to write exam first he register his details and then select the topics on which he want to write
source code - JSP-Servletsource code i want
source code for my project online examination it includes two modules user and administrator so if user want to write exam first he register his details and then select the topics on which he want to write
source code of javasource code of java how to create an application using applets is front end and back end is sqlwith jdbc application is enter the student details and teaching & non teaching staff details and front end is enter in internet
Source Code - Java BeginnersSource Code How to clear screen on command line coding like cls in DOS? Hi Friend,
Here is the
code to execute cls command of DOS through the java file but only one restriction is that it will execute
source code - Java Beginnerssource code Hi...i`m new in java..please help me to
write program that stores the following numbers in an array named price:
9.92, 6.32, 12,63... message dialog box. Hi Friend,
Try the following
code:
import
Source code of a website in HL and JSP.Source code of a website in HL and JSP. I want the
source code of a website of 10 pages with database connectivity.
Source code should be in HTML and JSP. Thanks
Need source code - Swing AWTNeed
source code Hai,
I need a
source code for developing the project, title is "Face Recognition" and the backend as My-sql....
Thanks & Regards
attendance management system source codeattendance management system
source code sir i want full ateendance management project please send me
source code i am asking so many members... answer so please send
code it's very urgent
java source code - Java Beginnersjava
source code I have written a
source code for recording invoices. I wish it to be evaluated. Could somebody help me with it?
Moreover, I do not know the method to attach the JAR for evaluation. My email
source code program - Java Beginnerssource code program I need the
source code for a program that converts temperatures from celsius to fahrenheit and vice versa, as well as converting kilometers to miles and vice versa using Java "classes". Hi
attendance management project source codeattendance management project
source code sir i want full ateendance management project please send me
source code i am asking so many members... answer so please send
code it's very urgent
attendance management project source codeattendance management project
source code sir i want full ateendance management project please send me
source code i am asking so many members... answer so please send
code it's very urgent
Need source code - Swing AWTNeed
source code Hai,
I need a idea and
code for developing the project "Face Recognition" with the backend as My-sql....
Thanks & Regards
Source Code cls - Java BeginnersSource Code cls Dear RoseIndia Team,
Thanks for your prompt reply to my question about alternate to cls of dos on command line
source code.
I have two submissions.
1. Instead of three lines if we simply write
Need Java Source Code - JDBCNeed Java
Source Code I have a textfield for EmployeeId in which the Id, for eg: "E001" has to be generated automatically when ever i click... be implemented. Hi friend,
Please send me
code because your posted