Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package com.company;
- import java.sql.*;
- import java.util.Scanner;
- public class Main {
- public static void main(String[] args) {
- try{
- Class.forName("org.sqlite.JDBC");
- Connection connection = DriverManager.getConnection("jdbc:sqlite:./src/base/users.db");
- System.out.println("Connection");
- Scanner in = new Scanner(System.in);
- String name = in.nextLine();
- String phone = in.nextLine();
- String query =
- "INSERT INTO users (name, phone) " +
- "VALUES ('" + name + "', '" + phone + "')";
- Statement statement = connection.createStatement();
- statement.executeUpdate(query);
- System.out.println("Add");
- query = "SELECT * FROM users";
- ResultSet resultSet = statement.executeQuery(query);
- while (resultSet.next()) {
- int id = resultSet.getInt("id");
- name = resultSet.getString("name");
- phone = resultSet.getString("phone");
- System.out.println(id + "\t " + name + "\t " + phone);
- }
- statement.close();
- connection.close();
- } catch (Exception e) {
- System.out.println(e.getMessage());
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement