基于lucene的案例开发：纵横小说数据库操作

转载请注明出处：http://blog.csdn.net/xiaojimanman/article/details/46785223

http://www.llwjy.com/blogdetail/efda32f346445dd8423a942aa4c8c2cd.html

个人博客站已经上线了，网址 www.llwjy.com ~欢迎各位吐槽~

-------------------------------------------------------------------------------------------------

      首先和大家说一生抱歉，由于最近经常在外面出差，博客断更了很长时间，后面不出意外的话，博客会恢复更新。

      在上次的博客中已经介绍了纵横小说的数据库表结构，这里需要说明的是，我在设计数据表的时候，取消了数据表之间的外键，至于为什么这样做这里就不再多说，感兴趣的可以自行百度下。下面我们就开始今天的介绍：

模版类

      在介绍数据库的操作之前，我们首先看一下定义的模版（javabean），这里定义了四个模版分别为抓取入口信息模版、小说简介页模版、小说章节列表模版、小说阅读页模版，类中只有一些简单的set和put方法，下面就看下具体的代码实现：

1.CrawlListInfo

 /**  
 *@Description:     
 */ 
package com.lulei.crawl.novel.zongheng.model;  
  
public class CrawlListInfo {
	private String url;
	private String info;
	private int frequency;
	
	public String getUrl() {
		return url;
	}
	public void setUrl(String url) {
		this.url = url;
	}
	public String getInfo() {
		return info;
	}
	public void setInfo(String info) {
		this.info = info;
	}
	public int getFrequency() {
		return frequency;
	}
	public void setFrequency(int frequency) {
		this.frequency = frequency;
	}
}

2.NovelIntroModel

 /**  
 *@Description:     
 */ 
package com.lulei.crawl.novel.zongheng.model;  
  
public class NovelIntroModel {
	private String md5Id;
	private String name;
	private String author;
	private String description;
	private String type;
	private String lastChapter;
	private String chapterlisturl;
	private int wordCount;
	private String keyWords;
	private int chapterCount;
	
	public String getMd5Id() {
		return md5Id;
	}
	public void setMd5Id(String md5Id) {
		this.md5Id = md5Id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getAuthor() {
		return author;
	}
	public void setAuthor(String author) {
		this.author = author;
	}
	public String getDescription() {
		return description;
	}
	public void setDescription(String description) {
		this.description = description;
	}
	public String getType() {
		return type;
	}
	public void setType(String type) {
		this.type = type;
	}
	public String getLastChapter() {
		return lastChapter;
	}
	public void setLastChapter(String lastChapter) {
		this.lastChapter = lastChapter;
	}
	public String getChapterlisturl() {
		return chapterlisturl;
	}
	public void setChapterlisturl(String chapterlisturl) {
		this.chapterlisturl = chapterlisturl;
	}
	public int getWordCount() {
		return wordCount;
	}
	public void setWordCount(int wordCount) {
		this.wordCount = wordCount;
	}
	public String getKeyWords() {
		return keyWords;
	}
	public void setKeyWords(String keyWords) {
		this.keyWords = keyWords;
	}
	public int getChapterCount() {
		return chapterCount;
	}
	public void setChapterCount(int chapterCount) {
		this.chapterCount = chapterCount;
	}
}

3.NovelChapterModel

 /**  
 *@Description:     
 */ 
package com.lulei.crawl.novel.zongheng.model;  
  
  
public class NovelChapterModel {
	private String url;
	private int chapterId;
	private long time;
	public String getUrl() {
		return url;
	}
	public void setUrl(String url) {
		this.url = url;
	}
	public int getChapterId() {
		return chapterId;
	}
	public void setChapterId(int chapterId) {
		this.chapterId = chapterId;
	}
	public long getTime() {
		return time;
	}
	public void setTime(lon