tengo
este ejemplo a ver si te sirve
Saludos
Gerardo Santillana
IT Department
Delphi Mechatronic
Systems
Phone USA (956) 554 5832
Phone MX 01868 8128163
x.5832
Saludos, foreros.
¿Algún alma caritativa me podría dar un ejemplo básico de como utilizar
jdbc nativo para un insert y un update, por ejemplo (por supuesto en
una aplicación java en el ISeries), o al menos decirme donde puedo
encontrar uno ?
Gracias anticipadas
--
Saludos.
Fernando Pérez
Cerámica Saloni. Dpto. Sistemas
****************************************************************************************
Note: If the reader of this message is not the intended recipient, or
an employee or agent responsible for delivering this message to the
intended recipient, you are hereby notified that any dissemination,
distribution or copying of this communication is strictly prohibited.
If you have received this communication in error, please notify us
immediately by replying to the message and deleting it from your
computer. Thank you.
****************************************************************************************
|
//////////////////////////////////////////////////////////////////////////////////
//
// JDBCPopulate example. This program uses the AS/400 JDBC driver to
// create and populate a table.
//
// Command syntax:
// JDBCPopulate system collectionName tableName
//
// For example,
// JDBCPopulate MySystem MyLibrary MyTable
//
//////////////////////////////////////////////////////////////////////////////////
import java.lang.*;
import java.sql.*;
import java.util.*;
import com.ibm.db2.jdbc.app.*;
class JDBCPopulate
{
// Strings to be added in the WORD column of the table.
private static final String words[]
= { "One", "Two", "Three", "Four", "Five",
"Six", "Seven", "Eight", "Nine", "Ten",
"Eleven", "Twelve", "Thirteen", "Fourteen", "Fifteen",
"Sixteen", "Seventeen","Eighteen", "Nineteen", "Twenty" };
public static void main (String[] parameters)
{
// Check the input parameters.
if (parameters.length != 3) {
System.out.println("");
System.out.println("Usage:");
System.out.println("");
System.out.println(" JDBCPopulate system collectionName tableName");
System.out.println("");
System.out.println("");
System.out.println("For example:");
System.out.println("");
System.out.println("");
System.out.println(" JDBCPopulate MySystem MyLibrary MyTable");
System.out.println("");
return;
}
String system = parameters[0];
String collectionName = parameters[1];
String tableName = parameters[2];
Connection connection = null;
try {
// Load the AS/400 Toolbox for Java JDBC driver.
//DriverManager.registerDriver(new com.ibm.db2.jdbc.app.DB2Driver ());
//DriverManager.registerDriver(new com.ibm.as400.access.AS400JDBCDriver());
// Class.forName("com.ibm.as400.access.AS400JDBCDriver");
Class.forName("com.ibm.db2.jdbc.app.DB2Driver");
// Get a connection to the database. Since we do not
// provide a user id or password, a prompt will appear.
//
// Note that we provide a default schema here so
// that we do not need to qualify the table name in
// SQL statements.
//
connection = DriverManager.getConnection ("jdbc:db2://"
// connection = DriverManager.getConnection ("jdbc:as400://"
+ system + "/" + collectionName);
// Drop the table if it already exists.
try {
Statement dropTable = connection.createStatement ();
dropTable.executeUpdate ("DROP TABLE " + tableName);
}
catch (SQLException e) {
// Ignore.
}
// Create the table.
Statement createTable = connection.createStatement ();
createTable.executeUpdate ("CREATE TABLE " + tableName
+ " (I INTEGER, WORD VARCHAR(20), SQUARE INTEGER, "
+ " SQUAREROOT DOUBLE)");
// Prepare a statement for inserting rows. Since we
// execute this multiple times, it is best to use a
// PreparedStatement and parameter markers.
PreparedStatement insert = connection.prepareStatement ("INSERT INTO "
+ tableName + " (I, WORD, SQUARE, SQUAREROOT) "
+ " VALUES (?, ?, ?, ?)");
// Populate the table.
for (int i = 1; i <= words.length; ++i) {
insert.setInt (1, i);
insert.setString (2, words[i-1]);
insert.setInt (3, i*i);
insert.setDouble (4, Math.sqrt(i));
insert.executeUpdate ();
}
// Output a completion message.
System.out.println ("Table " + collectionName + "." + tableName
+ " has been populated.");
}
catch (Exception e) {
System.out.println ();
System.out.println ("ERROR: " + e.getMessage());
}
finally {
// Clean up.
try {
if (connection != null)
connection.close ();
}
catch (SQLException e) {
// Ignore.
}
}
System.exit (0);
}
}
