Advertisement
Ansaid

DataBase

Dec 28th, 2019
185
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.32 KB | None | 0 0
  1. package com.company;
  2.  
  3. import java.sql.*;
  4. import java.util.Scanner;
  5.  
  6. public class Main {
  7.  
  8.     public static void main(String[] args) {
  9.  
  10.         try{
  11.             Class.forName("org.sqlite.JDBC");
  12.             Connection connection = DriverManager.getConnection("jdbc:sqlite:./src/base/users.db");
  13.             System.out.println("Connection");
  14.             Scanner in = new Scanner(System.in);
  15.             String name = in.nextLine();
  16.             String phone = in.nextLine();
  17.             String query =
  18.                     "INSERT INTO users (name, phone) " +
  19.                     "VALUES ('" + name + "', '" + phone + "')";
  20.  
  21.             Statement statement = connection.createStatement();
  22.             statement.executeUpdate(query);
  23.             System.out.println("Add");
  24.  
  25.             query = "SELECT * FROM users";
  26.             ResultSet resultSet = statement.executeQuery(query);
  27.             while (resultSet.next()) {
  28.                 int id = resultSet.getInt("id");
  29.                 name = resultSet.getString("name");
  30.                 phone = resultSet.getString("phone");
  31.                 System.out.println(id + "\t " + name + "\t " + phone);
  32.             }
  33.             statement.close();
  34.             connection.close();
  35.         } catch (Exception e) {
  36.             System.out.println(e.getMessage());
  37.         }
  38.     }
  39. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement