How you can do a SQL terminal like in java?

Question

0.00/5 (No votes)

See more:

let me explain, some years ago i had one project in university by some bad teacher, i mean he didnt even explain what was java and he gave us that project on our first day, it was so painful to see just one guy did it and it was because that guy was teacher favorite, he had a lot of diplomas about programming and everything...props for him but i always had the question...how do you do that?

the project was this "simple"...you had a .txt file and you have to open it with your program...which has to say on the terminal "the file ...txt is open" and then you can search-like sql, you do querys and the program would tell you how many things where in the file, create new tables, eliminate them, modify, everything.

anyone has a remote idea how you do that?

What I have tried:

i tried and failed big time before and never thought about it until now.

Posted 2-Jun-21 19:36pm

vonhacker

Updated 2-Jun-21 21:21pm

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2021-06-02T19:56:00

Basically, don't.
A text-based file is a really bad idea: it doesn't have any structure and it's intended to store human-readable data, and what you are trying to create is anything but that!

You are talking about creating a whole database engine, and they are very, very complex - particularly if you want to do "SQL" searches and queries.

Frankly, I don't believe for a minute that anyone gave that as a project on the first day of any development language class - the students would have no idea even what database tables were, and being able to compile and (just about) run a Java app to say "Hello World!" is no basis for creating formatted file I/O based apps.

Richard MacCutchan · Answer 2 · 2021-06-02T21:21:00

Solution 2

Quote:
anyone has a remote idea how you do that?

Well, as OriginalGriff says, it is not a good idea for an actual program. However, if you want to do it as an exercise in learning Java then it could be interesting. I would start at The Java™ Tutorials[^] which will lead you through all the steps necessary.

Posted 2-Jun-21 21:21pm

Richard MacCutchan

Comments

vonhacker 18-Jun-21 0:53am

I know is not a good idea, but it was the professor gave us as project for the semester

Richard MacCutchan 18-Jun-21 3:28am

So do what I suggested and study the tutorials. You will not learn a complete language by posting questions here.