81,091
社区成员
发帖
与我相关
我的任务
分享
==> Preparing: select count(1) from t_query_log WHERE deptname like '%'||?||'%'
==> Parameters: 0(Integer)
是integer类型的,在debug的时候,参数数据传递无误。Preparing: select * from ( select ID,USERNAME,USERNUMBER,DEPTNAME,DEPCODE,QUERYPARAM,QUERYDATE,REMOTEADDR,QUERYTYPE,QUERYRESULT from t_query_log WHERE usernumber like '%'||?||'%' order by querydate desc ) where rownum <= 10
==> Parameters: z(String)
<select id="selectForPage" parameterType="com.zl.bx.entity.QueryLog" resultType="com.zl.bx.entity.QueryLog">
select <include refid="Base_Column_List"/>
是个实体类
private String username;
/**
* 用户身份证
*/
private String usernumber;
/**
* 部门名
*/
我是身份证可以查,部门名不能查values(#{id,jdbcType=VARCHAR}
,#{username,jdbcType=VARCHAR},#{usernumber,jdbcType=VARCHAR}
,#{deptname,jdbcType=VARCHAR},#{depcode,jdbcType=VARCHAR}
,#{queryparam,jdbcType=VARCHAR},#{querydate,jdbcType=TIMESTAMP}
,#{remoteAddr,jdbcType=VARCHAR},#{queryType,jdbcType=NUMERIC}
,#{queryResult,jdbcType=NUMERIC})
<if test="usernumber !=null and usernumber !=''">
usernumber like '%'||#{usernumber}||'%'
</if>
<if test="deptname !=null and deptname !=''">
and deptname LIKE CONCAT(CONCAT('%', #{deptname}), '%')
</if>
实体类里也都是设置的String。。。[/quote]
usernumber like '%'||#{usernumber}||'%'
用#号 标示 里面是数字, 用$ 标示是 字符串
values(#{id,jdbcType=VARCHAR}
,#{username,jdbcType=VARCHAR},#{usernumber,jdbcType=VARCHAR}
,#{deptname,jdbcType=VARCHAR},#{depcode,jdbcType=VARCHAR}
,#{queryparam,jdbcType=VARCHAR},#{querydate,jdbcType=TIMESTAMP}
,#{remoteAddr,jdbcType=VARCHAR},#{queryType,jdbcType=NUMERIC}
,#{queryResult,jdbcType=NUMERIC})
<if test="usernumber !=null and usernumber !=''">
usernumber like '%'||#{usernumber}||'%'
</if>
<if test="deptname !=null and deptname !=''">
and deptname LIKE CONCAT(CONCAT('%', #{deptname}), '%')
</if>
实体类里也都是设置的String。。。public HSSFWorkbook readerFromExcel(String path){
POIFSFileSystem fs = null;
HSSFWorkbook workbook = null;
File file = new File(path);
if(file.exists()){
FileInputStream fin;
try {
fin = new FileInputStream(file);
fs = new POIFSFileSystem(fin);
workbook = new HSSFWorkbook(fs);
} catch (FileNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return workbook;
}
return null;
}