Sqlite JDBC 驱动示例

发布时间：2020-12-12 20:25:00 所属栏目：百科来源：网络整理

导读：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 {pu

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 = 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;");
			while (rs.next()) {
				System.out.println("name = " + rs.getString("name"));
				System.out.println("job = " + rs.getString("occupation"));
			}
			rs.close();
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		

	}

}

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!