-- Dec 5 In-Class Exercise
JAVA addition:
while (rs.next()) {
int a = rs.getInt("a");
String b = rs.getString("b");
String c = rs.getString("c");
if (a > 5)
System.out.println(
"a: " + a + "\n" +
"b: " + b + "\n" +
"c: " + c + "\n"
);
}
MYSQL:
ALTER TABLE my_table ADD COLUMN c CHAR(1);
MariaDB [ICE1205]> UPDATE my_table SET c='a' WHERE a=1;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
MariaDB [ICE1205]> UPDATE my_table SET c='z' WHERE a=2;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
MariaDB [ICE1205]> UPDATE my_table SET c='p' WHERE a=3;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
MariaDB [ICE1205]> INSERT INTO my_table VALUES (123, "no", 'c');
Query OK, 1 row affected (0.00 sec)
MariaDB [ICE1205]> INSERT INTO my_table VALUES (123, "麒麟", 'r');
Query OK, 1 row affected (0.00 sec)
MariaDB [ICE1205]> DELETE FROM my_table WHERE c='r';
Query OK, 1 row affected (0.01 sec)
MariaDB [ICE1205]> INSERT INTO my_table VALUES (55, "麒麟", 'r');
Query OK, 1 row affected (0.01 sec)
MariaDB [ICE1205]> INSERT INTO my_table VALUES (4, "nice", 'e');
Query OK, 1 row affected (0.00 sec)
MariaDB [ICE1205]> INSERT INTO my_table VALUES (10, "cloud", 'l');
Query OK, 1 row affected (0.00 sec)
sherwyn@tapeworm ~/cs157a/ice1205 $ java -cp $JDBC JdbcTest
a: 123
b: no
c: c
a: 55
b: 麒麟
c: r
a: 10
b: cloud
c: l
(
Edited: 2018-12-06)
JAVA addition:
while (rs.next()) {
int a = rs.getInt("a");
String b = rs.getString("b");
String c = rs.getString("c");
if (a > 5)
System.out.println(
"a: " + a + "\n" +
"b: " + b + "\n" +
"c: " + c + "\n"
);
}
MYSQL:
ALTER TABLE my_table ADD COLUMN c CHAR(1);
MariaDB [ICE1205]> UPDATE my_table SET c='a' WHERE a=1;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
MariaDB [ICE1205]> UPDATE my_table SET c='z' WHERE a=2;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
MariaDB [ICE1205]> UPDATE my_table SET c='p' WHERE a=3;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
MariaDB [ICE1205]> INSERT INTO my_table VALUES (123, "no", 'c');
Query OK, 1 row affected (0.00 sec)
MariaDB [ICE1205]> INSERT INTO my_table VALUES (123, "麒麟", 'r');
Query OK, 1 row affected (0.00 sec)
MariaDB [ICE1205]> DELETE FROM my_table WHERE c='r';
Query OK, 1 row affected (0.01 sec)
MariaDB [ICE1205]> INSERT INTO my_table VALUES (55, "麒麟", 'r');
Query OK, 1 row affected (0.01 sec)
MariaDB [ICE1205]> INSERT INTO my_table VALUES (4, "nice", 'e');
Query OK, 1 row affected (0.00 sec)
MariaDB [ICE1205]> INSERT INTO my_table VALUES (10, "cloud", 'l');
Query OK, 1 row affected (0.00 sec)
sherwyn@tapeworm ~/cs157a/ice1205 $ java -cp $JDBC JdbcTest
a: 123
b: no
c: c
a: 55
b: 麒麟
c: r
a: 10
b: cloud
c: l