private boolean insertRecordOnMultipleTables() { Connection conn = getConnection(); conn.setAutoCommit(false); PreparedStatement ps = conn.prepareStatement("insert into person values ('Ada', 36)"); ps.executeUpdate(); int totalRecords = selectRecord(); conn.commit(); conn.setAutoCommit(true); ps.close(); conn.close(); return totalRecords > 0; } private int selectRecord() { int result = 0; Connection conn = getConnection(); PreparedStatement ps = conn.prepareStatement("select count(1) from person"); ResultSet rs = ps.executeQuery(); if (rs.next()) { result = rs.getInt(1); } rs.close(); ps.close(); conn.close(); return result; }
See where the problem is?