java sqlite 驱动下载_Sqlite JDBC 驱动示例

sqlite JDBC 驱动示例

JDBC驱动下载地址：

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.sqlException;

import java.sql.Statement;

public class sqliteJDBC {

public static void main(String[] args) {

try {

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

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

Connection conn = null;

try {

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