Query for Retrieve record through month.

SELECT * FROM insatllment WHERE MONTH(Date) = 01

Month(Column_Name)
1-Column_Name is column name of Table.

Popular posts from this blog

Item State change of JComboBox and Get values from database and show Data on JTable.

 try     {     Class.forName("com.mysql.jdbc.Driver");     java.sql.Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3305/supplimentry","root","root");     String sql="select * from inventory where Brand_Name='"+jComboBox3.getSelectedItem().toString()+"'";     java.sql.PreparedStatement pst=con.prepareStatement(sql);     DefaultTableModel tm33 = (DefaultTableModel)list1.getModel();     tm33.setRowCount(0);  TableColumn col = new TableColumn(tm33.getColumnCount());  JTableHeader header = list1.getTableHeader();   header.setBackground(Color.yellow);        ResultSet rs = pst.executeQuery(sql);     int i=0;     while(rs.next())     {     Vector v2 = new Vector();     v2.addElement(rs.getString(1));     v2.addEle...
Read more

Kotlin Coroutines

  Coroutines are lightweight threads. By lightweight,   it means that creating coroutines doesn’t allocate new threads. Instead, they use predefined thread pools and smart scheduling for the purpose of which task to execute next and which tasks later . Coroutines are basically of two types: Stackless Stackful Stackless coroutines,  it means that the coroutines don’t have their own stack, so they don’t map on the native thread. Kotlin Coroutines Features. Lightweight- One can run many coroutines on a single thread due to support for suspension, which doesn’t block the thread where the coroutine is running. Suspending frees memory over blocking while supporting multiple concurrent operations. Built-in cancellation support : Cancellation is generated automatically through the running coroutine hierarchy. Fewer memory leaks : It uses structured concurrency to run operations within a scope. Jetpack integration : Many Jetpack libraries include extensions that provide full corou...
Read more