JavaSE15_JDBC编程之Java链接Sqlite

来源：互联网发布：淘宝开店培训骗局编辑：程序博客网时间：2024/06/10 12:06

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());}}}

0 0