Before getting into example, we should know what sqlite data base in android is. SQLite is an open source SQL database that stores data to a text file on a device. Android comes in with built in SQLite database implementation. SQLite supports all the relational database features. In order to access this database, you don't need to establish any kind of connections for it like JDBC, ODBC etc. This example demonstrate about How to encrypt pass word and store in Android sqlite Step 1 − Create a new project in Android Studio, go to File ⇒ New Project and fill all required details to create a new project. Step 2 − Add the following code to res/layout/ xml version="1. 0" encoding="utf-8"? >
How to get data from the existing SQLite on Android - Quora rawQuery("select (id ||': '||name || ': ' ||salary || ': '|| datetime) as fullname from " + CONTACTS_TABLE_NAME, null);
veToFirst();
while (AfterLast() == false) {
if ((res! = null) && (tCount() > 0))
(tString(tColumnIndex("fullname")));
veToNext();}
return array_list;}
public boolean update(String s, String s1) {
db. execSQL("UPDATE " + CONTACTS_TABLE_NAME + " SET name = " + "'" + s + "', " + "salary = " + "'" + s1 + "'");
public boolean delete() {
db. execSQL("DELETE from " + CONTACTS_TABLE_NAME);
return true;}} Let's try to run your application. I assume you have connected your actual Android Mobile device with your computer. To run the app from android studio, open one of your project's activity files and click Run icon from the toolbar. Select your mobile device as an option and then check your mobile device which will display your default screen − In the above result, it is storing salary in integer now click on refresh button to get encrypted salay as shown below Click here to download the project code
Published on 15-Mar-2019 15:29:57 Much more than documents. Discover everything Scribd has to offer, including books and audiobooks from major publishers. Cancel anytime. Documents Computers 0% found this document useful (0 votes) 64 views 35 pages Description: SQLITE and android Date uploaded Oct 09, 2015 Copyright © © All Rights Reserved Available Formats PDF, TXT or read online from Scribd Did you find this document useful? 0% found this document useful (0 votes) 64 views 35 pages Jump to Page You are on page 1 of 35
You're Reading a Free Preview
Pages 7 to 16 are not shown in this preview. Pages 20 to 22 are not shown in this preview. Pages 26 to 32 are not shown in this preview. Reward Your Curiosity Everything you want to read. Anytime. Anywhere. Any device. No Commitment. Cancel anytime.Vogella android sqlite server
Vogella android sqlite tool
How to get data from the existing SQLite on Android - Quora