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
Related Tutorials/Questions & Answers:
how to check dates while retrieving data from databasehow 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 BoxRetrieving 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
database and
how to add the
data in to JTree.
JTree : JTree is
used
retrieving xml document from databaseretrieving 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 excelRetrieving 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 TableRetrieving 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 jsphow 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
how to check username & password from database using jsphow 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
Retrieving value from multiple table in databaseRetrieving 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 display data from database in a TableViewHow 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 databasehow 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 databaseHow 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
Retrieving data from data base using jsp combo boxRetrieving data from data base using jsp combo box Hi guys please help me , i have on GUI page int that Server type(like apache,jboss,weblogic) one... of the server it has to display the process name
from database into the process name
How To Fetch Data From Database Into JTextAreaHow To Fetch
Data From Database Into JTextArea
In this section we will read about
how to get the
data from database table
into JTextArea.... The
getOperation() method I have defined for fetching the
data from database and set
How to Retrieve data from database in jspHow to Retrieve
data from database in jsp
In this section we will discuss about
how to fetch
data from database table.
We will give a simple example which... tableName" for
retrieving the
data from database table and execute this query
selecting data from databaseselecting
data from database
how to select
data from database using Dao in struts
Hi,
You have to load the
data from database using hibernate and send the
data in a Java file object to jsp page.ADS_TO_REPLACE_1
How to get data from Oracle database using JSPHow to get
data from Oracle
database using JSP hello i have a simple problem in jsp in the sense to get
data from the
database like oracle . I have...
data from the
database like oracle), I have created one jsp program like