SolrJ核心包     /solr-4.10.3/dist/solr-solrj-4.10.3.jar

SolrJ依赖包     /solr-4.10.3/dist/solrj-lib下的所有包

日志依赖包     /solr-4.10.3/example/lib/ext目录下的所有jar包

JDBC驱动包     mysql-connector-java-5.1.10-bin.jar

public class Product {

private Integer pid;

private String name;

private String catalog_name;

private double price;

private String description;

private String picture;

// 补全get、set方法

}

package cn.gzsxt.solr.dao;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.List;

import cn.gzsxt.solr.pojo.Product;

public class ProductDao {

private Connection connection;

private PreparedStatement pst;   

private ResultSet rs;

/**

 * 采集数据，查询所有商品

 * @return

 */

public List<Product> getAllProducts() {

 List<Product> products = new ArrayList<>();

try {

//1、加载驱动

Class.forName(“com.mysql.jdbc.Driver”);

//2、获取Connection连接

connection = DriverManager.getConnection(“jdbc:mysql://localhost:3306/solr”, “root”, “gzsxt”);

//3、获取PreparedStatement,执行预编译

pst = connection.prepareStatement(“select pid,name, catalog_name,price,description,picture from products”);

//4、执行sql搜索

rs = pst.executeQuery();

Product p = null;

while(rs.next()){

p = new Product();

p.setPid(rs.getInt(“pid”));

p.setName(rs.getString(“name”));

p.setPrice(rs.getFloat(“price”));

p.setPicture(rs.getString(“picture”));

p.setDescription(rs.getString(“description”));           

p.setCatalog_name(rs.getString(“catalog_name”));

products.add(p);

}

} catch (Exception e) {

e.printStackTrace();

}finally {

if(null!=rs){

try {

rs.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

if(null!=pst){

try {

pst.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

if(null!=connection){

try {

connection.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}

return products;

}

}

package cn.gzsxt.solr.test;

import org.junit.Test;

import cn.gzsxt.solr.dao.ProductDao;

public class ProductDaoTest {

@Test

public void getAllProducts(){

ProductDao dao = new ProductDao();

System.out.println(dao.getAllProducts());

}

}

public SolrInputDocument(Map fields){

        _documentBoost = 1.0F;

        _fields = fields;

}

public void addField(String name, Object value){

        addField(name, value, 1.0F);

}

域

Tokened

Indexed

Stored

商品的id

N

Y

Y

商品的名称

Y

Y

Y

商品的类别

N

Y

Y

商品的价格

Y

Y

Y

商品的图片

N

N

Y

商品描述信息

Y

Y

N

<!–product–>

<field name=”id” type=”string” indexed=”true” stored=”true” required=”true”

multiValued=”false” />

<field name=”product_name” type=”text_general” indexed=”true” stored=”true”/>

<field name=”product_catalog_name” type=”string” indexed=”true” stored=”true” />

<field name=”product_price”  type=”double” indexed=”true” stored=”true”/>

<field name=”product_description” type=”text_general” indexed=”true” stored=”false” />

<field name=”product_picture” type=”string” indexed=”false” stored=”true” />

/**

 * 将采集到的商品数据，转换成solr文档类型

 * @param products

 * @return

 */

public List<SolrInputDocument> getDocuments(List<Product> products){

List<SolrInputDocument> docs = new ArrayList<>();

SolrInputDocument doc = null;

for (Product product : products) {

doc = new SolrInputDocument();

doc.addField(“id”, product.getPid());

doc.addField(“product_name”, product.getName());

doc.addField(“product_price”, product.getPrice());

doc.addField(“product_catalog_name”, product.getCatalog_name());

doc.addField(“product_description”, product.getDescription());

doc.addField(“product_picture”, product.getPicture());

docs.add(doc);

}

return docs;

}

@Test

public void createIndex(){

// 1、 创建HttpSolrServer对象，通过它和Solr服务器建立连接。

// 参数：solr服务器的访问地址

HttpSolrServer server = new HttpSolrServer(“http://localhost:8080/solr/solrCore0719”);

// 2、 通过HttpSolrServer对象将SolrInputDocument添加到索引库。

ProductDao dao = new ProductDao();

        try {

server.add(dao.getDocuments(dao.getAllProducts()));

// 3、 提交。

server.commit();

System.out.println(“创建索引库成功!!!”);

} catch (SolrServerException e) {

e.printStackTrace();

} catch (IOException e) {

e.printStackTrace();

}

}

@Test

public void queryIndex() throws Exception {

// 创建HttpSolrServer对象，通过它和Solr服务器建立连接。

// 参数：solr服务器的访问地址

HttpSolrServer server = new HttpSolrServer(“http://localhost:8080/solr/solrCore0719”);

// 创建SolrQuery对象

SolrQuery query = new SolrQuery();

// 设置查询条件,参考主界面

query.set(“q”, “*:*”);

// 调用server的查询方法，查询索引库

QueryResponse response = server.query(query);

// 查询结果

SolrDocumentList results = response.getResults();

// 查询结果总数

long cnt = results.getNumFound();

System.out.println(“查询结果总数:” + cnt);

System.out.println(“——————–分隔符——————-“);

for (SolrDocument solrDocument : results) {

System.out.println(“商品id:”+solrDocument.get(“id”));

System.out.println(“商品名称:”+solrDocument.get(“product_name”));

System.out.println(“商品价格:”+solrDocument.get(“product_price”));

System.out.println(“商品类别:”+solrDocument.get(“product_catalog_name”));

System.out.println(“商品图片:”+solrDocument.get(“product_picture”));

System.out.println(“—————————————-“);

}

}

@Test

public void queryDynamic(){

//1、连接solr服务器

HttpSolrServer server = new HttpSolrServer(“http://localhost:8080/solr/solrCore0719”);

//2、创建查询对象，封装查询条件

SolrQuery query = new SolrQuery();

//设置默认搜索的域

query.set(“df”, “product_name”);

//参考管理界面中的 “q”标签，封装查询的关键词

query.set(“q”, “音乐盒“);

//添加价格过滤

query.addFilterQuery(“product_price:[10 TO 50]”);

//添加类别过滤

query.addFilterQuery(“product_catalog_name:幽默杂货“);

//设置排序  价格升序

query.set(“sort”,”product_price asc”);

//设置分页信息  第二页 每页10条   start=(page-1)*pageSize

query.set(“start”, 10);

query.set(“rows”,10);

//设置要查询字段

query.set(“fl”, “id,product_name,product_price”);

//3、执行查询

try {

QueryResponse response = server.query(query);

//获取查询的响应码

int status = response.getStatus();

System.out.println(“响应码:”+status);

if(0==status){

SolrDocumentList solrDocumentList = response.getResults();

long numFound = solrDocumentList.getNumFound();

System.out.println(“共查询到“+numFound+”条满足条件的数据!”);

System.out.println(“————–“);

for (SolrDocument s : solrDocumentList) {

System.out.println(“商品的id:”+s.get(“id”));

System.out.println(“商品的名称:”+s.get(“product_name”));

System.out.println(“商品的价格:”+s.get(“product_price”));

System.out.println(“商品的图片:”+s.get(“product_picture”));

System.out.println(“商品的类别名称:”+s.get(“product_catalog_name”));

System.out.println(“商品的描述:”+s.get(“product_decsription”));

System.out.println(“———–分隔符—————“);

}

}

} catch (SolrServerException e) {

e.printStackTrace();

}

}

<lib dir=”F:/depJar/contrib/dataimporthandler/lib/” regex=”.*\.jar” />

<lib dir=”F:/depJar/contrib/db/lib/” regex=”.*\.jar” />

<?xml version=”1.0″ encoding=”UTF-8″ ?>  

<dataConfig>   

<dataSource type=”JdbcDataSource”   

  driver=”com.mysql.jdbc.Driver”   

  url=”jdbc:mysql://localhost:3306/solr”   

  user=”root”   

  password=”gzsxt”/>   

<document>   

<entity name=”product” query=”SELECT pid,name,catalog,catalog_name,price,description,picture FROM products “>

 <field column=”pid” name=”id”/>

 <field column=”name” name=”product_name”/>

 <field column=”catalog_name” name=”product_catalog_name”/>

 <field column=”price” name=”product_price”/>

 <field column=”description” name=”product_description”/>

 <field column=”picture” name=”product_picture”/>

</entity>   

</document>   

</dataConfig>

<requestHandler name=”/dataimport”

class=”org.apache.solr.handler.dataimport.DataImportHandler”>

           <lst name=”defaults”>

           <str name=”config”>data-config.xml</str>

           </lst>

  </requestHandler> 

<!– IKAnalyzer–>

    <fieldType name=”text_ik” class=”solr.TextField”>

             <analyzer class=”org.wltea.analyzer.lucene.IKAnalyzer”/>

    </fieldType>

<field name=”id” type=”string” indexed=”true” stored=”true” required=”true” multiValued=”false” />

   <field name=”product_name” type=”text_ik” indexed=”true” stored=”true”/>

   <field name=”product_catalog_name” type=”string” indexed=”true” stored=”true” />

   <field name=”product_price”  type=”double” indexed=”true” stored=”true”/>

   <field name=”product_description” type=”text_ik” indexed=”true” stored=”false” />

   <field name=”product_picture” type=”string” indexed=”false” stored=”true” />

<?xml version=”1.0″ encoding=”UTF-8″?>

<beans xmlns=”http://www.springframework.org/schema/beans”

xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xmlns:mvc=”http://www.springframework.org/schema/mvc”

xmlns:context=”http://www.springframework.org/schema/context”

xmlns:aop=”http://www.springframework.org/schema/aop” xmlns:tx=”http://www.springframework.org/schema/tx”

xsi:schemaLocation=”http://www.springframework.org/schema/beans

http://www.springframework.org/schema/beans/spring-beans-3.1.xsd

http://www.springframework.org/schema/mvc

http://www.springframework.org/schema/mvc/spring-mvc-3.1.xsd

http://www.springframework.org/schema/context

http://www.springframework.org/schema/context/spring-context-3.1.xsd

http://www.springframework.org/schema/aop

http://www.springframework.org/schema/aop/spring-aop-3.1.xsd

http://www.springframework.org/schema/tx

http://www.springframework.org/schema/tx/spring-tx-3.1.xsd “>

<!– 配置扫描包 –>

<context:component-scan base-package=”cn.gzsxt” />

<!– 配置注解驱动 –>

<mvc:annotation-driven />

<!– jsp视图解析器 –>

<bean

class=”org.springframework.web.servlet.view.InternalResourceViewResolver”>

<!– 前缀 –>

<property name=”prefix” value=”/WEB-INF/jsp/”></property>

<!– 后缀 –>

<property name=”suffix” value=”.jsp”></property>

</bean>

<bean class=”org.apache.solr.client.solrj.impl.HttpSolrServer”>

<constructor-arg value=”http://localhost:8080/solr/solrCore0719″></constructor-arg>

</bean>

</beans>

<?xml version=“1.0” encoding=“UTF-8”?>

<web-app xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance” xmlns=“http://xmlns.jcp.org/xml/ns/javaee” xsi:schemaLocation=“http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd” id=“WebApp_ID” version=“3.1”>

  <display-name>JD0719</display-name>

  <!– SpringMVC配置 –>

<servlet>

<servlet-name>springmvc</servlet-name>

<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>

<init-param>

<param-name>contextConfigLocation</param-name>

<param-value>classpath:springmvc.xml</param-value>

</init-param>

</servlet>

<servlet-mapping>

<servlet-name>springmvc</servlet-name>

<url-pattern>/</url-pattern>

</servlet-mapping>

<filter>

<filter-name>Character Encoding</filter-name>

<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>

<init-param>

<param-name>encoding</param-name>

<param-value>UTF-8</param-value>

</init-param>

</filter>

<filter-mapping>

<filter-name>Character Encoding</filter-name>

<url-pattern>*.action</url-pattern>

</filter-mapping>

</web-app>

package cn.gzsxt.solr.controller;

import org.springframework.stereotype.Controller;

import org.springframework.web.bind.annotation.PathVariable;

import org.springframework.web.bind.annotation.RequestMapping;

@Controller

public class PageController {

@RequestMapping(value=”/{page}”)

public String showPage(@PathVariable(“page”)String page){

return page;

}

}

<bean class=”org.apache.solr.client.solrj.impl.HttpSolrServer”>

<constructor-arg value=”http://localhost:8888/solr/solrCore0719“></constructor-arg>

</bean>

请求路径

list.action

请求方式

POST

请求参数

queryString、catalog_name、price、curPage、sort（共5个）

返回结果

定义Product 以及ProductModel

public class Product {

// 商品编号

private String pid;

// 商品名称

private String name;

// 商品分类名称

private String catalog_name;

// 价格

private double price;

// 商品描述

private String description;

// 图片名称

private String picture;

}

public class ResultModel {

private List<Product> productList;

// 商品总数

private Long recordCount;

// 总页数

private int pageCount;

// 当前页

private int currentPage;

}

public interface ProductDao {

//查询商品信息，包括分页信息

public ResultModel queryProduct(SolrQuery query) throws Exception;

}

package cn.gzsxt.dao.impl;

import java.util.ArrayList;

import java.util.List;

import java.util.Map;

import org.apache.solr.client.solrj.SolrQuery;

import org.apache.solr.client.solrj.impl.HttpSolrServer;

import org.apache.solr.client.solrj.response.QueryResponse;

import org.apache.solr.common.SolrDocument;

import org.apache.solr.common.SolrDocumentList;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Repository;

import cn.gzsxt.bean.Product;

import cn.gzsxt.bean.ResultModel;

import cn.gzsxt.dao.ProductDao;

@Repository

public class ProductDaoImpl implements ProductDao {

@Autowired

private HttpSolrServer server;

@Override

public ResultModel queryProduct(SolrQuery query) throws Exception {

ResultModel result = new ResultModel();

// 通过server查询索引库

QueryResponse response = server.query(query);

// 获得查询结果

SolrDocumentList documentList = response.getResults();

// 把查询结果总数设置到ResultModel

result.setRecordCount(documentList.getNumFound());

List<Product> productList = new ArrayList<>();

Product product = null;

// 高亮信息

Map<String, Map<String, List<String>>> highlighting = response

.getHighlighting();

for (SolrDocument solrDocument : documentList) {

product = new Product();

product.setPid((String) solrDocument.get(“id”));

String prodName = (String) solrDocument.get(“product_name”);

List<String> list = highlighting.get(solrDocument.get(“id”)).get(

“product_name”);

if (list != null)

prodName = list.get(0);

product.setName(prodName);

product.setCatalog_name((String) solrDocument

.get(“product_catalog_name”));

product.setPrice((float) solrDocument.get(“product_price”));

product.setPicture((String) solrDocument.get(“product_picture”));

productList.add(product);

}

// 把商品列表放到ResultMap中

result.setProductList(productList);

return result;

}

}

public interface ProductService {

public ResultModel queryProduct(String queryString, String cataName,

String price, String sort, Integer curPage) throws Exception;

}

package cn.gzsxt.service.impl;

import org.apache.solr.client.solrj.SolrQuery;

import org.apache.solr.client.solrj.SolrQuery.ORDER;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Service;

import cn.gzsxt.dao.ProductDao;

import cn.gzsxt.service.ProductService;

import cn.gzsxt.vo.ResultModel;

@Service

public class ProductServiceImpl implements ProductService {

@Autowired

private ProductDao productDao;

@Override

public ResultModel queryProduct(String queryString, String cataName,

String price, String sort, Integer curPage) throws Exception {

//封装查询条件

SolrQuery query = new SolrQuery();

//判断查询条件是否为空

if(!””.equals(queryString)&& null != queryString){

query.setQuery(queryString);

}else{

query.setQuery(“*:*”);

}

//判断过滤条件是否为空

if(!””.equals(cataName)&& null !=cataName){

query.addFilterQuery(“product_catalog_name:”+cataName);

}

//判断商品价格是否为空

if(!””.equals(price) && null != price){

String[] prices = price.split(“-“);

if(prices.length == 2){

query.addFilterQuery(“product_price:[“+prices[0]+” TO “+prices[1]+”]”);

}

}

//设置排序

if(“1”.equals(sort)){

query.setSort(“product_price”, ORDER.desc);

}else {

query.setSort(“product_price”, ORDER.asc);

}

//设置分页信息

if(null == curPage){

curPage = 1;

}

query.setStart((curPage-1)*20);

query.setRows(20);  //每页20条数据

//设置默认搜索域

query.set(“df”,”product_name”);

query.setHighlight(true);

query.addHighlightField(“product_name”);

query.setHighlightSimplePre(“<font style=\”color:red\”>”);

query.setHighlightSimplePost(“</font>”);

ResultModel result = productDao.queryProduct(query);

result.setCurrentPage(curPage);

// 总页数 = 总数量 / 每页数据条数  结果向上取整

double ceil = Math.ceil(result.getRecordCount().doubleValue()/20);

result.setPageCount((int)ceil);

return result;

}

}

package cn.gzsxt.controller;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Controller;

import org.springframework.ui.ModelMap;

import org.springframework.web.bind.annotation.RequestMapping;

import cn.gzsxt.service.ProductService;

import cn.gzsxt.vo.ResultModel;

@Controller

public class ProductController {

@Autowired

private ProductService productService;

@RequestMapping(“/list.action”)

public String queryProduct(String queryString, String catalog_name,

String price, String sort, Integer curPage, ModelMap model)

throws Exception {

ResultModel resultModel = productService.queryProduct(queryString, catalog_name,

price, sort, curPage);

model.addAttribute(“result”, resultModel);

model.addAttribute(“queryString”, queryString);

model.addAttribute(“catalog_name”, catalog_name);

model.addAttribute(“price”, price);

model.addAttribute(“sort”, sort);

model.addAttribute(“page”, curPage);

return “product_list”;

}

}