<dependency>
            <groupId>com.microsoft.sqlserver</groupId>
            <artifactId>mssql-jdbc</artifactId>
            <version>6.1.0.jre8</version>
        </dependency>

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

@SuppressWarnings("CallToPrintStackTrace")
public class ServiceJDBC {
  static String className;
  static String strUrl;
  static String userName;
  static String passWord;

  static{
    try{     
        className = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; 
        strUrl = "СЕРВЕР";
        userName = "ЮЗЕР";
        passWord = "ПАРОЛЬ";
      Class.forName(className);
    }catch(ClassNotFoundException ex){
      ex.printStackTrace();
    }
  }
  
  public Connection getConnection() throws SQLException{
    return DriverManager.getConnection(strUrl, userName, passWord);
  }
  
  public void closeConnection(Connection cnn){
    if(cnn == null) return;
    try{
      cnn.close();
    } catch (SQLException ex){
      ex.printStackTrace();
    } 
  }   
}

  public class ServiceAsset extends ServiceJDBC{
    
	  public List<AssetModel> getAppendedList(){
		List<AssetModel> list = new ArrayList<AssetModel>();
		  Connection cnn = null;
		try{
		  cnn = getConnection();
		  PreparedStatement pst = cnn.prepareStatement("SELECT * FROM ...");

		  ResultSet rst = pst.executeQuery();
		 
		  while(rst.next()){
			AssetModel am = new AssetModel();
			am.setType(rst.getString("type"));
			am.setTitle(rst.getString("title"));
			am.setLink(rst.getString("link"));
			am.setSerial(rst.getString("serial"));
			
			list.add(am);
		  }
		} catch (SQLException ex){
		  ...
		} finally {
		  super.closeConnection(cnn);
		}
		return list;
	  }
  ...
  }

        ServiceAsset sa = new ServiceAsset();
        List<AssetModel> listAssets = sa.getAppendedList();