What is JDBC?
JDBC stands for Java Database Connectivity.
A question from JavaRanch thread -> http://saloon.javaranch.com/cgi-bin/ubb/ultimatebb.cgi?ubb=get_topic&f=3&t=011739
Answer from Corey McGlone , a bartender (one of my favorites):
Sure, JDBC allows you to connect to a database. However, the real beauty of JDBC is the way in which it does that. Essentially, JDBC provides an added layer of abstraction between your application and your database. If you ever decide to swap out your database (Oracle for SQL Server, for example), you shouldn't have to change your Java code, at all, except perhaps to load a different driver. That's the real benefit of using JDBC - it doesn't tie you to a specific database vendor.
If you think about it, it's really rather close to the whole notion of Java - a language that allows applications to be moved easily from one OS to another. JDBC allows you to swap out databases in a similar manner.
JDBC Articles
- Overpower the PreparedStatement, a Java World article says, Save time debugging your database queries with DebuggableStatement is here -> http://www.javaworld.com/javaworld/jw-01-2002/jw-0125-overpower.html
- A good article explains the JDBC Driver Types is here -> http://www.javadesign.info/JSE/JDBC/jdbc_architecture
How to insert a file ?
You can make use of stmt.setBinaryStream() method. Have a look at this thread -> http://saloon.javaranch.com/cgi-bin/ubb/ultimatebb.cgi?ubb=get_topic&f=3&t=012422&p=1
JDBC FAQ
- FAQ Home page from JavaRanch -> http://faq.javaranch.com/java/JdbcFaq
- A Must read, JDBC Usage Questions is at -> http://faq.javaranch.com/java/JdbcUsageQuestions
- http://java.sun.com/javase/technologies/database/index.jsp
http://java.sun.com/products/jdbc/faq.html
http://java.sun.com/docs/books/tutorial/jdbc/basics/index.html
http://java.sun.com/developer/Books/JDBCTutorial/index.html
http://java.sun.com/j2se/1.5/pdf/jdbc-rowset-tutorial-1.5.0.pdf
http://java.sun.com/javase/6/docs/technotes/guides/jdbc/
http://java.sun.com/javase/6/docs/technotes/guides/jdbc/getstart/GettingStartedTOC.fm.html
http://java.sun.com/products/jdbc/articles.html
Get disconnected with CachedRowSet -> Javaworld Article -> http://www.javaworld.com/javaworld/jw-02-2001/jw-0202-cachedrow.html
*