doubts in setDate(i,date,cal) API of preparedStatement

[Vinney Shanmugam]

	cal = Calendar.getInstance();
	String date = "1999-05-05";
	dateVal = dateVal.valueOf(date);

		pstmt =con.prepareStatement("insert into senthilcat.senthilsch.test_date values (?)");
		pstmt.setDate(1,dateVal, cal);
		pstmt.executeUpdate();
		System.out.println("Date inserting into DB is :"+dateVal);

This is code should insert date = 1999-05-05 to the table in the database or the current date, when the this program is executed?
I am not clear about how the code for setDate(1,date,cal) is implemented. How significantly, the calendar object helps in setting date?

[ujjwal soni]

What error are you getting ?

Check out my code below

/**
 * Author Ujjwal B Soni
 * Code Added : 29th December 2008
 * Last Modified 31st July 2009
 */

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

public class DemoPreparedStatementSetDate {
  public static java.sql.Date getCurrentJavaSqlDate() {
    java.util.Date today = new java.util.Date();
    return new java.sql.Date(today.getTime());
  }

  public static Connection getConnection() throws Exception {
    String driver = "org.gjt.mm.mysql.Driver";
    String url = "jdbc:mysql://localhost/databaseName";
    String username = "root";
    String password = "root";
    Class.forName(driver);
    Connection conn = DriverManager.getConnection(url, username, password);
    return conn;
  }

  public static void main(String[] args) throws Exception {
    Connection conn = null;
    PreparedStatement pstmt = null;
    try {
      conn = getConnection();
      String query = "insert into date_table(id, date_column) values(?, ?)";
      pstmt = conn.prepareStatement(query);
      pstmt.setString(1, "0001");
      java.sql.Date date = getCurrentJavaSqlDate();
      pstmt.setDate(2, date);

      // execute query, and return number of rows created
      int rowCount = pstmt.executeUpdate();
      System.out.println("rowCount=" + rowCount);
    } finally {
      pstmt.close();
      conn.close();
    }
  }
}

[Vinney Shanmugam]

Hi ujjwal.... thanks for the reply. But, my doubt is on setDate(1,date,calendar) and your program is about setDate(1,date), which i am not interested in.

If you could please explain me about setDate(1,date,cal) API.... thanks a lot for the reply though.....!

[Jeanne Boyarsky]

explorer vinney wrote:How significantly, the calendar object helps in setting date?

It's for the time zone. In your example, it's not much use for two reasons:
1) There isn't a time
2) The date and calendar refer to the same object