Results 1 to 4 of 4
  1. 10-14-2009, 09:24 AM #1
    saran87
    saran87 is offline Member
    Join Date
    Jul 2009
    Location
    india
    Posts
    9
    Rep Power
    0

    Default how to populate text box value in between sql query

    this is my query..

    query="SELECT Invoiceno, InvoiceDate, TotalAmount FROM tblInvoice WHERE InvoiceDate BETWEEN AND )";
    Thanks In Advance......
    Reply With Quote Reply With Quote
  2. 10-14-2009, 09:31 AM #2
    r035198x
    r035198x is offline Senior Member
    Join Date
    Aug 2009
    Posts
    2,388
    Rep Power
    6

    Default

    By text box do you mean HTML input box or JTextfield?
    Either way read about PreparedStatement to see how to pass parameters to it.
    Reply With Quote Reply With Quote
  3. 10-14-2009, 09:34 AM #3
    saran87
    saran87 is offline Member
    Join Date
    Jul 2009
    Location
    india
    Posts
    9
    Rep Power
    0

    Default

    yes it is a html text box only....
    Reply With Quote Reply With Quote
  4. 10-14-2009, 09:40 AM #4
    RamyaSivakanth's Avatar
    RamyaSivakanth
    RamyaSivakanth is offline Senior Member
    Join Date
    Apr 2009
    Location
    Chennai
    Posts
    760
    Rep Power
    5

    Default

    u tell the requirement clearly.

    for getting inputs from html and do some db operations u should have some serverside code such as jsp/servlet.
    Ramya:cool:
    Reply With Quote Reply With Quote
« Problem calling Oracle stored procedure (bug?) | can't return a value from a method / jdbc »

Similar Threads

  1. populate jtable from jtextboxes and jcombo
    By purejoker in forum AWT / Swing
    Replies: 4
    Last Post: 12-02-2010, 09:29 AM
  2. Help Pls!! Jcombobox populate with mysql
    By kwink in forum AWT / Swing
    Replies: 1
    Last Post: 03-23-2009, 04:11 AM
  3. populate jCombobox with database data
    By joeyxaza in forum JDBC
    Replies: 1
    Last Post: 02-08-2009, 12:09 AM
  4. populate jCombobox with database data
    By joeyxaza in forum JDBC
    Replies: 0
    Last Post: 01-19-2009, 04:30 PM
  5. how to populate data in drop-down box
    By ma-la in forum JavaServer Pages (JSP) and JSTL
    Replies: 0
    Last Post: 11-01-2008, 11:24 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules