Skip to content

Instantly share code, notes, and snippets.

@binjoo
binjoo / oracle.sql
Last active August 29, 2015 14:04
SQL:插入日历数据
declare
i int;
now date;
date1 date;
week int;
begin
now := trunc(sysdate);
for i in 0..2000 loop
date1 := now + i;
week := to_number(to_char(date1 - 1, 'd'));
@binjoo
binjoo / gist:3926302
Created October 21, 2012 08:17
JAVA:补齐不足长度
public class Test {
public static void main(String[] args) {
Test test = new Test();
System.out.println(test.lpad(10, 23));
}
/**
* 补齐不足长度
* @param length 长度
* @param number 数字
@binjoo
binjoo / gist:3926300
Created October 21, 2012 08:16
JAVA:MD5加密
import java.security.MessageDigest;
import java.security.NoSuchAlgorithmException;
public class Md5 {
public static String toMd5(String arg) {
try {
MessageDigest md = MessageDigest.getInstance("MD5");
md.update(arg.getBytes());
byte b[] = md.digest();
int i;
@binjoo
binjoo / gist:3926379
Created October 21, 2012 08:43
PHP:TYPECHO:获得访客最近评论数
//获得访客最近评论数
function get_author_comments_num($email = "") {
if(empty($email)) return;
$commentsNum = Helper::options()->commentsNum;
$time = time() - (24 * 60 * 60 * $commentsNum); //当前时间戳减去30天的时间戳
$db = Typecho_Db::get();
$sql = $db->select('COUNT(mail) as emailnum')->from('table.comments')
->where('status = ?','approved')
->where('mail = ?',$email)
->where('created > ?',$time);
@binjoo
binjoo / gist:3926319
Created October 21, 2012 08:24
JAVA:英雄联盟语录
import java.io.BufferedReader;
import java.io.File;
import java.io.FileInputStream;
import java.io.InputStreamReader;
import java.util.ArrayList;
import java.util.Collections;
import java.util.List;
public class sdf {
public static void main(String[] args) {
@binjoo
binjoo / FeiQSocket.java
Created October 21, 2012 09:13
JAVA:模拟飞秋发送消息
public class FeiQSocket {
public static void main(String[] args) throws Exception {
List<String> hosts = new ArrayList<String>();
String host = "localhost"; //目标IP
int port = 2425; //目标端口,缺省为 2425
InetAddress IPAddress = InetAddress.getByName(host);
//String str = "1_lbt4_10#32899#002481627512#0#35807#0:1:Administrators:1D46A2A23307456:288:内容"; //普通消息
String str = "1_lbt4_35#128#0022680C51AC#0#35807#0:1250815230:Administrators:1D46A2A23307456:209:"; //抖屏
byte[] buf = str.getBytes();
@binjoo
binjoo / RenamePic.java
Created October 21, 2012 13:02
JAVA:根据EXIF信息给图片批量命名
import java.io.File;
import java.util.Iterator;
import com.drew.imaging.jpeg.JpegMetadataReader;
import com.drew.metadata.Directory;
import com.drew.metadata.Metadata;
import com.drew.metadata.Tag;
import com.drew.metadata.exif.ExifDirectory;
/***
* 批量修改目录下图片,根据EXIF信息命名。
@binjoo
binjoo / ReadMinds.java
Created October 21, 2012 17:27
JAVA:吉普赛人神奇的读心术
import java.util.Scanner;
public class ReadMinds {
public static void main(String[] args) {
String result = init(); // 初始化
Scanner scan = new Scanner(System.in);
scan.nextLong();
System.out.println(result);
}
@binjoo
binjoo / gist:3958249
Created October 26, 2012 11:15
JAVA:面试题:请实现一个函数:凑14;输入很多个整数(1<=数值<=13),任意两个数相加等于14就可以从数组中删除这两个数,求剩余数(按由小到大排列)。
import java.util.ArrayList;
import java.util.List;
import java.util.Scanner;
public class Test {
/*
* 请实现一个函数:凑14; 输入很多个整数(1<=数值<=13);
* 任意两个数相加等于14就可以从数组中删除这两个数,求剩余数(按由小到大排列);
*/
public static void main(String[] args) {
@binjoo
binjoo / gist:3987731
Created October 31, 2012 15:39
JAVA:面试题:给定一个一亿长度的数组,数组元素中随机放了0~9,10个数字,要求你统计每个数出现的次数。
public class Test {
public static void main(String[] args) {
int[] a = new int[100000000];
for (int i = 0; i < a.length; i++) {
a[i] = (int) (Math.random() * 10);
}
int[] b = {0, 0, 0, 0, 0, 0, 0, 0, 0, 0};
long start = System.currentTimeMillis();
for (int i = 0; i < a.length; i++) {
b[a[i]] += 1;