Skip to content

Instantly share code, notes, and snippets.

View lacucaracha-jp's full-sized avatar

lacucaracha lacucaracha-jp

View GitHub Profile
import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.net.HttpURLConnection;
import java.net.URL;
import java.net.URLEncoder;
import java.util.Date;
import java.util.List;
import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.net.HttpURLConnection;
import java.net.URL;
import java.net.URLEncoder;
import java.util.Date;
import java.util.List;
import net.arnx.jsonic.JSON;
<li class="entrylist-unit category-life hb-entry-unit-with-favorites" data-eid="278176225" data-entryrank="2" data-bookmark-count="26">
<h3 class="hb-entry-link-container">
<a
href="http://www.yutorism.jp/entry/bedroom"
class="entry-link"
title="寝るときは夫婦一緒?別々? - ゆとりずむ"
data-entryrank="2"
data-track-click-target="direct">寝るときは夫婦一緒?別々? - ゆとりずむ</a>
</h3>
CREATE TABLE BOOKMARKS (
EID VARCHAR (4000),
BOOKMARKUSER VARCHAR (4000),
URL VARCHAR (4000),
STARCOUNT NUMERIC (5),
TIMESTAMP TIME,
COMMENT VARCHAR (4000),
TAG VARCHAR (4000),
SITE VARCHAR (4000),
PRIMARY KEY (
import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.net.HttpURLConnection;
import java.net.URL;
import java.net.URLEncoder;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
select BOOKMARKUSER,COUNT(*)
from Bookmarks
GROUP BY BOOKMARKUSER
ORDER BY COUNT(*) desc
import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.math.BigDecimal;
import java.net.HttpURLConnection;
import java.net.MalformedURLException;
import java.net.URL;
import java.net.URLEncoder;
import java.sql.DriverManager;
CREATE TABLE PAGES
(
EID VARCHAR(4000) PRIMARY KEY,
DATE DATE,
CATEGORY VARCHAR(4000),
ENTRYRANK NUMERIC(5),
COUNT NUMERIC(5),
TITLE VARCHAR(4000),
URL VARCHAR(4000)
);
<script>
if(typeof jQuery != 'undefined'){
jQuery(document).ready(function($){
/* ----------------------------------------------------------------- */
// スクロール量の計測
/* ----------------------------------------------------------------- */
$(function(){
const puppeteer = require('puppeteer');
let page;
async function getBrowserPage() {
// Launch headless Chrome. Turn off sandbox so Chrome can run under root.
const browser = await puppeteer.launch({ args: ['--no-sandbox'] });
return browser.newPage();
}