Java SQLite Tutorial

 

1. JDBC jar 다운받기

 

https://bitbucket.org/xerial/sqlite-jdbc/downloads 

 

 

2. Classpath 에 jar 연결하기.

 

 

3. DB and table creation

 

Connection conn = null;

Statement stmt = null;

try {

Class.forName( "org.sqlite.JDBC" );

conn = DriverManager.getConnection( "jdbc:sqlite:test.db" );

stmt = conn.createStatement();

String sql = "CREATE TABLE test " +

"(_id INT PRIMARY KEY NOT NULL," +

" name TEXT NOT NULL, " + 

" image BLOB NOT NULL )"; 

stmt.executeUpdate(sql);

} catch ( Exception e ) {

System.err.println( e.getClass().getName() + ": " + e.getMessage() );

System.exit(0);

}

finally{

SQLiteUtils.close( stmt );

}

System.out.println("DB creation success.");

return conn;

 

 

4. Transactions