What's the simplest way to store data from a java program to MySQL?

Question

I want to store data in string form to MySQL. I have created the tables in the MySQL. I haven't worked with DATABASE ever. Can you please provide me code to store that data in the MySQL DB. e.g. Let's say I have a string "stack_overflow" and there is a column "SiteName" in a table "SiteDetails" in the DataBase. So how to store the string "stack_overflow" in the column "SiteName".

Answer 1

I would look at the Hibernate project. While it may not be simpler right now, as your application grows it will prove to be a life saver. Hibernate.org

Answer 2

You should start from the Java JDBC tutorial. After you understand what is happening there you will need a JDBC driver for MySQL.

Answer 3

I suggest reading about a few technologies so you can learn the framework ways of doing this stuff. Such as JPA or OJB. However, to directly answer your question, the easiest way would be with straight SQL over a JDBC connection.

 insert into SiteDetails (ID, SiteName)
 values(1, 'stackoverflow')

or

update SiteDetails 
set SiteName = 'stackoverflow'
where ID = 1

Answer 4

Use a PreparedStatement

Answer 5

There is iBatis which works great and gives you control of your query