· 7 years ago · Jan 20, 2019, 11:06 AM
12019-01-19 16:52:48.127 1605-1605/? E/AudioFlinger: not enough memory for AudioTrack size=131296
22019-01-19 16:52:48.127 1605-1605/? E/AudioFlinger: createRecordTrack_l() initCheck failed -12; no control block?
32019-01-19 16:52:48.141 1605-18287/? I/AudioFlinger: AudioFlinger's thread 0xdf9836c0 tid=18287 ready to run
42019-01-19 16:52:48.143 3235-17962/com.google.android.googlequicksearchbox:search E/IAudioFlinger: createRecord returned error -12
52019-01-19 16:52:48.144 3235-17962/com.google.android.googlequicksearchbox:search E/AudioRecord: AudioFlinger could not create record track, status: -12
62019-01-19 16:52:48.156 3235-17962/com.google.android.googlequicksearchbox:search E/AudioRecord-JNI: Error creating AudioRecord instance: initialization check failed with status -12.
72019-01-19 16:52:48.160 3235-17962/com.google.android.googlequicksearchbox:search E/android.media.AudioRecord: Error code -20 when initializing native AudioRecord object.
8 com.google.android.apps.gsa.shared.speech.b.g: Error reading from input stream
9 at com.google.android.apps.gsa.staticplugins.microdetection.d.k.a(SourceFile:91)
10 at com.google.android.apps.gsa.staticplugins.microdetection.d.l.run(Unknown Source:14)
11 at com.google.android.libraries.gsa.runner.a.a.b(SourceFile:32)
12 at com.google.android.libraries.gsa.runner.a.c.call(Unknown Source:4)
13 at java.util.concurrent.FutureTask.run(FutureTask.java:266)
14 at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:458)
15 at java.util.concurrent.FutureTask.run(FutureTask.java:266)
16 at com.google.android.apps.gsa.shared.util.concurrent.b.g.run(Unknown Source:4)
17 at com.google.android.apps.gsa.shared.util.concurrent.b.aw.run(SourceFile:4)
18 at com.google.android.apps.gsa.shared.util.concurrent.b.aw.run(SourceFile:4)
19 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167)
20 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641)
21 at java.lang.Thread.run(Thread.java:764)
22 at com.google.android.apps.gsa.shared.util.concurrent.b.i.run(SourceFile:6)
23 Caused by: com.google.android.apps.gsa.shared.exception.GsaIOException: Error code: 393238 | Buffer overflow, no available space.
24 at com.google.android.apps.gsa.speech.audio.Tee.j(SourceFile:103)
25 at com.google.android.apps.gsa.speech.audio.au.read(SourceFile:2)
26 at java.io.InputStream.read(InputStream.java:101)
27 at com.google.android.apps.gsa.speech.audio.ao.run(SourceFile:17)
28 at com.google.android.apps.gsa.speech.audio.an.run(SourceFile:2)
29 at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:458)
30
31public class MainActivity extends Activity {
32
33EditText studentid = (EditText) findViewById(R.id.id);
34EditText studentname = (EditText) findViewById(R.id.name);
35TextView first = (TextView) findViewById(R.id.first);
36
37@Override
38public void onCreate(Bundle save) {
39 super.onCreate(save);
40}
41
42public void loadStudents(View view) {
43 MyDBHandler dbHandler = new MyDBHandler(this, null, null, 1);
44 first.setText(dbHandler.loadHandler());
45 studentid.setText("");
46 studentname.setText("");
47}
48
49
50public void addStudent(View view) {
51 MyDBHandler dbHandler = new MyDBHandler(this, null, null, 1);
52 int id = Integer.parseInt(studentid.getText().toString());
53 String name = studentname.getText().toString();
54 Student student = new Student(id, name);
55 dbHandler.addHandler(student);
56 studentid.setText("");
57 studentname.setText("");
58}
59}
60
61public class Student {
62// fields
63private int studentID;
64private String studentName;
65// constructors
66public Student() {}
67public Student(int id, String studentname) {
68 this.studentID = id;
69 this.studentName = studentname;
70}
71// properties
72public void setID(int id) {
73 this.studentID = id;
74}
75public int getID() {
76 return this.studentID;
77}
78public void setStudentName(String studentname) {
79 this.studentName = studentname;
80}
81public String getStudentName() {
82 return this.studentName;
83}
84}
85
86public class MyDBHandler extends SQLiteOpenHelper {
87//information of database
88private static final int DATABASE_VERSION = 1;
89private static final String DATABASE_NAME = "studentDB.db";
90public static final String TABLE_NAME = "Student";
91public static final String COLUMN_ID = "StudentID";
92public static final String COLUMN_NAME = "StudentName";
93//initialize the database
94public MyDBHandler(Context context, String name, SQLiteDatabase.CursorFactory factory, int version) {
95 super(context, DATABASE_NAME, factory, DATABASE_VERSION);
96}
97@Override
98public void onCreate(SQLiteDatabase db) {
99 String CREATE_TABLE = "CREATE TABLE" + TABLE_NAME + "(" + COLUMN_ID +
100 "INTEGER PRIMARYKEY," + COLUMN_NAME + "TEXT )";
101 db.execSQL(CREATE_TABLE);
102}
103@Override
104public void onUpgrade(SQLiteDatabase db, int i, int i1) {}
105public String loadHandler() {
106 String result = "";
107 String query = "SELECT * FROM " + TABLE_NAME;
108 SQLiteDatabase db = this.getWritableDatabase();
109 Cursor cursor = db.rawQuery(query, null);
110 while (cursor.moveToNext()) {
111 int result_0 = cursor.getInt(0);
112 String result_1 = cursor.getString(1);
113 result += String.valueOf(result_0) + " " + result_1 +
114 System.getProperty("line.separator");
115 }
116 cursor.close();
117 db.close();
118 return result;
119}
120public void addHandler(Student student) {
121 ContentValues values = new ContentValues();
122 values.put(COLUMN_ID, student.getID());
123 values.put(COLUMN_NAME, student.getStudentName());
124 SQLiteDatabase db = this.getWritableDatabase();
125 db.insert(TABLE_NAME, null, values);
126 db.close();
127}
128public Student findHandler(String studentname) {
129
130 String query = "Select * FROM " + TABLE_NAME + " WHERE " + COLUMN_NAME + " = " + "'" + studentname + "'";
131 SQLiteDatabase db = this.getWritableDatabase();
132 Cursor cursor = db.rawQuery(query, null);
133 Student student = new Student();
134 if (cursor.moveToFirst()) {
135 cursor.moveToFirst();
136 student.setID(Integer.parseInt(cursor.getString(0)));
137 student.setStudentName(cursor.getString(1));
138 cursor.close();
139 } else {
140 student = null;
141 }
142 db.close();
143 return student;
144}
145public boolean deleteHandler(int ID) {
146
147 boolean result = false;
148 String query = "Select * FROM " + TABLE_NAME + " WHERE " + COLUMN_ID + " = '" + String.valueOf(ID) + "'";
149 SQLiteDatabase db = this.getWritableDatabase();
150 Cursor cursor = db.rawQuery(query, null);
151 Student student = new Student();
152 if (cursor.moveToFirst()) {
153 student.setID(Integer.parseInt(cursor.getString(0)));
154 db.delete(TABLE_NAME, COLUMN_ID + "=?",
155 new String[] {
156 String.valueOf(student.getID())
157 });
158 cursor.close();
159 result = true;
160 }
161 db.close();
162 return result;
163}
164public boolean updateHandler(int ID, String name) {
165 SQLiteDatabase db = this.getWritableDatabase();
166 ContentValues args = new ContentValues();
167 args.put(COLUMN_ID, ID);
168 args.put(COLUMN_NAME, name);
169 return db.update(TABLE_NAME, args, COLUMN_ID + "=" + ID, null) > 0;
170}
171}
172
173<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
174xmlns:tools="http://schemas.android.com/tools"
175android:layout_width="match_parent"
176android:layout_height="match_parent"
177tools:context="com.example.testovanisql.MainActivity">
178
179<TextView
180 android:layout_width="wrap_content"
181 android:layout_height="wrap_content"
182 android:id="@+id/first"
183 android:layout_alignParentTop="true"
184 android:layout_alignParentLeft="true"/>
185<EditText
186 android:layout_width="wrap_content"
187 android:layout_height="wrap_content"
188 android:paddingTop="50dp"
189 android:layout_centerHorizontal="true"
190 android:ems="15"
191 android:id="@+id/id"/>
192<EditText
193 android:layout_width="wrap_content"
194 android:layout_centerHorizontal="true"
195 android:layout_height="wrap_content"
196 android:ems="15"
197 android:paddingTop="90dp"
198 android:id="@+id/name"/>
199<Button
200 android:layout_width="wrap_content"
201 android:layout_height="wrap_content"
202 android:text="save"
203 android:layout_below="@+id/name"
204 android:id="@+id/save"
205 android:layout_centerHorizontal="true"
206 android:onClick="addStudent"/>
207<Button
208 android:layout_width="wrap_content"
209 android:layout_height="wrap_content"
210 android:text="load"
211 android:layout_below="@+id/save"
212 android:id="@+id/load"
213 android:layout_centerHorizontal="true"
214 android:onClick="loadStudents"/>
215
216</RelativeLayout>
217
218public class SQLitehelper extends SQLiteOpenHelper {
219
220private static String DATABASE_NAME = "Demochat.db";
221String TABLE_NAME = "chatdata";
222String COL_1 = "ID";
223String COL_2 = "TYPE";
224String COL_3 = "DATE";
225String COL_4 = "TIME";
226String COL_5 = "MSG";
227
228
229
230public SQLitehelper(MainActivity context) {
231 super(context, DATABASE_NAME, null, 1);
232
233}
234
235@Override
236public void onCreate(SQLiteDatabase db) {
237 db.execSQL("create table " + TABLE_NAME + "(ID INTEGER PRIMARY KEY AUTOINCREMENT,TYPE TEXT,DATE TEXT,TIME TEXT,MSG TEXT)");
238}
239
240@Override
241public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
242 db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
243 onCreate(db);
244}
245public boolean insertData(String type, String date, String time, String msg){
246 SQLiteDatabase db = this.getWritableDatabase();
247 ContentValues contentValues=new ContentValues();
248 contentValues.put(COL_2,type);
249 contentValues.put(COL_3,date);
250 contentValues.put(COL_4,time);
251 contentValues.put(COL_5,msg);
252 long results=db.insert(TABLE_NAME,null,contentValues);
253 if(results==-1){
254 return false;
255 }
256 else {
257 return true;
258 }
259}
260public Cursor gtealldata(){
261 SQLiteDatabase db=this.getWritableDatabase();
262 Cursor res=db.rawQuery("select * from "+TABLE_NAME,null);
263 return res;
264}
265
266@Override
267public void onCreate(SQLiteDatabase db) {
268 final String CREATE_TABLE =
269 "CREATE TABLE " + TABLE_NAME + " ("
270 + COLUMN_ID + " INTEGER PRIMARY KEY, "
271 + COLUMN_NAME + " TEXT);";
272 db.execSQL(CREATE_TABLE);
273}