1.SQLiteJDBC

SQLiteJDBCDriver可以在这个网站下载https://bitbucket.org/xerial/sqlite-jdbc/overview，当前稳定版本sqlite-jdbc-3.7.2.jar

2. Java 代码

添加sqlite-jdbc-3.7.2.jar，与你添加其他jar包的方法一样。

1. importjava.sql.Connection;
2. importjava.sql.DriverManager;
3. importjava.sql.ResultSet;
4. importjava.sql.SQLException;
5. importjava.sql.Statement;
7. publicclassSQLiteTest
8. {
9. staticvoidmain(String[]args)throwsClassNotFoundException
10. //loadthesqlite-JDBCdriverusingthecurrentclassloader
11. Class.forName("org.sqlite.JDBC");
13. Connectionconnection=null;
14. try
15. //createadatabaseconnection
16. connection=DriverManager.getConnection("jdbc:sqlite:sample.db");
17. Statementstatement=connection.createStatement();
18. statement.setQueryTimeout(30);//settimeoutto30sec.
19. statement.executeUpdate("droptableifexistsperson");
20. statement.executeUpdate("createtableperson(idinteger,namestring)");
21. statement.executeUpdate("insertintopersonvalues(1,'leo')");
22. statement.executeUpdate("insertintopersonvalues(2,'yui')");
23. ResultSetrs=statement.executeQuery("select*fromperson");
24. while(rs.next())
25. //readtheresultset
26. System.out.println("name="+rs.getString("name"));
27. System.out.println("id="+rs.getInt("id"));
28. }
29. }
30. catch(SQLExceptione)
31. {
32. //iftheerrormessageis"outofmemory",
33. //itprobablymeansnodatabasefileisfound
34. System.err.println(e.getMessage());
35. finally
36. try
37. if(connection!=null)
38. connection.close();
39. catch(SQLExceptione)
40. //connectionclosefailed.
41. System.err.println(e);
42. }

（编辑：李大同）

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