HTML5 local database basic operations _ html5 tutorial skills-

In the local database, we can directly create a database using JavaScript and execute related database operations using SQL statements. For complex databases, HTML5 uses a local database for operations. For more information, see the following section to describe the APIs and usage of the local database.

1. Use openDatabase to create a database

We can use the openDatabase method to create a database. The openDatabase method passes five parameters: Database Name, database version number (which can be omitted), description of the Database, size of the allocated database, and callback function.

To create a local database, run the following code:

Var myWebDatabase = openDatabase ("user", "1.0", "user info", 1024*1024, function (){});

In this way, a user information table is created. Then, you can verify whether the created local database is successful:

Copy content from SQL Code to clipboard

1. If (! DataBase ){
2. Alert ("The database has been created successfully !");
3. } Else {
4. Alert ("The database has not been successfully created .")
5. } If (! DataBase ){
6. Alert ("The database has been created successfully !");
7. } Else {
8. Alert ("The database has not been successfully created .")
9. }

2. Execute SQL statements using the executeSql Method

With the executeSql method, we can directly execute normal SQL statements, as follows:

Context.exe cuteSql ('insert INTO testTable (id, name) VALUES (1, "Martin ")');

Of course, this only shows the functions of executeSql, and does not explain exactly how to use and use the executeSql method. To use this method, you must introduce transaction.

3. Use transaction to process transactions

This method is used to process transactions. Three parameters can be passed: A method containing the transaction content, a successful callback function, and a failed callback function (the latter two can be omitted ).

Combined with transaction and executeSql, we can add and create data tables to the database we created earlier. The Code is as follows:

Copy the content to the clipboard using JavaScript Code

1. MyWebDatabase. transaction (function (context ){
2. Context.exe cuteSql ('create table if not exists testTable (id unique, name )');
3. Context.exe cuteSql ('insert INTO testTable (id, name) VALUES (0, "Byron ")');
4. Context.exe cuteSql ('insert INTO testTable (id, name) VALUES (1, "Casper ")');
5. Context.exe cuteSql ('insert INTO testTable (id, name) VALUES (2, "Frank ")');
6. });

The meaning of SQL statements is not explained much, but here we can clearly see how to create a database data table and add data in a local database.

The above is all the content of this article, hoping to help you learn.

Link: http://blog.csdn.net/fareise/article/details/50786594