SQLite练习

1、首先导包，sqlitejdbc-v033-nested.jar

2、编写代码：

package com.mqp.sqlite;


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


public class TestSQLite {
public static void main(String[] args) {
try {
// 连接SQLite的JDBC
Class.forName("org.sqlite.JDBC");


// 建立一个数据库名sqlite_test.db的连接，如果不存在就在当前目录下创建之
Connection conn = DriverManager
.getConnection("jdbc:sqlite:sqlite_test.db");


java.sql.Statement state = conn.createStatement();


//state.executeUpdate("drop table tbl1");// 删除表
state.executeUpdate("create table tbl1(name varchar(20),salary int)");// 创建一个表，两列
state.executeUpdate("insert into tbl1 values('张三',8000)");// 插入数据
state.executeUpdate("insert into tbl1 values('LiSi',7800)");
state.executeUpdate("insert into tbl1 values('WangWu',5800)");


// 查询数据放在结构集里面
ResultSet rs = state.executeQuery("select * from tbl1;");


while (rs.next()) {
System.out.print("name:" + rs.getString("name") + "------");// 列属性1
System.out.println("salary:" + rs.getInt("salary"));// 列属性2
}


// 关闭流
rs.close();
conn.close();


} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}


}
}

3.运行结果：

name:张三------salary:8000
name:LiSi------salary:7800
name:WangWu------salary:5800