@Override public Cursor query( Uri uri, String[] projection, String selection, String[] selectionArgs, String sortOrder) { // Using SQLiteQueryBuilder to create a query SQLiteQueryBuilder queryBuilder = new SQLiteQueryBuilder(); // Check if the caller has requested a column which does not exist checkColumns(projection); // Set the table queryBuilder.setTables(NOTE_TABLE); int uriType = sURIMatcher.match(uri); switch (uriType) { case ALL_NOTES: break; default: throw new IllegalArgumentException("Unknown URI: " + uri); } SQLiteDatabase db = database.getWritableDatabase(); Cursor cursor = queryBuilder.query(db, projection, selection, selectionArgs, null, null, sortOrder); cursor.setNotificationUri(getContext().getContentResolver(), uri); return cursor; }
@Override public void open() throws SQLException { if (database != null) { if (database.isOpen()) database.close(); } database = dbHelper.getWritableDatabase(); }
public Livro getLivro(int id) { // 1. get reference to readable DB Livro livro = new Livro(); SQLiteMaterial dbMaterial = new SQLiteMaterial(con); SQLiteDatabase db = banco.getReadableDatabase(); // 2. build query Cursor cursor = db.query( TABLE_LIVRO, // a. table COLUMNS, // b. column names " id = ?", // c. selections new String[] {String.valueOf(id)}, // d. selections args null, // e. group by null, // f. having null, // g. order by null); // h. limit // 3. if we got results get the first one if (cursor != null) cursor.moveToFirst(); idLivro = cursor.getColumnIndex(KEY_ID); autor = cursor.getColumnIndex(KEY_AUTOR); cutter = cursor.getColumnIndex(KEY_CUTTER); isbn = cursor.getColumnIndex(KEY_ISBN); numeroTombo = cursor.getColumnIndex(KEY_NUMERO_TOMBO); idMaterial = cursor.getColumnIndex(sqlLiteMaterial.KEY_ID); ano = cursor.getColumnIndex(sqlLiteMaterial.KEY_ANO); classificacao = cursor.getColumnIndex(sqlLiteMaterial.KEY_CLASSIFICACAO); editora = cursor.getColumnIndex(sqlLiteMaterial.KEY_EDITORA); local = cursor.getColumnIndex(sqlLiteMaterial.KEY_LOCAL); referencia = cursor.getColumnIndex(sqlLiteMaterial.KEY_REFERENCIA); titulo = cursor.getColumnIndex(sqlLiteMaterial.KEY_TITULO); unitermo = cursor.getColumnIndex(sqlLiteMaterial.KEY_UNITERMO); volume = cursor.getColumnIndex(sqlLiteMaterial.KEY_VOLUME); // 4. tabela material livro = new Livro(); livro.setCodigoMaterial(Integer.parseInt(cursor.getString(idMaterial))); livro.setAno(cursor.getString(ano)); livro.setClassificacao(cursor.getString(classificacao)); livro.setEditora(cursor.getString(editora)); livro.setLocal(cursor.getString(local)); livro.setReferencia(cursor.getString(referencia)); livro.setTitulo(cursor.getString(titulo)); livro.setUnitermo(cursor.getString(unitermo)); livro.setVolume(cursor.getString(volume)); livro.setCodigoLivro(Integer.parseInt(cursor.getString(idLivro))); livro.setAutor(cursor.getString(autor)); livro.setCutter(cursor.getString(cutter)); livro.setIsbn(cursor.getString(isbn)); livro.setNumeroTombo(cursor.getString(numeroTombo)); Log.d("getLivro(" + id + ")", livro.toString()); return livro; }
public ArrayList<Livro> getAllLivro() { ArrayList<Livro> listaLivros = new ArrayList<Livro>(); SQLiteMaterial sqlMaterial; // = new SQLiteMaterial(con); // 1. build the query// String query = SQL_SELECT + SQL_GROUP_BY; // 2. get reference to writable DB SQLiteDatabase db = banco.getWritableDatabase(); Cursor cursor = db.rawQuery(query, null); // 3. go over each row, build book and add it to list Livro livro = null; if (cursor.moveToFirst()) { do { livro = new Livro(); idLivro = cursor.getColumnIndex(KEY_ID); autor = cursor.getColumnIndex(KEY_AUTOR); cutter = cursor.getColumnIndex(KEY_CUTTER); isbn = cursor.getColumnIndex(KEY_ISBN); numeroTombo = cursor.getColumnIndex(KEY_NUMERO_TOMBO); idMaterial = cursor.getColumnIndex(sqlLiteMaterial.KEY_ID); ano = cursor.getColumnIndex(sqlLiteMaterial.KEY_ANO); classificacao = cursor.getColumnIndex(sqlLiteMaterial.KEY_CLASSIFICACAO); editora = cursor.getColumnIndex(sqlLiteMaterial.KEY_EDITORA); local = cursor.getColumnIndex(sqlLiteMaterial.KEY_LOCAL); referencia = cursor.getColumnIndex(sqlLiteMaterial.KEY_REFERENCIA); titulo = cursor.getColumnIndex(sqlLiteMaterial.KEY_TITULO); unitermo = cursor.getColumnIndex(sqlLiteMaterial.KEY_UNITERMO); volume = cursor.getColumnIndex(sqlLiteMaterial.KEY_VOLUME); // 4. tabela material livro.setCodigoMaterial(Integer.parseInt(cursor.getString(idMaterial))); livro.setAno(cursor.getString(ano)); livro.setClassificacao(cursor.getString(classificacao)); livro.setEditora(cursor.getString(editora)); livro.setLocal(cursor.getString(local)); livro.setReferencia(cursor.getString(referencia)); livro.setTitulo(cursor.getString(titulo)); livro.setUnitermo(cursor.getString(unitermo)); livro.setVolume(cursor.getString(volume)); livro.setCodigoLivro(Integer.parseInt(cursor.getString(idLivro))); livro.setAutor(cursor.getString(autor)); livro.setCutter(cursor.getString(cutter)); livro.setIsbn(cursor.getString(isbn)); livro.setNumeroTombo(cursor.getString(numeroTombo)); listaLivros.add(livro); } while (cursor.moveToNext()); } Log.d("getAllLivro()", listaLivros.toString()); return listaLivros; }
public void reiniciaTabelaMensagem(SQLiteDatabase db) { String DELETE_TABLE = "DELETE FROM livro"; String DELETE_INDEX_TABLE = " DELETE FROM SQLITE_SEQUENCE WHERE NAME = 'livro'"; db.execSQL(DELETE_TABLE); db.execSQL(DELETE_INDEX_TABLE); banco.onCreate(db); }
public void editMovie(int mID, String mTitle) { LinearLayout viewGroup = (LinearLayout) findViewById(R.id.popupLinearLayout); LayoutInflater layoutInflater = (LayoutInflater) getSystemService(Context.LAYOUT_INFLATER_SERVICE); editMovieLayout = layoutInflater.inflate(R.layout.edit_movie, viewGroup); selectedMovie = db.getMovie(mID); int popupDimensions = WindowManager.LayoutParams.MATCH_PARENT; TextView mName = (TextView) editMovieLayout.findViewById(R.id.editMovieName); mName.setText(mTitle); final RatingBar mRating = (RatingBar) editMovieLayout.findViewById(R.id.editRating); mRating.setRating(selectedMovie.getRating()); // Creating the PopupWindow final PopupWindow popup = new PopupWindow(); popup.setContentView(editMovieLayout); popup.setWidth(popupDimensions); popup.setHeight(popupDimensions); popup.setFocusable(true); // popup.setAnimationStyle(R.style.PopupWindowAnimation); // Displaying the popup at the specified location, + offsets. popup.showAtLocation(editMovieLayout, Gravity.CENTER, 0, 0); ImageButton close = (ImageButton) editMovieLayout.findViewById(R.id.close); close.setOnClickListener( new View.OnClickListener() { @Override public void onClick(View v) { popup.dismiss(); } }); Button save = (Button) editMovieLayout.findViewById(R.id.saveMovieButton); save.setOnClickListener( new View.OnClickListener() { @Override public void onClick(View v) { selectedMovie.setRating(mRating.getRating()); db.updateMovie(selectedMovie); try { populateMyMovies(lv); } catch (ParseException e) { e.printStackTrace(); } popup.dismiss(); } }); }
@Override public List<Event> getAllEntries() { List<Event> events = new ArrayList<Event>(); String[] allColumnNames = dbHelper.getAllColumnNames(MySQLiteHelper.TABLE_EVENTS); if (database == null) database = dbHelper.getReadableDatabase(); Cursor cursor = database.query(MySQLiteHelper.TABLE_EVENTS, allColumnNames, null, null, null, null, null); cursor.moveToFirst(); while (!cursor.isAfterLast()) { Event event = cursorToEvent(cursor); events.add(event); cursor.moveToNext(); } // Make sure to close the cursor cursor.close(); return events; }
@Override public Object createEntry(String data) { ContentValues values = new ContentValues(); int endTitle = data.indexOf(";"); int endUser = data.indexOf(";", endTitle + 1); int endStartTime = data.indexOf(";", endUser + 1); int endEndTime = data.indexOf(";", endStartTime + 1); int endDescription = data.indexOf(";", endEndTime + 1); String title = data.substring(0, endTitle); String user = data.substring(endTitle + 1, endUser); Long starttime = Long.getLong(data.substring(endUser + 1, endStartTime)); Long endtime = Long.getLong(data.substring(endStartTime + 1, endEndTime)); String description = (data.substring(endEndTime + 1, endDescription)); String profilePicURI = (data.substring(endDescription + 1, data.length())); // TODO start and endtime check starttime = System.currentTimeMillis(); endtime = System.currentTimeMillis(); if (";".equals(profilePicURI)) profilePicURI = ""; values.put(MySQLiteHelper.COLUMN_TIMESTAMP, System.currentTimeMillis()); values.put(MySQLiteHelper.COLUMN_TITLE, title); values.put(MySQLiteHelper.COLUMN_USERNAME, user); values.put(MySQLiteHelper.COLUMN_STARTTIME, starttime); values.put(MySQLiteHelper.COLUMN_ENDTIME, endtime); values.put(MySQLiteHelper.COLUMN_DESCRIPTION, description); values.put(MySQLiteHelper.COLUMN_PICPROFILEURI, profilePicURI); long insertId = database.insert(MySQLiteHelper.TABLE_EVENTS, null, values); String[] allColumnNames = dbHelper.getAllColumnNames(MySQLiteHelper.TABLE_EVENTS); Cursor cursor = database.query( MySQLiteHelper.TABLE_EVENTS, allColumnNames, MySQLiteHelper.COLUMN_ID + " = " + insertId, null, null, null, null); Event event = null; if (cursor.moveToFirst()) event = cursorToEvent(cursor); cursor.close(); return event; }
@Override public int delete(Uri uri, String selection, String[] selectionArgs) { // TODO Auto-generated method stub int uriType = sURIMatcher.match(uri); switch (uriType) { case ALL_NOTES: break; default: throw new IllegalArgumentException("Unknown URI: " + uri); } SQLiteDatabase db = database.getWritableDatabase(); int numDeleted = db.delete(MySQLiteHelper.TABLE_COMMENTS, selection, null); Log.w(MainActivity.TAG, "Deleted items: " + String.valueOf(numDeleted)); return numDeleted; }
@Override public int update(Uri uri, ContentValues values, String selection, String[] selectionArgs) { Date date = new Date(); values.put(MySQLiteHelper.COLUMN_DATE_MODIFIED, date.getTime()); int uriType = sURIMatcher.match(uri); switch (uriType) { case ALL_NOTES: break; default: throw new IllegalArgumentException("Unknown URI: " + uri); } SQLiteDatabase db = database.getWritableDatabase(); int numRows = db.update(MySQLiteHelper.TABLE_COMMENTS, values, selection, null); return numRows; }
@Override public Uri insert(Uri uri, ContentValues values) { // TODO Auto-generated method stub // Check what we are inserting int uriType = sURIMatcher.match(uri); switch (uriType) { case NOTE_ID: values.put(MySQLiteHelper.COLUMN_CONTENTS, ""); values.put(MySQLiteHelper.COLUMN_DATE_MODIFIED, new Date().getTime()); SQLiteDatabase db = database.getWritableDatabase(); long id = db.insert(MySQLiteHelper.TABLE_COMMENTS, null, values); Uri returnUri = Uri.parse(uri + "/" + String.valueOf(id)); return returnUri; default: throw new IllegalArgumentException("Unknown URI: " + uri); } }
public long addLivro(Livro livro) { Log.d("addLivro", livro.getClassificacao()); // 1. get reference to writable DB SQLiteMaterial dbMaterial = new SQLiteMaterial(con); SQLiteDatabase db = banco.getWritableDatabase(); ContentValues values = new ContentValues(); Material material = new Material(); long i = 0; material.setAno(livro.getAno()); material.setClassificacao(livro.getClassificacao()); material.setEditora(livro.getEditora()); material.setLocal(livro.getLocal()); material.setReferencia(livro.getReferencia()); material.setTitulo(livro.getTitulo()); material.setUnitermo(livro.getUnitermo()); material.setVolume(livro.getVolume()); if (dbMaterial.addMaterial(material) > 0) { material = new Material(); material = dbMaterial.getUltimoMaterial(); if (material.getCodigoMaterial() > 0) { values.put(KEY_ID_MATERIAL, material.getCodigoMaterial()); values.put(KEY_AUTOR, livro.getAutor()); values.put(KEY_CUTTER, livro.getCutter()); values.put(KEY_ISBN, livro.getIsbn()); values.put(KEY_NUMERO_TOMBO, livro.getNumeroTombo()); // 3. insert i = db.insert( TABLE_LIVRO, // table null, // nullColumnHack values); // key/value -> keys = column names/ values = column values // 4. close db.close(); } } return i; }
@Override public boolean validarFecha(int dia, int mes, int anio, boolean bool) { // creo el calendario que me dara el timestamp en milisegundos Calendar cal = Calendar.getInstance(); cal.set(Calendar.DAY_OF_MONTH, dia); cal.set(Calendar.MONTH, mes); cal.set(Calendar.YEAR, anio); mes = mes + 1; // a partir del calendario puesto en fecha obtengo los milisegundos long t = cal.getTimeInMillis(); // + (1000 * 60 * 60 * 24 * 7 * 4); long current = new Date().getTime(); long dif = current - t; Integer mili_week = 604800000; Long week = dif / mili_week; ++week; Log.d("sqle", "" + dif + " / " + mili_week + " = " + week); Date aux = new Date(t); Log.d("sqle", aux.toString()); if (t <= current /*|| week == 0*/) { // guardo el texto con la fecha y la calculo try { String fecha = " " + dia + "-" + mes + "-" + anio; String timestamp = "" + t; String week_str = "" + week; Log.d("sqle", "fecha " + fecha); HashMap<String, String> map = new HashMap<String, String>(); map.put("fecha_str", fecha); map.put("fecha_t", timestamp); map.put("fecha_en_semanas", week_str); MySQLiteHelper db = new MySQLiteHelper(this); if (bool) { db.updateFechaPeriodo(map); bool = true; } else { if (db.agregarFechas(map)) { bool = true; } else { bool = false; } } } catch (Exception e) { Toast.makeText( PanzaGaleria.this, "No se pudo guardar la fecha. Se le requerira en algunas secciones.", Toast.LENGTH_LONG) .show(); bool = false; } } else { // lanzo un error y le digo que ponga bien la fecha Toast.makeText(PanzaGaleria.this, "Fecha no valida", Toast.LENGTH_SHORT).show(); this.ingresarFecha(); bool = false; } return bool; }
@Override public void close() { dbHelper.close(); }
@Override public View onCreateView( LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState) { ClassScoreboard userScore; ClassUser user; MySQLiteHelper db; ClassLevel userLevel; ProgressBar mProgress; int circleAvatarV, pointsUV, answeredWrongUV, questionsA; String levelNameV, levelDiscripV, usernameUV, emailUV, levelUV; View view = inflater.inflate(R.layout.fragment_userdetails, container, false); user = getArguments().getParcelable("chosenUser"); db = new MySQLiteHelper(getActivity()); userScore = db.getScore(user.getUser_id()); userLevel = db.getLevel(userScore.getLevel_id()); ImageView circleAvatar = (ImageView) view.findViewById(R.id.circleAvatar); TextView levelName = (TextView) view.findViewById(R.id.levelName); TextView levelDiscrip = (TextView) view.findViewById(R.id.levelDiscrip); TextView usernameU = (TextView) view.findViewById(R.id.usernameU); TextView emailU = (TextView) view.findViewById(R.id.emailU); TextView pointsU = (TextView) view.findViewById(R.id.pointsU); TextView levelU = (TextView) view.findViewById(R.id.levelU); TextView answeredWrongU = (TextView) view.findViewById(R.id.answeredWrongU); TextView answeredQuestions = (TextView) view.findViewById(R.id.answeredQuestionsU); circleAvatarV = getResources() .getIdentifier( user.getAvatar().toLowerCase(Locale.getDefault()), "drawable", getActivity().getPackageName()); circleAvatar.setImageResource(circleAvatarV); levelNameV = userLevel.getLevelname(); levelName.setText(levelNameV); levelDiscripV = userLevel.getLevelname(); levelDiscrip.setText(levelDiscripV); usernameUV = user.getUsername(); usernameU.setText(usernameUV); emailUV = user.getEmail(); emailU.setText(emailUV); pointsUV = userScore.getPoints(); pointsU.setText((String.valueOf(pointsUV))); answeredWrongUV = userScore.getWrong_number(); answeredWrongU.setText((String.valueOf(answeredWrongUV))); levelUV = Integer.toString(userScore.getLevel_id()); levelU.setText(levelUV); questionsA = (pointsUV / 10) + answeredWrongUV; answeredQuestions.setText(String.valueOf(questionsA)); mProgress = (ProgressBar) view.findViewById(R.id.progressBarU); mProgress.setProgress(pointsUV); ImageView btn; TextView txtV; for (int i = 1; i <= userScore.getLevel_id(); i++) { if (pointsUV >= i * 50) { if (i == 1) { txtV = (TextView) view.findViewById(R.id.txvElements); txtV.setVisibility(View.VISIBLE); } if (i == 9) { txtV = (TextView) view.findViewById(R.id.txvchallenges); txtV.setVisibility(View.VISIBLE); } btn = (ImageView) view.findViewById( getResources() .getIdentifier( "imageView" + String.valueOf(i), "id", getActivity().getPackageName())); btn.setVisibility(View.VISIBLE); } } return view; }
protected void onCreate(Bundle savedInstanceState) { requestWindowFeature(Window.FEATURE_NO_TITLE); super.onCreate(savedInstanceState); setContentView(R.layout.add_medicine); mySQLiteHelper = new MySQLiteHelper(add_medicine.this, "notepad.db", null, 1); db = mySQLiteHelper.getReadableDatabase(); text21m = (EditText) findViewById(R.id.text21m); latest_medicine = (TextView) findViewById(R.id.latest_medicine); latest_mdcount = (TextView) findViewById(R.id.latest_mdcount); latest_time = (TextView) findViewById(R.id.latest_truetime); input_count = (EditText) findViewById(R.id.input_count); medicine_name = (EditText) findViewById(R.id.medicine_name); TabHost tabHost; tabHost = getTabHost(); tabHost.addTab(tabHost.newTabSpec("tab1").setIndicator("录入").setContent(R.id.text1m)); tabHost.addTab(tabHost.newTabSpec("tab2").setIndicator("笔记").setContent(R.id.text2m)); tabHost.addTab(tabHost.newTabSpec("tab3").setIndicator("日志").setContent(R.id.text3m)); tabHost.setCurrentTab(0); // 用SharedPreference储存note SharedPreferences sp1 = getSharedPreferences("mdnote", MODE_PRIVATE); String notesString = sp1.getString("mdnote", ""); text21m.setText(notesString); cursor = db.query( "medicinetable", new String[] {"_id", "md", "mdcount", "time"}, null, null, null, null, null); if (cursor.moveToNext() != true) { latest_medicine.setText(""); latest_time.setText(""); latest_mdcount.setText(""); // cursor.close(); } else { cursor.moveToLast(); int mdindex = cursor.getColumnIndex("md"); String md = cursor.getString(mdindex); int mdcountindex = cursor.getColumnIndex("mdcount"); String mdcount = cursor.getString(mdcountindex); int timeindex = cursor.getColumnIndex("time"); String date = cursor.getString(timeindex); latest_medicine.setText(md); latest_time.setText(date); latest_mdcount.setText(mdcount); // cursor.close(); } tv = (TextView) findViewById(R.id.TextView001m); lv = (ListView) findViewById(R.id.ListView01m); // 数据库 // db=mySQLiteHelper.getReadableDatabase(); // cursor=db.query("medicinetable", new String[]{"_id","md","mdcount","time"}, null, null, null, // null, null); if (cursor.getCount() > 0) { tv.setVisibility(View.GONE); } SimpleCursorAdapter sca = new SimpleCursorAdapter( add_medicine.this, R.layout.md_item, cursor, new String[] {"md", "mdcount", "time"}, new int[] {R.id.TextView01m, R.id.TextView02m, R.id.TextView03m}); lv.setAdapter(sca); lv.setOnItemClickListener( new OnItemClickListener() { public void onItemClick(AdapterView<?> arg0, View arg1, int which, long arg3) { Builder builder = new Builder(add_medicine.this); builder.setSingleChoiceItems( new String[] {"查看", "修改", "删除"}, -1, new OnClickListener() { public void onClick(DialogInterface dialog, int which) { if (which == 0 && cursor.getCount() != 0) { int mdindex = cursor.getColumnIndex("md"); mdString = cursor.getString(mdindex); int ctindex = cursor.getColumnIndex("mdcount"); ctString = cursor.getString(ctindex); Toast.makeText( add_medicine.this, mdString + "|" + ctString + "片", Toast.LENGTH_SHORT) .show(); } else if (which == 2 && cursor.getCount() != 0) { int myidindex = cursor.getColumnIndex("_id"); myid = cursor.getInt(myidindex); Builder builder02 = new Builder(add_medicine.this); LayoutInflater inflater = LayoutInflater.from(add_medicine.this); View view = inflater.inflate(R.layout.deleteview, null); builder02.setView(view); builder02.setPositiveButton( "确定", new DialogInterface.OnClickListener() { public void onClick(DialogInterface dialog, int which) { db.delete("medicinetable", "_id=" + myid, null); cursor = db.query( "medicinetable", new String[] {"_id", "md", "mdcount", "time"}, null, null, null, null, null); SimpleCursorAdapter sca = new SimpleCursorAdapter( add_medicine.this, R.layout.md_item, cursor, new String[] {"md", "mdcount", "time"}, new int[] { R.id.TextView01m, R.id.TextView02m, R.id.TextView03m }); lv.setAdapter(sca); } }); builder02.setNegativeButton( "取消", new DialogInterface.OnClickListener() { public void onClick(DialogInterface dialog, int which) {} }); builder02.show(); } else if (which == 1 && cursor.getCount() != 0) { // 取得数据 int myidindex = cursor.getColumnIndex("_id"); myid = cursor.getInt(myidindex); Builder builder01 = new Builder(add_medicine.this); builder01.setTitle("编辑"); LayoutInflater inflater = LayoutInflater.from(add_medicine.this); View view = inflater.inflate(R.layout.md_updatedialogview, null); et01 = (EditText) view.findViewById(R.id.ed1m); et02 = (EditText) view.findViewById(R.id.ed2m); builder01.setView(view); builder01.setPositiveButton( "确定", new DialogInterface.OnClickListener() { public void onClick(DialogInterface dialog, int which) { String md = et01.getText().toString(); String ct = et02.getText().toString(); if (TextUtils.isEmpty(md) || TextUtils.isEmpty(ct)) { } else { ContentValues cv = new ContentValues(); cv.put("md", md); cv.put("mdcount", ct); db.update("medicinetable", cv, "_id=" + myid, null); cursor = db.query( "medicinetable", new String[] {"_id", "md", "mdcount", "time"}, null, null, null, null, null); SimpleCursorAdapter sca = new SimpleCursorAdapter( add_medicine.this, R.layout.md_item, cursor, new String[] {"md", "mdcount", "time"}, new int[] { R.id.TextView01m, R.id.TextView02m, R.id.TextView03m }); lv.setAdapter(sca); } } }); builder01.setNegativeButton( "取消", new DialogInterface.OnClickListener() { public void onClick(DialogInterface dialog, int which) {} }); builder01.show(); } } }); builder.show(); } }); }
public NoteDataSource(Context context) { sqlHelper = MySQLiteHelper.getsInstance(context); this.database = sqlHelper.getWritableDatabase(); }
@Override protected void onCreate(Bundle savedInstanceState) { // TODO Auto-generated method stub super.onCreate(savedInstanceState); setContentView(R.layout.activity_search_list); list = getListView(); backBtn = (ImageButton) findViewById(R.id.backBtn); priceBtn = (Button) findViewById(R.id.orderByPriceBtn); timeBtn = (Button) findViewById(R.id.orderByTimeBtn); tvnomatchfound = (TextView) findViewById(R.id.tvnomatchfound); backBtn.setOnClickListener( new View.OnClickListener() { @Override public void onClick(View arg0) { // TODO Auto-generated method stub new HomeFragment().refresh(); shared.fromString = ""; shared.toString = ""; shared.through1String = ""; shared.fromPrice = ""; shared.toPrice = ""; shared.departureDate = ""; shared.day = ""; if (shared.through2String.length() > 0) { shared.through2String = ""; } if (shared.through3String.length() > 0) { shared.through3String = ""; } if (HomeFragment.throughPath2 != null) { HomeFragment.throughPath2.setText(""); HomeFragment.throughPath2.setEnabled(true); HomeFragment.throughPath2.setFocusableInTouchMode(true); HomeFragment.throughPath2.setError(null); } if (HomeFragment.throughPath3 != null) { HomeFragment.throughPath3.setText(""); HomeFragment.throughPath3.setEnabled(true); HomeFragment.throughPath3.setFocusableInTouchMode(true); HomeFragment.throughPath3.setError(null); } HomeActivity.mFrameLayout.setVisibility(View.GONE); finish(); } }); priceBtn.setOnClickListener( new OnClickListener() { @Override public void onClick(View arg0) { // TODO Auto-generated method stub @SuppressWarnings("unused") String arrange = selectQuery("cost", true); Toast.makeText( getApplicationContext(), "Transports ordered in price", Toast.LENGTH_SHORT) .show(); if (price_clicked == false) { price_clicked = true; time_clicked = false; cur = dbHelper.getData(myquery + " order by transportation.cost" + " asc"); adpater1.cursor = cur; System.out.println("arrange"); adpater1.notifyDataSetChanged(); } } }); timeBtn.setOnClickListener( new OnClickListener() { @Override public void onClick(View arg0) { // TODO Auto-generated method stub @SuppressWarnings("unused") String arrange = selectQuery("cost", true); Toast.makeText( getApplicationContext(), "Transports ordered in time", Toast.LENGTH_SHORT) .show(); if (time_clicked == false) { price_clicked = false; time_clicked = true; cur = dbHelper.getData(myquery + " order by transportation.interval" + " asc"); adpater1.cursor = cur; adpater1.notifyDataSetChanged(); } } }); dbHelper = new MySQLiteHelper(getApplicationContext()); if (shared.vehicle != "all") v_id = dbHelper.getIdForName(dbHelper.TAG_TYPE, shared.vehicle); try { myquery = selectQuery("cost", true); } catch (Exception e) { } cur = dbHelper.getData(myquery); try { if (cur.getCount() == 0) { // here cur is null so we will have to check if direct path is // possible without other search criteria before giving // suggestions myquery = selectQuery("cost", false); Cursor cur1 = dbHelper.getData(myquery); if (cur1.getCount() == 0) { head = true; Intent intentnomatch = new Intent(getApplicationContext(), NoMatchFound.class); startActivityForResult(intentnomatch, 2); } else { // -------------------- list.setVisibility(View.GONE); tvnomatchfound.setVisibility(View.VISIBLE); } } } catch (Exception e) { } adpater1 = new MyArrayAdapter1(getApplicationContext(), cur); setListAdapter(adpater1); new HomeFragment().refresh(); }
public void open() throws SQLException { database = dbHelper.getWritableDatabase(); }
public void close() { sqlHelper.close(); }
public void onClick(View v) { cinput1 = (EditText) findViewById(R.id.username_field); input1 = cinput1.getText().toString(); cinput2 = (EditText) findViewById(R.id.password_field); input2 = cinput2.getText().toString(); if (v.getId() == R.id.login_button) { if (checkFormat(input1) && checkFormat(input2)) { ArrayList<User> users = new ArrayList<User>(db.getAllUsers()); boolean contains = false; for (int i = 0; i < users.size(); i++) { if (users.get(i).getUsername().equals(input1) && users.get(i).getPassword().equals(input2)) { contains = true; if (contains) { System.out.println("Contains==True"); loggedUser = new User(users.get(i)); loggedId = loggedUser.getId(); loggedUsername = loggedUser.getUsername(); break; } } } if (contains) { AlertDialog.Builder dlgAlert = new AlertDialog.Builder(this); dlgAlert.setMessage("Successfully Logged in"); dlgAlert.setPositiveButton( "OK", new DialogInterface.OnClickListener() { public void onClick(DialogInterface dialog, int which) { Intent I = new Intent(getApplicationContext(), CancelHold.class); // ***PASS INFO TO RESULTS*** Bundle extraInfo = new Bundle(); // transactionStuff extraInfo.putString("username", loggedUsername); extraInfo.putInt("id", loggedId); I.putExtras(extraInfo); startActivity(I); } }); dlgAlert.setCancelable(true); dlgAlert.create().show(); } if (!contains) { AlertDialog.Builder dlgAlert = new AlertDialog.Builder(this); dlgAlert.setMessage("Sorry The Account Does Not Exist or Passowrd Is Incorrect."); dlgAlert.setPositiveButton( "OK", new DialogInterface.OnClickListener() { public void onClick(DialogInterface dialog, int which) {} }); dlgAlert.setCancelable(true); dlgAlert.create().show(); } } else { AlertDialog.Builder dlgAlert = new AlertDialog.Builder(this); dlgAlert.setMessage("Your Username or Password are not correctly formatted! Please Retry!"); dlgAlert.setPositiveButton( "OK", new DialogInterface.OnClickListener() { public void onClick(DialogInterface dialog, int which) {} }); dlgAlert.setCancelable(true); dlgAlert.create().show(); } } }
private void populateMyMovies(ListView tLV) throws ParseException { List<Movie> movies = db.getAllMovies(sortStr, sortDir); List<Map<String, String>> list = new ArrayList<Map<String, String>>(); if (movies.size() < 1) { toastMessage(MainActivity.this, getString(R.string.no_movie_notice)); } else { for (Movie i : movies) { Map map = new HashMap(); map.put("id", i.getId()); map.put("title", i.getTitle()); String target = i.getDateStr(); DateFormat df = new SimpleDateFormat("EEE MMM dd kk:mm:ss z yyyy", Locale.ENGLISH); DateFormat newf = new SimpleDateFormat("EEE, MMM d, yyyy", Locale.ENGLISH); Date mDate = df.parse(target); String newDate = newf.format(mDate); map.put("date", newDate); map.put("rating", i.getRating()); map.put("lat", String.valueOf(i.getVenue().getLat())); map.put("lng", String.valueOf(i.getVenue().getLng())); map.put("type", i.getVenue().getVenue_type()); map.put("venue_name", i.getVenue().getVenue_name()); list.add(map); } movieAdapter = new SimpleAdapter( this, list, R.layout.my_movies_layout, new String[] {"title", "date", "rating", "type"}, new int[] { R.id.my_movie_title, R.id.my_movie_date, R.id.my_movie_rating, R.id.my_movie_icon }); movieAdapter.setViewBinder(new MyMovieBinder()); tLV.setAdapter(movieAdapter); tLV.setLongClickable(true); tLV.setOnItemClickListener( new AdapterView.OnItemClickListener() { public void onItemClick(AdapterView<?> parent, View view, int position, long id) { Map item = (Map) parent.getAdapter().getItem(position); LatLng latlong = new LatLng( Double.valueOf(item.get("lat").toString()), Double.valueOf(item.get("lng").toString())); mMap.clear(); Marker marker = mMap.addMarker( new MarkerOptions() .position(latlong) .title(item.get("title").toString()) .snippet(item.get("venue_name").toString())); // Zoom in, animating the camera. mMap.animateCamera(CameraUpdateFactory.newLatLngZoom(latlong, 13), 800, null); marker.showInfoWindow(); } }); } }
public void close() { dbHelper.close(); }
public String selectQuery(String order, boolean check) { String MULTIPLE_VALID_ROUTE = ""; String single_route = ""; String ourCase = ""; String myquery = "select " + tablehelper.TransportationColumns.CONTACT_PHONE + ", " + tablehelper.TransportationColumns.DEPART_TIME + ", " + tablehelper.TransportationColumns.ARRIVAL_TIME + ", " + tablehelper.TransportationColumns.COST + ", " + tablehelper.TransportationColumns.REMARKS + ", " + tablehelper.TransportationColumns.TYPE_ID + ", " + tablehelper.TransportationColumns.ID + ", " + tablehelper.TransportationColumns.INTERVAL + ", " + tablehelper.TransportationColumns.ROUTE_ID + ", " + tablehelper.CompanyColumns.NAME + ", " + tablehelper.RouteColumns.FULL_ROUTE + " from " + tablehelper.TransportationColumns.TABLENAME + " JOIN " + tablehelper.ScheduleColumns.TABLENAME + " ON " + tablehelper.ScheduleColumns.TRANSPORTATION_ID + " = " + tablehelper.TransportationColumns.ID + " JOIN " + tablehelper.CompanyColumns.TABLENAME + " ON " + tablehelper.CompanyColumns.ID + " = " + tablehelper.TransportationColumns.COMPANY_ID + " JOIN " + tablehelper.RouteColumns.TABLENAME + " ON " + tablehelper.TransportationColumns.ROUTE_ID + " = " + tablehelper.RouteColumns.ID + " where route.full_route like '%" + shared.fromString + "%' and route.full_route like '%" + shared.toString + "%' and ('" + shared.fromString + "' = (select name from node where name = '" + shared.fromString + "')) and ('" + shared.toString + "' = (select name from node where name = '" + shared.toString + "'))"; if (check) myquery = appendParameterToQuery(myquery); myquery = myquery + " order by transportation." + order + " asc"; cur = dbHelper.getData(myquery); cur.moveToFirst(); int row_count = cur.getCount(); if (cur.getCount() == 0) { ourCase = "NO_ROUTE_ATALL_JPT"; } if (row_count == 1) { ourCase = "SINGLE_ROUTE"; int r_id = Integer.parseInt(cur.getString(cur.getColumnIndex("route_id"))); String quer1 = "select route_node.id from route_node where route_id = " + r_id + " and node_id = (select id from node where name = '" + shared.fromString + "')"; String quer2 = "select route_node.id from route_node where route_id = " + r_id + " and node_id = (select id from node where name = '" + shared.toString + "')"; Cursor cur1 = dbHelper.getData(quer1); Cursor cur2 = dbHelper.getData(quer2); cur1.moveToFirst(); cur2.moveToFirst(); List<Integer> r_n_id = new ArrayList<Integer>(); r_n_id.add(Integer.parseInt(cur1.getString(cur1.getColumnIndex("id")))); r_n_id.add(Integer.parseInt(cur2.getString(cur2.getColumnIndex("id")))); if (r_n_id.get(0) < r_n_id.get(1)) { single_route = "select " + tablehelper.TransportationColumns.CONTACT_PHONE + ", " + tablehelper.TransportationColumns.DEPART_TIME + ", " + tablehelper.TransportationColumns.ARRIVAL_TIME + ", " + tablehelper.TransportationColumns.COST + ", " + tablehelper.TransportationColumns.REMARKS + ", " + tablehelper.TransportationColumns.TYPE_ID + ", " + tablehelper.TransportationColumns.ID + ", " + tablehelper.TransportationColumns.INTERVAL + ", " + tablehelper.TransportationColumns.ROUTE_ID + ", " + tablehelper.CompanyColumns.NAME + ", " + tablehelper.RouteColumns.FULL_ROUTE + " from " + tablehelper.TransportationColumns.TABLENAME + " JOIN " + tablehelper.ScheduleColumns.TABLENAME + " ON " + tablehelper.ScheduleColumns.TRANSPORTATION_ID + " = " + tablehelper.TransportationColumns.ID + " JOIN " + tablehelper.CompanyColumns.TABLENAME + " ON " + tablehelper.CompanyColumns.ID + " = " + tablehelper.TransportationColumns.COMPANY_ID + " JOIN " + tablehelper.RouteColumns.TABLENAME + " ON " + tablehelper.TransportationColumns.ROUTE_ID + " = " + tablehelper.RouteColumns.ID + " where route.full_route like '%" + shared.fromString + "%' and route.full_route like '%" + shared.toString + "%' and route_id = " + r_id; } else { ourCase = "NO_ROUTE_ATALL_JPT"; // return "select * from route where name = 'aaa'"; } } if (row_count > 1) { ourCase = "MULTIPLE_ROUTE"; int correct_count = 0; List<Integer> r_id = new ArrayList<Integer>(); List<Integer> r_id_valid = new ArrayList<Integer>(); cur.moveToFirst(); while (!cur.isAfterLast()) { r_id.add(Integer.parseInt(cur.getString(cur.getColumnIndex("route_id")))); cur.moveToNext(); } int i = 0; while (i < r_id.size()) { String quer1 = "select route_node.id from route_node where route_id = " + r_id.get(i) + " and node_id = (select id from node where name = '" + shared.fromString + "')"; String quer2 = "select route_node.id from route_node where route_id = " + r_id.get(i) + " and node_id = (select id from node where name = '" + shared.toString + "')"; Cursor cur1 = dbHelper.getData(quer1); Cursor cur2 = dbHelper.getData(quer2); List<Integer> r_n_id = new ArrayList<Integer>(); cur1.moveToFirst(); cur2.moveToFirst(); r_n_id.add(Integer.parseInt(cur1.getString(cur1.getColumnIndex("id")))); r_n_id.add(Integer.parseInt(cur2.getString(cur2.getColumnIndex("id")))); Log.d("crossvoer", "values of r_n_id:" + r_n_id); if (r_n_id.get(0) < r_n_id.get(1)) { // save r_id in another list r_id_valid.add(r_id.get(i)); correct_count++; } i++; } if (correct_count == 0) { ourCase = "NO_ROUTE_ATALL_JPT"; } if (correct_count > 0) { ourCase = "MULTIPLE_ROUTE"; } StringBuilder MULTIPLE_ROUTE_VALID_ROUTE = new StringBuilder(); MULTIPLE_ROUTE_VALID_ROUTE.append( "select " + tablehelper.TransportationColumns.CONTACT_PHONE + ", " + tablehelper.TransportationColumns.DEPART_TIME + ", " + tablehelper.TransportationColumns.ARRIVAL_TIME + ", " + tablehelper.TransportationColumns.COST + ", " + tablehelper.TransportationColumns.REMARKS + ", " + tablehelper.TransportationColumns.TYPE_ID + ", " + tablehelper.TransportationColumns.ID + ", " + tablehelper.TransportationColumns.INTERVAL + ", " + tablehelper.TransportationColumns.ROUTE_ID + ", " + tablehelper.CompanyColumns.NAME + ", " + tablehelper.RouteColumns.FULL_ROUTE + " from " + tablehelper.TransportationColumns.TABLENAME + " JOIN " + tablehelper.ScheduleColumns.TABLENAME + " ON " + tablehelper.ScheduleColumns.TRANSPORTATION_ID + " = " + tablehelper.TransportationColumns.ID + " JOIN " + tablehelper.CompanyColumns.TABLENAME + " ON " + tablehelper.CompanyColumns.ID + " = " + tablehelper.TransportationColumns.COMPANY_ID + " JOIN " + tablehelper.RouteColumns.TABLENAME + " ON " + tablehelper.TransportationColumns.ROUTE_ID + " = " + tablehelper.RouteColumns.ID + " where route.full_route like '%" + shared.fromString + "%' and route.full_route like '%" + shared.toString + "%' and route_id in ("); Iterator<Integer> it = r_id_valid.iterator(); while (it.hasNext()) { MULTIPLE_ROUTE_VALID_ROUTE.append(it.next()); MULTIPLE_ROUTE_VALID_ROUTE.append(","); } MULTIPLE_ROUTE_VALID_ROUTE.append("0)"); MULTIPLE_VALID_ROUTE = MULTIPLE_ROUTE_VALID_ROUTE.toString(); } // end of if if (ourCase.equals("NO_ROUTE_ATALL_JPT")) { return "select full_route from route where name = 'aaa'"; } else if (ourCase.equals("SINGLE_ROUTE")) { return single_route; } else if (ourCase.equals("MULTIPLE_ROUTE")) { return MULTIPLE_VALID_ROUTE; } else return ""; }