- 注册时间
- 2013-10-17
- 最后登录
- 2013-10-23
- 阅读权限
- 10
- 积分
- 20
- 精华
- 0
- 帖子
- 7
|
xiaohu 发表于 2013-10-17 16:54
就是我jsp里通过java代码查出数据拼接成这样的字符串,然后用json返回(附加:我用miniui.js控件会导致IE ...
我jsp中的代码和字符串拼接,我这个字符串有效吗,能返回并读出吗
<%
String data = "";
Connection db = null;
PreparedStatement stat = null;
ResultSet rs = null;
try{
db = ConnectionProvider.getConnection();
String sql1 = "select * from company_info where street = '五马街道'";
stat = db.prepareStatement(sql);
rs = stat.executeQuery();
data += "[{id: 'wmjd', text: '五马街道'},";
while(rs.next()){
data += "{id: 'aa', text: '"+rs.getString("companyname")+"', pid: 'wmjd'},";
}
String sql2 = "select * from company_info where street = '松台街道'";
stat = db.prepareStatement(sql);
rs = stat.executeQuery();
data += "{id: 'stjd', text: '松台街道'},";
while(rs.next()){
data += "{id: 'bb', text: '"+rs.getString("companyname")+"', pid: 'stjd'},";
}
data += "]";
|
|