bd

/*private void doTest1() throws SQLException {

        Statement stmt = conn.createStatement();
        ResultSet rset = stmt.executeQuery("SELECT IMIE, NAZWISKO, PENSJA FROM PRACOWNICY");

        System.out.println("TEST1 - Query result:");
        int i = 1;
        while (rset.next()) {
            System.out.println("[" + i + "]:" + rset.getString(1));
            System.out.println("[" + i + "]:" + rset.getString(2));
	    System.out.println("[" + i + "]:" + rset.getString(3));
            i++;
        }

        rset.close();
        stmt.close();
    }*/

    /**
     * Using precompiled statement object
     * @throws SQLException
     */
    /*private void doTest2() throws SQLException {

	String sql = "UPDATE PRACOWNICY SET PENSJA = PENSJA + 100 WHERE ID =?";
        Statement stmt = conn.createStatement();
	PreparedStatement req = conn.prepareStatement(sql);
	ResultSet rset = stmt.executeQuery("SELECT ID, IMIE, NAZWISKO, PENSJA FROM PRACOWNICY WHERE PENSJA < 10000");

	while (rset.next())
	{
	req.setInt(1, rset.getInt(1));
	req.executeUpdate();
	}

        rset.close();
        stmt.close();
	req.close();
    }*/