package test;
import java.sql.*;
public class Test {
public static void main(String[] args) throws Throwable {
Class.forName("org.sqlite.JDBC");
Connection con = DriverManager.getConnection("jdbc:sqlite:C:/data/work/sqlite/test.db");
Statement s = con.createStatement();
ResultSet rs = s.executeQuery("select * from x;");
System.out.println("id,name");
while (rs.next()) {
System.out.println(rs.getString(1) + "\t" + rs.getString(2));
}
rs.close();
s.close();
con.close();
}
}
name,job
xxxx x
xxxx x
xx2d x
xxxx x
xxxx x
xxxx x
xxxx x
xxxx x
A0001 test
A0001 test
A0001 test
A0002 test2
- 繋がりました!
- sqliteはチョットしたことに使えそうです。