技术问答mybatis濡備綍閬嶅巻string鏁扮粍 - 扬州沐宇科技

鍦?MyBatis 涓亶鍘?String 鏁扮粍鍙互浣跨敤 foreach 鏍囩鏉ュ疄鐜般€?/p>

渚嬪锛屽亣璁炬垜浠湁涓€涓?String 鏁扮粍锛岄渶瑕佸湪 SQL 璇彞涓娇鐢ㄨ繖涓暟缁勭殑鍊艰繘琛屾煡璇紝鍙互鎸夌収浠ヤ笅姝ラ鏉ュ疄鐜帮細

鍦?SQL 璇彞涓娇鐢?foreach 鏍囩鏉ラ亶鍘?String 鏁扮粍涓殑鍊硷紝绀轰緥濡備笅锛?/li>

<select id="selectUsersByIds" parameterType="map" resultType="User">
    SELECT * FROM users
    WHERE id IN
    <foreach item="item" index="index" collection="ids" open="(" separator="," close=")">
        #{item}
    </foreach>
</select>

鍦?Java 浠ｇ爜涓紶鍏?String 鏁扮粍浣滀负鍙傛暟锛屽苟灏嗗弬鏁颁紶閫掔粰 SQL 璇彞锛岀ず渚嬪涓嬶細

List<User> selectUsersByIds(String[] ids);

璋冪敤鏂规硶骞朵紶鍏?String 鏁扮粍鍙傛暟锛岀ず渚嬪涓嬶細

String[] ids = {"1", "2", "3"};
List<User> users = userDao.selectUsersByIds(ids);

杩欐牱灏卞彲浠ュ湪 MyBatis 涓亶鍘?String 鏁扮粍骞朵娇鐢ㄦ暟缁勪腑鐨勫€艰繘琛屾煡璇€?/p>