MYSQL - Create Database

1. Open your terminal. 

2. Connect to MySql.If not use below link to know how to connect.

How to Connect to MySql Database using MAC terminal

3. Once you logged into your mysql then type the below command 
to create a database.
mysql> CREATE DATABASE OMS;
Query OK, 1 row affected (0.00 sec)   
1 row affected means Database is created successfully.

4. To use this Database OMS type below command.
mysql> USE OMS;
Database changed

5. Check which database you are using by using below command.
mysql> SELECT DATABASE();
+------------+
| DATABASE() |
+------------+
| oms        |
+------------+
1 row in set (0.00 sec)


***********Happy Learning*************

How to Connect to MySql Database using MAC terminal

1. Open your terminal. 

2. Check your current directory by typing pwd.
$ pwd

Output :
/usr/local/mysql/bin
your directory should be the bin folder of mysql else go to that 
directory by typing.
$ cd /usr/local/mysql/bin


3. When you are in mysql bin folder login to your mysql database 
using below command and enter password.
$ ./mysql -u root -p
Enter password: 
Output :

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 93
Server version: 5.7.19 MySQL Community Server (GPL)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. 
All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input 
statement.

mysql>    

If you see above welcome message then you are logged in to your mysql database.

Java - JDBC Connection Example-1.

Problem Description
How to connect to a database using JDBC?

Assume that database name is OMS(OrderManagementSystem) and it has table named orders which has 5 records.

JAVA INSTALLATION ON MAC

1. Download the Java from Oracle official site.
2. You can download from here : Oracle Site
3. Double click on the file that is downloaded to launch it.
4. Double click on the package icon to launch install Wizard.
5. Click Next and Finish.

Basic Enum EXAMPLE

An enum type is a special data type that enables for a variable to be a set of predefined constants and the names of an enum type's fields are in uppercase letters.

In the Java programming language, you define an enum type by using the enum keyword.

Project Structure

OrderStatus.java

Test.java

OUTPUT

Download SourceCode From Github

ClickToDownload

Get our Articles via Email. Enter your email address.

SWAGGER 2 CONFIGURATION IN AN EXISTING SPRING REST API

How to change Maven resources folder location ?

Maven resources folder contains all your project related xml files , images , text files.

If you want to change the default location from "yourproject/src/main/resources" to your required one or you want to add a new resource folder as per your project needs.

Follow below steps.

Go to your project pom.xml file and search for resources tag and add the new resource folder location with resource tag as below.

For example :

<!-- POM File -->
<resources>
<----------Old resource folder-----------------!>
<resource>
 <directory>src/main/resources</directory>
</resource>
<----------New resource folder-----------------!>
<resource>
 <directory>src/main/Yourrequiredfoldername</directory>
</resource>
<-----------------------------------------------!>
</resources>

Hope this is helpful..........!!!!Thank You.