mac下eclipse使用sqlite的问题
package com.wangbylove.db;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class SqliteTest {
public static void main(String[] args) {
Connection conn = null;
try {
//System.out.println( System.getProperty("java.library.path"));
System.setProperty("java.library.path", ".");
Class.forName("org.sqlite.JDBC");
conn = DriverManager.getConnection("jdbc:sqlite:hello.db");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from user");
while(rs.next()){
String id = rs.getString(1);
String code= rs.getString(2);
System.out.println("用户名:" + id + ", 密码:" + code);
}
rs.close();
stmt.close();
conn.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
Exception in thread "main" java.lang.UnsatisfiedLinkError: no sqlitejdbc in java.library.path