• 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
  
• Store and retrieve an object from a table
  
• Retrieve an Image
  
• Insert an Image
  
• Connect to an Oracle database with JDBC
  
• Connect to Oracle using a connection pool
  
• Get JDBC driver for major database vendors
  
• Handle dates
  
• Call a stored procedure
  
• Stored procedure with Input/Output parms and a ResultSet
  
• Fix incomplete field returned by the ResultSet
  
• Get row count from SQL
  
• Transfer a ResultSet to a JTable
  
• List tables in a database
  
• Display ResultSet data in an HTML Table in Servlet
  
• Detect SQL error or warning
  
• Make DSN-less connection
  
• Read Excel worksheet
  
• Handle Excel files
  
• Select a CharSet when connecting to DBMS
  
• Get current date using JDBC
  
• Enable JDBC logging
  
• Detect if a table exists
  
• Convert a ResultSet in XML
  
• Escape special character in a LIKE clause
  
• Insert the current date
  
• Log the SQL Statements
  

Database

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