读书人

jdbc怎么用代码创建sqlite数据库

发布时间: 2012-04-06 12:22:24 作者: rapoo

jdbc如何用代码创建sqlite数据库?
有做过的吗?说说api,谢谢。

[解决办法]
添加 相关包然后

Java code
package sqlite;import java.sql.*;public class Test {    public static void main(String[] args) throws Exception {        Class.forName("org.sqlite.JDBC");        Connection conn = DriverManager.getConnection("jdbc:sqlite:test.db");        Statement stat = conn.createStatement();        stat.executeUpdate("drop table if exists people;");        stat.executeUpdate("create table people (name, occupation);");        PreparedStatement prep = conn.prepareStatement(                "insert into people values (?, ?);");        prep.setString(1, "Gandhi");        prep.setString(2, "politics");        prep.addBatch();        prep.setString(1, "Turing");        prep.setString(2, "computers");        prep.addBatch();        prep.setString(1, "Wittgenstein");        prep.setString(2, "smartypants");        prep.addBatch();        conn.setAutoCommit(false);        prep.executeBatch();        conn.setAutoCommit(true);        ResultSet rs = stat.executeQuery("select * from people;");        while (rs.next()) {            System.out.println("name = " + rs.getString("name"));            System.out.println("job = " + rs.getString("occupation"));        }        rs.close();        conn.close();    }} 

读书人网 >J2SE开发

热点推荐