/
Nicholas
/
java_basics
Обзор
Документация
Войти
/
Nicholas
/
java_basics
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
SQLAndHibernate/src/main/java/Main.java
30 строк
1 KB
Николай Соколовский
Homework
08 ноя 2023, 18:41
08 ноя 2023, 18:41
42c2b97
Код
Авторство
О чём код?
import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; public class Main { public static void main(String[] args) { String url = "jdbc:mariadb://192.168.1.136:3306/skillbox"; String user = "test"; String pass = "tset321TSET#@!"; try (Connection connection = DriverManager.getConnection(url, user, pass)) { Statement statement = connection.createStatement(); ResultSet resultSet = statement.executeQuery ("SELECT count(*) / (month(max(pl.subscription_date)) - month(min(pl.subscription_date))) AS avgsales, " + " pl.course_name " + "FROM PurchaseList pl " + "WHERE year(pl.subscription_date) = 2018 " + "GROUP BY pl.course_name;"); while (resultSet.next()) { String courseName = resultSet.getString("course_name"); String avgSales = resultSet.getString("avgsales"); System.out.println(courseName+" - среднее значение продаж - "+avgSales); } resultSet.close(); statement.close(); } catch (Exception ex) { ex.printStackTrace(); } } }