数据类型转换

Question

怎样把数据库里返回的数据集在 jsp页面上转换成下边形式的变量？            var teams = [{
                            'label': '江苏舜天队',
                            'value': '江苏舜天队',
                            'win': 14,
                            'tie': 9,
                            'lose': 3,
                            'score': 51
                        },{
                            'label': '广州恒大队',
                            'value': '广州恒大队',
                            'win': 15,
                            'tie': 6,
                            'lose': 5,
                            'score': 51
                        }]

Answer 1

你读取成list，然后直接使用fastjson转换
fastjson下载
http://code.alibabatech.com/wiki/display/FastJSON/Home

Answer 2

按照json格式重写bean的toString方法
然后放到list里输出就可以了啊 貌似

Answer 3

按照json个方法 后台将数据转换成字符串回调到前台页面 然后按照对象点属性的方法逐一点出来

Answer 4

<script type="text/javascript">
var teams=[];
var $$ = dwr.util.byId;

function getAllDrug(){
drugInfoService.sleAllDrugStr(result);
}

function result(data){
teams = data;
alert(teams + "\n \n LENGTH: " + teams.length);
        }

$(document).ready(function(){getAllDrug();});
      
 function methd(){
      $("#custom").AutoComplete({
                'data': teams,
                'width':170,
                'listStyle': 'custom',
                'maxHeight': 300,
                'createItemHandler': function(index, data){
               
                    var div = $("<div></div>")
                    var cell2 = $("<div style='display:table-cell;vertical-align:top;'></div>").appendTo(div);
                    var cell2_1 = $("<div></div>").append(data.drugName).appendTo(cell2);
                    var cell2_2 = $("<div style='vertical-align:top;'></div>")
.append("<div style='display:table-cell;width:100px;'>名称: "+data.drugName+"    </div>")
                                .append("<div style='display:table-cell;width:100px;'>单价: "+data.drugPrice+" 元</div>")
                                .append("<div style='display:table-cell;width:100px;'>库存: "+data.drugStock+" 克</div><br/>")
                                .appendTo(cell2);
                    return div;
                }
            }).AutoComplete('show');
}

</script>在文本框里还是不能自动检索，郁闷了。搞了一个网上了。

Answer 5

var teams = [{ 'label': '',
                            'value': 'AY',
  'drugName': '艾叶',
                            'drugPrice': 0.5,
                            'drugStock': 1000
                        },{
'label': '',
                            'value': 'AY',
  'drugName': '艾叶',
                            'drugPrice': 0.5,
                            'drugStock': 1000
                        },{
'label': '',
                            'value': 'AY',
  'drugName': '艾叶',
                            'drugPrice': 0.5,
                            'drugStock': 1000
                        },{
'label': '',
                            'value': 'AY',
  'drugName': '艾叶',
                            'drugPrice': 0.5,
                            'drugStock': 1000
                        },{
'label': '',
                            'value': 'AY',
  'drugName': '艾叶',
                            'drugPrice': 0.5,
                            'drugStock': 1000
                        },{
'label': '',
                            'value': 'AY',
  'drugName': '艾叶',
                            'drugPrice': 0.5,
                            'drugStock': 1000
                        },{
'label': '',
                            'value': 'BP',
  'drugName': '冰片',
                            'drugPrice': 1.0,
                            'drugStock': 1000
                        },{
'label': '',
                            'value': 'SX',
  'drugName': '麝香',
                            'drugPrice': 9.5,
                            'drugStock': 1000
                        }];
单独写个数据集 就可以自动检索，什么情况，郁闷！

Answer 6

function result(data){
teams = eval(data);
alert(teams + "\n \n LENGTH: " + teams.length);
        }
加了 eval（）之后

Answer 7

function result(data){
            teams = $.parseJSON(data);
            alert(teams + "\n \n LENGTH: " + teams.length);
        }

Answer 8

终于弄明白了，原来
{ 'label':    ' ',
        'value':    'AY',
'drugName': '艾叶',
        'drugPrice': 0.5,
        'drugStock': 1000
}
label 必须是String 类型的搞了一个晚上，谢谢各位了。