Month Filter

//global variables
String year="2018";//butangan ug default value daan
String dateMonth;
int m=0;
//sa combobox sa month
DefaultTableModel model = (DefaultTableModel) name_of_table.getModel();
Connection con=null;
Statement stat;
ResultSet res;
String month = (String) cmMonth.getSelectedItem();
if(month=="January"){
m=1;
}
//so on
dateMonth = year+"-0"+m; //the reason why gi concat nato to string ang month is mag error mana if int ang date
//query
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/self_servicedb", "root", "");
stat = con.createStatement();
String query = "SELECT * from your_tableWHERE date LIKE '" + dateMonth + "%'";
res= stat.executeQuery(query);
//display