[baoqiu.xiao@... ~]sudo iptables -A INPUT -p tcp -s 127.0.0.1 --dport 6666 -j ACCEPT
[baoqiu.xiao@... ~]sudo iptables -A INPUT -p tcp -s XX.XX.XX.184 --dport 6666 -j ACCEPT
[baoqiu.xiao@... ~]sudo iptables -A INPUT -p tcp --dport 6666 -j REJECT

[baoqiu.xiao@... ~]sudo iptables -L -n --line-number
Chain INPUT (policy ACCEPT)
num  target     prot opt source               destination         
1    ACCEPT     tcp  --  127.0.0.1            0.0.0.0/0           tcp dpt:6666 
2    ACCEPT     tcp  --  XX.XX.XX.184         0.0.0.0/0           tcp dpt:6666 
3    REJECT     tcp  --  0.0.0.0/0            0.0.0.0/0           tcp dpt:6666 reject-with icmp-port-unreachable 

Chain FORWARD (policy ACCEPT)
num  target     prot opt source               destination         

Chain OUTPUT (policy ACCEPT)
num  target     prot opt source               destination

[baoqiu.xiao@... ~]sudo iptables -D INPUT 1

    <!--手机号解析-->
    <dependency>
        <groupId>com.googlecode.libphonenumber</groupId>
        <artifactId>libphonenumber</artifactId>
        <version>7.2.1</version>
    </dependency>
    <!--手机归属地定位相关-->
    <dependency>
        <groupId>com.googlecode.libphonenumber</groupId>
        <artifactId>geocoder</artifactId>
        <version>2.9</version>
    </dependency>
    <!-- 手机运营商相关 -->
    <dependency>
        <groupId>com.googlecode.libphonenumber</groupId>
        <artifactId>carrier</artifactId>
        <version>1.21</version>
    </dependency>

public class LibphonenumberUsage {

    private static final PhoneNumberUtil phoneNumberUtil = PhoneNumberUtil.getInstance();

    private static PhoneNumberToCarrierMapper carrier = PhoneNumberToCarrierMapper.getInstance();

    private static PhoneNumberOfflineGeocoder geocoder = PhoneNumberOfflineGeocoder.getInstance();

    private static final String DEFAULT_COUNTRY = "CN";

    private static final String[] phoneCases = new String[] {
            "00861861****515",  //中国
            "008869****7718",   //台湾
            "00658****994",     //新加坡
            "1591****718",      //中国
            "00820****704546",  //Korea
            "1709****155"       //中国170
    };

    private static final String[] countryCodes = new String[]{
            "886",      //台湾
            "65",       //新加坡
            "86",       //中国
            "82",       //Korea
            "86"        //中国170
    };
    private static final String[] phones = new String[]{
            "972****718",        //台湾
            "82****94",         //新加坡
            "1591****718",      //中国
            "1074****46",       //Korea
            "1709****155"       //中国170
    };

    public static final Map<String, String> CHINESE_CARRIER_MAPPER = Maps.newHashMap();
    static {
        CHINESE_CARRIER_MAPPER.put("China Mobile", "中国移动");
        CHINESE_CARRIER_MAPPER.put("China Unicom", "中国联通");
        CHINESE_CARRIER_MAPPER.put("China Telecom", "中国电信");
    }

    public static void main(String[] args) {
//        parsePhone();

//        validPhone();

//        phoneCarrierCase();

        phoneGeoCase();
    }

    /**
     * 电话解析case
     */
    private static void parsePhone() {


        for(String phone : phoneCases) {
            Phonenumber.PhoneNumber pn = doParse(phone);
            System.out.println(phone + " --> " + pn.getCountryCode() + ", " + pn.getNationalNumber());
        }
    }

    /**
     * 解析逻辑
     */
    private static final Phonenumber.PhoneNumber doParse(String phone) {
        try {
            return phoneNumberUtil.parse(phone, DEFAULT_COUNTRY);
        } catch (NumberParseException e) {
            throw new NumberFormatException("invalid phone number: " + phone);
        }
    }

    /**
     * 电话解析case
     */
    private static void validPhone() {
        for (int i = 0; i < countryCodes.length; i++) {
            boolean valid = doValid(countryCodes[i], phones[i]);
            System.out.println(countryCodes[i] + " , " + phones[i] + " --> " + valid);
        }
    }

    /**
     * 手机校验逻辑
     */
    private static boolean doValid(String countryCode, String phoneNumber){
        int ccode = Integer.parseInt(countryCode);
        long phone = Long.parseLong(phoneNumber);

        Phonenumber.PhoneNumber pn = new Phonenumber.PhoneNumber();
        pn.setCountryCode(ccode);
        pn.setNationalNumber(phone);

        return phoneNumberUtil.isValidNumber(pn);
    }

