Column Retrieval and Comparison With Last Month

package Test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;
import java.time.LocalDateTime;
import java.time.LocalTime;
import java.time.format.DateTimeFormatter;

public class TimePatterns {
	public static void main(String[] args) {
		LocalDateTime now = LocalDateTime.now();
		DateTimeFormatter dtf = DateTimeFormatter.ofPattern("MM");
		//		System.out.println(dtf.format(now));
		LocalDateTime lastMonth=now.minusMonths(1);
		//		System.out.println(dtf.format(lastMonth));
		try{
			Class.forName("oracle.jdbc.driver.OracleDriver");
			Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","hr","hr");
			Statement stmt=conn.createStatement();
			//			ResultSet rs=stmt.executeQuery("select id,totalworkhours from NEC ");

			ResultSet rs = stmt.executeQuery("SELECT * FROM attendance");
			ResultSetMetaData rsmd = rs.getMetaData();
			int count=rsmd.getColumnCount();
			//			System.out.println(count);
			while(rs.next()) {
				for(int i=4;i<=count;i++) {
					String name = rsmd.getColumnName(i);
					//			System.out.println(name.substring(7, 9));
					if(name.substring(7, 9).equals(dtf.format(lastMonth))){
						//				System.out.println("yess");
						LocalTime todaysTotal;
						String a=rs.getString(i);
						if(rs.wasNull()) {
							todaysTotal=LocalTime.parse("00:00");
						}
						else {
							todaysTotal=LocalTime.parse(rs.getString(i));
							System.out.println(todaysTotal);
						}
					}
				}
			}

		}catch(Exception e) {
			System.out.println(e);
		}

	}
}