Sqlite作为一种轻量级的数据库,使用起来非常的方便。
1、下载Sqlitejdbc
网址:https://bitbucket.org/xerial/sqlite-jdbc
2、将下载到的jar可以直接放到工程中
3、使用
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Test {
private static Connection con;
private static Statement stmt;
private static ResultSet res;
public static void main(String[] args) {
try {
Class.forName("org.sqlite.JDBC");
con = DriverManager.getConnection("jdbc:sqlite://D:/db.db");
stmt = con.createStatement();
String sql = "SELECT * FROM user;";
res = stmt.executeQuery(sql);
while(res.next()){
System.out.println("id:"+res.getInt(1));
System.out.println("name:"+res.getString(2));
}
} catch (Exception e) {
e.printStackTrace();
}finally{
try {
res.close();
stmt.close();
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}