Dmitriy Sukharev. IT Blog

Well, I haven't remembered syntax of database creation in UTF-8 character set with MySQL for quite a long time. Finally I decided to write a little snippet because I used it so often last time.

CREATE DATABASE database CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE USER 'username'@'localhost' IDENTIFIED BY ...

In this article I want to show you how to use Oracle Database via JDBC. I'm going to describe the easy way of connection to database, creation of table, and fetching, inserting, updating and deleting rows in created table (CRUD).

What do you need for this?

First of all ...