Java Video Tutorial 38

In this tutorial I show you how to add and delete rows in a JTable that will then effect the database. I also cover allowing the user to change the database on a cell basis.

After this tutorial, you'll be able to do anything with Java JTables.

[derekbanas]

Great! I'm very happy that you like them. I decided about 2 years ago to completely cover one language. It has been very fun :)

[derekbanas]

I'll revisit Python in the future. I just want to make sure I completely cover Java before I move on. When I was making those python tutorials, nobody was watching them so I figured there was no interest.

[derekbanas]

You're very welcome. I'll cover that very soon.

[derekbanas]

It should help. There is a tutorial attached to this about sabermetrics that may help teach mysql as well.

[derekbanas]

I think you're referring to using threads. I have covered them a bit, but have much more to cover

[derekbanas]

Thank you :) Yes you'd basically just need to issue a new query

[UCBCteam]

I am a very big fan of yours Derek....

[derekbanas]

I'm going to cover networks and thread techniques with network programming. I'm not certain what you are looking for though. Do you have an example?

[derekbanas]

It is hard to say. Have you taken a look at my code here goo. gl/3F4Oq

[shugu]

Dude, you're amazing!! Thanks a lot.

[shaco]

Hello Derek! I have a question. I will have a course soon called "databases". This is what it will cover:

Relational model, E-R diagrams
Functional dependencies
Normalization, BCNF, Multivalued dependencies, 3NF, 4NF
SQL DDL, SQL Queries, Relational Algebra
Assertions, Triggers
SQL/PSM, Embedded SQL, JDBC
Transactions, Authorization
Indexes
NoSQL, XML

Now I wonder, which of your videos should I watch to get started with this course? I always start by watching your videos when learning programming and then looking at slides&example code&books. But now Im a little confused of what videos of yours will be useful for me? If you take your time to read&answer this question, thank you a million times!

[StefanBanu]

Hi Derek, can you restructure all this project(code) in an MVC project?i know you did another tutorial for MVC pattern but I'll would like this project to see it structured, in proper methods, proper classes etc. in order to don't have everything in the main method and only one class.Thanks. 

[lightningthebeast]

This might sound a tad bit odd but you are using the terminal of mac, what would a PC user use ? If your answer is mysql workbench then could you please tell me how to use that . Reason being that no matter how easy something is, you cant master it on your own without any help .
I was trying to follow along with your tutorial but how to setup my workbench is my biggest obstacle .

Any help would be (actually) appreciated
P.S sorry for this paragraph of a comment :D

[shugu]

This is so much easier than using Netbeans!

[luca]

Hi Derek, this is great stuff! thank you!

but what if I have multiple frames? is there any other tutorial that implements that?

[Pattbonn]

Hey Derek,
Thank you, as always. Your time is very much appreciated.
I saw on this tutorial on NewThinkTank that someone had mentioned they could only update the State column. Was this mentioned and fixed by anyone else? I have the same issue, example error:

java.sql.SQLException: Column 'Last Name' not found.

relating to the 'Default' option in the switch statement:

rows.updateString(updateCol, value);

The error is the same for updating First Name, Last Name, and Birth (with the relevant field name, as defined in the DB, referenced in said error code).

Any further advice would be greatly appreciated.

[dimplehouse]

Hi Derek - when are you going to do more tutorials on Python? I've missed them. wxPython and wxGlade would be good topics!

[spanky]

dam getting into some good stuff now. I want to learn it all but I cant move on without mastering each topic first. Time to make some more databases

[TheTuhmen]

Hey Derek, when you're setting a value for the variable updateCol isn't that the value that we gave it in our table rather than our actual database value? Correct me if i'm wrong but your code doesn't work. Rather than giving the updateCol the value of "birth" you're getting the value "Birth Date" from the table not the database.

[danialaflakian]

oh.I got . at first delete from db, bcz when row is removed from default table model, the return selected row will change .
But dear Derek I have modify your code some how and I want to make it as a software which is possible to install by one .exe file ( let say I want to make one install file from your cod) .
how can i? do you have any tutorial .
any way .I appreciate what you are doing.