This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
built_in:database [2015/09/19 08:28] stevegarman [Description] |
built_in:database [2017/04/15 20:20] 65.103.182.121 old revision restored (2015/09/19 08:28) |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== Database ====== | + | i hpe you love dick |
- | + | ||
- | ===== Description ===== | + | |
- | Create or open a database using the OpenDatabase method of the [[built_in: | + | |
- | < | + | |
- | //the database is called " | + | |
- | db = app.OpenDatabase( " | + | |
- | </ | + | |
- | To save your database in a specific folder, use an absolute path. See [[built_in: | + | |
- | + | ||
- | ===== Methods ===== | + | |
- | ^Method ^Description ^ | + | |
- | |Database.Close() | | | + | |
- | |Database.Delete() | | | + | |
- | |Database.ExecuteSql( sql, params, success, error ) | | | + | |
- | |Database.GetName() | | | + | |
- | |Database.GetType() | | | + | |
- | |Database.openError(e) | | | + | |
- | |Database.openSuccess() | | | + | |
- | + | ||
- | ===== Example ===== | + | |
- | //(sample taken from the DroidScript sample section)// | + | |
- | + | ||
- | <code javascript> | + | |
- | + | ||
- | // | + | |
- | function OnStart() | + | |
- | { | + | |
- | // | + | |
- | lay = app.CreateLayout( " | + | |
- | + | ||
- | // | + | |
- | btnAdd = app.CreateButton( " | + | |
- | btnAdd.SetOnTouch( btnAdd_OnTouch ); | + | |
- | lay.AddChild( btnAdd ); | + | |
- | + | ||
- | // | + | |
- | btnRemove = app.CreateButton( " | + | |
- | btnRemove.SetOnTouch( btnRemove_OnTouch ); | + | |
- | lay.AddChild( btnRemove ); | + | |
- | + | ||
- | // | + | |
- | btnDelete = app.CreateButton( " | + | |
- | btnDelete.SetOnTouch( btnDelete_OnTouch ); | + | |
- | lay.AddChild( btnDelete ); | + | |
- | + | ||
- | // | + | |
- | txt = app.CreateText( "", | + | |
- | txt.SetMargins( 0, | + | |
- | txt.SetBackColor( "# | + | |
- | txt.SetTextSize( 18 ); | + | |
- | lay.AddChild( txt ); | + | |
- | + | ||
- | // | + | |
- | app.AddLayout( lay ); | + | |
- | + | ||
- | // | + | |
- | db = app.OpenDatabase( " | + | |
- | + | ||
- | // | + | |
- | db.ExecuteSql( " | + | |
- | " | + | |
- | + | ||
- | // | + | |
- | DisplayAllRows(); | + | |
- | } | + | |
- | + | ||
- | // | + | |
- | function btnAdd_OnTouch() | + | |
- | { | + | |
- | // | + | |
- | db.ExecuteSql( " | + | |
- | " | + | |
- | + | ||
- | // | + | |
- | DisplayAllRows(); | + | |
- | } | + | |
- | + | ||
- | // | + | |
- | function btnRemove_OnTouch() | + | |
- | { | + | |
- | // | + | |
- | db.ExecuteSql( " | + | |
- | + | ||
- | // | + | |
- | DisplayAllRows(); | + | |
- | } | + | |
- | + | ||
- | // | + | |
- | function btnDelete_OnTouch() | + | |
- | { | + | |
- | // | + | |
- | db.Delete(); | + | |
- | + | ||
- | // | + | |
- | DisplayAllRows(); | + | |
- | } | + | |
- | + | ||
- | // | + | |
- | function DisplayAllRows() | + | |
- | { | + | |
- | txt.SetText("" | + | |
- | + | ||
- | // | + | |
- | db.ExecuteSql( " | + | |
- | } | + | |
- | + | ||
- | // | + | |
- | function OnResult( results ) | + | |
- | { | + | |
- | var s = ""; | + | |
- | var len = results.rows.length; | + | |
- | for(var i = 0; | + | |
- | { | + | |
- | var item = results.rows.item(i) | + | |
- | s += item.id + ", | + | |
- | } | + | |
- | txt.SetText( s ); | + | |
- | } | + | |
- | + | ||
- | // | + | |
- | function OnError( msg ) | + | |
- | { | + | |
- | app.Alert( " | + | |
- | console.log( " | + | |
- | } | + | |
- | + | ||
- | </ | + |