spring（4）

<?xml version="1.0" encoding="UTF-8"?> select * from servlet delete from servlet where id=#{id}; insert into servlet(id,username,password) values (#{id},#{username},#{password}); update servlet set username=#{username},password=#{password} where id=#{id}; select * from servlet where username=#{username} limit 1; select * from servlet where username like "%"#{start}"%" limit #{start},#{size}; select count(*) from servlet where username like #{cc}; package com.zhongruan.service.Impi;

import com.zhongruan.bean.User;
import com.zhongruan.bean.pojo.Fenye;
import com.zhongruan.dao.Iuserdao;
import com.zhongruan.service.Iuserservice;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.ArrayList;
import java.util.List;
@Service
public class userser implements Iuserservice {
@Autowired
private Iuserdao userdao;
private User uu;
@Override
public List finda() {

    return userdao.findall();
}

@Override
public void shanchu(int id) {
    userdao.delete(id);
}

@Override
public void xz(User user) {
    userdao.xinzeng(user);
}

@Override
public void xg(User user) {
    userdao.xiugai(user);
}

@Override
public Boolean pd(String username,String password) {
    User zhi = userdao.cha(username);
    System.out.println(username);
    System.out.println(password);
    if (zhi!=null&& password.equals(zhi.getPassword())){
        return true;
    }else{
        return false;
    }
}

@Override
public Fenye fen(String mz,int dangqian, int tiaoshu) {
    Fenye fenye=new Fenye();
    fenye.setCurrent_page(dangqian);
    fenye.setNumber_of_bars(tiaoshu);
    int qs=(dangqian-1)*5;
    List<User> jj=userdao.paging(mz,qs,tiaoshu);
    fenye.setList(jj);
    int hangshu = userdao.hangshu(mz);
    fenye.setRow_number(hangshu);
    Double qq=Double.valueOf(hangshu);
    Double ceil = Math.ceil(qq / tiaoshu);
    fenye.setThe_number_of_pages(ceil.intValue());
    return null;
}

}