Java操作数据库Sqlite样例代码

Java对数据的操作需要通过JDBC中间件，需要先配置好sqlite-jdbc-(版本号).jar。

JDBC学习教程可参考：http://www.runoob.com/w3cnote/jdbc-use-guide.html

Sqlite教程JAVA部分教程：http://www.runoob.com/sqlite/sqlite-java.html

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class SqliteJDBC {
    public static void main(String[] args) {
        Connection cnt = null;
        try {
            // 加载驱动程序
            Class.forName("org.sqlite.JDBC");
            // 创建连接对象
            cnt = DriverManager.getConnection("jdbc:sqlite:test.db");
            System.out.println("Opened database successfully.");
            // 创建会话状态
            Statement stmt = cnt.createStatement();

            // 建表 
            String sql = "CREATE TABLE COMPANY "+
            "(ID INT PRIMARY KEY NOT NULL, "+
            "NAME TEXT NOT NULL, "+
            "AGE INT NOT NULL, "+
            "ADDRESS CHAR(50), "+
            "SALARY REAL);";
            stmt.executeUpdate(sql);
            System.out.println("create table successfully.");
            // 填入数据
            sql = "INSERT INTO COMPANY (ID, NAME, AGE, ADDRESS, SALARY) "+ "VALUES (1, 'Paul', 32, 'California', 20000.00);";
            stmt.executeUpdate(sql);
            sql = "INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) " + "VALUES (4, 'Mark', 25, 'Rich-Mond ', 65000.00 );"; 
            stmt.executeUpdate(sql);
            System.out.println("fill data successfully.");
            // 数据查询
            Query(stmt);
            // 更新数据操作
            sql = "UPDATE COMPANY set SALARY = 25000.00 where ID=1;";
            stmt.executeUpdate(sql);
            System.out.println("update successfully.");
            Query(stmt);

            // 删除数据操作
            sql = "DELETE from COMPANY where ID=4;";
            stmt.executeUpdate(sql);
            System.out.println("delete successfully.");
            Query(stmt);
                
            // 关闭声明，及连接
            stmt.close();
            cnt.close();
        }catch(Exception e){
            System.err.println(e.getClass().getName() + ":" + e.getMessage());
            System.exit(0);
        }
    }

    // 单独创建查询功能模块
    public static void Query(Statement stmt) throws SQLException{
        String sql = "SELECT * FROM COMPANY;";
        ResultSet rs = stmt.executeQuery(sql);
        while(rs.next()) {
             int ID = rs.getInt("ID");
             String Name = rs.getString("NAME");
             int Age = rs.getInt("AGE");
             String Address = rs.getString("ADDRESS");
             float Salary = rs.getFloat("SALARY");
             System.out.println( "ID = " + ID );
             System.out.println( "NAME = " + Name );
             System.out.println( "AGE = " + Age );
             System.out.println( "ADDRESS = " + Address );
             System.out.println( "SALARY = " + Salary );
             System.out.println();
        }
        rs.close();
    }
}