how to check dates while retrieving data from database
i want to update database record based on delivery date i have tried this query but it wont work
b="update deliveryorder set prtnm='"+arr[1]+"',stn='"+arr[0]+"',sbston='"+arr[2]+"',tqty='"+arr1[0]+"',del1='"+arr2[1]+"',del2='"+arr2[2]+"',del3='"+arr2[3]+"',grd='"+arr2[4]+"',remrk='"+arr2[5]+"',dqty='"+arr1[1]+"',cqty='"+arr1[2]+"',bqty='"+arr1[3]+"' where dno="+k1+" and ddt="+k+"";
int exe=st.executeUpdate(b);
pls help me.....
View Answers
Ads
Related Tutorials/Questions & Answers:
how to check dates while retrieving data from database
how to
check dates while retrieving data from database i want to update
database record based on delivery date i have tried this query but it wont work
b="update deliveryorder set prtnm='"+arr[1]+"',stn='"+arr[0]+"',sbston
Advertisements
Retrieving Data from Database to fill Combo Box
Retrieving Data from Database to fill Combo Box Sir,
I have a JSP Page with a combo box and a label. I have a
database that has two fields id... displaying path that is stored in the
database but not the image itself. Kindly
Retrieving JTree structure from database
Retrieving JTree structure
from database
This example shows
how to
retrieving data from... the steps required to create tree
retrieving the
data from the
database.
Here
retrieving xml document from database
retrieving xml document
from database Hi Guys,
I want to retrieve the xml document stored in the
database on to a jsp page using jdbc/odbc connnection.Please help me in implementing this feature.
Thank You
Madhu
Retrieving specific data from excel
Retrieving specific
data from excel Hello everyone, i have written a simple code to retrieve
data from excel sheet and working fine, the excel file... first sheet
from the workbook
HSSFSheet sheet = workbook.getSheetAt(0
Retrieving the Image from a database Table
Retrieving the Image
from a
database Table
Consider a case where we want... to retrieve the
image
from the
database table. You can do it very easily after...
from the
database table our java program need to make a connection
how to get data from database into dropdownlist in jsp
how to get
data from database into dropdownlist in jsp Can anybody tell me what is the problem in this code as i am not able to fetch the
data from... tutorial go through the link JSP Get
Data Into Dropdown list
From Database
Retrieving value from multiple table in database
Retrieving value
from multiple table in database Hi fnds, I want to maintain the financial
database of 20 users for 1 year and update the details... contains the
data like name,amount,paiddate and balance of individual users... i
how to check username & password from database using jsp
how to
check username & password
from database using jsp Hello,
I....
in my oracle10G
database already contain table name admin which has name, password.
name is amit and password is ddave.
so hw could i
check whether the username
How to display data from database in a TableView
How to display
data from database in a TableView I need to populate a TableView (JavaFx) with
database items. I designed the TableView in JavaFx... at this.
The classes:
This is the Class that creates the
database data object:
import
How to show data from database in textbox in jsp
How to show
data from database in textbox in jsp
How to show
data from database in textbox in jsp
Here is an example that retrieve the particular record
from the
database and display it in textbox using JSP.
<
how to display data from jsp file into database
how to display
data from jsp file into database this is a jsp file...+",'"+email+"')");
out.println("
Data is successfully inserted into
database...(); in the below example. the error is "cannot convert
from java.sql.Statement
How to get the most recent data from the sql database
How to get the most recent
data from the sql database Hi, just wanted to show the most recent row
from the
database table...in my web page...
dates..
Now, it the web page that is going to show all the recodes but the latest