Searching through KeyReleased with data Diffrence and count month.


private void jTextField15KeyReleased(java.awt.event.KeyEvent evt) {                                        
    
        DateFormat dateFormat = new SimpleDateFormat("yyyy/MM/dd");
        try
        {
           Class.forName("com.mysql.jdbc.Driver");
            java.sql.Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3305/commity","root","root");
    String sql="select i.MemberName as Name,g.Group_Number as GroupName,g.Starting_Date,g.Ending_Date,g.Cost as Amount,i.Payment as Installment,i.date,i.Withdraw from insatllment i inner join group1 g on i.Group_Number=g.Group_Number\n" +
"where i.MemberName='"+jTextField15.getText()+"'";
    java.sql.PreparedStatement pst=con.prepareStatement(sql);
   DefaultTableModel tm33 = (DefaultTableModel)sark.getModel();
   // System.out.println("Naveen");
       tm33.setRowCount(0);
    ResultSet rs = pst.executeQuery(sql);
     int i=0;
  while(rs.next())
  {
Vector v2 = new Vector();
Calendar startCalendar = Calendar.getInstance();
startCalendar.setTime(rs.getDate(3));
Calendar endCalendar = Calendar.getInstance();
endCalendar.setTime(new java.sql.Date(System.currentTimeMillis()));
int diffYear = endCalendar.get(Calendar.YEAR) - startCalendar.get(Calendar.YEAR);
int diffMonth = diffYear * 12 + endCalendar.get(Calendar.MONTH) - startCalendar.get(Calendar.MONTH);
//System.out.println(""+diffMonth);
v2.addElement(rs.getString(1));
v2.addElement(rs.getString(2));
 Calendar cal = Calendar.getInstance();
cal.setTime(rs.getDate(7));
java.util.Date d = new java.util.Date(cal.getTimeInMillis());
// System.out.println("Moprivate void jTextField15KeyReleased(java.awt.event.KeyEvent evt) {                                        
    
        DateFormat dateFormat = new SimpleDateFormat("yyyy/MM/dd");
        try
        {
           Class.forName("com.mysql.jdbc.Driver");
            java.sql.Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3305/commity","root","root");
    String sql="select i.MemberName as Name,g.Group_Number as GroupName,g.Starting_Date,g.Ending_Date,g.Cost as Amount,i.Payment as Installment,i.date,i.Withdraw from insatllment i inner join group1 g on i.Group_Number=g.Group_Number\n" +
"where i.MemberName='"+jTextField15.getText()+"'";
    java.sql.PreparedStatement pst=con.prepareStatement(sql);
   DefaultTableModel tm33 = (DefaultTableModel)sark.getModel();
   // System.out.println("Naveen");
       tm33.setRowCount(0);
    ResultSet rs = pst.executeQuery(sql);
     int i=0;
  while(rs.next())
  {
Vector v2 = new Vector();
Calendar startCalendar = Calendar.getInstance();
startCalendar.setTime(rs.getDate(3));
Calendar endCalendar = Calendar.getInstance();
endCalendar.setTime(new java.sql.Date(System.currentTimeMillis()));
int diffYear = endCalendar.get(Calendar.YEAR) - startCalendar.get(Calendar.YEAR);
int diffMonth = diffYear * 12 + endCalendar.get(Calendar.MONTH) - startCalendar.get(Calendar.MONTH);
//System.out.println(""+diffMonth);
v2.addElement(rs.getString(1));
v2.addElement(rs.getString(2));
 Calendar cal = Calendar.getInstance();
cal.setTime(rs.getDate(7));
java.util.Date d = new java.util.Date(cal.getTimeInMillis());
// System.out.println("Mprivate void jTextField15KeyReleased(java.awt.event.KeyEvent evt) {                                        
    
        DateFormat dateFormat = new SimpleDateFormat("yyyy/MM/dd");
        try
        {
           Class.forName("com.mysql.jdbc.Driver");
            java.sql.Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3305/commity","root","root");
    String sql="select i.MemberName as Name,g.Group_Number as GroupName,g.Starting_Date,g.Ending_Date,g.Cost as Amount,i.Payment as Installment,i.date,i.Withdraw from insatllment i inner join group1 g on i.Group_Number=g.Group_Number\n" +
"where i.MemberName='"+jTextField15.getText()+"'";
    java.sql.PreparedStatement pst=con.prepareStatement(sql);
   DefaultTableModel tm33 = (DefaultTableModel)sark.getModel();
   // System.out.println("Naveen");
       tm33.setRowCount(0);
    ResultSet rs = pst.executeQuery(sql);
     int i=0;
  while(rs.next())
  {
Vector v2 = new Vector();
Calendar startCalendar = Calendar.getInstance();
startCalendar.setTime(rs.getDate(3));
Calendar endCalendar = Calendar.getInstance();
endCalendar.setTime(new java.sql.Date(System.currentTimeMillis()));
int diffYear = endCalendar.get(Calendar.YEAR) - startCalendar.get(Calendar.YEAR);
int diffMonth = diffYear * 12 + endCalendar.get(Calendar.MONTH) - startCalendar.get(Calendar.MONTH);
//System.out.println(""+diffMonth);
v2.addElement(rs.getString(1));
v2.addElement(rs.getString(2));
 Calendar cal = Calendar.getInstance();
cal.setTime(rs.getDate(7));
java.util.Date d = new java.util.Date(cal.getTimeInMillis());
// System.out.println("Month Name :"+new SimpleDateFormat("MMMM").format(d));
   v2.addElement(rs.getDouble(5));
   v2.addElement(rs.getDouble(6));
   v2.addElement(new SimpleDateFormat("MMMM").format(d));
   v2.addElement(rs.getString(8));
   v2.addElement(diffMonth);
  tm33.addRow(v2);
  }
con.close();
pst.close();
        }
     catch (ArrayIndexOutOfBoundsException e) {
        JOptionPane.showMessageDialog(this, "Press OK!!", "Error!", JOptionPane.ERROR_MESSAGE);
    }
        catch(Exception e)
        {
            e.printStackTrace();
            System.out.println(e);
            JOptionPane.showMessageDialog(null, e);
        }

    }onth Name :"+new SimpleDateFormat("MMMM").format(d));
   v2.addElement(rs.getDouble(5));
   v2.addElement(rs.getDouble(6));
   v2.addElement(new SimpleDateFormat("MMMM").format(d));
   v2.addElement(rs.getString(8));
   v2.addElement(diffMonth);
  tm33.addRow(v2);
  }
con.close();
pst.close();
        }
     catch (ArrayIndexOutOfBoundsException e) {
        JOptionPane.showMessageDialog(this, "Press OK!!", "Error!", JOptionPane.ERROR_MESSAGE);
    }
        catch(Exception e)
        {
            e.printStackTrace();
            System.out.println(e);
            JOptionPane.showMessageDialog(null, e);
        }

    }nth Name :"+new SimpleDateFormat("MMMM").format(d));
   v2.addElement(rs.getDouble(5));
   v2.addElement(rs.getDouble(6));
   v2.addElement(new SimpleDateFormat("MMMM").format(d));
   v2.addElement(rs.getString(8));
   v2.addElement(diffMonth);
  tm33.addRow(v2);
  }