    private static void phoneCarrierCase() {
        for (int i = 0; i < countryCodes.length; i++) {
            String carrier = doCarrier(countryCodes[i], phones[i]);
            System.out.println(countryCodes[i] + " , " + phones[i] + " --> " + (CHINESE_CARRIER_MAPPER.containsKey(carrier)?CHINESE_CARRIER_MAPPER.get(carrier):carrier));
        }
    }

    /**
     * 手机运营商
     */
    private static String doCarrier(String countryCode, String phoneNumber){
        int ccode = Integer.parseInt(countryCode);
        long phone = Long.parseLong(phoneNumber);

        Phonenumber.PhoneNumber pn = new Phonenumber.PhoneNumber();
        pn.setCountryCode(ccode);
        pn.setNationalNumber(phone);

        //返回结果只有英文，自己转成成中文
        return carrier.getNameForNumber(pn, Locale.ENGLISH);
    }

    private static void phoneGeoCase() {
        for (int i = 0; i < countryCodes.length; i++) {
            String geo = doGeo(countryCodes[i], phones[i]);
            System.out.println(countryCodes[i] + " , " + phones[i] + " --> " + geo);
        }
    }

    /**
     * 手机归属地
     */
    public static String doGeo(String countryCode, String phoneNumber){
        int ccode = Integer.parseInt(countryCode);
        long phone = Long.parseLong(phoneNumber);

        Phonenumber.PhoneNumber pn = new Phonenumber.PhoneNumber();
        pn.setCountryCode(ccode);
        pn.setNationalNumber(phone);

        return geocoder.getDescriptionForNumber(pn, Locale.CHINESE);
    }
}

/**
 * 创建索引
 *
 * @author: xiaobaoqiu  Date: 15-9-8 Time: 下午4:04
 */
public final class Indexer {

    public static void main(String[] args) {
        indexDocs(CommonConfig.SOURCE_FILE_DIR, CommonConfig.INDEX_FILE_DIR, true);
    }

    /**
     * 构建磁盘索引
     *
     * @param dirPath 原始文件
     * @param indexPath 索引文件存放路径
     * @param create    创建or更新
     */
    public static void indexDocs(String dirPath, String indexPath, boolean create) {
        try {
            Directory dir = FSDirectory.open(new File(indexPath));
            Analyzer analyzer = new StandardAnalyzer(Version.LUCENE_4_10_0);
            IndexWriterConfig iwc = new IndexWriterConfig(Version.LUCENE_4_10_0, analyzer);

            if (create) {
                iwc.setOpenMode(IndexWriterConfig.OpenMode.CREATE);
            } else {
                iwc.setOpenMode(IndexWriterConfig.OpenMode.CREATE_OR_APPEND);
            }

            IndexWriter writer = new IndexWriter(dir, iwc);
            doIndexDocs(writer, new File(dirPath));

            System.out.println("Build index finished...");
            writer.close();
        }catch (IOException ioe) {
            //do something...
        }
    }

    static void doIndexDocs(IndexWriter writer, File file) throws IOException {
        if (!file.canRead()) {
            System.out.println("文件不可读:" + file.getAbsolutePath());
            return;
        }

        //文件夹则索引文件夹下的索引文件
        if (file.isDirectory()) {
            String[] files = file.list();
            if (files != null) {
                for (int i = 0; i < files.length; i++) {
                    doIndexDocs(writer, new File(file, files[i]));
                }
            }
        } else {
            doIndexFile(writer, file);
        }
    }

    /**
     * 索引一个文件
     *
     * @param writer
     * @param file
     */
    private static void doIndexFile(IndexWriter writer, File file) throws IOException{
        //单个文件
        FileInputStream fis;
        try {
            fis = new FileInputStream(file);
        } catch (FileNotFoundException fnfe) {
            //do nothing
            return;
        }

        try {
            // 创建一个新的空的Document
            Document doc = new Document();

            //文件路径字段
            doc.add(new StringField(CommonConfig.PATH_FIELD_NAME, file.getPath(), Field.Store.YES));
            //文件最后修改时间字段
            doc.add(new LongField(CommonConfig.MODIFIED_FIELD_NAME, file.lastModified(), Field.Store.NO));
            //文件内容,不存储原始串
            doc.add(new TextField(CommonConfig.CONTENTS_FIELD_NAME, new BufferedReader(new InputStreamReader(fis, StandardCharsets.UTF_8))));

            //新建索引 or 更新索引
            if (writer.getConfig().getOpenMode() == IndexWriterConfig.OpenMode.CREATE) {
                writer.addDocument(doc);
            } else {
                writer.updateDocument(new Term("path", file.getPath()), doc);
            }
        } finally {
            fis.close();
        }
    }
}

