Inserting values from java GUI into postgresql data base

Question

I am having problems inserting data into a postgres table created using java. The created table part of the code works fine, its only when I am inserting values into the table that nothing happens. The code I am using to populate the table tt is:

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                         
      String txt1 = jTextField1.getText();
      int number = Integer.parseInt(txt1);
      String name= jTextField2.getText(); 
      String txt3 = jTextField3.getText();
      int mean = Integer.parseInt(txt3);
      Connection c = null;
      Statement stmt = null;
      try {
         Class.forName("org.postgresql.Driver");
         c = DriverManager.getConnection("jdbc:postgresql://localhost:5432/tst", "postgres", "21262050");
         c.setAutoCommit(false);
         System.out.println("Opened database successfully");
         String sql  = "INSERT INTO tt(noun, max, nbr) VALUES(?, ?, ?)";
         PreparedStatement pst =  c.prepareStatement(sql);
         pst.setString(1, name);
         pst.setInt(2,mean );
         pst.setInt(3, number);

         pst.executeUpdate();

      } catch (SQLException ex) {
            Logger.getLogger(insrt.class.getName()).log(Level.SEVERE, null, ex);
      }


      catch(Exception e){
            e.printStackTrace();
        }

    }                                        

    public static void main(String args[]) {

        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new insrt().setVisible(true);
            }
        });
    }

RubioRic · Accepted Answer · 2016-04-26 13:42:15Z

3

You're establishing autocommit to false.

After the auto-commit mode is disabled, no SQL statements are committed until you call the method commit explicitly.

https://docs.oracle.com/javase/tutorial/jdbc/basics/transactions.html#disable_auto_commit

Try executing c.commit() after pst.executeUpdate();

answered Apr 26, 2016 at 13:42

RubioRic

2,4684 gold badges32 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

saml Over a year ago

I would question why it is necessary to turn off auto commit for this example?

RubioRic Over a year ago

@TheShady No problem. Mark the answer as accepted if you please.

Collectives™ on Stack Overflow

Inserting values from java GUI into postgresql data base

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related