jdbc servlet ssm 实现简单的增删改查与模糊查询

jdbc servlet ssm 实现简单的增删改查与模糊查询

一、分页
1.pageinfo list size totalcount totalpage currentPage
2.dao findAll(start) get totalcount
3.service new pageinfo 对象 给pageinfo 赋值
4.controller 在modelandview 里面添加pageinfo 对象
5.页面 在页面展示数据，在页码拼接当前页
二、过滤器 filter
1.新建 loginfilter implements Filter 在filter里面 判断session里是否有user 如果没有user并且当前的请求不是login.do 跳转到登入页面，否则继续执行
2.web.xml 配置filter 拦截所有的*.do
3.到userController里的login 方法，登入成功后把用户信息放到session里面

UserMapper

<mapper namespace="com.wu.dao.UserDao" >
    <select id="findUserByUserName" parameterType="String" resultType="user">
        select * from tb_user where username=#{
   username}
    </select>
    <select id="findAll" parameterType="int" resultType="user">
        select * from tb_user limit #{
   start},5
    </select>
    <delete id="deleteById" parameterType="int">
        delete from tb_user where id =#{
   id}
    </delete>
    <insert id="addUser" parameterType="String">
        insert into tb_user(username,password) value (#{
   username},#{
   password})
    </insert>
    <select id="selectById" parameterType="int" resultType="user">
        select * from tb_user where id=#{
   id}
    </select>
    <update id="update" parameterType="user">
        update tb_user set username=#{
   username},password=#{
   password} where id=#{
   id}
    </update>
    <select id="getTotalCount" resultType="int">
        select count(*) from tb_user
    </select>
    <select id="search" parameterType="String">
        select * from tb_user where username like "%"#{
   username}"%"
    </select>
<