public   void  dateTest(Integer agentid)  throws  SQLException 
  {
    Connection connection =  null ;
     try  {
     connection = dataSource.getConnection();
      String sql = "UPDATE " + AGENTS_TABLE + " SET " +
          AGENT_CLOSE_DATE + "=(?) WHERE " + AGENT_ID + "=" + agentid;
      PreparedStatement pstmt = connection.prepareStatement(sql);

      java.sql.Date date = (java.sql.Date)( new  java.util.Date());

      pstmt.setDate( 1 , date);
      pstmt.executeUpdate();
      pstmt.close();

    }
     catch  (SQLException e)
    {
      e.printStackTrace();
    }
  }