Java JDBC Tutorial – Part 13: Reading Database Connection Info from a Properties file with MySQL

---

Please subscribe to this channel :-)

[luvcodetv]

Cecep Gorbacev Hey. I like your suggestion of how to print to a printer or an excel format. I'm thinking of adding the feature "Export to Excel". This button will generate a CSV file that you can then open with Excel. Does that sound like a good plan for a video?

[luvcodetv]

Cecep Gorbacev Glad you liked the videos:-)

[simonghiwot]

This playlist was a huge help for my own project match appreciated

[CecepGorbacev]

This is awsome and the way you explain everything like exact what i needed. coooolll..
i've just downloaded all your tutorial and will learn from it tonight. I hope i can finish it in two or three days.

Than after all of this, i think we need a tutorial about how to print it to device such us printer or an excel format. *request

[wilfredomendez]

The tuts that I've been looking for, thanks

[derail]

These videos are super helpful, especially when I'm new to this

Is it possible to get a video where you use user input to add, update, and/or delete records in the database
Also is it possible to get a video with using multiple classes to do queries, prepared statements, etc

[alexandersmirnov]

Thank you very much for such a good tutorial. It`s really help me.
I wish you good luck)

[dravarian]

Just went through all of the java mySql videos and it has helped so much. Not just with the interaction with mySql, but with little stuff like making stubs and the fact that eclipse has a form generator -.- I've been making swing forms purely from code for like 4 years, idk why I never even thought to look for an interactive designer.

I was wondering if displaying / updating views that were created from joins was something you could go over. Like lets say I had a table with customers, a table with products, and then the many to many relationship table that went along with both of those. How would I display a list of people's names with what they bought?
e.g.
Customer
ID    Name
1    Tim
2    Nick
3    Deb

Products
ID    Name
1    Milk
2    Eggs
3    Turnips

Purchases
P_ID    C_ID
2        1
1        3
3        3
1        2

If I wanted to show Customer name then all of the food they bought what should I do?

[RiteekaRathod]

Thank you Chád for making JDBC such easy for me :)

[shriebrown]

This is a great tutorial. So if I am using a Properties file in Tomcat, what will be the correct path?

[engineerali]

Can you make a tutorial for making a form in Java GUI and filling it with information and saving it to the db

Thanks for all these tutorials. I am learning a lot

Cheers!

[shriebrown]

Thank you for the prompt reply. I tested the choice 2 by using servlet class through the link you recommended. It worked. But I am building a SqlHelper which needs to be a java util regular class. To call a regular Java class by the correct path in Tomcat is the issue for me.

[mny]

Chad...are you going to continue the tutorial with implementing the server on JDBC ? :D it would be so useful! thanks a lot!

[jimmatrix]

Thank you. Can you show how to use the

[AnuradhaWishmantha]

Is there a way to store the password in an encrypted format in the properties file?

[syednoman]

Hello Chad

After completing all your JDBC and Swing Videos, I tried to export this swing application as a JAVA Jar File and I selected everything to be exported and set the EmployeeSearchApp.java as my Main Class. The executable jar file gets created successfully and if I look into my created jar file, all the files including the demo.properties file that I used to make the DAO is also exported correct.

Problem is that when I double click on my generated jar file to run it like a standalone application, it throws me an error saying filenotfoundexception: demo.properties (The system cannot find the specified file).

Can you please help me to understand why this executable jar file cannot find the demo.properties file although its inside the jar? In eclipse, the demo.properties file exists in my root project folder and I am reading it in my DAO as per your provided code below:

// get db properties
Properties props = new Properties();
props.load(new
String user = props.getProperty("user");
String password =
String dburl = props.getProperty("dburl");

Thanks for your time and support.

[itchap]

Hey luv2code, how does one pass the properties useSSL=false using your method?

[eza]

I am new in JDBC, anyone want to share their knowledge and help me please