sql query to get date from jdatechooser:

Asked Sep 19 '17 at 06:52

Active Sep 19 '17 at 09:00

Viewed 414 times

Help me: i am trying to populate data from sql database with the selected date from jdatechooser only i.e showing data from database of date 2017-08-30 only.

Here is the code:

public void actionPerformed(ActionEvent e)
{
    try
    { 
        Date date = jDate.getDate();
        String query = " Select *from Transactions WHERE Month(transaction_date) =  Month('"+date+"')  ";
        PreparedStatement pst = con.prepareStatement(query);
        //pst.setDate(1,sqlchooser);             CONVERT(char(10), transaction_date  ,126)=CONVERT(char(10), getdate(),126);";
        ResultSet rs = pst.executeQuery();
        table.setModel(DbUtils.resultSetToTableModel(rs));
    }
    catch (Exception e1){
        e1.printStackTrace();
    }           
}

Error:

java.lang.NullPointerException

edited Sep 19 '17 at 07:52

Zsmaster

1,549
4
19
28

asked Sep 19 '17 at 06:52

Amna Doll

where is your code? – Raju Sharma Sep 19 '17 at 06:52
I have updated code in question sir kindly review – Amna Doll Sep 19 '17 at 06:59
what does `Month(transaction_date) '"+date+"'` mean? i don't any thing similair before – Youcef LAIDANI Sep 19 '17 at 07:06
it will compar month part only check again i updated sorry previous one was not right – Amna Doll Sep 19 '17 at 07:13
so what is the problem now? – Youcef LAIDANI Sep 19 '17 at 07:14
Do you get any error on above code? please update that too, so we can find where you are facing problem. – Raju Sharma Sep 19 '17 at 07:16
it shows null pointer exception: error – Amna Doll Sep 19 '17 at 07:17
Please [edit](https://stackoverflow.com/posts/46292039/edit) your [original question](https://stackoverflow.com/q/46292039/230513) to include a [mcve] that exhibits the problem you describe. – trashgod Sep 19 '17 at 09:01
Please learn how to properly use a `PreparedStatement` – Sep 19 '17 at 09:05

sql query to get date from jdatechooser:

0 Answers0