Skip to content

Instantly share code, notes, and snippets.

View fankay's full-sized avatar
🚀
loading...

fankay

🚀
loading...
  • kaishengit
  • China.Jiaozuo
  • X @fankay
View GitHub Profile
@fankay
fankay / gist:9181919
Created February 24, 2014 04:20
中国省市表 mysql版本
DROP TABLE IF EXISTS `province`;
CREATE TABLE `province` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=gbk;
-- ----------------------------
-- Records of province
-- ----------------------------
INSERT INTO `province` VALUES ('1', '北京市');
@fankay
fankay / BeanPropertyRowMapper.java
Created November 6, 2013 03:34
新版本的数据库操作类
package com.kaishengit.db.RowMapper;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import com.kaishengit.util.BeanUtil;
public class BeanPropertyRowMapper<T> implements RowMapper<T>{
@fankay
fankay / v2ex_api.md
Created October 13, 2013 04:38 — forked from fanzeyi/v2ex_api.md
@fankay
fankay / Servlets.java
Created August 7, 2013 08:24
Serlvet自动将表单值或URL参数赋值到实体类中
package com.kaishengit.util;
import java.lang.reflect.Method;
import java.util.Map;
import java.util.Map.Entry;
public class Servlets {
//map 模拟request.getParamterNames()
public static <T> T setObjectValue(Class<T> clazz,
@fankay
fankay / demo.html
Created July 25, 2013 15:24
Ajax拖动文件上传(Html5 drop file upload)
<!doctype html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Drop file upload</title>
<style>
#dropdiv{
margin: 40px auto;
width: 900px;
height: 400px;
@fankay
fankay / CacheHelp.java
Created July 18, 2013 04:01
EhCache + JDBC + CommonsDBUtil + Commons DBCP
package com.kaishengit.util;
import java.io.Serializable;
import net.sf.ehcache.CacheManager;
import net.sf.ehcache.Ehcache;
import net.sf.ehcache.Element;
public class CacheHelp {
@fankay
fankay / GZipFilter.java
Created July 17, 2013 09:26
GZipFilter
package com.kaishengit.filter;
import java.io.ByteArrayOutputStream;
import java.io.IOException;
import java.io.OutputStreamWriter;
import java.io.PrintWriter;
import java.util.zip.GZIPOutputStream;
import javax.servlet.Filter;
import javax.servlet.FilterChain;
@fankay
fankay / 查询一个列的集合
Created July 16, 2013 07:05
Commons DBUtils的使用
QueryRunner runner = new QueryRunner(dataSource);
String sql = "select id from t_user";
List<Integer> list = runner.query(sql, new ColumnListHandler<Integer>());
@fankay
fankay / chedui.jsp
Created July 2, 2013 10:15
SiteMesh产生动态的菜单效果
<head>
<meta name="menu" content="chedui">
</head>
<body>
</body>
@fankay
fankay / MyFragement.java
Last active December 17, 2015 23:59
Android自动加载的ListView
package com.kaishengit.bbs;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;
import org.apache.http.HttpResponse;
import org.apache.http.client.ClientProtocolException;
import org.apache.http.client.methods.HttpGet;
import org.apache.http.impl.client.DefaultHttpClient;