import java.sql.*;

public class SQLite1 {
	
	public static void main (String args[]) throws Exception {
		// Регистрируем драйвер
		Class.forName("org.sqlite.JDBC");
		// Подготавливаем соединение
		Connection conn = DriverManager.getConnection("jdbc:sqlite:test.db");
		Statement stat = conn.createStatement();
		// stat.executeUpdate("DROP TABLE IF EXISTS people;");
		// stat.executeUpdate("CREATE TABLE people (name, occupation);");
		PreparedStatement prep = conn.prepareStatement("INSERT INTO people VALUES (?, ?);");
		
		prep.setString(1, "Gandhi");
		prep.setString(2, "Politics");
		prep.addBatch();
		prep.setString(1, "Turing");
		prep.setString(2, "Computers");
		prep.addBatch();
		prep.setString(1, "Leonchik");
		prep.setString(2, "Programmer");
		prep.addBatch();
		
		conn.setAutoCommit(false);
		prep.executeBatch();
		conn.setAutoCommit(true);
		
		ResultSet rs = stat.executeQuery("SELECT name, occupation FROM people;");
		
		while(rs.next()) {
			System.out.println("Name: " + rs.getString("name") 
				+ "\t\tJob:  " + rs.getString("occupation"));
		}
		rs.close();
		conn.close();
	}
}