进来准备使用一种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 }
唯有不断学习方能改变！ -- Ryan Miao
