How to insert the output of my java application into mysql database
I am trying to write a twitter applic开发者_C百科ation. I crawled the twits, and I now have stored it in a folder called Twits. And in the folder, it has text files containing the information of the tweets like userid, text, etc. How can I insert the folder, or the output into mysql database. Any help would be greatly appreciated. I am new to databases, and java itself, I have been stuck on this for a while now. Thank you.
I would recommend you to work through a tutorial like this one: http://www.developer.com/java/data/article.php/3417381
Your goal should be to reproduce what they're doing step by step. If you understand how to do mysql with Java you can then apply your new knowledge to your Twitter app.
Have fun!
Edit
SQL at w3schools: http://www.w3schools.com/sql/sql_intro.asp PreparedStatement at Java tutorials: http://download.oracle.com/javase/tutorial/jdbc/basics/prepared.html
精彩评论