sqlite - java 初学

1.连接数据库

添加依赖jdbc:

 
         <dependency>
        
         <groupId>org.xerial</groupId> 
        
         <artifactId>sqlite-jdbc</artifactId> 
        
         <version>
         3.8
         .
         11.2
         </version> 
        
         </dependency>

链接代码：

package com.test.database.sqlite;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

/**
 * Created by miaorf on 2016/6/20.
 */
public class SQLiteJDBC {

    public static void main(String[] args) {
        
        Connection c = null;
        try {
            Class.forName("org.sqlite.JDBC");
            c= DriverManager.getConnection("jdbc:sqlite:test.db");

        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }catch (SQLException e) {
            e.printStackTrace();
        }

        System.out.println("Open databse successfully");
    }


}

执行结束发现，在项目根目录会生成一个叫做test.db的文件，这就是我们的数据库了。

2. 创建表

 1 package com.test.database.sqlite;
 2 
 3 import java.sql.Connection;
 4 import java.sql.DriverManager;
 5 import java.sql.SQLException;
 6 import java.sql.Statement;
 7 
 8 /**
 9  * Created by miaorf on 2016/6/20.
10  */
11 public class SQLiteJDBC {
12 
13     public static void main(String[] args) {
14 
15         Connection c = null;
16         Statement stmt = null;
17         try {
18             Class.forName("org.sqlite.JDBC");
19             c= DriverManager.getConnection("jdbc:sqlite:test.db");
20             System.out.println("Opened database successfully");
21 
22             stmt = c.createStatement();
23             String sql = "CREATE TABLE COMPANY " +
24                     "(ID INT PRIMARY KEY     NOT NULL," +
25                     " NAME           TEXT    NOT NULL, " +
26                     " AGE            INT     NOT NULL, " +
27                     " ADDRESS        CHAR(50), " +
28                     " SALARY         REAL)";
29             stmt.executeUpdate(sql);
30             stmt.close();
31             c.close();
32 
33             System.out.println("create table  successfully");
34 
35         } catch (ClassNotFoundException e) {
36             e.printStackTrace();
37         }catch (SQLException e) {
38             e.printStackTrace();
39         }
40 
41 
42     }
43 
44 
45 }

本文转自Ryan.Miao博客园博客，原文链接：http://www.cnblogs.com/woshimrf/p/5602096.html，如需转载请自行联系原作者

相关文章：