executeUpdate("create table t (s nvarchar(10))"); s.executeUpdate("insert into t values ('ö')"); s.executeUpdate("insert into t values (null)"); try (ResultSet rs = s.executeQuery("select s from t")) { while (rs.next()) println(rs.getNString(1)); } } finally { s....
)"); ps.setInt(1, 1); ps.setObject(2, ldtSent); ps.executeUpdate(); ResultSet rs = st.executeQuery("SELECT dt FROM foo WHERE id=1"); rs.next(); final LocalDateTime ldtRcvd = rs.getObject(1, LocalDateTime.class); System.out.printf("LocalDateTime rcvd: %s%n", ldtRcvd.toString()...
// repConn.createStatement().execute("insert into Address values (5,'401 Arapho Rd.','Richardson','TX','70440')"); // repConn.createStatement().executeUpdate("update Address set state = 'CA' where addressid = 5"); System.out.println("Update Database"); repConn.commit(); } catch (E...