/**
 * 查询索引
 * 接受用户输入作为Query词
 *
 * @author: xiaobaoqiu  Date: 15-9-8 Time: 下午4:09
 */
public final class Searcher {

    public static void main(String[] args) throws Exception {
        search(CommonConfig.INDEX_FILE_DIR, CommonConfig.CONTENTS_FIELD_NAME);
    }

    public static void search(String indexPath, String field) throws Exception {
        IndexReader reader = DirectoryReader.open(FSDirectory.open(new File(indexPath)));
        IndexSearcher searcher = new IndexSearcher(reader);
        Analyzer analyzer = new StandardAnalyzer(Version.LUCENE_4_10_0);
        QueryParser parser = new QueryParser(Version.LUCENE_4_10_0, field, analyzer);

        //接受用户输入
        BufferedReader in = new BufferedReader(new InputStreamReader(System.in, StandardCharsets.UTF_8));
        String queryString = null;
        while (StringUtils.isNotEmpty(queryString = in.readLine())) {
            Query query = parser.parse(queryString.trim());

            doSearch(searcher, query);
        }
        reader.close();
    }

    public static void doSearch(IndexSearcher searcher, Query query) throws IOException {
        // 搜索 CommonConfig.SEARCH_MAX_ITEM_COUNT 个数据
        TopDocs results = searcher.search(query, CommonConfig.SEARCH_MAX_ITEM_COUNT);
        ScoreDoc[] hits = results.scoreDocs;
        int numTotalHits = results.totalHits;
        System.out.println(numTotalHits + " total matching documents");

        if (ArrayUtils.isEmpty(hits)) return;

        for (ScoreDoc hit : hits) {
            System.out.println();
            Document hitDoc = searcher.doc(hit.doc);
            System.out.println(CommonConfig.PATH_FIELD_NAME + " = " + hitDoc.get(CommonConfig.PATH_FIELD_NAME) +
                    "\n" + CommonConfig.MODIFIED_FIELD_NAME + " = " + hitDoc.get(CommonConfig.MODIFIED_FIELD_NAME) +
                    "\n" + CommonConfig.CONTENTS_FIELD_NAME + " = " + hitDoc.get(CommonConfig.CONTENTS_FIELD_NAME));
        }
    }
}

//page1:
如何使用Lucene完善搜索

//page2
Lucene数据如何存储

//page3
Lucene如何实现搜索

//page4
作者:肖宝秋

//page1:
如何, 使用, Lucene, 完善, 搜索

//page2
Lucene, 数据, 如何, 存储

//page3
Lucene, 如何, 实现, 搜索
作者, 肖宝秋

如何 --> page1, page2, page3
使用 --> page1
Lucene --> page1, page2, page3
完善 --> page1
搜索 --> page1, page3
数据 --> page2
存储 --> page2
实现 --> page3
作者 --> page4
肖宝秋 --> page4

Term1,Document Frequency  --> Doc1,Frequency1 ; Doc2,Frequency2

文件一:Students should be allowed to go out with their friends, but not allowed to drink beer.
文件二:My friend Jerry went to school to see his students but found them drunk which is not allowed.

Students,allowed,go,their,friends,allowed,drink,beer,My,friend,Jerry,went,school,see,his,students,found,them,drunk,allowed

student,allow,go,their,friend,allow,drink,beer,my,friend,jerry,go,school,see,his,student,find,them,drink,allow

Document = {term1, term2, …… ,term N}
Document Vector = {weight1, weight2, …… ,weight N}

Query = {term1, term 2, …… , term N}
Query Vector = {weight1, weight2, …… , weight N}

... FROM table1 INNER|LEFT|RIGHT JOIN table2 ON conditiona

-- 显示join
select * from
table1 inner join table2
on table1.name = table2.name;

-- 隐式join
select table1.*, table2.*
from table1, table2
where table1.name = table2.name;

-- 方案1
select * from A
inner join B on B.name = A.name
left join C on C.name = B.name
left join D on D.id = C.id
where C.status>1 and D.status=1;

-- 方案2
select * from A
inner join B on B.name = A.name
left join C on C.name = B.name and C.status>1
left join D on D.id = C.id and D.status=1

SELECT article.aid,article.title,user.username FROM article NATURAL JOIN user