JavaSE15_JDBC编程之Java链接Sqlite

JDBC编程之Java链接Sqlite

1. 下载驱动SQLite Xerial Driver

2. 编辑Demo

package com.hoonee.javase.jdbc;

import java.io.File;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

/**
 * JDBC编程之链接Sqlite数据库
 * 
 * @author Hoonee
 * @mail hoonee@163.com
 */
public class SqliteDemo {
	public static void main(String[] args) {

		// 每次执行程序时，删除原来的数据库
		File demoDbFile = new File("src/com/hoonee/javase/jdbc/demo.db");
		if (demoDbFile.exists()) {
			demoDbFile.delete();
		}

		// 导入数据库驱动
		try {

			Class.forName("org.sqlite.JDBC");
			System.out.println("Load sqlite Driver sucess!");
		} catch (java.lang.ClassNotFoundException e) {

			System.out.println("Fail to Load sqlite Driver!");
			System.out.println(e.getMessage());

		}
		try {
			// 链接数据库
			String url = "jdbc:sqlite:src/com/hoonee/javase/jdbc/demo.db";
			Connection conn = DriverManager.getConnection(url);
			System.out.println("get connection sucessfully!");

			Statement stmt = conn.createStatement();
			System.out.println("create statement sucessfully!");

			// 创建表
			stmt.execute("CREATE TABLE t_demo(id integer primary key, name char(10))");

			// 插入数据
			stmt.execute("INSERT INTO t_demo(id, name) VALUES(1, 'sqlite')");
			stmt.execute("INSERT INTO t_demo(id, name) VALUES(2, 'mysql')");

			// 查询数据
			ResultSet rs = stmt.executeQuery("SELECT * FROM t_demo");
			System.out.println("execute query sucessfully!");
			System.out.println("id\tname");
			while (rs.next()) {
				String id = rs.getString("id");
				String name = rs.getString("name");
				System.out.println(id + "\t" + name);
			}

			// 关闭数据库资源
			stmt.close();
			System.out.println("close statement sucessfully!");
			conn.close();
			System.out.println("close connection sucessfully!");
		}

		catch (SQLException e) {
			System.out.println("Fail！");
			System.out.println(e.getMessage());
		}
	}
}