Advertisement
thoredge

Scala Dynamic ORM - Database Setup

Apr 14th, 2011
116
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Scala 0.53 KB | None | 0 0
  1. import java.sql.{ResultSetMetaData, DriverManager}
  2.  
  3. Class.forName("org.h2.Driver");
  4. val conn = DriverManager.getConnection("jdbc:h2:mem:ory", "sa", "")
  5. conn.createStatement.execute("""
  6.  create table MyTable (
  7.    id integer not null,
  8.    name varchar(255) not null,
  9.    age integer
  10.  )
  11. """)
  12. conn.createStatement.execute("insert into MyTable values (1, 'johnny', 25)")
  13. conn.createStatement.execute("insert into MyTable values (1, 'jeannie', 16)")
  14. conn.createStatement.execute("insert into MyTable values (1, 'johanna', null)")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement