Is it possible to store user inputs by the Scanner Class in a database?

Question

I have an application made in Java, and I need to store the user’s registration information in the database:

Cpf, password, name, address, telephone

System.out.println("Digite seu CPF");
cpf = ler.nextLine();           

System.out.println("Senha: ");
senha = ler.nextLine();

System.out.print("Nome Completo: ");
nome = ler.nextLine();

System.out.print("Endereço: ");
endereco = ler.nextLine();

System.out.print("Telefone: ");
telefone = ler.nextInt();

I want to get this data through the Scanner class and save to the database.

To manage the database I am using Postgressql, and the IDE for the application is Eclipse.

I’ve already connected the database to Eclipse through JDBC, but I don’t know how to get user inputs and store them in the database using the Java Scanner Class. I searched the internet and the only tutorials I find is using Jframe and the IDE is Netbeans.

//Conexão do eclipse com o postgresql


import java.sql.*;
public class ConexaoSQL {

    //Statement = Realizar pesquisa no banco de dados
    public Statement stm;
    //ResulSet = Armazenar o resultado da pesquisa
    public ResultSet rs;

    //Driver = identifica no serviço do banco de dados
    private String driver = "org.postgresql.Driver";;

    //Caminho = Indica qual o diretório do banco de dados
    private String caminho = "jdbc:postgresql://localhost:5432/agencia";;

    /*
     Usuário: postgres
     Senha: admin
     */
    private String usuario = "postgres";;
    private String senha = "admin";;

    //Conection = Realizar a Conexão com banco de Dados
    public Connection con;

    public void conexao(){ //conecta ao banco de dados
        System.setProperty("jdbc.Drivers", driver);
        try {
            con=DriverManager.getConnection(caminho, usuario, senha);
            System.out.println("Conectado com Sucesso ao SQL!");
        } catch (SQLException e) {
            System.err.println("Erro de conexão ao SQL");
            e.printStackTrace();
        }
    }
    public void desconecta(){//desconecta do banco de dados
        try {
            con.close();
            System.out.println("Desconectado com Sucesso!");
        } catch (SQLException e) {
            System.err.println("Erro ao fechar conexão com banco de dados");
            e.printStackTrace();
        }

    }
}

Could someone help me or send me a tutorial that has something similar? Thanks for any help.

      Table PostGreSQL

Answer 1

If you already have all the correct information in the variables (If no inconvenience occurred using the Scanner object) then you can save in the database using an object PreparedStatement

I’d be more or less like this:

//...
ConexaoSQL conexao = new ConexaoSQL();
conexao.conexao();
Connection = conexao.con;
PreparedStatement statement = null;
StringBuilder sb = new StringBuilder();
try{
   sb.append("insert into Cliente values (?, ?, ?, ?, ?)");
   statement = con.preparedStatement(sb.toString());
   statement.setString(1, cpf);
   statement.setString(2, senha);
   statement.setString(3, nome);
   statement.setString(4, endereco);
   statement.setString(5, telefone);
   statement.execute();
   con.commit();
}catch(Exception e){
   System.out.println("Alguma exceção ocorreu" + e.toString());
}

It is necessary you adjust according to your requirements. But basically you use an object of PreparedStatement to insert this data into your table. Note that I used String in all fields, but if the data type of your field is different, you should adjust according to the database data type.

Any questions, I’m available.

Answer 2

You can create an object of the User type and fill it with the information that comes from Scanner, can be in the constructor of the user class itself or by the methods set class. And then create a method to insert into the database by passing this object as a method parameter.

Ex:

public void inserirUsuario(Usuario usuario){
 //código para inserir no banco, tem vários exemplo de insert na internet
}