precious-ming

View GitHub Profile

Recently created

Least recently created

Recently updated

Least recently updated

precious-ming / gist:8d4e1b001e67cb481466

Created September 20, 2014 07:43

JDBC获取自动增长的主键值

	public static void main(String[] args) throws Exception {

	Class.forName("com.mysql.jdbc.Driver");
	Connection conn = DriverManager.getConnection("jdbc:mysql:///kaishengit_db", "root", "root");

	String sql = "insert into t_test(username,address) values('vv','china')";
	Statement stat = conn.createStatement();

	stat.execute(sql, Statement.RETURN_GENERATED_KEYS);

precious-ming / gist:13570298fd0d59aeceb2

Created September 20, 2014 07:39

利用RandomAccessFile类将一个文件分割为多个文件(图片)

	//分割
	public static void splitFile(String path,int count) {

	try {
	RandomAccessFile raf = new RandomAccessFile(path, "r");
	//文件总大小
	long length = raf.length();
	//每份文件大小
	long maxSize = length / count;
	//最后一份文件大小

precious-ming / demo.html

Last active August 29, 2015 14:06

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;

precious-ming / time.html

Created September 20, 2014 07:05

网页时间显示

	<!DOCTYPE HTML>
	<html lang="en-US">
	<head>
	<meta charset="UTF-8">
	<title></title>
	</head>
	<body>

	<div>
	<span id="nowTime"></span>

precious-ming / traversal.html

Created September 20, 2014 07:02

遍历（js、java）

	<!DOCTYPE HTML>
	<html lang="en-US">
	<head>
	<meta charset="UTF-8">
	<title></title>
	</head>
	<body>
	<div>
	<img src="http://img3.cache.netease.com/ent/2014/8/20/20140820195348e7e34.jpg" alt="成龙就房祖名吸毒道歉:我教子无方很羞愧" width="310" height="220">
	</div>

precious-ming / checkbox-btn.html

Created September 20, 2014 06:49

jQuery-选中checkbox按钮可用

	<!DOCTYPE HTML>
	<html lang="en-US">
	<head>
	<meta charset="UTF-8">
	<title></title>
	</head>
	<body>
	<div>
	<button id="commit" disabled>提交</button>
	<input id="checkboxId" type="checkbox" />选中后提交按钮可用

precious-ming / HtmlRegexpUtil.java

Created September 2, 2014 02:08

HTML标签过滤（正则）

	import java.util.ArrayList;
	import java.util.List;
	import java.util.regex.Matcher;
	import java.util.regex.Pattern;

	/**
	* <p>
	* Title: HTML相关的正则表达式工具类
	* </p>
	* <p>

precious-ming / canton.sql

Last active August 29, 2015 14:05

中国省市表 (MySQLl版本)

	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', '北京市');

precious-ming / webDate

Created March 15, 2014 09:40

网页显示当前时间

	<!DOCTYPE HTML>
	<html lang="en-US">
	<head>
	<meta charset="UTF-8">
	<title></title>
	</head>
	<body>

	<div>
	<span id="nowTime"></span>

precious-ming / jsl与excel

Last active December 27, 2015 18:19

使用jxl创建、读取和修改excel。

	---导入jar包或者使用maven
	maven
	<dependency>
	<groupId>net.sourceforge.jexcelapi</groupId>
	<artifactId>jxl</artifactId>
	<version>2.6.12</version>
	</dependency>