加载笔记接口

package com.whc.wznoteserver2.service;

import java.util.List;

import com.whc.wznoteserver2.entity.NoteBook;
import com.whc.wznoteserver2.param.NoteBookParam;

public interface NoteBookService {

	
	public int getCount(NoteBookParam param);
	
	/**
	 * 获取笔记本信息
	 * @return
	 */
	public List<NoteBook> getNoteBook(NoteBookParam param);
	
	
	/**
	 * 添加笔记本信息
	 * @param noteBook 要添加的笔记本
	 * @return
	 */
	public int addNoteBook(NoteBook noteBook);
	
	
	/**
	 * 查询单个笔记本信息
	 * @param noteBook 根据noteBook的id来查询
	 * @return
	 */
	public List<NoteBook> getNoteBookDetail(NoteBook noteBook);
	
	
	/**
	 * 更新笔记本信息
	 * @param noteBook 要更新的笔记本
	 * @return
	 */
	public int updateNoteBook(NoteBook noteBook);
	
	
	/**
	 * 删除笔记本
	 * @param noteBook 要删除的笔记本
	 * @return
	 */
	public int deleteNoteBook(NoteBook noteBook);
}

实现接口

package com.whc.wznoteserver2.serviceimpl;

import java.util.List;

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

import com.whc.wznoteserver2.dao.NoteBookDao;
import com.whc.wznoteserver2.entity.NoteBook;
import com.whc.wznoteserver2.param.NoteBookParam;
import com.whc.wznoteserver2.service.NoteBookService;

@Service
public class NoteBookImpl implements NoteBookService{

	@Autowired
	NoteBookDao noteBookDao;
	
	public int getCount(NoteBookParam param) {
		return noteBookDao.getCount(param);
	}
	
	/**
	 * 获取笔记本信息
	 * @return
	 */
	public List<NoteBook> getNoteBook(NoteBookParam param) {
		return noteBookDao.getNoteBook(param);
	}

	/**
	 * 添加笔记本信息
	 * @param noteBook 要添加的笔记本
	 * @return
	 */
	public int addNoteBook(NoteBook noteBook) {
		return noteBookDao.addNoteBook(noteBook);
	}

	/**
	 * 查询单个笔记本信息
	 * @param noteBook 根据noteBook的id来查询
	 * @return
	 */
	public List<NoteBook> getNoteBookDetail(NoteBook noteBook) {
		return noteBookDao.getNoteBookDetail(noteBook);
	}

	/**
	 * 更新笔记本信息
	 * @param noteBook 要更新的笔记本
	 * @return
	 */
	public int updateNoteBook(NoteBook noteBook) {
		return noteBookDao.updateNoteBook(noteBook);
	}

	/**
	 * 删除笔记本
	 * @param noteBook 要删除的笔记本
	 * @return
	 */
	public int deleteNoteBook(NoteBook noteBook) {
		return noteBookDao.deleteNoteBook(noteBook);
	}

}

数据库Dao NoteBookDao.java 包括 根据笔记本Id加载笔记本、根据笔记名称查找笔记、修改笔记、保存笔记等操作

package com.whc.wznoteserver2.dao;

import java.util.List;

import com.whc.wznoteserver2.entity.NoteBook;
import com.whc.wznoteserver2.param.NoteBookParam;

public interface NoteBookDao {
	
	/**
	 * 获取记录数
	 * @return
	 */
	public int getCount(NoteBookParam param);

	/**
	 * 获取笔记本信息
	 * @return
	 */
	public List<NoteBook> getNoteBook(NoteBookParam param);
	
	/**
	 * 添加笔记本信息
	 * @param noteBook 要添加的笔记本
	 * @return
	 */
	public int addNoteBook(NoteBook noteBook);
	
	/**
	 * 查询单个笔记本信息
	 * @param noteBook 根据noteBook的id来查询
	 * @return
	 */
	public List<NoteBook> getNoteBookDetail(NoteBook noteBook);
	
	/**
	 * 更新笔记本信息
	 * @param noteBook 要更新的笔记本
	 * @return
	 */
	public int updateNoteBook(NoteBook noteBook);
	
	/**
	 * 删除笔记本
	 * @param noteBook 要删除的笔记本
	 * @return
	 */
	public int deleteNoteBook(NoteBook noteBook);

}

笔记相关Mapper NoteBookMapper.xml,各种操作的id 要和NoteDao 中的方法名保持一致。

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//ibatis.apache.org//DTD Mapper 3.0//EN"      
 "http://ibatis.apache.org/dtd/ibatis-3-mapper.dtd">
 
<mapper namespace="com.whc.wznoteserver2.dao.NoteBookDao">

	<select id="getCount" resultType="Integer" parameterType="com.whc.wznoteserver2.param.NoteBookParam">
		select count(*) from note_t_notebooks where isdelete=0 and userid=#{userid}
	</select>
	
	<select id="getNoteBook"  resultType="com.whc.wznoteserver2.entity.NoteBook">
		select id,name,addtime,isdelete,userid from note_t_notebooks where isdelete=0 and userid=#{userid} order by addtime desc limit #{page},#{limit}
	</select>
	
	<insert id="addNoteBook" parameterType="com.whc.wznoteserver2.entity.NoteBook">
		insert into note_t_notebooks (id,name,addtime,isdelete,userid) values(#{id},#{name},#{addtime},#{isdelete},#{userid})
	</insert>
	
	<select id="getNoteBookDetail" parameterType="com.whc.wznoteserver2.entity.NoteBook" resultType="com.whc.noteserver.entity.NoteBook">
		select id,name,addtime,isdelete,userid from note_t_notebooks  where id=#{id}
	</select>
	
	<update id="updateNoteBook" parameterType="com.whc.wznoteserver2.entity.NoteBook">
		update note_t_notebooks set name=#{name} where id=#{id}
	</update>
	
	<update id="deleteNoteBook" parameterType="com.whc.wznoteserver2.entity.NoteBook">
		update note_t_notebooks set isdelete=1 where id=#{id}
	</update>
</mapper>