找个高手,写个jsp网页,简单查询mysql表记录 本帖最后由 SECOWU 于 2013-07-24 16:45:28 编辑 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 测试数据:-- ------------------------------ Records of logtab-- ----------------------------INSERT INTO `logtab` VALUES ('16820416', '1', '3925911744', '192.168.0.234', 'app.webaccess share.ti_sourceip+\' 192.168.0.234 \'+app.webaddr+\' api.m.taobao.com\'', '', '1', '1374535885', '网å€è®¿é—®ï¼šæºåœ°å€ 192.168.0.234 ç½‘ç«™åœ°å€ api.m.taobao.com', '網å€è¨ªå•ï¼šæºåœ°å€ 192.168.0.234 ç¶²ç«™åœ°å€ api.m.taobao.com', 'URL access: Source address 192.168.0.234 Website address api.m.taobao.com');INSERT INTO `logtab` VALUES ('16820416', '1', '3925911744', '192.168.0.234', 'app.webaccess share.ti_sourceip+\' 192.168.0.234 \'+app.webaddr+\' img01.taobaocdn.com\'', '', '2', '1374535886', '网å€è®¿é—®ï¼šæºåœ°å€ 192.168.0.234 ç½‘ç«™åœ°å€ img01.taobaocdn.com', '網å€è¨ªå•ï¼šæºåœ°å€ 192.168.0.234 ç¶²ç«™åœ°å€ img01.taobaocdn.com', 'URL access: Source address 192.168.0.234 Website address img01.taobaocdn.com');INSERT INTO `logtab` VALUES ('16820416', '1', '3925911744', '192.168.0.234', 'app.webaccess share.ti_sourceip+\' 192.168.0.234 \'+app.webaddr+\' img02.taobaocdn.com\'', '', '3', '1374535886', '网å€è®¿é—®ï¼šæºåœ°å€ 192.168.0.234 ç½‘ç«™åœ°å€ img02.taobaocdn.com', '網å€è¨ªå•ï¼šæºåœ°å€ 192.168.0.234 ç¶²ç«™åœ°å€ img02.taobaocdn.com', 'URL access: Source address 192.168.0.234 Website address img02.taobaocdn.com');INSERT INTO `logtab` VALUES ('16820416', '1', '3925911744', '192.168.0.234', 'app.webaccess share.ti_sourceip+\' 192.168.0.234 \'+app.webaddr+\' img01.taobaocdn.com\'', '', '4', '1374535887', '网å€è®¿é—®ï¼šæºåœ°å€ 192.168.0.234 ç½‘ç«™åœ°å€ img01.taobaocdn.com', '網å€è¨ªå•ï¼šæºåœ°å€ 192.168.0.234 ç¶²ç«™åœ°å€ img01.taobaocdn.com', 'URL access: Source address 192.168.0.234 Website address img01.taobaocdn.com');INSERT INTO `logtab` VALUES ('16820416', '1', '3925911744', '192.168.0.234', 'app.webaccess share.ti_sourceip+\' 192.168.0.234 \'+app.webaddr+\' api.m.taobao.com\'', '', '5', '1374535887', '网å€è®¿é—®ï¼šæºåœ°å€ 192.168.0.234 ç½‘ç«™åœ°å€ api.m.taobao.com', '網å€è¨ªå•ï¼šæºåœ°å€ 192.168.0.234 ç¶²ç«™åœ°å€ api.m.taobao.com', 'URL access: Source address 192.168.0.234 Website address api.m.taobao.com');INSERT INTO `logtab` VALUES ('16820416', '1', '3925911744', '192.168.0.234', 'app.webaccess share.ti_sourceip+\' 192.168.0.234 \'+app.webaddr+\' img01.taobaocdn.com\'', '', '6', '1374535887', '网å€è®¿é—®ï¼šæºåœ°å€ 192.168.0.234 ç½‘ç«™åœ°å€ img01.taobaocdn.com', '網å€è¨ªå•ï¼šæºåœ°å€ 192.168.0.234 ç¶²ç«™åœ°å€ img01.taobaocdn.com', 'URL access: Source address 192.168.0.234 Website address img01.taobaocdn.com');INSERT INTO `logtab` VALUES ('16820416', '1', '889235648', '192.168.0.53', 'app.webaccess share.ti_sourceip+\' 192.168.0.53 \'+app.webaddr+\' data.video.qiyi.com\'', '', '7', '1374535888', '网å€è®¿é—®ï¼šæºåœ°å€ 192.168.0.53 ç½‘ç«™åœ°å€ data.video.qiyi.com', '網å€è¨ªå•ï¼šæºåœ°å€ 192.168.0.53 ç¶²ç«™åœ°å€ data.video.qiyi.com', 'URL access: Source address 192.168.0.53 Website address data.video.qiyi.com');INSERT INTO `logtab` VALUES ('16820416', '1', '3925911744', '192.168.0.234', 'app.webaccess share.ti_sourceip+\' 192.168.0.234 \'+app.webaddr+\' img03.taobaocdn.com\'', '', '8', '1374535888', '网å€è®¿é—®ï¼šæºåœ°å€ 192.168.0.234 ç½‘ç«™åœ°å€ img03.taobaocdn.com', '網å€è¨ªå•ï¼šæºåœ°å€ 192.168.0.234 ç¶²ç«™åœ°å€ img03.taobaocdn.com', 'URL access: Source address 192.168.0.234 Website address img03.taobaocdn.com');INSERT INTO `logtab` VALUES ('16820416', '1', '3741362368', '192.168.0.223', 'app.webaccess share.ti_sourceip+\' 192.168.0.223 \'+app.webaddr+\' adshmct.qq.com\'', '', '9', '1374535888', '网å€è®¿é—®ï¼šæºåœ°å€ 192.168.0.223 ç½‘ç«™åœ°å€ adshmct.qq.com', '網å€è¨ªå•ï¼šæºåœ°å€ 192.168.0.223 ç¶²ç«™åœ°å€ adshmct.qq.com', 'URL access: Source address 192.168.0.223 Website address adshmct.qq.com'); 帮我在查询显示的访问网址即clogcontent里的网址给单独显示出来成这个样式,方便点击跳转,例如:api.m.taobao.com 急,急,如何把数据库查询的数据在jsp页面上用 下拉框显示 struts2错误,帮忙看看 用struts开发web中遇到的问题 td 属性 Tomcat中数据库连接池的配置解决方案 如何读取控件的中文值? 在地址栏上输入http://localhost:8080 没有反应呢? 利用业务时间花了大半年做了一个findmaven的网站,大家给点建议 向高手请教如何将一字符串从十进制轮换为十进制? 求助:关于类数组的问题 连接mysql数据库出错 DetachedCriteria查询,怎么通过给定的单词去查询不包含这些单词的信息?
-- ----------------------------
-- Records of logtab
-- ----------------------------
INSERT INTO `logtab` VALUES ('16820416', '1', '3925911744', '192.168.0.234', 'app.webaccess share.ti_sourceip+\' 192.168.0.234 \'+app.webaddr+\' api.m.taobao.com\'', '', '1', '1374535885', '网å€è®¿é—®ï¼šæºåœ°å€ 192.168.0.234 ç½‘ç«™åœ°å€ api.m.taobao.com', '網å€è¨ªå•ï¼šæºåœ°å€ 192.168.0.234 ç¶²ç«™åœ°å€ api.m.taobao.com', 'URL access: Source address 192.168.0.234 Website address api.m.taobao.com');
INSERT INTO `logtab` VALUES ('16820416', '1', '3925911744', '192.168.0.234', 'app.webaccess share.ti_sourceip+\' 192.168.0.234 \'+app.webaddr+\' img01.taobaocdn.com\'', '', '2', '1374535886', '网å€è®¿é—®ï¼šæºåœ°å€ 192.168.0.234 ç½‘ç«™åœ°å€ img01.taobaocdn.com', '網å€è¨ªå•ï¼šæºåœ°å€ 192.168.0.234 ç¶²ç«™åœ°å€ img01.taobaocdn.com', 'URL access: Source address 192.168.0.234 Website address img01.taobaocdn.com');
INSERT INTO `logtab` VALUES ('16820416', '1', '3925911744', '192.168.0.234', 'app.webaccess share.ti_sourceip+\' 192.168.0.234 \'+app.webaddr+\' img02.taobaocdn.com\'', '', '3', '1374535886', '网å€è®¿é—®ï¼šæºåœ°å€ 192.168.0.234 ç½‘ç«™åœ°å€ img02.taobaocdn.com', '網å€è¨ªå•ï¼šæºåœ°å€ 192.168.0.234 ç¶²ç«™åœ°å€ img02.taobaocdn.com', 'URL access: Source address 192.168.0.234 Website address img02.taobaocdn.com');
INSERT INTO `logtab` VALUES ('16820416', '1', '3925911744', '192.168.0.234', 'app.webaccess share.ti_sourceip+\' 192.168.0.234 \'+app.webaddr+\' img01.taobaocdn.com\'', '', '4', '1374535887', '网å€è®¿é—®ï¼šæºåœ°å€ 192.168.0.234 ç½‘ç«™åœ°å€ img01.taobaocdn.com', '網å€è¨ªå•ï¼šæºåœ°å€ 192.168.0.234 ç¶²ç«™åœ°å€ img01.taobaocdn.com', 'URL access: Source address 192.168.0.234 Website address img01.taobaocdn.com');
INSERT INTO `logtab` VALUES ('16820416', '1', '3925911744', '192.168.0.234', 'app.webaccess share.ti_sourceip+\' 192.168.0.234 \'+app.webaddr+\' api.m.taobao.com\'', '', '5', '1374535887', '网å€è®¿é—®ï¼šæºåœ°å€ 192.168.0.234 ç½‘ç«™åœ°å€ api.m.taobao.com', '網å€è¨ªå•ï¼šæºåœ°å€ 192.168.0.234 ç¶²ç«™åœ°å€ api.m.taobao.com', 'URL access: Source address 192.168.0.234 Website address api.m.taobao.com');
INSERT INTO `logtab` VALUES ('16820416', '1', '3925911744', '192.168.0.234', 'app.webaccess share.ti_sourceip+\' 192.168.0.234 \'+app.webaddr+\' img01.taobaocdn.com\'', '', '6', '1374535887', '网å€è®¿é—®ï¼šæºåœ°å€ 192.168.0.234 ç½‘ç«™åœ°å€ img01.taobaocdn.com', '網å€è¨ªå•ï¼šæºåœ°å€ 192.168.0.234 ç¶²ç«™åœ°å€ img01.taobaocdn.com', 'URL access: Source address 192.168.0.234 Website address img01.taobaocdn.com');
INSERT INTO `logtab` VALUES ('16820416', '1', '889235648', '192.168.0.53', 'app.webaccess share.ti_sourceip+\' 192.168.0.53 \'+app.webaddr+\' data.video.qiyi.com\'', '', '7', '1374535888', '网å€è®¿é—®ï¼šæºåœ°å€ 192.168.0.53 ç½‘ç«™åœ°å€ data.video.qiyi.com', '網å€è¨ªå•ï¼šæºåœ°å€ 192.168.0.53 ç¶²ç«™åœ°å€ data.video.qiyi.com', 'URL access: Source address 192.168.0.53 Website address data.video.qiyi.com');
INSERT INTO `logtab` VALUES ('16820416', '1', '3925911744', '192.168.0.234', 'app.webaccess share.ti_sourceip+\' 192.168.0.234 \'+app.webaddr+\' img03.taobaocdn.com\'', '', '8', '1374535888', '网å€è®¿é—®ï¼šæºåœ°å€ 192.168.0.234 ç½‘ç«™åœ°å€ img03.taobaocdn.com', '網å€è¨ªå•ï¼šæºåœ°å€ 192.168.0.234 ç¶²ç«™åœ°å€ img03.taobaocdn.com', 'URL access: Source address 192.168.0.234 Website address img03.taobaocdn.com');
INSERT INTO `logtab` VALUES ('16820416', '1', '3741362368', '192.168.0.223', 'app.webaccess share.ti_sourceip+\' 192.168.0.223 \'+app.webaddr+\' adshmct.qq.com\'', '', '9', '1374535888', '网å€è®¿é—®ï¼šæºåœ°å€ 192.168.0.223 ç½‘ç«™åœ°å€ adshmct.qq.com', '網å€è¨ªå•ï¼šæºåœ°å€ 192.168.0.223 ç¶²ç«™åœ°å€ adshmct.qq.com', 'URL access: Source address 192.168.0.223 Website address adshmct.qq.com');
api.m.taobao.com