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();
|
