Spring3 整合 Mybatis3 - JAVA

然后是MyBatis的配置ibatis-config.xml：
[html] view plaincopy
< xml version="1.0" encoding="UTF-8" >
"http://mybatis.org/dtd/mybatis-3-config.dtd">

接着是映射文件：

[html]

这样，配置就完成了：

接着我们要实现多个java类。

首先是Map类：

[java]
public interface SQLMapper {

}

[java]
public interface KeywordExportPVMapper extends SQLMapper{
List getKeywordExportPVList(KeywordExportPVDataBean keywordExportPVDataBean);

String getKeywordExportPVTotalNumByDate(KeywordExportPVDataBean keywordExportPVDataBean);
}

接着是DAO类：
[java]
import java.util.List;

import javax.inject.Inject;

import org.mybatis.spring.support.SqlSessionDaoSupport;
import org.springframework.stereotype.Service;

import com.log.bean.KeywordExportPVDataBean;
import com.log.bean.mapper.KeywordExportPVMapper;

@Service
public class KeywordExportPVDaoImpl extends SqlSessionDaoSupport implements KeywordExportPVDao{

@Inject
private KeywordExportPVMapper mapper;

public List getKeywordExportPVList(
KeywordExportPVDataBean keywordExportPVDataBean) {
List result = mapper.getKeywordExportPVList(keywordExportPVDataBean);
int index = (keywordExportPVDataBean.getPage() - 1) * keywordExportPVDataBean.getRows() + 1;
for(KeywordExportPVDataBean data : result) {
data.setId(index++);
}
return result;
}

public String getKeywordExportPVTotalNumByDate(KeywordExportPVDataBean keywordExportPVDataBean) {
return mapper.getKeywordExportPVTotalNumByDate(keywordExportPVDataBean);
}

}

一个java bean类
[java]
public class KeywordExportPVDataBean implements Serializable {

private static final long serialVersionUID = 7729632882629489521L;
。。。
}

最后，我们在Controller中调用它
[java]
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.inject.Inject;

import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.ResponseBody;

import com.log.bean.KeywordExportPVDataBean;
import com.log.bean.dao.KeywordExportPVDao;

@Controller
public class KeywordInfoController {

@Inject
KeywordExportPVDao keywordExportPVDao;

@RequestMapping(value="getKeywordExportPVData.do", method=RequestMethod.POST)
@ResponseBody
public Object getKeywordExportPVInfo(KeywordExportPVDataBean req_data ){
List rows = keywordExportPVDao.getKeywordExportPVList(req_data);
String records = keywordExportPVDao.getKeywordExportPVTotalNumByDate(req_data);
Map result = new HashMap ();
result.put("records", Integer.valueOf(records));
result.put("total", Integ

Spring3 整合 Mybatis3(二)