Jdbc

What is JDBC?

JDBC stands for Java Database Connectivity.

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

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

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
*

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-Share Alike 2.5 License.