Connecting Java application and PostgreSQL with JDBC without using eclipse (execute at command prompt)

Introduction

As a programming education instructor, I teach beginners to understand the basics of programming languages without dare to use an integrated development environment. Therefore, it was necessary to prepare an environment for running Java applications without using eclipse.

What you can do by reading this article

You will be able to run Java applications using the PostgreSQL API at the command prompt.

Execution environment

The execution environment uses the following.

Add JDBC jar file for PostgreSQL

Start "Stack Builder" which is an attached application when installing PostgreSQL.

スタックビルダ 4.2.0の起動画面

Select "pgJDBC vXX.X.XX" from the applications you want to install. Since this is an installer, the save directory can be anywhere. (If you get lost, save it in the download folder.)

スタックビルダ 4.2.0のインストールしたいアプリケーションの選択画面

Open the "edb_pgjdbc.exe" downloaded above and add the jar file. Please install with the default save destination ("C: \ Program Files (x86) \ PostgreSQL \ pgJDBC").

Connect to PostgreSQL using JDBC

Recently, when I do Java programming, I have more opportunities to develop using an integrated development environment (eclipse, etc.), and I rarely implement it with a simple editor such as Sakura Editor. (I used to use it when I was studying at university ...) I often see how JDBC is used in eclipse, but I will review it.

When using JDBC with eclipse, after creating a new Java project Right-click on the project and follow the steps below to add the JDBC jar file.

eclipse新規Javaプロジェクト作成画面

(English) Select "Build Path"-> "Add External Archives ..."-> "postgresql-XX.X.XX.jar" (Japanese) "Build path"-> "Add external archive"

ビルドパスの追加後

Once added, it will appear in the Package Explorer.

eclipseでビルドパスの追加方法

Source code you want to run

We have already created tables (menuitems) in the database (restaurantdb).

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class P5_1 {
   public static void main(String[] args) {

       String url = "jdbc:postgresql://127.0.0.1:5432/restaurantdb";
       String user = "postgres";
       String password = "postgres";
       String sql = "SELECT * FROM menuitems";

       try (Connection connection = DriverManager.getConnection(url, user, password);
           Statement statement = connection.createStatement();
           ResultSet resultSet = statement.executeQuery(sql)) {

           while(resultSet.next()) {
               String id = resultSet.getString(1);
               String name = resultSet.getString(2);
               int price = resultSet.getInt(3);
               String kindId = resultSet.getString(4);
               Boolean isDisabled = resultSet.getBoolean(5);

               System.out.println(id + " " + name + " " + price + " " + kindId + " " + isDisabled);
           }
       } catch (SQLException e) {
           e.printStackTrace();
       }
   }
}

The main subject: I want to solve the problem that an error occurs when trying to connect to a database from a Java program without using eclipse.

C:\java-programming\JDBCSample>javac P5_1.java

C:\java-programming\JDBCSample>java P5_1
java.sql.SQLException: No suitable driver found for jdbc:postgresql://127.0.0.1:5432/restaurantdb
       at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:702)
       at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)
       at P5_1.main(P5_1.java:15)

There seem to be two ways to suppress the above error. -Add "CLASSPATH" to the environment variable -Give the execution option "-cp" at runtime

Add "CLASSPATH" to the environment variable

First, you have the option of adding "CLASSPATH" to your environment variables. Add the following to "Control Panel"-> "System"-> "Advanced system settings"-> "Environment variables"-> "User environment variables". Variable name "CLASSPATH" Value "C: \ Program Files (x86) \ PostgreSQL \ pgJDBC \ postgresql-42.2.12.jar ;."

Add execution option "-cp" at runtime

If for some reason you cannot change the environment variables, you can add options at run time.

For example, to compile and execute "P5_1.java", enter the following command.

> javac P5_1.java

> java -cp "C:\Program Files (x86)\PostgreSQL\pgJDBC\postgresql-42.2.12.jar;." P5_1

(The execution result is displayed)

Summary

This time, I called the JDBC API from a Java program without using eclipse. You may not use it very often, but it may be a good idea to give it a try to understand how it works.

Thank you very much.

reference

Recommended Posts

Connecting Java application and PostgreSQL with JDBC without using eclipse (execute at command prompt)
[Mac / Java / Eclipse / PostgreSQL] Connect Java application and database
How to execute Postgresql copy command with column information on Java
Compile Java at the command prompt
Use JDBC with Java and Scala.
Java and Derby integration using JDBC (using NetBeans)
[Tutorial] Download Eclipse → Run the application with Java (Pleiades)
[Java 11] I tried to execute Java without compiling with javac
[Tutorial] Download Eclipse → Run Web application with Java (Pleiades)
[Java] Development with multiple files using package and import
When a Java file created with the Atom editor is garbled when executed at the command prompt