lucene mysql 实例_Lucene入门示例

流程

环境搭建(导入依赖包)

一、采集数据(获取数据，并将数据转为Lucene所需要的文档)

【1】创建与数据库相关的pojo

public class Book {

private Integer bookId; // 图书ID private String name; // 图书名称 private Float price; // 图书价格 private String pic; // 图书图片 private String description; // 图书描述 // 补全get\set方法}

【2】获取数据库连接

public class DBUtil {

public static Connection getConnection() {

//四要素 String driver = "com.mysql.jdbc.Driver";

String url = "jdbc:mysql://192.168.100.251:3306/lucene_data";

String username = "root";

String password = "123456";

try {

//获取连接并返回 Class.forName(driver);

return DriverManager.getConnection(url, username, password);

} catch (ClassNotFoundException e) {

e.printStackTrace();

} catch (SQLException e) {

e.printStackTrace();

}

return null;

}

}

【3】查询获取所有数据、并将所有数据转为Lucene

public class BookDao {

//一、采集数据 (获取所有数据)

public List getAll() throws SQLException {

List books =new ArrayList<>();

//获取连接

Connection connection = DBUtil.getConnection();

//获取操作对象

Statement statement = connection.createStatement();

//处理查询

ResultSet resultSet = statement.executeQuery("select * from book");

while (resultSet.next()) {

Book book = new Book();

book.setBookId(resultSet.getInt("id"));

book.setName(resultSet.getString("name"));

book.setPic(resultSet.getString("pic"));

book.setPrice(resultSet.getFloat("price"));

book.setDescription(resultSet.getString("description"));

books.add(book);

}

connection.close();

resultSet.close();

return books;

}

//二、将数据转为Lucene文档

public List get