Java PostgreSQL Example

In this post, we will learn how to insert a record into a PostgreSQL database using the JDBC API.

Make sure that you have installed PostgreSQL database in your machine.

PostgreSQL driver

To include the PostgreSQL Java driver, we need to add the following Maven dependency:
<dependency>    <groupId>org.postgresql</groupId>    <artifactId>postgresql</artifactId>    <version>42.2.0</version></dependency>

Create Table Script

CREATETABLEIF NOT EXISTS authors (    idserialPRIMARY KEY,     nameVARCHAR(25));

Insert Record in PostgreSQL database

importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.PreparedStatement;importjava.sql.SQLException;importjava.util.logging.Level;importjava.util.logging.Logger;publicclassJavaPostgreSqlPrepared {publicstaticvoidmain(String[]args) {String url="jdbc:postgresql://localhost:5432/testdb";String user="user name here";String password="password here";int id=6;String author="Trygve Gulbranssen";String query="INSERT INTO authors(id, name) VALUES(?, ?)";try (Connection con=DriverManager.getConnection(url, user, password);PreparedStatement pst= con.prepareStatement(query)) {            pst.setInt(1, id);            pst.setString(2, author);            pst.executeUpdate();        }catch (SQLException ex) {Logger lgr=Logger.getLogger(JavaPostgreSqlPrepared.class.getName());            lgr.log(Level.SEVERE, ex.getMessage(), ex);        }    }}


Related Java Source Code Examples:

