· 10 years ago · Aug 30, 2016, 02:46 PM
1import java.sql.*;
2
3public class SQLiteJDBC {
4
5 public static void main(String[] args) {
6
7 Connection c = null;
8 Statement stmt = null;
9
10 try {
11 Class.forName("org.sqlite.JDBC");
12 c = DriverManager.getConnection("jdbc:sqlite:test.db");
13 c.setAutoCommit(false);
14
15 System.out.println("Opened Database Succesfully.");
16
17 stmt = c.createStatement();
18 String sql = "CREATE TABLE company "
19 + "(id INTEGER AUTO INCREMENT NOT NULL, "
20 + "name VARCHAR(50) NOT NULL, "
21 + "age INTEGER NOT NULL, "
22 + "address VARCHAR(50), "
23 + "salary DOUBLE, "
24 + "CONSTRAINT company_pk PRIMARY KEY (ID)"
25 + ");";
26 stmt.executeUpdate(sql);
27 stmt.close();
28
29 } catch (Exception e) {
30
31 if (e.getMessage().equals("table company already exists")) {
32 System.out.println(e.getMessage());
33 }
34
35 }
36 try {
37 Class.forName("org.sqlite.JDBC");
38 c = DriverManager.getConnection("jdbc:sqlite:test.db");
39 c.setAutoCommit(false);
40
41 stmt = c.createStatement();
42 String sql = "INSERT INTO company VALUES "
43 + "('Chen', 20, 'valenzuela', 20000);";
44 stmt.executeUpdate(sql);
45
46 sql = "INSERT INTO company VALUES "
47 + "('Patrick', 23, 'Malabon', 25000);";
48 stmt.executeUpdate(sql);
49
50 sql = "INSERT INTO company VALUES "
51 + "('John', 18, 'Manila', 50000);";
52 stmt.executeUpdate(sql);
53
54 sql = "INSERT INTO company VALUES "
55 + "('Rhenan', 30, 'Quezon', 15000);";
56 stmt.executeUpdate(sql);
57
58 stmt.close();
59 c.commit();
60 c.close();
61
62 } catch (Exception e) {
63
64 if (e.getMessage().equals("table company already exists")) {
65 System.out.println(e.getMessage());
66 }
67 }
68
69 try {
70 Class.forName("org.sqlite.JDBC");
71 c = DriverManager.getConnection("jdbc:sqlite:test.db");
72
73 stmt = c.createStatement();
74
75 String sql = "SELECT * FROM company;";
76 ResultSet rs = stmt.executeQuery(sql);
77
78 while (rs.next()) {
79
80 System.out.println(rs.getInt("id") + " " + rs.getString("name") + " " + rs.getInt("age") + " " + rs.getString("address") + " " + rs.getDouble("salary"));
81
82 }
83
84 } catch (Exception e) {
85
86 if (e.getMessage().equals("table company already exists")) {
87 System.out.println(e.getMessage());
88 }
89
90 }
91
92 }
93
94}