Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // codigo de conexao
- Connection conexao;
- try {
- String stringConexao = "jdbc:postgresql://localhost:5432/";
- String nomeBanco = "postgres";
- String usuarioBanco = "postgres";
- String senhaBanco = "12345";
- Class.forName("org.postgresql.Driver");
- conexao = DriverManager.getConnection(stringConexao + nomeBanco,
- usuarioBanco, senhaBanco);
- //JOptionPane.showMessageDialog(null, "O bagulho pegou!");
- } catch (SQLException e) {
- JOptionPane.showMessageDialog(null, e.getMessage());
- conexao = null;
- } catch (ClassNotFoundException e) {
- JOptionPane.showMessageDialog(null, e.getMessage());
- conexao = null;
- }
- // fim codigo de conexao
- // adicionar ao banco de dados
- String sql = "INSERT INTO public.hospedes (cpf, nome) VALUES (?,?)";
- try {
- PreparedStatement stmt = conexao.prepareStatement(sql);//preparando banco de dados para receber um funcionario
- stmt.setString(1, campo_cpf.getText());
- stmt.setString(2, campo_nome.getText());
- //stmt.setString(3, ObjUsuario.cpf);
- //stmt.setString(4, ObjUsuario.telefone);
- stmt.execute();
- JOptionPane.showMessageDialog(null, "Hospede Cadastrado com sucesso!");
- } catch (SQLException ex){
- ex.printStackTrace();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement