program for an database connection in java

I am facing problem how want to connect the MySQL database through JDBC (please provide some tips or tutorials link) and how to retrieve the table rows in the output console .

Another thing is that I want some tips or tutorials regarding how to INSERT, 开发者_运维知识库UPDATE, DELETE & SELECT & search in the database through JDBC?

---

Here is short example which does the things you require: DevDaily.com - A Simple JDBC Example.