c#中SQLite 如何在程序代码中创建表
解决方案 »
- varchar 和 nvarchar的选择?
- 如何利用sql语句实现类似powerbuilder中重复列值
- 日志提示错误15457是什么意思
- sql 嵌套统计性能问题。求高手解答 急!急急急急急!!
- 请教SQL查询某几列除外的所有列
- 请SQL SERVER 问里有没有一个计算两数除之后得余数的函数?
- SQL表约束问题.
- sql 安装时出现”无法找到动态链接库SQLUNIRL.dll于指定的路径“c:\winnt\siystem 32 在线等!!谢谢!
- 如何在where子句中写if或其他判断语句
- SQL數据庫的導入/導出向導不能用了?
- 大家能看出来这个SQL语句有什么错误不?
- 小弟一新人,今天开始学习SQL,各位大侠们能给点建议吗?
http://ronald9-qq-com.iteye.com/blog/962183
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();
}
} 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();
}
}
注意:1. Connection conn = DriverManager.getConnection("jdbc:sqlite:test.db");
如果指定名称所代表的数据库不存在则自动创建.如果存在则直接使用. 2. stat.executeUpdate("drop table if exists people;");
stat.executeUpdate("create table people (name, occupation);");
通过代码来创建删除表. 没啥好说的了.