faizakram

import java.awt.image.BufferedImage;
import java.io.File;
import java.io.IOException;
import java.nio.file.DirectoryStream;
import java.nio.file.Files;
import java.nio.file.Path;
import java.nio.file.Paths;
import java.util.UUID;

import javax.imageio.ImageIO;

faizakram

package com.care.connection.careconnection;

import static org.junit.jupiter.api.Assertions.assertNotEquals;
import static org.mockito.Mockito.when;

import java.util.ArrayList;
import java.util.List;

import org.junit.jupiter.api.BeforeEach;
import org.junit.jupiter.api.Test;

faizakram

SELECT t1.name user_name, dep.name department, t1.created_on
FROM employee t1 JOIN department dep ON t1.department_id =dep.id
WHERE t1.created_on = (SELECT MAX(t2.created_on)
                 FROM employee t2
                 WHERE t2.department_id = t1.department_id);
                 
                 
-- If not exists in the child table               
SELECT p.id 
FROM project p 

faizakram

#======================== Composite Key Group By =================================
Function<UserInfo, List<Object>> compositeKey = userInfo ->
    Arrays.<Object>asList(userInfo.getName(), userInfo.getId());
Map<Object, List<UserInfo>> map = userInfos.stream().collect(Collectors.groupingBy(compositeKey, Collectors.toList()));

#===================================================

Integer arr[] = { 5, 5, 1, 2, 3, 2, 1, 1 };
List<Integer> data = Stream.of(arr).collect(Collectors.toList());
System.out.println("Move Data into List"+data);

faizakram

import java.io.File;
import java.io.OutputStream;
import java.util.ArrayList;
import java.util.List;
import java.util.zip.ZipEntry;
import java.util.zip.ZipOutputStream;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

faizakram

package test.overriding;

import java.awt.image.BufferedImage;
import java.io.File;
import java.io.IOException;
import java.nio.file.DirectoryStream;
import java.nio.file.Files;
import java.nio.file.Path;
import java.nio.file.Paths;
import java.util.UUID;

faizakram

public class RowCopy {

	public static void main(String[] args) throws Exception {
		HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream("E:/budget-1.xls"));
		HSSFSheet sheet = workbook.getSheet("Budget");
		copyRow(workbook, sheet, 5, 8);
		copyRow(workbook, sheet, 6, 9);
		FileOutputStream out = new FileOutputStream("E:/output.xls");
		workbook.write(out);
		out.close();

faizakram

package com.st.fileUplaod;

import java.io.File;

import com.amazonaws.auth.AWSStaticCredentialsProvider;
import com.amazonaws.auth.BasicAWSCredentials;
import com.amazonaws.regions.Regions;
import com.amazonaws.services.s3.AmazonS3;
import com.amazonaws.services.s3.AmazonS3ClientBuilder;
/*Add this Jar File

faizakram

import java.io.ByteArrayInputStream;
import java.io.InputStream;
import java.util.UUID;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;

import com.amazonaws.services.s3.AmazonS3;
import com.amazonaws.services.s3.model.CreateBucketRequest;
import com.amazonaws.services.s3.model.GetBucketLocationRequest;

faizakram

const mapToAoO = m => {
  return Array.from(m).map( ([k,v]) => {return {[k]:v}} );
};

JSON.stringify(mapToAoO(map));