A simple JDBC Update
/******************************************************************************/
/* */
/* FILE: JDBCUpdate.java */
/* */
/* A simple JDBC Update */
/* ==================== */
/* */
/* V1.00 24-JAN-1999 Te https://www.heimetli.ch */
/* */
/* ------------------------------------------------------------------------- */
/* */
/* This example was coded and tested with JDK1.2.2 */
/* */
/* Access was used as database, over the JDBC-ODBC bridge which comes */
/* with the JDK. */
/* */
/* To run this example, you need a database with the following properties: */
/* => no username */
/* => no password */
/* => a table called "Cust" */
/* => a column called "CUST_NO" with a numeric type */
/* => a system DSN called "Database" */
/* */
/******************************************************************************/
import java.sql.* ;
class JDBCUpdate
{
public static void main( String args[] )
{
try
{
/***********************************************************/
/* */
/* Since JDBC4 the following line is no longer necessary. */
/* */
/* See the comments in JDBC4Query.html */
/* */
/***********************************************************/
// Load the database driver
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" ) ;
// Get a connection to the database
Connection conn = DriverManager.getConnection( "jdbc:odbc:Database" ) ;
// Print all warnings
for( SQLWarning warn = conn.getWarnings(); warn != null; warn = warn.getNextWarning() )
{
System.out.println( "SQL Warning:" ) ;
System.out.println( "State : " + warn.getSQLState() ) ;
System.out.println( "Message: " + warn.getMessage() ) ;
System.out.println( "Error : " + warn.getErrorCode() ) ;
}
// Get a statement from the connection
Statement stmt = conn.createStatement() ;
// Execute the Update
int rows = stmt.executeUpdate( "UPDATE Cust SET CUST_NO = 9842 WHERE CUST_NO = 9841" ) ;
// Print how many rows were modified
System.out.println( rows + " Rows modified" ) ;
// Close the statement and the connection
stmt.close() ;
conn.close() ;
}
catch( SQLException se )
{
System.out.println( "SQL Exception:" ) ;
// Loop through the SQL Exceptions
while( se != null )
{
System.out.println( "State : " + se.getSQLState() ) ;
System.out.println( "Message: " + se.getMessage() ) ;
System.out.println( "Error : " + se.getErrorCode() ) ;
se = se.getNextException() ;
}
}
catch( Exception e )
{
System.out.println( e ) ;
}
}
}