sqlite数据库 java_【Java】操作Sqlite数据库

首先在https://github.com/xerial/sqlite-jdbc下载jar包

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class MainProcess {

public static void main(String[] args) {

Connection connection = null;

try {

// create a database connection

connection = DriverManager.getConnection("jdbc:sqlite:sample.db");

Statement statement = connection.createStatement();

statement.setQueryTimeout(30); // set timeout to 30 sec.

statement.executeUpdate("drop table if exists person");

statement.executeUpdate("create table person (id integer, name string)");

statement.executeUpdate("insert into person values(1, ‘leo‘)");

statement.executeUpdate("insert into person values(2, ‘yui‘)");

ResultSet rs = statement.executeQuery("select * from person");

while (rs.next()) {

// read the result set

System.out.println("name = " + rs.getString("name"));

System.out.println("id = " + rs.getInt("id"));

}

} catch (SQLException e) {

// if the error message is "out of memory",

// it probably means no database file is found

System.err.println(e.getMessage());

} finally {

try {

if (connection != null)

connection.close();

} catch (SQLException e) {

// connection close failed.

System.err.println(e);

}

}

}

}

【Java】操作Sqlite数据库

标签：except   str   sys   http   create   base   timeout   creat   rman

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：http://www.cnblogs.com/verstin/p/6536133.html