java jdbc select from where with string type

Question

I am trying to solve a problem of my code. In the following code, it contains JComboBox which have a list of month. When I click on January, I want to show all the details of that month.

private void jComboBox1_MonthsActionPerformed(java.awt.event.ActionEvent evt) {   
  String selection = (String)jComboBox1_Months.getSelectedItem();
     if(selection.equals("January")){
        try{

          String sql = "select * from booking where Date = ??/01/??"; //problem
          pst = conn.prepareStatement(sql);
          rs = pst.executeQuery();
          viewBookingTable.setModel(DbUtils.resultSetToTableModel(rs));
          } catch(Exception e){

          }     
     }
}

The format for the Date is 12/01/16 in the Database with type CHAR.
Please help. Thank you very much in advance.

tmarwen · Accepted Answer · 2015-03-23 10:08:15Z

1

Even though I suggest revisiting your aprroach and favor the usage of the java.sql.Date type, you can select the desired rows using a LIKE predicate:

String sql = "SELECT * FROM booking WHERE Date LIKE '%/01/%'";

answered Mar 23, 2015 at 10:08

tmarwen

16.5k5 gold badges48 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

angeldev · Accepted Answer · 2015-03-21 17:16:55Z

0

Yo could do that:

String sql = "select * from booking where SUBSTR(Date,4,2) = "01";

answered Mar 21, 2015 at 17:16

angeldev

2,0533 gold badges20 silver badges30 bronze badges

Comments

satnam · Accepted Answer · 2015-03-21 17:20:19Z

0

int index = jComboBox1_Months.getSelectedIndex() + 1;
String sql = "SELECT * FROM `booking` WHERE `date` like '%?%';
pst = conn.prepareStatement(sql);
pst.setObject(1, index);
...

answered Mar 21, 2015 at 17:20

satnam

11.6k6 gold badges35 silver badges43 bronze badges

Collectives™ on Stack Overflow

java jdbc select from where with string type

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related