SELECT * FROM (SELECT hh.*, ROWNUM RN FROM( SELECT
FLDACCOUNT "账号",
FLDVISITTIME "访问时间",
FLDURL "目标URL",
FLDTARGETIP "目标IP",
FLDTARGETPORT "目标端口",
FLDREQTYPE "访问类型",
FLDSOURCEIP "源IP",
FLDSOURCEPORT "源端口",
FLDSOURCEMAC "源MAC"
FROM
TBLUSERVISITLOG
WHERE
(1=1)
and (FLDACCOUNT <> '0' )) hh WHERE ROWNUM <= 15)WHERE RN >= 1求助正则表达式能不能帮我只截取里边“”号里边的内容用得是Java
FLDACCOUNT "账号",
FLDVISITTIME "访问时间",
FLDURL "目标URL",
FLDTARGETIP "目标IP",
FLDTARGETPORT "目标端口",
FLDREQTYPE "访问类型",
FLDSOURCEIP "源IP",
FLDSOURCEPORT "源端口",
FLDSOURCEMAC "源MAC"
FROM
TBLUSERVISITLOG
WHERE
(1=1)
and (FLDACCOUNT <> '0' )) hh WHERE ROWNUM <= 15)WHERE RN >= 1求助正则表达式能不能帮我只截取里边“”号里边的内容用得是Java
解决方案 »
- hibernate分页分页
- 调用远程ejb后出现与本地ejb冲突问题
- web 开发中,怎么实现,让数据记录向上向下移动功能
- 关于一个简单的链接传值的问题
- Struts+Spring+ibatis insert的问题
- 新手请教
- ext表格式下拉框问题
- JAVA下载LINUX的TXT文件,文件内容中文乱码
- struts中怎样给"<html:submit property="submit" value="submit"/>"之类的加.css叫...
- 一个简单问题,快来抢分啊!
- dos命令解压缩怎么写的
- 在eclipse+tomcat下开发 jsp+javabean jsp无法转换成servlet文件
String str = "SELECT * FROM (SELECT hh.*, ROWNUM RN FROM( SELECT\n";
str = str + "FLDACCOUNT \"账号\",\n";
str = str + "FLDVISITTIME \"访问时间\",\n";
str = str + "FLDURL \"目标URL\",\n";
str = str + "FLDTARGETIP \"目标IP\",\n";
str = str + "FLDTARGETPORT \"目标端口\",\n";
str = str + "FLDREQTYPE \"访问类型\",\n";
str = str + "FLDSOURCEIP \"源IP\",\n";
str = str + "FLDSOURCEPORT \"源端口\",\n";
str = str + "FLDSOURCEMAC \"源MAC\"\n"; Pattern addListener = Pattern.compile(".*\"(.*?)\".*");
Matcher matcher = addListener.matcher(str);
System.out.println(str); while (matcher.find()) {
System.out.println( matcher.group(1) );
}