Алгоритм определения информации тарификации

MySQL Community ni yuklab olish

• Yuklab olish havolasi: https://dev.mysql.com/downloads/windows/installer/8.0.html

MySQL Community ni tizimga o’rnatish bo’yich qo’llanma

• MySQL Community ni tizimga o’rnatish bo’yicha video yo’rqnomani ko’rish uchun quyidagi havolaga kiring:
• https://www.youtube.com/watch?v=7LwOvVPavWA

• MySQL Community ni tizimga o’rnagandan keyin rasmda ko’rsatilgan MySQL WorkBench 8.0 CE ishga tushiriladi.

MySQL WorkBench 8.0 CE dasturing asosiy oynasi

MySQL WorkBench 8.0 CE da Ma’lumotlar bazasi va jadval yaratish

Java.sql paketini import qilish

JDBC drayveridan foydalanish

• JDB driverni yuklab olish uchun quyidagi havolaga kiring: https://dev.mysql.com/downloads/connector/j/

JDBC ni yuklab olish sahifasi

JDBC ni Intellij IDEA ga o’rnatish

• Yuklab olingan .zip fayli arxivdan chiqariladi va Intellij IDEA ni File->Project Structure.. bo’limiga kiriladi (Ctrl+Alt+Shift+S).

Main.class tarkibi:

• package com.company; import java.sql.*; public class Main { public static void main(String[] args) { try { Connection dbConnection = DriverManager.getConnection( "jdbc:mysql://localhost:3306/java_kurs", "root", "root"); Statement statement = dbConnection.createStatement(); ResultSet resultSet = statement.executeQuery("select * from users"); while (resultSet.next()) { System.out.println(resultSet.getString("name" )); System.out.println(resultSet.getString("age" )); System.out.println(resultSet.getString("email" )); } } catch (Exception e){ e.printStackTrace(); } }}

Xulosa

• JDBC river - MySQL va SQL Server ga dasturlash tillaridan ulanishga imkon beruvchi yordamchi dastur.
• JDBC river ning MySql uchun alohida va SQL Server uchun alohida paketlari mavjud.

• E’tiboringiz uchun rahmat