Java Record Class ExampleJava Text Blocks ExampleJava Record Builder Pattern ExampleJava Record Constructor ExampleJava Record Constructor Validation ExampleJava Record Serializable ExampleJava Record Getter ExampleJava Record Default ConstructorJava Records CRUD (Create, Read, Update, Delete) ExampleJava Record Custom MethodsJava Record Custom toStringJava Record Custom equals and hashCodeJava Records with Spring Boot CRUD ExampleJava Record Implement Interface ExampleJava Switch Expressions ExampleJava Pattern Matching for instanceofJava Sealed Class ExampleJava Sealed Class vs Final ClassJava Sealed Class Record ExampleJava Sealed Class Generic ExampleJava Sealed Class Enum ExampleJava Sealed Class Switch ExampleJava var Keyword ExampleJava CompactNumberFormat Class ExampleJava Vector API ExamplePattern Matching for Switch ExampleCollectors.teeing() in Stream API ExampleJava FileSystems.newFileSystem() Method ExampleJava Files.readString() and Files.writeString() ExampleJava String isBlank ExampleJava String strip ExampleJava String repeat ExampleJava String lines ExampleJava String stripIndent ExampleJava Binary Search (Recursive and Iterative) ProgramJava Happy Birthday ProgramJava Program That Calculates the Age of a PersonJava Logical And Or Xor ExamplesJava Format Date and Time ExamplesJava Convert String to Date and TimeJava Convert Roman to Integer NumberJava Convert Octal to HexaDecimalJava Convert Octal to DecimalJava Convert Integer Number to Roman NumberJava Convert Hexadecimal to BinaryJava Convert Decimal to OctalJava Convert Decimal to BinaryJava Convert Binary to DecimalJava Convert Binary to an OctalJava Convert Binary to a HexadecimalJava Convert a Unix Timestamp to Date TimeJava Check If Two Integer Arrays are EqualsJava program that removes all white spaces from the given stringJava 8 program that counts the number of vowels and consonants in a given stringJava 8 program that reverses words of a given stringJava Program to Count Number of Digits in an IntegerJava Program Fibonacci Series Using RecursionJava Program to Find Factorial of a NumberJava program to calculate the area of TriangleJava Program to Calculate Area of SquareJava Program to Calculate Area of RectangleJava Program to find the Smallest of three numbers using Ternary OperatorJava Program to Find Largest of Three NumbersJava Program to Find GCD of Two NumbersJava Program to Check Armstrong NumberJava Program to Generate Random NumberJava Program to Check if Number is Positive or NegativeJava program to check prime numberJava Program to Calculate Simple InterestJava Program to Swap Two Numbers Without using a Temporary VariableJava Program to Swap Two NumbersJava Program to Find ASCII Value of a CharacterJava Program to Check Whether an Alphabet is Vowel or ConsonantJava Program to Check Leap YearJava Program to Check Even or Odd NumberJava Program to Add Two NumbersJava Program to Swap Two Strings Without Using Third VariableJava Program to Swap Two Strings with Third VariableHow to Get All Digits from String in JavaFind Duplicate Number in Array in JavaHow to Get Current Working Directory in Java?Check Palindrome String in JavaJava Program to Create Pyramid Of NumbersCreate a String object in Java ExampleJava String valueOf() Method ExampleJava String.trim() Method ExampleJava String.toUpperCase() Method ExampleJava String toLowerCase() Method ExampleJava String toCharArray() Method ExampleJava String substring() Method ExampleJava String.startsWith() Method ExampleJava String split() Method ExampleJava String.replaceFirst() Method ExampleJava String.replaceAll() Method ExampleJava String replace() Method ExampleJava String regionMatches() Method ExampleJava String length() Method ExampleJava String lastIndexOf() Method ExampleJava String intern() Method ExampleJava String indexOf() Method ExampleJava String getChars() Method ExampleJava String getBytes() Method ExampleJava String equals() and equalsIgnoreCase() ExampleJava String.endsWith() Method ExampleJava String.contentEquals() Method ExampleJava String.contains() Method ExampleJava String concat() Method ExampleWhat's the Simplest Way to Print a Java Array?Merge two String Arrays ExampleChecks If a String is Not Empty and Not Null in JavaReverse a String in Java Using StringBuilderCapitalize the First Letter of a String in Java ExampleJava String codePointAt() Method ExampleJava String Compare Using equals() MethodSort String in Descending Order in JavaSort String in Ascending Order in JavaHow to Get All Digits from String in JavaJava String getDigits() Utility MethodJava String isAlphanumeric() Utility MethodJava String isAlpha() Utility MethodJava String countMatches() Utility MethodJava String mergeStringArrays(String array1[], String array2[]) Utility Method ExampleJava String quote( String str) Utility MethodJava arrayToMap(String[][] array) Utility MethodJava String fromBufferedReader() Utility Method - Converts a BufferedReader into a StringJava String isNumericSpace() Utility MethodJava String isNumeric() Utility MethodJava String isAlphanumericSpace() Utility MethodJava String isAlphaSpace(() Utility MethodJava trimArrayElements() Utility MethodJava trimArrayElements() Utility MethodJava String containsWhitespace() Utility MethodJava String isBlank() Utility MethodJava String isAnyEmpty() Utility MethodJava String isNotEmpty() Utility MethodJava String isEmpty() Utility MethodJava String Uppercase First Character ExampleJava String uppercaseFirstChar() Utility MethodJava String trimTrailingCharacter() Utility MethodJava String trimLeadingCharacter() Utility MethodJava String trimTrailingWhitespace() Utility MethodJava String trimLeadingWhitespace() Utility MethodJava String trimAllWhitespace() Utility MethodJava String trimWhitespace() Utility MethodJava StringBuilder trimToSize() Method ExampleJava StringBuilder substring() Method ExampleJava StringBuilder setLength() Method ExampleJava StringBuilder reverse() Method ExampleJava StringBuilder lastIndexOf() Method ExampleJava StringBuilder insert() Method ExampleJava StringBuilder indexOf() Method ExampleJava StringBuilder getChars() Method ExampleJava StringBuilder ensureCapacity() Method ExampleJava StringBuilder deleteCharAt() Method ExampleJava StringBuilder delete() Method ExampleJava StringBuilder codePointBefore() Method ExampleJava StringBuilder codePointAt Method ExampleJava StringBuilder capacity() Method ExampleJava StringBuilder append() Method ExampleJava Convert Integer to String ExampleJava Convert Float to String ExampleJava Convert Double to String ExampleJava Convert Short to String ExampleJava Convert Long to String ExampleJava Convert Character to String ExampleJava Convert Byte to String ExampleJava Convert Boolean to String ExampleJava Convert String To Short ExampleJava Convert String To Long ExampleJava Convert String To Integer ExampleJava Convert String To Float ExampleJava Convert String To Double ExampleJava Convert String To Byte ExampleJava Convert String To Boolean ExampleClear ArrayList in Java ExampleJava ArrayList add(), get() and set() Method ExampleIterate over ArrayList Using forEach JavaIterate over ArrayList using Iterator in JavaJava ArrayList indexOf() and lastIndexOf() ExampleSearch an Element in an ArrayList in JavaJava ArrayList removeAll() Method ExampleJava ArrayList remove() Method ExampleHow to Iterate over ArrayList in JavaHow to Remove Element from ArrayList in JavaHow to Access Elements of ArrayList in JavaCreate ArrayList from Another ArrayList in JavaHow to Create an ArrayList and Add Elements to ItJava ArrayList subList() ExampleGet Index of Elements in ArrayList ExampleJava ArrayList removeIf() ExampleCopying part of Array in Java ExampleSorting an Array using Arrays.sort() MethodCheck Two Arrays are Deeply EqualJava Arrays.copyOf() Example - Copying an ArrayJava Arrays.binarySearch() Example - Searching an ArrayJava Arrays.asList() Example - Convert Array to ArrayListSort String in Ascending Order in JavaSort String in Descending Order in JavaSort Integer in Ascending Order in Java ExampleSort Integer in Descending Order in Java ExampleSort User-Defined Objects in Ascending Order in JavaSort User-Defined Objects in Descending Order in JavaSort User-Defined Objects using Comparator InterfaceJava LinkedList add(), addFirst(), addLast() and addAll() ExampleIterate LinkedList using forEach() Method ExampleIterate through a LinkedList using an Iterator in JavaIterate or Loop Through Elements LinkedList in Java ExampleSearch Elements of LinkedList in Java with ExampleRemove First and Last Elements of LinkedList in JavaGet Elements from LinkedList Java ExampleJava LinkedList remove(), removeFirst(), removeLast(), removeIf() and clear() ExampleCreate HashSet in JavaIterating over a HashSet using IteratorIterate over HashSet in JavaRemove Element from HashSet in JavaCreate HashSet in JavaIterating over a LinkedHashSet using forEach() Method ExampleIterate over LinkedHashSet using Iterator in Java ExampleIterate over LinkedHashSet in Java ExampleRemove all Elements from LinkedHashSet in Java ExampleRemove Element from LinkedHashSet ExampleCheck If an Element Exists in Java LinkedHashSet ExampleCreate LinkedHashSet in Java ExampleCreate TreeSet in Java ExampleIterating over a TreeSet using Java 8 forEach() MethodIterate over a TreeSet using Iterator in Java ExampleIterate over TreeSet in Java ExampleRemove All Elements from Java TreeSet ExampleRemove First and Last Element from TreeSet in JavaRemove Element from TreeSet in Java ExampleCheck If an Element Exists in Java TreeSet ExampleJava TreeSet add(), first() and last() Method ExampleJava Convert ArrayList to Stack ExampleJava Convert Array to Stack ExampleJava Stack push() Method ExampleJava Stack empty() Method ExampleJava Stack peek() Method ExampleJava Stack search() Method ExampleJava Stack pop() Method ExampleJava Deque and ArrayDeque ExamplesIterating over a Queue in Java ExampleJava Queue isEmpty(), size(), element() and peek() ExampleJava Queue Interface ExampleJava Priority Queue of User Defined Objects ExampleJava Create a Priority Queue with a Custom ComparatorCreate a Priority Queue in Java ExampleHashMap Stream and Filtering ExampleJava HashMap Iteration over Values ExampleJava HashMap Iteration over KeysJava HashMap replace() ExampleJava HashMap size ExampleIterate over a HashMap Java using LambdaIterate over a HashMap Java 8 forEachIterating over a HashMap using Iterator in JavaIterate over HashMap in JavaHow to Store Employee Objects in HashMapRemove Entry from HashMap JavaCheck If Value Exists in HashMap Java ExampleCheck If Key Exists in HashMap Java ExampleCreate a HashMap in Java ExampleHow to Delete Data from MySQL Table using JavaHow to Insert Data in MySQL Table using JavaHow to Create Database Table in JavaJDBC DriverManager ExampleJDBC PreparedStatement ExampleJDBC Statement ExampleJava MySQL DataSource ExampleUpdate Query in MySQL using Java PreparedStatementLogin Example with JSP + Servlet + JDBC + MySQL DatabaseJSP + JDBC + MySQL Example TutorialJSP Form Example with JDBC and MySQL DatabaseJava JDBC CRUD Example - SQL Insert, Select, Update, and Delete ExamplesJava Swing JDBC MySQL Database ExampleJava JDBC Connection to HSQLDB DatabaseJDBC Connection to H2 Database ExampleJDBC Connection to PostgreSQL ExampleJDBC Connection to Oracle Database ExampleJDBC Transaction Management ExampleJDBC Delete Query ExampleJDBC Select Query ExampleJDBC Update Query ExampleJDBC Insert Multiple Rows ExampleJDBC Create a Table ExampleWhat are different types of JDBC DriversAdvantages of Hibernate Framework over JDBCJava PostgreSQL ExampleJava H2 Insert Record ExampleJava H2 Embedded Database ExampleJava H2 Create Table ExampleJava Simple Lambda Expression ExampleJava Lambda Expressions Multiple StatementsJava Lambda Expressions forEach ExampleJava Lambda Expression with Multiple Parameters ExampleJava Lambda Expression Runnable ExampleJava Lambda Expression Comparator ExampleRefactoring Factory Design Pattern with LambdasRefactoring Chain of Responsibility Pattern with LambdasRefactoring Observer Design Pattern with LambdasRefactoring Strategy Design Pattern with LambdasIterate HashMap with forEach() + Lambda Expression ExampleIterate HashSet with forEach() + Lambda Expression ExampleIterate ArrayList with forEach() + Lambda Expression ExampleJava method reference to a constructor exampleJava method reference to static method exampleJava method reference to an instance method of an object exampleJava method reference to an instance method of an arbitrary object of a particular typeJava 8 - Create Stream Object from Arrays ExampleJava 8 Creating a Stream from an ArrayJava 8 - Create Stream Object from Collection, List, SetJava 8 Stream - Sort List of String objects in Descending Order ExampleJava 8 Stream - Sort List of String objects in Ascending Order ExampleHow to convert a Java 8 Stream to an Array?Java 8 Stream - allMatch(),anyMatch() and noneMatch() ExampleJava 8 Stream - Sort List of Objects by Multiple FieldsJava 8 Stream - Sort List of Custom Objects in Ascending and Descending OrderJava 8 - Stream filter(), forEach(), collect() and Collectors.toList() ExampleJava Stream filter null values exampleJava Stream filter map by values exampleJava Stream filter map by keys exampleJava 8 Collectors.counting() ExampleJava 8 Collectors.averagingDouble() ExampleJava 8 Collectors.toSet() ExampleJava 8 Collectors.toList() ExampleJava 8 Collectors.joining() exampleJava 8 Stream multiple filter operationsJava 8 Stream filter map by keysJava 8 Stream filter map by valuesJava 8 Stream collect to list exampleJava 8 Stream Collectors.counting() exmapleJava 8 Collectors.collectingAndThen() exampleJava 8 Collectors.toList() ExampleJava 8 Collectors.minBy() and Collectors.maxBy() exampleJava Stream filter() ExampleJava Stream map() ExampleJava Stream flatMap() ExampleJava Stream distinct() ExampleJava Stream limit() ExampleJava Stream peek() ExampleJava Stream anyMatch() ExampleJava Stream allMatch() ExampleJava Stream noneMatch() ExampleJava Stream collect() ExampleJava Stream count() ExampleJava Stream findAny() ExampleJava Stream findFirst() ExampleJava Stream forEach() ExampleJava Stream min() ExampleJava Stream max() ExampleJava Stream reduce() ExampleJava Stream toArray() ExampleJava Function Functional Interface ExampleJava Supplier Functional Interface ExampleJava Consumer ExampleJava BiConsumer ExampleJava BiFunction ExampleJava Predicate ExampleJava 8 LongConsumer ExampleJava 8 IntConsumer ExampleJava 8 DoubleConsumer ExampleJava StringJoiner ExampleCreate Optional Class Object in Java - empty(), of(), ofNullable() MethodsOptional get() Method - Get Value from Optional Object in JavaOptional isPresent() Method ExampleOptional orElse() Method ExampleOptional orElseGet() Method ExampleOptional orElseThrow() Method ExampleOptional filter() and map() Method ExamplesJava 8 program that counts the number of vowels and consonants in a given stringJava 8 program that reverses words of a given stringJava 8 - Copy List into Another List ExampleCheck Whether the Given Year is Leap Year or Not in JavaJava 8 forEach() Array ExampleJava 8 forEach() Map ExampleJava 8 forEach() Set ExampleJava 8 forEach() List ExampleGetting current date and time with ClockConvert LocalDate to Date in JavaConvert LocalDateTime into Date in JavaConnvert java.util.Date to java.time.LocalDateTime ExampleConvert java.util.Date to java.time.LocalDate ExampleDuration Between Two LocalDate in JavaJava Convert ZonedDateTime to String ExampleConvert String to ZonedDateTime in JavaCompare ZonedDateTime Objects in JavaHow to Get Hour, Minute, Second from ZonedDateTime in JavaConvert ZonedDateTime to LocalTime ExampleConvert ZonedDateTime to LocalDateTime in JavaJava ZonedDateTime now() and of() Method ExampleConvert LocalDateTime to LocalTime in JavaConvert LocalDateTime to LocalDate in JavaCompare LocalDateTime Objects in JavaJava LocalDateTime - Get Hour, Minute and SecondHow to Get Day Month and Year from LocalDateTime in JavaJava LocalDateTime now() Method ExampleHow to Get Current Date Time in JavaConvert LocalDate to String in JavaConvert String to LocalDate in JavaJava LocalDate isLeapYear() Method ExampleHow to Get Number of Days from Month and Year using LocalDate in JavaCompare Java LocalDate Objects ExampleHow to Add Days Weeks Months and Years to LocalDate in JavaHow to get Day Month and Year from LocalDate in JavaJava LocalDate now() Method Example - Get Current Date and Specific DateConvert LocalTime to String in JavaConvert String to LocalTime in JavaJava LocalTime isBefore() and isAfter() Method ExampleHow to Compare Time in JavaJava 8 - LocalTime getHour(), getMinute(), getSecond() and getNano() ExampleJava LocalTime now() Method Example - Get Current Time and Specific TimeJava 8 Get Local Date Time in All Available Time ZonesHow to get year, month, day, hours, minutes, seconds and milliseconds of LocalDateTime in Java 8?How to get year, month, day, hours, minutes, seconds and milliseconds of Date in Java?Difference between Two Dates in JavaCreate LocalDateTime from LocalDate and LocalTime in Java

Comments

Post a Comment