Read rows from a mysql table via java

Question

I need sample code to read rows of data from a mysql table using java

Answer 1

Standard tutorial from Oracle/Sun

example with explanation

Answer 2

Here is a tutorial with sample code: http://www.developer.com/java/data/article.php/3417381/Using-JDBC-with-MySQL-Getting-Started.htm

Answer 3

A very simple tutorial: http://www.vogella.de/articles/MySQLJava/article.html

Google is your friend.

Answer 4

I wouldn't recommend using the JDBC API directly, it's error prone (sooner or later you forget to close a conection) and too verbose. There are many nice layers to use on top of JDBC. If you want to write SQL, I think Spring JDBCTemplate is nice. Or better, Groovy's SQL support (if you are just bound to 'Java the platform', not 'Java the language').
Then there are object relational mappers (ORM) where you don't need to write SQL. Take a look at Hibernate and JPA