Experiment 8 SQLite Database operations

Lab Report

Course Name		Mobile Internet development based on Android platform		Date of experiment	May 4, 2016
Name of the experimental project		SQLite database Operations		Location of the experiment	S3010
Type of experiment		-Verification Type √ design type-comprehensive type		Hours	2
The purpose and requirements of the experiment (the knowledge points which are involved in this experiment and are required to be mastered)
Purpose Design a Personal Address book, master the development of the database under the Android platform, the personal Address Book mainly includes the contact list and contact details and other interfaces. Requirements The main interface of the program is the directory of contacts that displays the name of the contact on the phone. Long press the contact's name to display details about the contact. Add and Remove buttons to add contacts and delete contacts.
second, the experimental environment (the hardware equipment and related software used in this experiment)
(1) PC Machine (2) Operating system: Windows XP (3) Software: Eclipse, jdk1.6,android Sdk,adt
Third, the contents and steps of the experiment
1) Create a new contact project 2) Define string resource String.xml 3) Add a detail.xml and Item.xml file to the project 4) New Myopenhelper.java class 5) New Detailactivity.java class
Four, the experimental results (the experimental source program list and operating results or experimental conclusions, experimental design drawings)
Code: String.xml Code: Main_activity.xml's: Detail.xml's: Item.xml's: Mainactivity.java part of the code: Query edit box Listener (fuzzy query function): Remove Features: Add Features: Myopenhelper.java part of the code: Detailactivity.java part of the code: Save Button Event: Run Result: () Contacts all Communicator Display result graph: Fuzzy query: Add to: Remove the Communicator AA: To view individual Communicator details: To modify individual Communicator details:
Five, Experimental summary (analysis of the results of the experiment, experience and improvement of experimental ideas)
This experiment in the process of doing probably logical thinking has been, but halfway through the encounter some problems. During the experiment, I found that inserting Chinese-language data at the command prompt is garbled during the code query, because inserting data at the command prompt is not the same as Android encoding, and the other is basically no problem.
Experimental reviews
Experimental results			Guide Teacher Signature: Date

Experiment 8 SQLite Database operations