How to Insert Date Month by month via JDBC (MySQL DB)

[priyanka kulathilaka]

Now my code generated other data from today to mention period. those are correctly inserted.but date inserted as same date.
need to insert month by month. because hope to make a monthly installment calculator
please help me friends..

Double installment = (totalAmount - initialInstallment) / numberOfInstallments;
        Integer installmentNo = 1;
        String dueDate = new java.util.Date().toString();
        for (int i = 1; i < numberOfInstallments; i++) {
            String sql = "insert into installments(purchase_id,installment_no,amount,due_date) values(?,?,?,?)";

            try {
                pst = conn.prepareStatement(sql);
                pst.setInt(1, maxId);
                pst.setInt(2, installmentNo);
                pst.setDouble(3, installment);
                pst.setDate(4, changeDateFormat(dueDate));
                pst.execute();

                updateJTable();

            } catch (Exception e) {
                JOptionPane.showMessageDialog(null, e);
            }

            installmentNo += 1;

            Calendar cal = new GregorianCalendar();
            cal.setTime(changeDateFormat(dueDate));
            cal.add(Calendar.DAY_OF_MONTH, 30);
            //this section i need to clarified

        }

    private java.sql.Date changeDateFormat(String notFormatted) {
        java.util.Date today = null;
        try {
            SimpleDateFormat sdf = new SimpleDateFormat("EEE MMM dd HH:mm:ss zzz yyyy");
            today = sdf.parse(notFormatted);
        } catch (Exception e) {
            JOptionPane.showMessageDialog(null, "Cannot parse date");
        }
        return new java.sql.Date(today.getTime());
    }

[T Mishra]

Are you getting any error ?

[priyanka kulathilaka]

T Mishra wrote:Are you getting any error ?

sorted it

thanks

[Campbell Ritchie]

And how did you sort it? We would like to know, because the same problem might appear in the future.

[priyanka kulathilaka]

Campbell Ritchie wrote:And how did you sort it? We would like to know, because the same problem might appear in the future.

        Double installment = (totalAmount - initialInstallment) / numberOfInstallments;
        Integer installmentNo = 1;
        java.util.Date dueDate = new java.util.Date();
        for (int i = 1; i < numberOfInstallments; i++) {
            String sql = "insert into installments(purchase_id,installment_no,amount,due_date) values(?,?,?,?)";
            try {
                pst = conn.prepareStatement(sql);
                pst.setInt(1, maxId);
                pst.setInt(2, installmentNo);
                pst.setDouble(3, installment);
                pst.setDate(4, changeDateFormat(dueDate));
                pst.execute();
                updateJTable();
            } catch (Exception e) {
                JOptionPane.showMessageDialog(null, e);
            }

            installmentNo += 1;

            Calendar cal = new GregorianCalendar();
            cal.setTime(changeDateFormat(dueDate));
            cal.add(Calendar.MONTH, 1);
            dueDate = cal.getTime();
        }