H2 example

h2_example.java

public class h2_example {

  import java.io.IOException;
  import java.sql.Connection;
  import java.sql.DriverManager;
  import java.sql.ResultSet;
  import java.sql.Statement;
  import java.util.ArrayList;
  
  public static void main(String... args){
    Connection connection = null;
    ResultSet resultSet = null;
    Statement statement = null;
    try {
        // Class.forName("org.h2.Driver");
        connection = DriverManager.getConnection("jdbc:h2:~/test", "sa", "");
        statement = connection.createStatement();
        resultSet = statement.executeQuery("SELECT EMPNAME FROM employeedetails");
        while (resultSet.next()) {
            System.out.println("EMPLOYEE NAME:"
                    + resultSet.getString("EMPNAME"));
        }
    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        try {
            resultSet.close();
            statement.close();
            connection.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
  }

}