SQLite JDBC Demo

最新推荐文章于 2025-04-23 07:12:18 发布

SuperEditor

最新推荐文章于 2025-04-23 07:12:18 发布

阅读量1k

点赞数

CC 4.0 BY-SA版权

分类专栏： SQLite Java 文章标签： sqlite jdbc exception table insert string

本文链接：https://blog.youkuaiyun.com/SuperEditor/article/details/6174517

SQLite 同时被 2 个专栏收录

1 篇文章

订阅专栏

Java

1 篇文章

订阅专栏

本文通过一个Java程序示例展示了如何使用SQLite进行数据库操作，包括创建表、插入数据、批量提交及查询记录等基本功能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

package cz.sqlite;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;

public class Test {
public static void main(String[] args) {
  try {
   Class.forName("org.sqlite.JDBC");
   Connection conn = DriverManager
     .getConnection("jdbc:sqlite:g:/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, "Wittgenstein");
   prep.setString(2, "smartypants");
   prep.addBatch();
   conn.setAutoCommit(false);
   prep.executeBatch();
   conn.setAutoCommit(true);
   ResultSet rs = stat.executeQuery("select * from people limit 1 offset 1;");
   while (rs.next()) {
    System.out.println("name = " + rs.getString("name"));
    System.out.println("job = " + rs.getString("occupation"));
   }
   rs.close();
   conn.close();
  } catch (Exception e) {
   e.printStackTrace();
  }
}
}