Abstract: The purpose of the study is to demonstrate the diversity of solutions on the issue of connecting to a database, including a description of the developed connection controller class, as well as various ways to create connection pools on a web server and application servers. The article discusses the practical issues of using JDBC technology when building a Java web application. In the examples, the presentation and business layer of the application are developed using JSP-pages and servlets, the database operates on the MySQL platform. The described methods for creating and configuring a connection pool are shown on the example of the ApacheTomcat web server and the GlassFish application server. The question of optimizing database connections in Java applications remains open, despite the diversity of solutions. The study examines and proposes methods for constructing classes of connectors, various methods for creating pool connections, and describes the results of solving problems arising from the implementation of the described techniques. A detailed classification of ways to connect to the database is given.

Abstract: The object of research is a module for accounting of supplied goods, which is part of the automated information system. The author presents a project for module implementation. The project contains a technical description of functions and features of the software implementation of accounting of supplied goods as well as the objects included in this software. The given model gives a clear view of the automated information system components that must be deployed for accounting of supplied goods using FIFO or LIFO methods. The model shows algorithms for the implementation of operations of incoming, expenditure and cancellation of the goods. The model is constructed using the CASE-tools in UML 2.1 notation and includes a data chart, use case diagram, and other diagrams, which describe the details of behavior, implementing and deploying the module. The used approach to automating the accounting of supplied goods is based on including a certain degree of redundancy in the logical database model, which allows using a more convenient mechanism of registration of supply and consumption of goods and raw materials. The proposed model provides a software client-server implementation of the different options: using a thin and thick client with a dedicated business logic layer.