package com.shogol.core.db;

import org.javalite.activejdbc.Base;
import org.springframework.stereotype.Repository;

@Repository
public class Connection implements IConnection {

    @Override
    public void open()
    {
        Base.open("com.mysql.jdbc.Driver", "jdbc:mysql://localhost/shogol_angular", "root", "");
    }

    @Override
    public void close()
    {
        Base.close();
    }

}

package com.shogol.web.backend.controller;

import com.shogol.core.db.Connection;
import javax.annotation.PostConstruct;
import javax.annotation.PreDestroy;
import org.javalite.activejdbc.LazyList;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.*;
import org.springframework.web.bind.annotation.*;

@Controller("User")
public class User {
    
    @Autowired
    protected Connection dbConnection;

    protected int perPage = 30;

    @RequestMapping("/backend/com.shogol.web.backend.controller.User/list/page/{page}")
    @ResponseBody
    public String list(@PathVariable("page") long page)
    {

        // вот здесь возникала ошибка, что коннекта нет //////////////////////////////////////
        LazyList<com.shogol.core.model.User> users = com.shogol.core.model.User.findAll().limit(perPage).offset(perPage * page);
    
        String json = users.toJson(true);

        return json;
    }

    @PostConstruct
    public void openConnection()
    {
        dbConnection.open();
    }

    @PreDestroy
    public void closeConnection()
    {
        dbConnection.close();
    }

}

        
    @PostConstruct
    public void openConnection()
    {
        dbConnection.open();
        
        LazyList<com.shogol.core.model.User> users = com.shogol.core.model.User.findAll().limit(perPage).offset(perPage * page);
    }