【Mybatis传入多参数 _mybatis 】

Mybatis传入多参数

我也踩过这个坑( 1 )

已统计您的踩坑,无需重复点击

回答(0)

mybatis

详细描述

错误截图

源码

<!--命名空间-->
<mapper namespace="cn.wzy.springMybatis.dao.UserMapper">
    <!--防止实体类与数据库命名不一致-->
    <resultMap id="userMap" type="User">
        <id column="user_id" property="user_id"/>
        <result column="user_name" property="user_name"/>
        <result column="user_qq" property="user_qq"/>
        <result column="user_type" property="user_type"/>
        <result column="admissiontime" property="admissiontime"/>
        <result column="graduatedfrom" property="graduatedfrom"/>
        <result column="sid" property="sid"/>
        <result column="dailylink" property="dailylink"/>
        <result column="hope" property="hope"/>
        <result column="recommender" property="recommender"/>
        <result column="known" property="known"/>
        <result column="create_at" property="create_at"/>
        <result column="update_at" property="update_at"/>
    </resultMap>
    <select id="selectFromNameOrSid" resultMap="userMap">
        select * from users
        <where>
         <choose>
            <when test="user_name != null and user_name != ''">
                USER_NAME=#{user_name}
            </when>
             <when test="sid != null and sid != ''">
                 SID=#{sid}
             </when>
         </choose>
        </where>
    </select>
</mapper>

package cn.wzy.springMybatis.dao;

import cn.wzy.springMybatis.entity.User;
import java.util.List;

public interface UserMapper {
    List<User> selectFromNameOrSid(String user_name,long sid);
}

package cn.wzy.springMybatis.service;

public interface Service {
    int selectFromNameOrSid(String user_name,long sid);
}





package cn.wzy.springMybatis.service;

import cn.wzy.springMybatis.dao.UserMapper;
import cn.wzy.springMybatis.entity.User;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import java.sql.Timestamp;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class ServiceImpl implements Service {
    ApplicationContext context = new ClassPathXmlApplicationContext("spring/spring-mybatis.xml");
    SqlSessionFactory factory = (SqlSessionFactory) context.getBean("sqlSessionFactory"); 

   //SelectFromNameOrSid
    public int selectFromNameOrSid(String user_name,long sid){
        //获得会话对象
        SqlSession sqlsession = factory.openSession(true);
        try{
            UserMapper userMapper = sqlsession.getMapper(UserMapper.class);
            List<User> list = userMapper.selectFromNameOrSid(user_name,sid);
            for (User User : list) {
                System.out.println(User);
            }
        }
        catch (Exception e) {
            e.printStackTrace();
        }
        finally {
            sqlsession.close();
        }
        return 1;
    }
}

url

点我跳转源码链接

编辑于2024-11-11