如何从Firefox获取书签
问题描述:
如何使用java从firefox获取书签.我想要一些示例代码来获取书签并将其存储到数据库中.
How to get bookmarks from firefox using java.I want some sample code for getting bookmarks and store them into database.
答
Firefox将书签保存在SQLLite中从您开始的DB操作系统将需要一个 JDBC驱动程序 [
Firefox holds the bookmarks in a SQLLite DB os to start with you''ll need a JDBC driver[^]
Here''s an example I found:
import java.sql.*;
public class firefoxBookmarksReader {
public static void main(String[] args) throws Exception {
Class.forName("org.sqlite.JDBC");
// replace the path appropriately depending on the location of places.sqlite
Connection conn = DriverManager.getConnection(
"jdbc:sqlite:/home/deepak/.mozilla/firefox/yvf7p20d.default/places.sqlite//");
if(conn==null)
{
System.out.println("ERROR");
}
System.out.println(conn.toString());
Statement stat = conn.createStatement();
ResultSet rs = stat.executeQuery("select * from moz_bookmarks;");
while (rs.next()) {
System.out.println("id = " + rs.getString("id"));
System.out.println("keyword = " + rs.getString("keyword_id"));
System.out.println("title = " + rs.getString("title"));
}
rs.close();
conn.close();
}
}