jdbc连接sqllite
来源:互联网 发布:电脑网络usb共享给手机 编辑:程序博客网 时间:2024/05/21 16:40
import java.sql.*;
public class TestSQLite {
/**
* @param args
*/
public static void main(String args[])
{
try{
Class.forName("org.sqlite.JDBC");
Connection con = DriverManager.getConnection("jdbc:sqlite:G:\\zieckey.db");
Statement stat = con.createStatement();
stat.executeUpdate("drop table if exists jester");
stat.executeUpdate("create table jester(name varchar(20),salary int);");//create table two row
stat.executeUpdate("insert into jester values('BEHOLD',200);");
stat.executeUpdate("insert into jester values('GIST',300);");
ResultSet rs = stat.executeQuery("select * from behold;");
while(rs.next())
{
System.out.print("name = "+rs.getString("name")+" ");
System.out.println("salary = "+rs.getString("salary"));
}
rs.close();
con.close();
}catch(Exception e){
e.printStackTrace();
}
}
}
public class TestSQLite {
/**
* @param args
*/
public static void main(String args[])
{
try{
Class.forName("org.sqlite.JDBC");
Connection con = DriverManager.getConnection("jdbc:sqlite:G:\\zieckey.db");
Statement stat = con.createStatement();
stat.executeUpdate("drop table if exists jester");
stat.executeUpdate("create table jester(name varchar(20),salary int);");//create table two row
stat.executeUpdate("insert into jester values('BEHOLD',200);");
stat.executeUpdate("insert into jester values('GIST',300);");
ResultSet rs = stat.executeQuery("select * from behold;");
while(rs.next())
{
System.out.print("name = "+rs.getString("name")+" ");
System.out.println("salary = "+rs.getString("salary"));
}
rs.close();
con.close();
}catch(Exception e){
e.printStackTrace();
}
}
}
- jdbc连接sqllite
- Android中使用jdbc连接Sqllite
- java连接sqllite代码
- java连接sqllite数据库
- SqlLite连接字符串
- js连接sqllite数据库
- Java新手之SqlLite连接
- SQLlite
- sqllite
- SQLLITE
- sqllite
- sqllite
- SqlLite
- SqlLite---
- jdbc连接
- JDBC连接
- JDBC连接
- JDBC连接
- uva 297
- 对C语言编程者的Verilog开发指南实例
- Ans2_5.特定数字组成平方数
- apache设置[禁止列出目录/显示index.php]
- linux常用命令(一)
- jdbc连接sqllite
- hdu4268 Alice and Bob
- Redis 远程连接
- 802.11 wireless 1(主要还是学习ccna wireless的体系)
- 关于白宫开放出来的开源代码- wh-app-android
- 802.11 wireless 2
- Javascript学习第一季(8)
- 802.11 wireless 3
- 长春网络赛hdu4272LianLianKan