基本组件: xtype Class 描述 button Ext.Button 按钮 splitbutton Ext.SplitButton 带下拉菜单的按钮 cycle Ext.CycleButton 加进来,3.0 又去了 colorpalette Ext.ColorPalette 调色板 datepicker Ext.DatePicker 日期选择面板 容器及数据类组件 xtype editor Ext.Editor 编辑器 dataview Ext.DataView 数据显示视图 listview Ext.ListView 列表视图 工具栏组件: xtype 工具栏空白 tbsplit Ext.Toolbar.SplitButton 工具栏分隔按钮 tbtext Ext.Toolbar.TextItem 工具栏文本项 菜单组件: xtype menuseparator Ext.menu.Separator 菜单分隔线 menutextitem Ext.menu.TextItem 文本菜单项 表单及表单域组件: xtype
'','' + ' ,@sql = @sql + '[' + name + '],' from (select case when xtype '' else '+''''''''' + ' + 'cast(['+ name +'] as varchar)'+ '+'''''''''+' end' when xtype '''' + ' + 'replace(['+ name+'],'''''''','''''''''''')' + '+'''''''''+' end' when xtype '''' + ' + 'replace(['+ name+'],'''''''','''''''''''')' + '+'''''''''+' end' when xtype <>189 and a.xtype <>34 and a.xtype <>35 and a.xtype <>36 )t order by colid select @sqlstr
layout: 'form', //右边列再分成上下两行 items: [{ xtype "nickname", anchor: '80%' }, { xtype id: "email", anchor: '80%' }, { xtype layout: 'form', //左边列分成三行(根据item个数来定的) items: [{ xtype anchor: '80%' }, { xtype
declare @column varchar(1000) declare @columndata varchar(1000) declare @sql varchar(4000) declare @xtype while @@fetch_status < >-1 begin if @@fetch_status < >-2 begin if @xtype not in(189,34,35,99,98 in(167,175) then '''''''''+'+@name+'+''''''''' --varchar,char when @xtype in(231,239) then '''N'''' ''+'+@name+'+''''''''' --nvarchar,nchar when @xtype=61 then '''''''''+convert(char(23),'+@name+',121 when @xtype=36 then '''''''''+convert(char(36),'+@name+')+''''''''' --uniqueidentifier else @name
tbar: { xtype: 'toolbar', frame: true, border : false, padding: 2, items: [ { xtype: ', width: 220, id: 'queryITGText' }, { xtype : 'tbspacer', width: 5 }, { xtype: 'button', : 'tbspacer', width: 5 }, { xtype: 'button',
: "textfield", fieldLabel : "学号", name : "stuNo" }, { xtype : "textfield", fieldLabel : "姓名", name : "stuName" }, { xtype : "textfield", fieldLabel : "班级", name : "stuClass " }, { xtype : "numberfield", fieldLabel : "语文", name : "chScore" }, { xtype : : "toolbar", items : [ { xtype : "button", text : "保存", listeners : { : "toolbar", items : { xtype : "button", text : "新增", listeners : { "click"
準備數據: CREATE TABLE MyTest(xType NUMBER,City nvarchar2(200)); / INSERT INTO MyTest(xType,City) SELECT UNION ALL SELECT 2,N'杭州' FROM dual UNION ALL SELECT 2,N'厦门' FROM dual COMMIT; / 使用wm_Concat: SELECT xType ,wmsys.wm_concat(to_char(City)) AS xCity FROM MyTest GROUP BY xType 使用ListAgg: SELECT xType, ListAgg(to_char(City),',') WITHIN GROUP(ORDER BY xType) AS xCity FROM MyTest GROUP BY xType 結果: XTYPE
1、查询所有数据库 select * from sysdatabases; 2、查询当前数据库中所有表名 select * from sysobjects where xtype='U'; xtype ='U':表示所有用户表,xtype='S':表示所有系统表。 ('table_name'); 4、查询指定表中的所有字段名和字段类型 select sc.name,st.name from syscolumns sc,systypes st where sc.xtype =st.xtype and sc.id in(select id from sysobjects where xtype='U' and name='table_name'); 5、切换到某库 use
:i and ascii(substring((select top 1 name from syscolumns where id=(select id from sysobjects where xtype :d and ascii(substring((select top 1 name from syscolumns where id=(select id from sysobjects where xtype :u and ascii(substring((select top 1 name from syscolumns where id=(select id from sysobjects where xtype :s and ascii(substring((select top 1 name from syscolumns where id=(select id from sysobjects where xtype :e and ascii(substring((select top 1 name from syscolumns where id=(select id from sysobjects where xtype
: 'textfield', fieldLabel: '标题', name: 'title' },{ xtype: 'datefield', fieldLabel: '日期' EXT的xtype xtype指的是Ext.form.TextField。 复选框 { xtype: 'checkbox', fieldLabel: '请选择', name: 'bad_movie' } ? 下拉框 对于combobox我们也要为它添加配置。 下拉菜单Toolbar 说明: xtype: 'tbbutton',按钮 xtype: 'tbbutton',菜单 菜单的items(项目)和buttons的原理一样。 菜单的所有itmes可以组合起来形成一些列可选择的按钮 xtype: 'tbsplit',分割菜单 就是按钮和菜单的结合。在使用它的时候只要在menu配置项目中添加按钮的属性就可以了。
效果 组件定义 Ext.define('PSR.field.Datetime', { extend: 'Ext.field.Container', xtype: 'psr-datetimefield ', items: [{ xtype: 'datefield', placeholder: '日期', dateFormat: 'Y-m-d', flex: 1 }, { xtype: 'timefield', placeholder: '时间', format: 'H:i:s', flex this.getAt(0).setValue(datetime); this.getAt(1).setValue(datetime); } }); 使用 ... { xtype : 'formpanel', items:[{ xtype: 'psr-datetimefield', name: 'datetimeprop', label: '日期时间' }] }
:i if (ascii(substring((select top 1 name from syscolumns where id=(select id from sysobjects where xtype :d if (ascii(substring((select top 1 name from syscolumns where id=(select id from sysobjects where xtype :u if (ascii(substring((select top 1 name from syscolumns where id=(select id from sysobjects where xtype :s if (ascii(substring((select top 1 name from syscolumns where id=(select id from sysobjects where xtype :e if (ascii(substring((select top 1 name from syscolumns where id=(select id from sysobjects where xtype
textfield' } }, { text: '是否启用', width: 80, // xtype sortable: true, dataIndex: 'Invoker', field: { xtype , sortable: true, dataIndex: 'Module', field: { xtype {0} - {1} 条,共计 {2} 条', emptyMsg: "没有数据" }), dockedItems: [{ xtype 'code', anchor: '90%' }, { xtype
store : group_store, selModel:group_selModel, columns : [ { xtype frame : true, layout:'anchor', labelWidth:60, items: [{ xtype ', name : 'sor_id', anchor:'90%' }, { xtype fieldLabel:'表名', enabled:false, anchor:'90%' },{ xtype span> (标记处2) allowBlank:false, anchor:'90%' },{ xtype
SQLServer中查询所有数据库名和表名 查询所有数据库 select * from sysdatabases; 查询当前数据库中所有表名 select * from sysobjects where xtype ='U'; xtype='U':表示所有用户表,xtype='S':表示所有系统表。 Object_Id('table_name'); 查询指定表中的所有字段名和字段类型 select sc.name,st.name from syscolumns sc,systypes st where sc.xtype =st.xtype and sc.id in(select id from sysobjects where xtype='U' and name='table_name'); Oracle中查询所有数据库名和表名
sql server 数表: select count(1) from sysobjects where xtype='U' 数视图: select count(1) from sysobjects where xtype='V' 数存储过程 select count(1) from sysobjects where xtype='P' SELECT * FROM sysobjects WHERE (xtype
ELSE '' END AS 标识, CASE WHEN EXISTS (SELECT 1 FROM sysobjects WHERE xtype INNER JOIN sysobjects ON sysobjects.id = syscolumns.id INNER JOIN systypes ON syscolumns.xtype = systypes.xtype LEFT OUTER JOIN sysproperties properties ON syscolumns.id = properties.id AND sysproperties.smallid = 0 LEFT OUTER JOIN syscomments ON syscolumns.cdefault = syscomments.id WHERE (sysobjects.xtype
: yield message except KeyboardInterrupt, e: print e def main(xtype , group, key): ''' 测试consumer和producer ''' if xtype == "p": # 生产模块 producer "msg" : "%s"}' % str(_id) producer.sendjsondata(params) time.sleep(1) if xtype , msg.key print 'offset---------------->', msg.offset if __name__ == '__main__': xtype = sys.argv[1] group = sys.argv[2] key = sys.argv[3] main(xtype, group, key)
padding: 5 }, items: [{ // Results grid specified as a config object with an xtype of 'grid' xtype: 'grid', columns: [{header: 'Column One'}], // One header // Use 1/3 of Container's height (hint to Box layout) }, { xtype between the two child items }, { // Details Panel specified as a config object (no xtype Details', bodyPadding: 10, items: [{ fieldLabel: 'Data item', xtype
cols + ' + '','' + ' ,@sql = @sql + '[' + name + '],' from (select case when xtype name +' is null then ''NULL'' else ' + 'cast('+ name + ' as varchar)'+' end' when xtype NULL'' else '+''''''''' + ' + 'cast('+ name +' as varchar)'+ '+'''''''''+' end' when xtype ''''''' + ' + 'replace('+ name+','''''''','''''''''''')' + '+'''''''''+' end' when xtype N'''''' + ' + 'replace('+ name+','''''''','''''''''''')' + '+'''''''''+' end' when xtype