Skip to content

Latest commit

 

History

History
50 lines (40 loc) · 1.12 KB

README.md

File metadata and controls

50 lines (40 loc) · 1.12 KB
Raw

"# movieTicketsSale"

Table of contents

General info

Data Base application with JDBI implementation

Technologies

  • Java - version 12
  • gson - version 2.8.4
  • maven - version 3.6
  • Mocito

Setup

download, compile and run Local instance MySQL80 localhost port 3306 root // admin

Code Examples

public List getInfo() {

    return connection.withHandle(handle ->
            handle.createQuery("select ss.id, mm.title, ss.start_date_time, mm.price, mm.genre, mm.duration, cc.name, cc.surname, cc.email " +
                    "FROM sales_stand ss JOIN movie mm " +
                    "ON ss.movie_id = mm.id " +
                    "INNER JOIN customer cc " +
                    "ON cc.id = ss.customer_id;")
                    .mapToBean(MovieWithDateTime.class)
                    .list()
    );

Features

To-do list:

  • cleanCode - optimize code
  • Junit
  • SQL
  • Json
  • Mocito
  • pretty look console

Status

Project is: in_progress