com.scoretracker.service.ScoreTrackerServiceImpl.java Source code

Introduction

Here is the source code for com.scoretracker.service.ScoreTrackerServiceImpl.java

Source

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package com.scoretracker.service;

import com.scoretracker.model.Klas;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;
import javax.ejb.Stateless;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.Query;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

/**
 *
 * @author Sander
 */
@Stateless
public class ScoreTrackerServiceImpl implements ScoreTrackerService {

    @PersistenceContext
    private EntityManager em;

    public ArrayList<String> getExcel() {
        ArrayList<String> lijst = new ArrayList<String>();
        try {

            FileInputStream fileInputStream = new FileInputStream("C:\\poi-test.xls");
            HSSFWorkbook workbook = new HSSFWorkbook(fileInputStream);
            HSSFSheet worksheet = workbook.getSheet("POI Worksheet");
            HSSFRow row1 = worksheet.getRow(0);
            HSSFCell cellA1 = row1.getCell((short) 0);
            String a1Val = cellA1.getStringCellValue();
            HSSFCell cellB1 = row1.getCell((short) 1);
            String b1Val = cellB1.getStringCellValue();
            HSSFCell cellC1 = row1.getCell((short) 2);
            String c1Val = cellC1.getStringCellValue();
            HSSFCell cellD1 = row1.getCell((short) 3);
            String d1Val = cellD1.getStringCellValue();

            lijst.add(a1Val);
            lijst.add(b1Val);
            lijst.add(c1Val);
            lijst.add(d1Val);

        } catch (FileNotFoundException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }
        return lijst;
    }

    public ArrayList<Klas> getKlassen() {
        Query q = em.createQuery("SELECT k FROM Klas k");
        return (ArrayList<Klas>) q.getResultList();
    }

}