JDBC差不多,如果你熟悉JDBC的话,也有图形化的工具,可以用图形化的工具建表什么的,比较容易。
下面是一个小例子:
[java]
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- /**
- *
- * @author XXX
- * @version 1.0.0
- * @2013-01-09 09:34:15
- */
- public class HelloSqlite {
- public static void main(String[] args) {
- // 加载驱动
- try {
- Class.forName("org.sqlite.JDBC");
- } catch (ClassNotFoundException e) {
- // TODO Auto-generated catch block
- // e.printStackTrace();
- System.out.println("数据库驱动未找到!");
- }
- // 得到连接 会在你所填写的目录建一个你命名的文件数据库
- Connection conn;
- try {
- conn = DriverManager.getConnection("jdbc:sqlite:c:/test.db",null,null);
- // 设置自动提交为false
- conn.setAutoCommit(false);
- Statement stmt = conn.createStatement();
- //判断表是否存在
- ResultSet rsTables = conn.getMetaData().getTables(null, null, "student", null);
- if(rsTables.next()){
- System.out.println("表存在,创建表的事情不要做了");
- } else {
- stmt.executeUpdate("create table student (id,name);");
- }
- stmt.executeUpdate("insert into student values (1,'hehe');");
- stmt.executeUpdate("insert into student values (2,'xixi');");
- stmt.executeUpdate("insert into student values (3,'haha');");
- // 提交
- conn.commit();
- // 得到结果集
- ResultSet rs = stmt.executeQuery("select * from student;");
- while (rs.next()) {
- System.out.println("id = " + rs.getString("id"));
- System.out.println("name = " + rs.getString("name"));
- }
- rs.close();
- conn.close();
- } catch (SQLException e) {
- e.printStackTrace();
- System.out.println("SQL异常!");
- }
- }
- }
先要到网上下个 sqlitejdbc.jar 的包,下个支持JAVA的就行了。下载地址推荐
http://www.xerial.org/maven/repository/artifact/org/xerial/sqlite-jdbc/3.7.2/