This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
built_in:database [2017/04/15 20:20] 65.103.182.121 old revision restored (2015/09/19 08:28) |
built_in:database [2017/04/30 04:47] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | i hpe you love dick | + | ====== Database ====== |
+ | |||
+ | ===== 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( " | ||
+ | } | ||
+ | |||
+ | </ |