1. 保留2位小数
java.text.NumberFormat formater =java.text.DecimalFormat.getInstance();
formater.setMaximumFractionDigits(2);
formater.setMinimumFractionDigits(2);
System.out.println(formater.format(3.2343242343));
System.out.println(formater.format(30000));
2.查询某一列值相等的大于1的返回值
SELECT t.cd_name,
COUNT(*)
FROM chem_drug t
GROUP BY t.cd_name
HAVING COUNT(*) > 1;
查询某一列相等的大于1的返回值
3.从sql server 随机取10条数据
select top 10 * from 表 order by newid()
4.删除重复某列重复行
delete from xg_diathclassinfo where ci_id not in
(select max(ci_id) from xg_diathclassinfo group by ci_name )
5.给力的去掉数组中重复的数据
String[] arr = { "fog ", "fog ", "fog628 ", "fog629 "};
arr=(String[])( new HashSet(Arrays.asList(arr)).toArray(new String[0]));
6.找到Map中值为null的并进行修改
Iterator iter = tempMap.entrySet().iterator();
while (iter.hasNext()) {
Map.Entry entry = (Map.Entry) iter.next();
if (entry.getValue() == null) {
//这里可以对Map进行修改,但是不能使用tempMap.remove(key)的方法
//只能使用iterator.remove();
}
}
java.text.NumberFormat formater =java.text.DecimalFormat.getInstance();
formater.setMaximumFractionDigits(2);
formater.setMinimumFractionDigits(2);
System.out.println(formater.format(3.2343242343));
System.out.println(formater.format(30000));
2.查询某一列值相等的大于1的返回值
SELECT t.cd_name,
COUNT(*)
FROM chem_drug t
GROUP BY t.cd_name
HAVING COUNT(*) > 1;
查询某一列相等的大于1的返回值
3.从sql server 随机取10条数据
select top 10 * from 表 order by newid()
4.删除重复某列重复行
delete from xg_diathclassinfo where ci_id not in
(select max(ci_id) from xg_diathclassinfo group by ci_name )
5.给力的去掉数组中重复的数据
String[] arr = { "fog ", "fog ", "fog628 ", "fog629 "};
arr=(String[])( new HashSet(Arrays.asList(arr)).toArray(new String[0]));
6.找到Map中值为null的并进行修改
Iterator iter = tempMap.entrySet().iterator();
while (iter.hasNext()) {
Map.Entry entry = (Map.Entry) iter.next();
if (entry.getValue() == null) {
//这里可以对Map进行修改,但是不能使用tempMap.remove(key)的方法
//只能使用iterator.remove();
}
}