kivy python 读取oracle数据库_如何从Kivy数据库中获取spinner中的数据

在测试.py在import sqlite3 as lite

from kivy.uix.screenmanager import Screen

from kivy.app import App

from kivy.lang import Builder

from kivy.core.window import Window

from kivy.uix.popup import Popup

from kivy.uix.treeview import TreeView, TreeViewLabel, TreeViewNode

from kivy.uix.label import Label

from kivy.properties import ObjectProperty

Window.size = (700, 530)

con = lite.connect('demo.db')

con.text_factory = str

cur = con.cursor()

def populate_tree_view(tree_view, parent, node):

if parent is None:

tree_node = tree_view.add_node(TreeViewLabel(text=node['node_id'],

is_open=True))

else:

tree_node = tree_view.add_node(TreeViewLabel(text=node['node_id'],

is_open=True), parent)

for child_node in node['children']:

populate_tree_view(tree_view, tree_node, child_node)

tree = [{'node_id': 'Test2',

'children': []},

{'node_id': 'Test3',

'children': []}]

class TreeViewLabel(Label, TreeViewNode):

pass

class TreeviewGroup(Popup):

treeview = ObjectProperty(None)

tv = ObjectProperty(None)

def __init__(self, **kwargs):

super(TreeviewGroup, self).__init__(**kwargs)

self.tv = TreeView(root_options=dict(text="Test1"),

hide_root=False,

indent_level=4)

for branch in tree:

populate_tree_view(self.tv, None, branch)

self.remove_widgets()

self.treeview.add_widget(self.tv)

def remove_widgets(self):

for child in [child for child in self.treeview.children]:

self.treeview.remove_widget(child)

class GroupScreen(Screen):

groupName = ObjectProperty(None)

popup = ObjectProperty(None)

def display_groups(self, instance):

if len(instance.text) > 0:

self.popup = TreeviewGroup()

self.popup.open()

class Group(App):

#cur.execute("SELECT * FROM `m_state` order by state_id asc")

#rows = cur.fetchall()

#print(rows)

rows = [(1, 'test1', 111), (2, 'test2', 112), (3, 'test3', 113), (4, 'test4', 114)]

def build(self):

self.root = Builder.load_file('test.kv')

return self.root

if __name__ == '__main__':

Group().run()

在试验电压在

：基弗1.10.0

^{pr2}$

有人能帮我吗？

1在上面的图像中，状态代码显示了111111211314，它们是静电。怎么了为了动态显示这些状态代码。我从数据库中检索数据，该数据库看起来

行=[(1，'test1'，111)，(2，'test2'，112)，(3，'test3'，113)，(4，'test4'，114]

第三个索引值是1112113114。如何将这些值放入微调器。在