CODEWITHSUNDEEP
java
user6825497
user6825497

Reputation:

How do I store data in Java without need of extra software?

I am currently developing a program in Java using NetBeans that manages expenses. In this program I used MySQL to store data. Now I want to ask that if I give the program to one of my friend, he would also have to install MySQL using the same password that I used. Is there a way in which he will not be required to install MySQL?

Now suppose if my friend already has MySQL, but with a different password. My program would not work in that case, and it would be hard to replace my password with his password in the code. Is there a way to make the program run on his PC?

Earlier once, I have used an Oxford dictionary program. That time I did not have Microsoft Access installed. When I installed Microsoft Access I came to know that all the words of the dictionary are stored in a Microsoft Access file. How can I do this? I.e. how can I use MySQL/Microsoft Access to store data without the need to install either of them?

Upvotes: 0

Views: 635

Answers (3)

T.G
T.G

Reputation: 1921

The best solution in my opinion would be SQLite as it is light, and data can be stored locally in a desired location in a single file. H2 is more likely to be a developer tool.

This solution does not require additional software to be present on the user machine. Of course it has its limits, but as a simply storage for program dynamic data it is a good solution. It is worth mentioning that Android applications also can store their data in LiteSQL. It is a bit different approach there, but the principle stays the same.

Upvotes: 0

MyYyY
MyYyY

Reputation: 61

You can use an in-memory database like H2 Database if you don't require a large amount of data

But I think you should make your db connection configurable by using a properties file

Upvotes: 1

Mark
Mark

Reputation: 1498

If you want everyone to be able to use the database, you need to run it on a server that people can access through the internet.

However if you don't care about them using the same database and just want them to use their own, you could for example create a small file named "config.ini" or something like that and put the login information (like the password) in there. Then just read it in your code and use the info you read to log into your database. That way, every new user will only have to change the config.ini file without ever having to touch the code.

Upvotes: 0

Related Questions