I have made a java application to store information but i don't want to use MySql or Oracle interface instead i want to make my own GUI which is easier to interact is it possible somehow? if so how? the reason why i want to do so is to make sure i don't need to fire queries to get things done is there any alternative if so please suggest so that i can make my application work even for those who don't know about the Database and Queries.
Since you are in Java land, you could use something like JavaFX for the GUI work.
I would read about MVC (model, view, controller) architecture too.