Java : How to add date in to mysql database and get back

Question

I need to add current date +7 day in to my sql database and retrieve it back how do i do that?

Calendar cal = Calendar.getInstance();
                        cal.add(Calendar.DATE, 7); // add 7 days  
                        int date = cal.get(Calendar.DATE);
                        int month = cal.get(Calendar.MONTH);
                        int year = cal.get(Calendar.YEAR);
                        String newdate = Integer.toString(date);
                        String concat = newdate.concat("-" + Integer.toString(cal.get(Calendar.MONTH)) + "-" + Integer.toString(cal.get(Calendar.YEAR)));

I found this code

java.util.Date newDate = new Date(result.getDate("VALUEDATE").getTime());

What have you tried?

Keppil
– Keppil

2012-10-17 16:51:55 +00:00
Commented Oct 17, 2012 at 16:51 — Keppil
– Keppil, Commented Oct 17, 2012 at 16:51

juergen d · Accepted Answer · 2012-10-17 16:51:32Z

1

You can do that in MySQL directly

update your_table
set date_column = date_column + interval 7 day

Doc

answered Oct 17, 2012 at 16:51

juergen d

205k40 gold badges303 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tom G · Accepted Answer · 2012-10-17 16:55:03Z

Download the Java MySql Connector library http://dev.mysql.com/downloads/connector/j/ and add the jar file to the build path.

Now you can add to your table

    Connection conn = null;
    try {
        conn =  DriverManager.getConnection("<databaseURLHere>" + "user=<usernameHere>&password=<passwordHere");
        Statement stmt = conn.createStatement();
        String uid = UUID.randomUUID().toString();
        uid = uid.replaceAll("-", "");
        uid = uid.substring(0, 16);
        if (stmt.execute("<sql query here>")) {
        //    rs = stmt.getResultSet();
        }

    } catch (SQLException ex) {
        System.out.println("SQLException: " + ex.getMessage());
        System.out.println("SQLState: " + ex.getSQLState());
        System.out.println("VendorError: " + ex.getErrorCode());
    }

Collectives™ on Stack Overflow

Java : How to add date in to mysql database and get back

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related