Real'sHowTo

Custom Search

• Java
  • Language
  • String and Number
  • Applet
  • AWT
  • Swing
  • Environment
  • IO
  • Javascript interaction
  • JDBC
  • Thread
  • Networking
  • JSP & Servlet
  • XML
  • Internationalization
  • Security
  • JNI/JNA
  • Date & Time
  • Open Source
  • Varia
  • Deprecated
  • Links
• Javascript & Web
  • Language
  • HTML & CSS
  • Form
  • Java interaction
  • Mobile
  • Varia
• Powerbuilder
  • Powerscript
  • Win API & Registry
  • Datawindow
  • PFC
  • Common problems
  • EAServer
  • Database
  • Links
• More HowTo
  • WSH & VBScript
  • Windows, Batch, PDF, Internet
  • Links
• Varia
  • Download
  • Real's HowTo FAQ
  • Contact me
  • Donate!
  • Funny 1
  • Funny 2
  • Funny 3
  • Funny 4
  • One line
  • Deep Thoughts
  • Ascii Art
• Big Index
• Latest Comments

Database HowTo

• General
  • Get JDBC driver for major database vendors
  • Connect to a database via JDBC-ODBC
  • SELECT data from a table
  • INSERT data into a table
  • MODIFY data in a table
  • DELETE data in a table
  • Test for an empty ResultSet
  • Get row count from SQL
  • Store and retrieve an object from a table
  • Retrieve an Image
  • Insert an Image
  • Call a stored procedure
  • Stored procedure with Input/Output parms and a ResultSet
  • Fix incomplete field returned by the ResultSet
  • Transfer a ResultSet to a JTable
  • Detect SQL error or warning
  • Make DSN-less connection
  • Select a CharSet when connecting to DBMS
  • List tables in a database
  • Enable JDBC logging
  • Detect if a table exists
  • Convert a ResultSet in XML
  • Display ResultSet data in an HTML Table in Servlet
  • Escape special character in a LIKE clause
  • Log the SQL Statements
  • Insert data in batch mode
  • Retrieve large ResultSet
• Date and time in JDBC
  • Handle dates
  • Get current date using JDBC
  • Insert the current date
• Excel
  • Read Excel worksheet
  • Handle Excel files
• Oracle
  • Connect to an Oracle database with JDBC
  • Connect to Oracle using a connection pool
  • Retrieve the generated keys (JDBC Oracle)
  • Debug Oracle JDBC connection
  • Connect to an Oracle database using Kerberos
  • Identify the connected program to an Oracle database
  • Use a CHAR field in the WHERE clause in a PreparedStatement

Database HowTo

Written and compiled by Réal Gagnon ©1998-2013
[ home ]