FileDocCategorySizeDatePackage
InsertRowBug.javaAPI DocExample1720Fri Apr 06 22:35:46 BST 2001None

InsertRowBug

public class InsertRowBug extends Object

Fields Summary
Constructors Summary
Methods Summary
public static voidmain(java.lang.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());
        }