con.close();
pst.close();
        }
     catch (ArrayIndexOutOfBoundsException e) {
        JOptionPane.showMessageDialog(this, "Press OK!!", "Error!", JOptionPane.ERROR_MESSAGE);
    }
        catch(Exception e)
        {
            e.printStackTrace();
            System.out.println(e);
            JOptionPane.showMessageDialog(null, e);
        }

    }

Popular posts from this blog

Simple Sign up design. Android.

Image
<?xml version="1.0" encoding="utf-8"?> <androidx.constraintlayout.widget.ConstraintLayout xmlns:android="http://schemas.android.com/apk/res/android"     xmlns:app="http://schemas.android.com/apk/res-auto"     xmlns:tools="http://schemas.android.com/tools"     android:layout_width="match_parent"     android:layout_height="match_parent"     app:layout_behavior="@string/appbar_scrolling_view_behavior"     tools:context=".Signup"     tools:showIn="@layout/activity_signup">     <ScrollView         android:layout_width="fill_parent"         android:layout_height="fill_parent"         android:fillViewport="true"         tools:ignore="MissingConstraints">     <LinearLayout         android:layout_width="fill_parent"         android:layout_height="fill_parent"         android:orientation="vertic
Read more

Cart page design in android.

Image
<?xml version="1.0" encoding="utf-8"?> <androidx.constraintlayout.widget.ConstraintLayout xmlns:android="http://schemas.android.com/apk/res/android"     xmlns:app="http://schemas.android.com/apk/res-auto"     xmlns:tools="http://schemas.android.com/tools"     android:layout_width="match_parent"     android:layout_height="match_parent"     app:layout_behavior="@string/appbar_scrolling_view_behavior"     tools:context=".Cart"     tools:showIn="@layout/activity_cart">     <LinearLayout         android:id="@+id/activity_cart_list"         xmlns:android="http://schemas.android.com/apk/res/android"         xmlns:tools="http://schemas.android.com/tools"         android:layout_width="match_parent"         android:layout_height="match_parent"         android:orientation="vertical"         android:weightSu
Read more

Set Date on jDateChooser and retrieve record from database.

 d5  = ((JTextField)jDateChooser1.getDateEditor().getUiComponent()).getText();         SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); Calendar c = Calendar.getInstance();         try {             c.setTime(sdf.parse(d5));         } catch (ParseException ex) {             Logger.getLogger(Commity.class.getName()).log(Level.SEVERE, null, ex);         } c.add(Calendar.MONTH, 1);  // number of days to add d5 = sdf.format(c.getTime()); System.out.println(""+d5);         try {             java.util.Date date = new SimpleDateFormat("yyyy-MM-d").parse(String.valueOf(d5));             jDateChooser1.setDate(date);                    } catch (ParseException ex) {             Logger.getLogger(Commity.class.getName()).log(Level.SEVERE, null, ex);         }         try         {     Class.forName("com.mysql.jdbc.Driver");     java.sql.Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3305/commity",
Read more