Not sure what your doing, but your doing it wrong. What is the overall task at hand, not the code you are trying to do what you think needs to be done.
Basically what I was required to do was insert values into a database using a textfile, implement code that changes the passwords into hashes, then after all of that is complete, make a log in screen using the data from the database to log in. I’ve sorted this out now. Thanks everyone for their input.
Is this for school?
insert values into a database using a textfile
You are never going to do this in the real world. If you needed to import numerous records from a text file, doing it with code is the LAST way it would be done.
It’s for college. I know it will never be used in the real world, that’s why I had to follow the requirements in the question paper and make it work that way instead of following everything from online. It’s stupid, but I’m not going to lose marks over that, that’s why I made sure I got it to work according to the requirements of the question paper.
It seems every time someone comes with school work, the teachers are teaching wrong. Unbelievable!
It’s usually the people who set the exam papers and assignment papers that have no idea what they’re doing. They’re just lazy and don’t prepare us for the real world. That’s the education system though, unfortunately.
I disagree with that statement. We have an ETL developer that his only job is to programmatically import records stored in files to databases.
Most programming courses in general are out dated. Even though this industry changes quickly, the curriculum is slow to change, partly due to the requirements to make a change. Take windows development. MOST colleges teach VB.NET as a required language. However, they still teach Windows Forms and not WPF. Windows forms were last an industry standard 15- 20 years ago.
We have an ETL developer that his only job is to programmatically import records stored in files to databases.
Really? Does he not know how to use mysql import or any of the many mysql gui’s to right click/import? He really keeps writing scripts to do it?
That is a really limited view actually. One there are more RDBMS’s than just MySQL. Two, the process normally ends up being automated. You also have to account for the myriad of formats that different senders will be using.
Since it appears you are unfamiliar with the position, ETL Developer
I should probably correct my assertion. Since I have never worked for another company but my own, I should say in my experience…
I actually have no idea what goes on in company’s.
Just learned something new, ETL, and as it turns out, I am going to need an ETL guy for the project I am working on right now. They have a really old poorly designed database that I am creating a new app/db from the ground up.
Since their existing db is so wrong, I have to completely ignore they have it and design a correct db. Doing the data migration is going to be a biotch.
I see there are various ETL software’s. Anybody ever use one? One of those listed on the Wiki may be just what I need.