SQLite
来源:互联网 发布:url短网址生成 java 编辑:程序博客网 时间:2024/06/07 08:05
从 sqlite-jdbc库下载 sqlite-jdbc-(VERSION).jar 的最新版本。
在您的 class 路径中添加下载的 jar 文件 sqlite-jdbc-(VERSION).jar,或者在 -classpath 选项中使用它,这将在后面的实例中进行讲解。
在学习下面部分的知识之前,您必须对 Java JDBC 概念有初步了解。如果您还未了解相关知识,那么建议您可以先花半个小时学习下 JDBC 教程相关知识,这将有助于您学习接下来讲解的知识。
package sqliteDemo;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class sqliteTest {
private static Connection c = null;
private static Statement stmt = null;
/**
* @param args
*/
public static void main(String[] args) {
try {
Class.forName("org.sqlite.JDBC");
c = DriverManager.getConnection("jdbc:sqlite:test.db");//如果数据库不存在,那么它就会被创建,最后将返回一个数据库对象。
System.out.println("Opened database successfully");
createdTable();
//insert();
//select();
//update();
//delete();
stmt.close();
c.close();
} catch ( Exception e ) {
System.err.println( e.getClass().getName() + ": " + e.getMessage() );
System.exit(0);
}
}
public static void createdTable() throws SQLException{
stmt = c.createStatement();
String sql = "CREATE TABLE COMPANY " +
"(ID INT PRIMARY KEY NOT NULL," +
" NAME TEXT NOT NULL, " +
" AGE INT NOT NULL, " +
" ADDRESS CHAR(50), " +
" SALARY REAL)";
stmt.executeUpdate(sql);
System.out.println("Table created successfully");
}
public static void insert() throws SQLException{
c.setAutoCommit(false);
stmt = c.createStatement();
String sql = "INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) " +
"VALUES (1, 'Paul', 32, 'California', 20000.00 );";
stmt.executeUpdate(sql);
sql = "INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) " +
"VALUES (2, 'Allen', 25, 'Texas', 15000.00 );";
stmt.executeUpdate(sql);
sql = "INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) " +
"VALUES (3, 'Teddy', 23, 'Norway', 20000.00 );";
stmt.executeUpdate(sql);
sql = "INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) " +
"VALUES (4, 'Mark', 25, 'Rich-Mond ', 65000.00 );";
stmt.executeUpdate(sql);
c.commit();
stmt.close();
System.out.println("Insert successfully");
}
public static void select() throws SQLException{
c.setAutoCommit(false);
stmt = c.createStatement();
ResultSet rs = stmt.executeQuery( "SELECT * FROM COMPANY;" );
while ( rs.next() ) {
int id = rs.getInt("id");
String name = rs.getString("name");
int age = rs.getInt("age");
String address = rs.getString("address");
float salary = rs.getFloat("salary");
System.out.print( "ID = " + id );
System.out.print( "NAME = " + name );
System.out.print( "AGE = " + age );
System.out.print( "ADDRESS = " + address );
System.out.println( "SALARY = " + salary );
}
rs.close();
}
public static void update() throws SQLException{
c.setAutoCommit(false);
stmt = c.createStatement();
String sql = "UPDATE COMPANY set SALARY = 25000.00 where ID=2;";
stmt.executeUpdate(sql);
c.commit();
ResultSet rs = stmt.executeQuery( "SELECT * FROM COMPANY;" );
while ( rs.next() ) {
int id = rs.getInt("id");
String name = rs.getString("name");
int age = rs.getInt("age");
String address = rs.getString("address");
float salary = rs.getFloat("salary");
System.out.print( "ID = " + id );
System.out.print( "NAME = " + name );
System.out.print( "AGE = " + age );
System.out.print( "ADDRESS = " + address );
System.out.println( "SALARY = " + salary );
}
rs.close();
}
public static void delete() throws SQLException{
c.setAutoCommit(false);
stmt = c.createStatement();
String sql = "DELETE from COMPANY where ID=2;";
stmt.executeUpdate(sql);
c.commit();
ResultSet rs = stmt.executeQuery( "SELECT * FROM COMPANY;" );
while ( rs.next() ) {
int id = rs.getInt("id");
String name = rs.getString("name");
int age = rs.getInt("age");
String address = rs.getString("address");
float salary = rs.getFloat("salary");
System.out.println( "ID = " + id );
System.out.println( "NAME = " + name );
System.out.println( "AGE = " + age );
System.out.println( "ADDRESS = " + address );
System.out.println( "SALARY = " + salary );
System.out.println();
}
rs.close();
}
}
- SQLite
- SQLite
- SQLite
- SQLite
- SQLite
- sqlite
- sqlite
- SQLite
- SQLite
- sqlite
- SQLite
- SQLite
- SQLite
- SQLite
- SQLite
- sqlite
- sqlite
- sqlite
- iOS的licode_APP简单分析
- 最全面的 Sublime Text 使用指南
- WCF Behaviors
- Android 基础控件- EditText
- 面向对象编程(类,构造器,重载,this关键字)
- SQLite
- PAT-B 1043. 输出PATest(20)
- Repond.js
- 时间格式转换
- 启动maven项目下载依赖慢
- Android通过广播接收者调用服务(service)内方法
- iOS 10个实用小技巧(总有你不知道的和你会用到的)
- 聚会游戏 Party Games
- rsync+inotify实时同步