Home Java How to connect postgresql with Java in Eclipse

How to connect postgresql with Java in Eclipse

1 min read
0
0
2,130

This tutorial will teach you how to connect postgresql with Java in Eclipse step by step.

First Step you have to download the relevant drivers. just go to google and type postgresql connector java. it will take to the respective website for downloading a jar file.

after downloaded the jar file you have to import into the eclipse project folder.

This how Establish the Database Java to postgresql.

Class.forName(“org.postgresql.Driver”); // Register the postgresql driver

con = DriverManager.getConnection(“jdbc:postgresql://localhost:5434/Lmsschool”, “postgres”, “123” );
//Give the database location 

We Have Created the Simple GUI Application and Connect postgresql

Paste code inside the Save Button

try
   {
    String name = txtname.getText();
    Connection con;
    Class.forName("org.postgresql.Driver");
    con = DriverManager.getConnection("jdbc:postgresql://localhost:5434/Lmsschool", "postgres", "123" );		        
    String sql = "INSERT INTO records(name) VALUES (?)";	  
    PreparedStatement statement = con.prepareStatement(sql);
    statement.setString(1,name);
    statement.executeUpdate();			
    JOptionPane.showMessageDialog(null, "Record Addedd Succssfully");	
     txtname.setText("");
     txtname.requestFocus();
   }
   catch(Exception e1)
     {
	System.out.println(e1.toString());
     }

i have attached the video link below. which will do this tutorials step by step.

 

 

 

  • Java String Methods

    Java provides a rich set of built-in methods for handling String operations efficiently. S…
  • Is Java Hard to Learn?

    Is Java Hard to Learn is it True? Java is one of the most popular programming languages in…
  • How to generate random with weight java

    Generating Random Numbers with Weights in Java Random number generation with weighted prob…
Load More Related Articles
Load More By admin
Load More In Java

Leave a Reply

Your email address will not be published. Required fields are marked *

Check Also

Registration with image upload Java Jdbc(Download Source code)

Introduction In this section, we will guide you step by step in the development of an imag…