summaryrefslogtreecommitdiffstats
path: root/kjsembed/docs/examples/sql/sql.js
blob: 5ef568de293869af1e318a8d7cdea9d833b6f421 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
#!/usr/bin/env kjscmd

var db = new SqlDatabase();
var mw = new KMainWindow();
var box = new QVBox( mw );
mw.setCentralWidget(box);

if ( db.addDatabase("QMYSQL3", "test" ))
{
	db.databaseName = "XXXX";
	db.userName = "XXXX";
	db.password = "XXXX";
	db.hostName = "XXXX";
	db.port = 3306;
	println("Database Name:" + db.databaseName);
	println("User Name:" + db.userName);
	println("Password:" + db.password);
	println("Host Name:" + db.hostName);
	println("Port:" + db.port);
	println("Driver Name:" + db.driverName);
	var list = new KListView(box);
	list.addColumn('One');
	list.addColumn('Two');
	list.addColumn('Three');
	if( db.open() )
	{
		var query = db.exec("select * from tasks" );
		println(query.size + " Results returned");
		if (query.active)
		{
			println(query.size + " Results returned");
			if( query.first() )
			{
				while( query.next())
				{
					println(query.value(0).toString() + " " +
							query.value(1).toString() + " " +
							query.value(2).toString());

					list.insertItem(query.value(0).toString(),
							query.value(1).toString(),
							query.value(2).toString());
				}
			}
			else
				println("Query Error: " + query.lastError);
		}
		else
			println("Database Connection Error: " + db.lastError);

	}
	else
		println("Database Open Error: " + db.lastError);
}
else
	println("Database Connection Error: " + db.lastError);
mw.show();