|
/*
* Copyright (c) Ian F. Darwin, http://www.darwinsys.com/, 1996-2002. All rights
* reserved. Software written by Ian F. Darwin and others. $Id: LICENSE,v 1.8
* 2004/02/09 03:33:38 ian Exp $
*
* Redistribution and use in source and binary forms, with or without
* modification, are permitted provided that the following conditions are met:
* 1. Redistributions of source code must retain the above copyright notice,
* this list of conditions and the following disclaimer. 2. Redistributions in
* binary form must reproduce the above copyright notice, this list of
* conditions and the following disclaimer in the documentation and/or other
* materials provided with the distribution.
*
* THIS SOFTWARE IS PROVIDED BY THE AUTHOR AND CONTRIBUTORS ``AS IS'' AND ANY
* EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
* WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
* DISCLAIMED. IN NO EVENT SHALL THE AUTHOR OR CONTRIBUTORS BE LIABLE FOR ANY
* DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
* (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
* LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
* ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
* (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
* SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
*
* Java, the Duke mascot, and all variants of Sun's Java "steaming coffee cup"
* logo are trademarks of Sun Microsystems. Sun's, and James Gosling's,
* pioneering role in inventing and promulgating (and standardizing) the Java
* language and environment is gratefully acknowledged.
*
* The pioneering role of Dennis Ritchie and Bjarne Stroustrup, of AT&T, for
* inventing predecessor languages C and C++ is also gratefully acknowledged.
*/
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
public class InsertRowBug {
public static void main(String args[]) {
String url;
// url = "jdbc:odbc:SQL Anywhere 5.0 Sample";
// url = "jdbc:oracle:thin:@server:1521:db570";
url = "jdbc:odbc:RainForestDSN";
String driver;
//driver = "oracle.jdbc.driver.OracleDriver";
driver = "sun.jdbc.odbc.JdbcOdbcDriver";
String user, pass;
user = "student";
pass = "student";
Connection con;
Statement stmt;
ResultSet uprs;
try {
Class.forName(driver);
} catch (java.lang.ClassNotFoundException e) {
System.err.println(e);
return;
}
try {
con = DriverManager.getConnection(url, user, pass);
stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
uprs = stmt.executeQuery("SELECT * FROM Music_Recordings");
// Check the column count
ResultSetMetaData md = uprs.getMetaData();
System.out.println("Resultset has " + md.getColumnCount()
+ " cols.");
int rowNum = uprs.getRow();
System.out.println("row1 " + rowNum);
uprs.absolute(1);
rowNum = uprs.getRow();
System.out.println("row2 " + rowNum);
uprs.next();
uprs.moveToInsertRow();
uprs.updateInt(1, 150);
uprs.updateString(2, "Madonna");
uprs.updateString(3, "Dummy");
uprs.updateString(4, "Jazz");
uprs.updateString(5, "Image");
uprs.updateInt(6, 5);
uprs.updateDouble(7, 5);
uprs.updateInt(8, 15);
uprs.insertRow();
uprs.close();
stmt.close();
con.close();
} catch (SQLException ex) {
System.err.println("SQLException: " + ex.getMessage());
}
}
}
|