lucene 全文检索数据库.docVIP

我们以前经常碰到搜索数据库的内容；用like ％的sql语句；如果数据量大而且多表查询时；用lucene2那就可以解决速度问题。lucene2搜索photo表的title，username，tagname，desr内容；用一个例题来说明更直观；此例题能搜索中文分词；（需要mysql5的jdbc包和lucene2的包）：1、数据库我用mysql5；建一个photo表；数据库名是test。 photo表有一下几个字段：CREATE TABLE `photo` (`photo_id` int(11) NOT NULL auto_increment,`title` varchar(11) default NULL,`address` varchar(50) default NULL,`descr` text,`user_id` int(11) default NULL,`user_name` varchar(11) default NULL,`upload_time` date default NULL,`tag_name` varchar(11) default NULL,PRIMARY KEY (`photo_id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=REDUNDANT;2、java文件有4个：文件Photo.java是数据库的photo表的操作文件；内容如下： import java.sql.Connection;import java.util.ArrayList;import java.util.Date;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException; public class Photo {?private long photoId;?private String title;?private String description;?private String address;?private String userName;?private long userId;?private String tag;?private Date date; ?public String getAddress() {??return address;?} ?public void setAddress(String address) {??this.address = address;?} ?public String getDescription() {??return description;?} ?public void setDescription(String description) {??this.description = description;?} ?public long getPhotoId() {??return photoId;?} ?public void setPhotoId(long photoId) {??this.photoId = photoId;?} ?public String getTag() {??return tag;?} ?public void setTag(String tag) {??this.tag = tag;?} ?public String getTitle() {??return title;?} ?public void setTitle(String title) {??this.title = title;?} ?public long getUserId() {??return userId;?} ?public void setUserId(long userId) {??this.userId = userId;?} ?public String getUserName() {??return userName;?} ?public void setUserName(String userName) {??this.userName = userName;?} ?public static Photo[] loadPhotos(Connection con) throws Exception {??ArrayListPhoto list = new ArrayListPhoto();??PreparedStatement pstm = nu