Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void createDatabase()
- {
- try {
- Class.forName("org.sqlite.JDBC");
- c = DriverManager.getConnection("jdbc:sqlite:SchemaStore.db");
- System.out.println("Opened database successfully");
- stmt = c.createStatement();
- String sql = "CREATE TABLE schemainfo " +
- "(DatabaseName TEXT NOT NULL," +
- " RelationName TEXT NOT NULL," +
- " FieldName PRIMARY KEY TEXT NOT NULL," +
- " FieldType TEXT NOT NULL," +
- " PartOfPrimKey BOOLEAN," +
- " PartOfForKey BOOLEAN," +
- " ParentRelation TEXT," +
- " ParentField TEXT)";
- stmt.executeUpdate(sql);
- stmt.close();
- c.close();
- } catch ( Exception e ) {
- System.err.println( e.getClass().getName() + ": " + e.getMessage() );
- System.exit(0);
- }
- };
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement