Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.{ResultSetMetaData, DriverManager}
- Class.forName("org.h2.Driver");
- val conn = DriverManager.getConnection("jdbc:h2:mem:ory", "sa", "")
- conn.createStatement.execute("""
- create table MyTable (
- id integer not null,
- name varchar(255) not null,
- age integer
- )
- """)
- conn.createStatement.execute("insert into MyTable values (1, 'johnny', 25)")
- conn.createStatement.execute("insert into MyTable values (1, 'jeannie', 16)")
- conn.createStatement.execute("insert into MyTable values (1, 'johanna', null)")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement