· 6 years ago · Jun 03, 2019, 09:00 PM
1package ysqlite;
2
3import java.sql.ResultSet;
4
5public class SQLiteJDBC
6{
7 public static void main( String args[] )
8 {
9
10 ycrud yc =new ycrud("test2");
11 yc.yconnect();
12
13 // yc.table_drop("users");;
14
15 String sql = "CREATE TABLE IF NOT EXISTS users " +
16 "(ID integer PRIMARY KEY AUTOINCREMENT," +
17 " name TEXT NOT NULL, " +
18 " password CHAR(8) NOT NULL, " +
19 " maill CHAR(50), " +
20 " active INT NOT NULL)";
21
22 String posts_table = "CREATE TABLE IF NOT EXISTS posts " +
23 "(ID integer PRIMARY KEY AUTOINCREMENT," +
24 " title TEXT NOT NULL, " +
25 " content TEXT NOT NULL, " +
26 " category_id INT NOT NULL)";
27
28
29 yc.ycreate_table(sql);
30
31
32 String fields = "name,password,maill,active";
33 String vals= "'user2','1234','vevea@gew.com',0";
34
35 //yc.yinsert("users", fields, vals);
36 //yc.yupdate("users", " name = 'tst2'", "Id = 2");
37 //yc.ydeleate("users", "ID = 2");
38 ResultSet rs = yc.yselect_all("users");
39
40
41 try {
42 while ( rs.next() )
43 {
44 int id = rs.getInt("ID");
45 String name = rs.getString("name");
46 int password = rs.getInt("password");
47 String maill = rs.getString("maill");
48 float active = rs.getFloat("active");
49 System.out.println( "ID = " + id );
50 System.out.println( "NAME = " + name );
51 System.out.println( "password = " + password );
52 System.out.println( "maill = " + maill );
53 System.out.println( "active = " + active );
54 System.out.println();
55 }
56 } catch (Exception e) {
57 // TODO Auto-generated catch block
58 e.printStackTrace();
59 }
60
61
62 /*
63 Connection c = null;
64 Statement stmt = null;
65 try {
66 Class.forName("org.sqlite.JDBC");
67 c = DriverManager.getConnection("jdbc:sqlite:test.db");
68 System.out.println("Opened database successfully");
69
70 //create table
71 stmt = c.createStatement();
72 String sql = "CREATE TABLE COMPANY " +
73 "(ID INT PRIMARY KEY NOT NULL," +
74 " NAME TEXT NOT NULL, " +
75 " AGE INT NOT NULL, " +
76 " ADDRESS CHAR(50), " +
77 " SALARY REAL)";
78 // stmt.executeUpdate(sql);
79
80 //insert
81 String insertsql = "INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) " +
82 "VALUES (1, 'Paul', 32, 'California', 20000.00 );";
83 // stmt.executeUpdate(insertsql);
84
85 insertsql = "INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) " +
86 "VALUES (2, 'Allen', 25, 'Texas', 15000.00 );";
87 // stmt.executeUpdate(insertsql);
88
89 insertsql = "INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) " +
90 "VALUES (3, 'Teddy', 23, 'Norway', 20000.00 );";
91 // stmt.executeUpdate(insertsql);
92
93 insertsql = "INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) " +
94 "VALUES (4, 'Mark', 25, 'Rich-Mond ', 65000.00 );";
95 // stmt.executeUpdate(insertsql);
96
97 //select
98 ResultSet rs = stmt.executeQuery( "SELECT * FROM COMPANY;" );
99 while ( rs.next() ) {
100 int id = rs.getInt("id");
101 String name = rs.getString("name");
102 int age = rs.getInt("age");
103 String address = rs.getString("address");
104 float salary = rs.getFloat("salary");
105 System.out.println( "ID = " + id );
106 System.out.println( "NAME = " + name );
107 System.out.println( "AGE = " + age );
108 System.out.println( "ADDRESS = " + address );
109 System.out.println( "SALARY = " + salary );
110 System.out.println();
111 }
112 rs.close();
113
114 //update
115 String updatesql = "UPDATE COMPANY set SALARY = 205.00 where ID=1;";
116 // stmt.executeUpdate(updatesql);
117 // c.commit();
118
119 //DELETE
120 String deletesql = "DELETE from COMPANY where ID=2;";
121 //stmt.executeUpdate(deletesql);
122
123
124 stmt.close();
125 } catch ( Exception e ) {
126 System.err.println( e.getClass().getName() + ": " + e.getMessage() );
127 System.exit(0);
128 }
129 System.out.println("Operation done successfully");*/
130 }
131}