HomeDigital EditionSys-Con RadioSearch Java Cd
Advanced Java AWT Book Reviews/Excerpts Client Server Corba Editorials Embedded Java Enterprise Java IDE's Industry Watch Integration Interviews Java Applet Java & Databases Java & Web Services Java Fundamentals Java Native Interface Java Servlets Java Beans J2ME Libraries .NET Object Orientation Observations/IMHO Product Reviews Scalability & Performance Security Server Side Source Code Straight Talking Swing Threads Using Java with others Wireless XML
 

"The Data Series - JDBC"
Vol. 3, Issue 4, p. 64

	

Listing 1.
  
Statement Statmt;  
ResultSet Res;  

Statmt = Con.createStatement();  
Res    = Statmt.executeQuery( "SELECT FORENAME,SURNAME,AGE FROM CONTACT WHERE FORENAME LIKE 'A%'" );  

while (Res.next()){  
  System.out.println( "Forename: " + Res.getString(1) );      
  System.out.println( "Surname : " + Res.getString(2) );  
  System.out.println( "Age     : " + Res.getInt(3) );  
}  

Statmt.close();  
Res.close();  

Listing 2.
  
Statement Statmt;  
ResultSet Res;  

Statmt = Con.createStatement();   
Statmt.executeUpdate( "INSERT INTO CONTACT(FORENAME,SURNAME,AGE) VALUES('Alan','Williamson',78)" );  
Statmt.close();
  
      
 

All Rights Reserved
Copyright ©  2004 SYS-CON Media, Inc.
  E-mail: [email protected]

Java and Java-based marks are trademarks or registered trademarks of Sun Microsystems, Inc. in the United States and other countries. SYS-CON Publications, Inc. is independent of Sun Microsystems, Inc.