tag:blogger.com,1999:blog-67700480307649050172024-03-13T05:45:48.449-07:00proxy-sitesjyotibahttp://www.blogger.com/profile/07468902621106592424noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-6770048030764905017.post-25083415578079428442017-04-01T03:40:00.002-07:002017-04-01T03:40:28.010-07:00Simple Database Insert/update/delete/serach/show opeartion using Sqlite <div dir="ltr" style="text-align: left;" trbidi="on">
package com.example.jyotibabhosale.practicedemo1database;<br /><br />import android.app.Activity;<br />import android.content.Context;<br />import android.database.Cursor;<br />import android.database.sqlite.SQLiteDatabase;<br />import android.os.Bundle;<br />import android.support.v7.app.AlertDialog;<br />import android.view.View;<br />import android.widget.Button;<br />import android.widget.TextView;<br /><br />public class MainActivity extends Activity {<br /><br /><br /> SQLiteDatabase db;<br /> TextView roll,name,marks;<br /> Button add,delete,update,view,viewall;<br /><br /> @Override<br /> protected void onCreate(final Bundle savedInstanceState) {<br /> super.onCreate(savedInstanceState);<br /> setContentView(R.layout.activity_main);<br /><br /> roll = (TextView) findViewById(R.id.editRoll);<br /> name = (TextView) findViewById(R.id.editName);<br /> marks = (TextView) findViewById(R.id.editMarks);<br /><br /> add = (Button) findViewById(R.id.btnAdd);<br /> delete = (Button) findViewById(R.id.btnDele);<br /> update = (Button) findViewById(R.id.btnUpda);<br /> view = (Button) findViewById(R.id.btnView);<br /> viewall = (Button) findViewById(R.id.btnViewAll);<br /><br /><br /> db = openOrCreateDatabase("jyo", Context.MODE_PRIVATE, null);<br /> db.execSQL("CREATE TABLE IF NOT EXISTS kaj(roll_no INTEGER,name VARCHAR,marks INTEGER);");<br /><br /> add.setOnClickListener(new View.OnClickListener() {<br /> @Override<br /> public void onClick(View view) {<br /> if (roll.getText().toString().trim().length() == 0 ||<br /> name.getText().toString().trim().length() == 0 ||<br /> marks.getText().toString().trim().length() == 0) {<br /> showMessage("Error", "plz enter a name");<br /> return;<br /> }<br /><br /> db.execSQL("INSERT INTO kaj VALUES('" + roll.getText() + "','" + name.getText() + "','" + marks.getText() + "');");<br /> showMessage("Success", "Record Inserted successfully");<br /> clearTest();<br /> }<br /> });<br /><br /> update.setOnClickListener(new View.OnClickListener() {<br /> @Override<br /> public void onClick(View view) {<br /> if (roll.getText().toString().trim().length() == 0) {<br /> showMessage("Error", "Enter a Roll_no");<br /> }<br /><br /> Cursor c = db.rawQuery("SELECT * FROM kaj WHERE roll='" + roll.getText() + "'", null);<br /> if (c.moveToFirst()) {<br /> db.execSQL("UPDATE kaj SET name='" + name.getText() + "',marks='" + marks.getText() + "' WHERE roll='" + roll.getText() + "'");<br /> showMessage("Success", "record updated");<br /><br /> } else {<br /> showMessage("Error", "plz enter valid data");<br /> }<br /> clearTest();<br /><br /> }<br /> });<br /><br /> delete.setOnClickListener(new View.OnClickListener() {<br /> @Override<br /> public void onClick(View view) {<br /><br /> if (roll.getText().toString().length() == 0) {<br /> showMessage("Error", "enter a roll_no");<br /> }<br /> Cursor c = db.rawQuery("SELECT * FROM kaj WHERE roll='" + roll.getText() + "'", null);<br /> if (c.moveToFirst()) {<br /> db.execSQL("DELETE FROM kaj WHERE roll='" + roll.getText() + "'");<br /> showMessage("success", "record deleted");<br /><br /> }<br /> clearTest();<br /><br /> }<br /> });<br /> view.setOnClickListener(new View.OnClickListener() {<br /> @Override<br /> public void onClick(View view) {<br /><br /> if (roll.getText().toString().length() == 0) {<br /> showMessage("Error", "plz enter a roll");<br /> }<br /> Cursor c = db.rawQuery("SELECT * FROM kaj WHERE roll='" + roll.getText() + "'", null);<br /> if (c.moveToFirst()) {<br /> name.setText(c.getString(1));<br /> marks.setText(c.getString(2));<br /> } else {<br /> showMessage("error", "enter valid data");<br /> }<br /><br /> }<br /> });<br /><br /><br /> view.setOnClickListener(new View.OnClickListener() {<br /> @Override<br /> public void onClick(View view) {<br /><br /> if (roll.getText().toString().length() == 0) {<br /> showMessage("Error", "plz enter a valid data");<br /> }<br /> Cursor c = db.rawQuery("SELECT * FROM kaj WHERE roll='" + roll.getText() + "'", null);<br /> if (c.getCount() == 0) {<br /> showMessage("error", "no data found");<br /> }<br /> StringBuffer buffer = new StringBuffer();<br /> while (c.moveToFirst()) {<br /> buffer.append("roll_no:" + c.getString(0));<br /> buffer.append("name:" + c.getString(1));<br /> buffer.append("marks:" + c.getString(2));<br /> }<br /> showMessage("Success", buffer.toString());<br /><br /><br /> }<br /> });<br />/* db=openOrCreateDatabase("Mydb", Context.MODE_PRIVATE,null);<br /> db.execSQL("CREATE TABLE IF NOT EXISTS student(roll_no INTEGER,name VARCHAR,marks INTEGER);");<br /><br /> add.setOnClickListener(new View.OnClickListener() {<br /> @Override<br /> public void onClick(View view) {<br /><br /> if(roll.getText().toString().trim().length()==0||<br /> name.getText().toString().trim().length()==0||<br /> marks.getText().toString().trim().length()==0)<br /> {<br /><br /> showMessage("Error","Plz enter valid data");<br /> return;<br /><br /> }<br /><br /> db.execSQL("INSERT INTO student VALUES('"+roll.getText()+"','"+name.getText()+"','"+marks.getText()+"');");<br /> showMessage("Success","Record Insert Succssfully");<br /> clearTest();<br /> }<br /> });<br /><br /><br /> delete.setOnClickListener(new View.OnClickListener() {<br /> @Override<br /> public void onClick(View view) {<br /><br /> if(roll.getText().toString().trim().length()==0)<br /> {<br /> showMessage("Error","Plz Enter a Roll_no");<br /> return;<br /> }<br /> Cursor c=db.rawQuery("SELECT * FROM student WHERE roll_no='"+roll.getText()+"'",null);<br /> if(c.moveToFirst())<br /> {<br /> db.execSQL("DELETE FROM student WHERE roll_no='"+roll.getText()+"'");<br /> showMessage("Success","Record Deleted");<br /> }<br /> else<br /> {<br /> showMessage("Error","Invalid Roll_no");<br /> }<br /> clearTest();<br /> }<br /> });<br /><br /> update.setOnClickListener(new View.OnClickListener() {<br /> @Override<br /> public void onClick(View view) {<br /> if(roll.getText().toString().trim().length()==0)<br /> {<br /> showMessage("Error","Plz Enter Roll_no");<br /> return;<br /> }<br /><br /> Cursor c=db.rawQuery("SELECT * FROM student WHERE roll_no='"+roll.getText()+"'",null);<br /> if(c.moveToFirst())<br /> {<br /><br /> db.execSQL("UPDATE student SET name='"+name.getText()+"',marks='"+marks.getText()+"' WHERE roll_no='"+roll.getText()+"'");<br /> showMessage("Success","Record Updated");<br /> }<br /> else<br /> {<br /> showMessage("Error","Invlid Roll_no");<br /> }<br /> clearTest();<br /><br /> }<br /> });<br /><br /><br /> view.setOnClickListener(new View.OnClickListener() {<br /> @Override<br /> public void onClick(View view) {<br /><br /> if(roll.getText().toString().trim().length()==0)<br /> {<br /> showMessage("Error","plz Enter Roll_no");<br /> return;<br /> }<br /> Cursor c=db.rawQuery("SELECT * FROM student WHERE roll_no='"+roll.getText()+"'",null);<br /> if(c.moveToFirst())<br /> {<br /> name.setText(c.getString(1));<br /> marks.setText(c.getString(2));<br /> }<br /> else<br /> {<br /> showMessage("Error","Invalid Roll_no");<br /> }<br /> clearTest();<br /><br /> }<br /><br /><br /> });<br /><br /><br /> viewall.setOnClickListener(new View.OnClickListener() {<br /> @Override<br /> public void onClick(View view) {<br /><br /> if(roll.getText().toString().length()==0)<br /><br /> {<br /> showMessage("Error","Plz Enter Valid Data");<br /> return;<br /> }<br /> Cursor c=db.rawQuery("SELECT * FROM STUDENT",null);<br /> if(c.getCount()==0)<br /> {<br /> showMessage("Error","No Record Found");<br /> return;<br /> }<br /> StringBuffer buffer=new StringBuffer();<br /> while (c.moveToFirst())<br /> {<br /><br /> buffer.append("Roll_no:"+c.getString(0));<br /> buffer.append("Name:"+c.getString(1));<br /> buffer.append("Marks:"+c.getString(2));<br /> }<br /> showMessage("Student Details", buffer.toString());<br /><br /> }<br /> });<br /><br /> }<br />*/<br /> }<br /> public void showMessage(String title,String Message)<br /> {<br /> AlertDialog.Builder builder=new AlertDialog.Builder(this);<br /> builder.setCancelable(true);<br /> builder.setTitle(title);<br /> builder.setMessage(Message);<br /> builder.show();<br /> }<br /><br />public void clearTest()<br />{<br /> roll.setText("");<br /> name.setText("");<br /> marks.setText("");<br /> roll.requestFocus();<br />}<br /><br /><br /><br /><br /><br />}<br /></div>
jyotibahttp://www.blogger.com/profile/07468902621106592424noreply@blogger.com0