进来准备使用一种embedded database,即嵌入式数据库,方便随项目本地存储。目前学习打算是sqlite和H2。
document:http://www.runoob.com/sqlite/sqlite-java.html
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 }