HUTSvNJQ

1*Can't create handler inside thread Thread[AsyncTask #1,5,main] that has not called Looper.prepare()* 
2     
3public Database_title(Connection_Server connection_server) {
4        super();
5    } 
6     
7import android.annotation.SuppressLint;
8import android.database.Cursor;
9import android.database.SQLException;
10import android.icu.text.SimpleDateFormat;
11import android.os.StrictMode;
12import android.util.Log;
13import java.sql.Connection;
14import java.sql.DriverManager;
15import java.util.Date;
16import java.util.Locale;
17
18public class Connection_Server {
19    private Database_title mDatabaseHelper;
20
21
22    @SuppressLint("NewApi")
23    public Connection CONN() {
24        String ip = "46.246.205.218";
25        String year_string = new SimpleDateFormat("yyyy", Locale.getDefault()).format(new Date());
26        String classs = "net.sourceforge.jtds.jdbc.Driver";
27        String db = "Main_"+year_string;
28        String un = "David";
29        String password = "*********";
30        mDatabaseHelper = new Database_title(this);
31        StrictMode.ThreadPolicy policy=new StrictMode.ThreadPolicy.Builder().permitAll().build();
32        StrictMode.setThreadPolicy(policy);
33        Connection conn = null;
34        String ConnURL;
35        try {
36            Class.forName(classs);
37
38            Cursor res = mDatabaseHelper.getAllData_main();
39            if (res.getCount()>0){
40                switch (res.getString(2)){
41                    case "text1":
42                        db= "Database_Athens_Main"+year_string;
43                        break;
44                    case "text2":
45                        db= "Database_Piraeus_Main"+year_string;
46                        break;
47                    case "text2":
48                        db= "Database_South_Main"+year_string;
49                        break;
50                    case "text3":
51                        db= "Database_North_Main"+year_string;
52                        break;
53                    case "text4":
54                        db= "Database_West_Main"+year_string;
55                        break;
56                }
57                Log.i("String Db","String DB: "+db);
58            }else{
59                db= "Database_Piraeus";
60                Log.i("String Db","String DB: DEFAULT SET!!");
61            }
62
63            ConnURL = "jdbc:jtds:sqlserver://" + ip + ";" + "databaseName=" + db + ";user=" + un + ";password=" + password + ";";
64            conn = DriverManager.getConnection(ConnURL);
65        }
66        catch (SQLException se)
67        {
68            Log.e("Error 1: ", se.getMessage());
69        }
70        catch (ClassNotFoundException e)
71        {
72            Log.e("Error 2: ", e.getMessage());
73        }
74        catch (Exception e)
75        {
76            Log.e("Error 3: ", e.getMessage());
77        }
78        return conn;
79    }
80} 
81     
82import android.content.ContentValues;
83import android.content.Context;
84import android.database.Cursor;
85import android.database.sqlite.SQLiteDatabase;
86import android.database.sqlite.SQLiteOpenHelper;
87import android.util.Log;
88import java.util.Calendar;
89import java.util.Date;
90
91public class Database_title extends SQLiteOpenHelper {
92
93    Date currentTime = Calendar.getInstance().getTime();
94
95    private static final String Database_Name = "DatabaseDias.db";
96
97    private static final String TABLE_NAME_1 = "main";
98    private static final String TABLE_NAME_2 = "title";
99    private static final String TABLE_NAME_3 = "events";
100
101    private static final String COL1_1 = "ID";
102    private static final String COL1_2 = "prs_nmb";
103    private static final String COL1_3 = "pd";
104    private static final String COL1_4 = "groupp";
105    private static final String COL1_5 = "userid";
106    private static final String COL1_6 = "passw";
107
108    private static final String COL2_1 = "ID";
109    private static final String COL2_2 = "prs_nmb";
110    private static final String COL2_3 = "pd";
111    private static final String COL2_4 = "groupp";
112    private static final String COL2_5 = "date";
113    private static final String COL2_6 = "cd_omd";
114    private static final String COL2_7 = "area";
115    private static final String COL2_8 = "daily_shf";
116    private static final String COL2_9 = "chief";
117    private static final String COL2_10 = "veh_type";
118    private static final String COL2_11 = "driver_A";
119    private static final String COL2_12 = "co_driver_A";
120    private static final String COL2_13 = "veh_A";
121    private static final String COL2_14 = "km_A";
122    private static final String COL2_15 = "fuel_A";
123    private static final String COL2_16 = "driver_B";
124    private static final String COL2_17 = "co_driver_B";
125    private static final String COL2_18 = "veh_B";
126    private static final String COL2_19 = "km_B";
127    private static final String COL2_20 = "fuel_B";
128
129    private static final String COL3_1 = "ID";
130    private static final String COL3_2 = "date";
131    private static final String COL3_3 = "cd_omadas";
132    private static final String COL3_4 = "orig_event";
133    private static final String COL3_5 = "address";
134    private static final String COL3_6 = "announcer";
135    private static final String COL3_7 = "Events_descr";
136
137
138    public Database_title(Context context) {
139        super(context, Database_Name, null, 1);
140        Log.d("Database Operations", "Database created...");
141    }
142
143
144
145    @Override
146    public void onCreate(SQLiteDatabase db) {
147        String createTable_1 = "CREATE TABLE " + TABLE_NAME_1 + "(" + COL1_1 +" INTEGER PRIMARY KEY AUTOINCREMENT,"+ COL1_2 +" INTEGER,"+ COL1_3 +" TEXT,"+ COL1_4 +" TEXT,"+ COL1_5 +" TEXT,"+ COL1_6 +" TEXT)";
148        String createTable_2 = "CREATE TABLE " + TABLE_NAME_2 + "(" + COL2_1 +" INTEGER PRIMARY KEY AUTOINCREMENT,"+ COL2_2 +" INTEGER,"+ COL2_3 +" TEXT,"+ COL2_4 +" TEXT,"+ COL2_5 +" TEXT,"+ COL2_6 +" TEXT,"+ COL2_7 +" TEXT,"+ COL2_8 +" TEXT,"+ COL2_9 +" TEXT,"+ COL2_10 +" TEXT,"+ COL2_11 +" TEXT,"+ COL2_12 +" TEXT,"+ COL2_13 +" TEXT,"+ COL2_14 +" TEXT,"+ COL2_15 +" TEXT,"+ COL2_16 +" TEXT,"+ COL2_17 +" TEXT,"+ COL2_18 +" TEXT,"+ COL2_19 +" TEXT,"+ COL2_20 +" TEXT)";
149        String createTable_3 = "CREATE TABLE " + TABLE_NAME_3 + "(" + COL3_1 +" INTEGER PRIMARY KEY AUTOINCREMENT,"+ COL3_2 +" INTEGER,"+ COL3_3 +" TEXT,"+ COL3_4 +" TEXT,"+ COL3_5 +" TEXT,"+ COL3_6 +" TEXT,"+ COL3_7 +" TEXT)";
150
151        db.execSQL(createTable_1);
152        db.execSQL(createTable_2);
153        db.execSQL(createTable_3);
154
155        Log.d(Database_Name, "Hello onCreate(SQLiteDatabase db) " );
156    }
157    @Override
158    public void onUpgrade(SQLiteDatabase db, int i, int i1) {
159        db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME_1);
160        onCreate(db);
161        Log.d(Database_Name, "Hello onUpgrade(SQLiteDatabase db, int i, int i1) " );
162    }
163    public boolean addData_main(String item_1,String item_2,String item_3,String item_4,String item_5) {
164        SQLiteDatabase db = this.getWritableDatabase();
165        ContentValues contentValues = new ContentValues();
166        contentValues.put(COL1_2, item_1);
167        contentValues.put(COL1_3, item_2);
168        contentValues.put(COL1_4, item_3);
169        contentValues.put(COL1_5, item_4);
170        contentValues.put(COL1_6, item_5);
171        long result = db.insert(TABLE_NAME_1, null, contentValues);
172
173        if (result == -1) {
174            return false;
175        }else{
176            return true;
177        }
178    }
179
180    public Cursor getAllData_main() {
181        SQLiteDatabase db = this.getWritableDatabase();
182        Cursor res = db.rawQuery("select * from " + TABLE_NAME_1, null);
183        return res;
184    }
185    /*
186    public Cursor getData(String Col,String table_name){
187        SQLiteDatabase db = this.getWritableDatabase();
188        String query = "SELECT * FROM " + table_name;
189        Cursor data = db.rawQuery(query, null);
190        return data;
191    }
192    */
193
194
195    public Cursor getItemID(String name){
196        SQLiteDatabase db = this.getWritableDatabase();
197        String query = "SELECT " + COL1_1 + " FROM " + TABLE_NAME_1 +
198                " WHERE " + COL1_2 + " = '" + name + "'";
199        Cursor data = db.rawQuery(query, null);
200        return data;
201    }
202
203    public boolean updateName_main(String prs_nmb, String pd, String groupp,String userid,String pass){
204        SQLiteDatabase db = this.getWritableDatabase();
205        ContentValues contentValues = new ContentValues();
206        //contentValues.put(COL1_1,"1");
207        contentValues.put(COL1_2,prs_nmb);
208        contentValues.put(COL1_3,pd);
209        contentValues.put(COL1_4,groupp);
210        contentValues.put(COL1_5,userid);
211        contentValues.put(COL1_6,pass);
212        db.update(TABLE_NAME_1,contentValues,"ID = 1",null);
213        return true;
214    }
215
216
217
218    public void deleteName(int id, String name){
219        SQLiteDatabase db = this.getWritableDatabase();
220        String query = "DELETE FROM " + TABLE_NAME_1 + " WHERE "
221                + COL1_1 + " = '" + id + "'" +
222                " AND " + COL1_2 + " = '" + name + "'";
223        Log.d(Database_Name, "deleteName: query: " + query);
224        Log.d(Database_Name, "deleteName: Deleting " + name + " from database.");
225        db.execSQL(query);
226    }
227}