Skip to content

Instantly share code, notes, and snippets.

View pablohdzvizcarra's full-sized avatar
🛏️
Need Sleep

Pablo Hernandez pablohdzvizcarra

🛏️
Need Sleep
View GitHub Profile
@pablohdzvizcarra
pablohdzvizcarra / RowSet.java
Created July 14, 2021 14:37
create a file with data form the database and read the data
package com.pluralsight.jdbc.course.m7c3;
import javax.sql.rowset.CachedRowSet;
import javax.sql.rowset.RowSetFactory;
import javax.sql.rowset.RowSetProvider;
import java.io.*;
import java.sql.SQLException;
public class RowSet
{
@pablohdzvizcarra
pablohdzvizcarra / SequenceTwoTransacctionsSQL.java
Created July 14, 2021 13:38
way to create two transactions in MySQL
package com.pluralsight.jdbc.course.m7c2;
import java.sql.*;
public class OrderComponent
{
public static void main(String[] args) throws SQLException
{
int customer = 112;
LineItem lineItem =
package com.pluralsight.jdbc.course.m6c2;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;
public class Procedures
{
private static final String URL
= "jdbc:mysql://localhost:3306/classicmodels?user=root&password=my-secret-pw";
@pablohdzvizcarra
pablohdzvizcarra / ProceduresMySQL.java
Created July 13, 2021 16:56
example two procedures operation with mysql
package com.pluralsight.jdbc.course.m6c2;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;
public class Procedures
{
private static final String URL
= "jdbc:mysql://localhost:3306/classicmodels?user=root&password=my-secret-pw";
@pablohdzvizcarra
pablohdzvizcarra / SavesAndReadBlobsAndClobs.java
Created July 13, 2021 14:29
operations to save and read clobs, blobs in mysql
package com.pluralsight.jdbc.course.m6c1;
import java.io.FileInputStream;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.io.Reader;
import java.sql.*;
public class SavesAndReadBlobsAndClobs
{
@pablohdzvizcarra
pablohdzvizcarra / Main.java
Created July 10, 2021 23:06
run only one async task
package org.async;
import java.util.concurrent.CompletableFuture;
public class Main
{
public static void main(String[] args)
{
// TODO: 7/10/21 Create a simple Task
// TODO: 7/10/21 Add sleep to thread, for the asynchronous task to be executed
@pablohdzvizcarra
pablohdzvizcarra / DBLauncher.java
Created July 2, 2021 14:16
simple config H2 database to Gradle
package com.example.infrastructure;
import org.h2.tools.Server;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
public class DBLauncher
@pablohdzvizcarra
pablohdzvizcarra / callApiAndPerseRequestInPOJO.java
Last active July 1, 2021 13:05
call api with HttpClient Java and parse json to POJO
package org.example;
import com.fasterxml.jackson.core.type.TypeReference;
import com.fasterxml.jackson.databind.ObjectMapper;
import java.io.IOException;
import java.net.URI;
import java.net.http.HttpClient;
import java.net.http.HttpRequest;
import java.net.http.HttpResponse;
@pablohdzvizcarra
pablohdzvizcarra / DifferentWaysToCreateStream.java
Created June 27, 2021 14:17
show differents ways to create a stream with some different types in Java
package com.pablohdz.application;
import com.pablohdz.entities.Person;
import java.io.IOException;
import java.nio.file.Files;
import java.nio.file.Path;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.Optional;
@pablohdzvizcarra
pablohdzvizcarra / CreateClassWithStringName.java
Created June 24, 2021 02:02
example to how create manually a class with name
final String className = file.readUTF();
final String personName = file.readUTF();
final int age = file.readInt();
final Class<?> personClass = Class.forName(className);
final Constructor<?> constructor =
personClass.getConstructor(String.class, int.class);
return (Person) constructor.newInstance(personName, age);