apple578994358gg
- 浏览: 52494 次
-
最新评论
文章列表
sql语句按条件取值
- 博客分类：
- descode函数
根据类型返回字段名 如果是0 返回 用户名 如果是 1 返回机构名
select t.rcv_type, decode(t.rcv_type, 0, (select tt.name
from tb_user tt
where t.* ** **
), 1, (select ttt.dept_name
...
dom4j增删改查
- 博客分类：
- dom4j操作XML文件
xml文件
<?xml version="1.0" encoding="UTF-8"?>
<books>
<book id="b001">
<title>java core</title>
<price>688</price>
</book>
<book id="b002">
<title>思想政治</title>
<price>515</pri ...
java反射自动填充
- 博客分类：
- java反射
package com.cgm;
public class Person {
private String name;
private String age;
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getAge() {
return age;
}
public void setAge(String age) {
this.age = age;
}
public Pe ...
java读取Xml
- 博客分类：
- javax读取xml
1.java代码
package com.cgm.domtest;
import java.util.ArrayList;
import java.util.List;
import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;
import org.w3c.dom.Document;
import org.w3c.dom.Element;
import org.w3c.dom.Node;
import org.w3c.dom.NodeList;
public cl ...
xml增删改查
- 博客分类：
- javax增删改查xml
package com.cgm.crudxml;
import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;
import javax.xml.transform.Result;
import javax.xml.transform.Source;
import javax.xml.transform.Transformer;
import javax.xml.transform.TransformerFactory;
import javax.xml.transform. ...
正则表达式使用用例
- 博客分类：
- 正则表达式实现IP排序
package com.cgm.regx;
import java.util.Arrays;
public class IPSort {
public static void main(String[] args) {
String ipstr = "192.168.1.200 10.10.10.10 4.4.4.4 0.0.0.0";
//不俩个0
ipstr = ipstr.replaceAll("(\\d+)", "00$1");//00192.00168.001.00200 0010.0010.0010.001 ...
package com.cgm.regx;
import java.io.BufferedReader;
import java.io.FileNotFoundException;
import java.io.InputStreamReader;
import java.net.URL;
import java.net.URLConnection;
import java.util.regex.Matcher;
import java.util.regex.Pattern;
public class NetSpider {
/**
* @param args
* @throws ...
硬盘图片文件写入到jsp
- 博客分类：
- 图片文件写入网页
详情参见http://cuisuqiang.iteye.com/blog/1741812
OutputStreamWriter outputStream = new OutputStreamWriter(new FileOutputStream(filePath + depId+ "custtmp/" + fileName), "UTF-8");
不能用buffered Write， 只能用 OutputStreamWriter，因为bufferedWriter是采用系统默认
--查出公司最高领导下面的下属
select level as l, e.* from employees e connect by e.manager_id=prior e.employee_id start with e.manager_id is null order by l
--查出包含 has字符的 %'[include]'%
SELECT ddd.department_name, ddd.department_id FROM departments ddd WHERE ddd.department_name like '%has%'
--查出匹配位置的 从第一个字符串开始
SELECT ddd.department_name, ddd.department_id FROM departments ddd WHERE ddd.department_name like 'has%'
--查出匹配位置的 ...