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

Advertisements

how to make a radiobutton selected when retrieving data from database using struts framework and spring jdbc
how to make a radiobutton selected when retrieving data from database using struts framework and spring jdbc how to make a radio button selected when retrieving data from database using struts framework and spring jdbc

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

Jdbc connectivity in java to oracle for retrieving data between two dates
dates from the database table. I am using combo box to get the date. Problem is arise when i get date from data base in the format such as 10/04/2012 00:00:00...Jdbc connectivity in java to oracle for retrieving data between two dates

The code for retrieving data from database into Drop Down List.
The code for retrieving data from database into Drop Down List. <% DataSource data = new MysqlDataSource(); Connection con... to MySQL"); PreparedStatement pre = con.prepareStatement("select * from

how to retrieve data from database ?????/
how to retrieve data from database ?????/ how to retrieve data from database

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 data from database to the textbox depending upon the id in jsp
retrieving data from database to the textbox depending upon the id in jsp Hi, our project involves fetching of data from database into textbox... rs=st.executeQuery("select * from item where itemid='"+id+"'"); while(rs.next

how to retrieve data from database
how to retrieve data from database unable to retrieve data from database using mySQL by using jsp sessions and beans for editing

retrieving data in to the dropdown box from postgresql database in core java
retrieving data in to the dropdown box from postgresql database in core...=st.executeQuery("SELECT role_name from role WHERE dept_id=1234"); if(rs!=null) {while(rs.next

While retrieving text from database onto JSP, the alignment of line and paragraphs is not followed
While retrieving text from database onto JSP, the alignment of line and paragraphs is not followed I have stored text database through textarea box. While trying to retrieve the same text from db, the text displayed onto

how to display data from database in jsp
how to display data from database in jsp how to display data from database in jsp

Connecting to MySQL database and retrieving and displaying data in JSP page
Connecting to MySQL database and retrieving and displaying data in JSP page...; This tutorial shows you how to connect to MySQL database and retrieve the data from the database. In this example we will use tomcat version 4.0.3 to run our

how to use bean to retrieve data from database
how to use bean to retrieve data from database how to use bean to retrieve data from database poda sendru

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

related retrieving value from oracle database
related retrieving value from oracle database how we get the value from database in the given textbox

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

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 insert list box in java script dynamically and elements retrieving from database like oracle
how to insert list box in java script dynamically and elements retrieving from database like oracle hi all, how can i insert elements into java script list box retrieving from Database. whenever I insert any element in the Db

how to insert list box in java script dynamically and elements retrieving from database like oracle
how to insert list box in java script dynamically and elements retrieving from database like oracle Hi, how to dynamically increase size of list box in javascript when elements retrieving from database.. That is whenever I

how to get data from database into dropdownlist in jsp
how to get data from database into dropdownlist in jsp //Customer Name: <select name="name"> <% try{ Class.forName...="select * from staff"; ResultSet rs=st.executeQuery(sql); while(rs.next

how to get data from database into dropdownlist in jsp
how to get data from database into dropdownlist in jsp Customer Name...=con.createStatement(); String sql="select * from staff"; ResultSet rs=st.executeQuery(sql); while(rs.next()){ } %> <option value

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

How to delete the row from the Database by using while loop in servlet
How to delete the row from the Database by using while loop in servlet Dear Sir/Madam, I am trying to delete the one user data in the Oracle SQL.... It is Urgent... When you retrieve the data from the Database by using

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 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

Ads