sql 语句中判断性别在页面显示乱码,感谢大侠们指导!!!谢谢
数据库使用mysql 数据库,sex字段定义type是 TINYINT size 默认20
后台sql语句如下
String sql = "select ti.user_id as 'user_id',"
+"ti.user_name as 'user_name',"
+"(CASE WHEN ti.user_sex = 0 THEN '未选择'"
+"WHEN ti.user_sex = 1 THEN '男'"
+"WHEN ti.user_sex = 2 THEN '女'"
+"ELSE ' '"
+"END) as 'user_sex',"
+"ti.user_mail as 'user_mail',"
+"ti.user_tel as 'user_tel',"
+"ti.user_address as 'user_address',"
+"ti.user_create_time as 'user_create_time',"
+"ti.user_rank_id as 'user_rank_id',"
+"ti.user_dept_id as 'user_dept_id'"
+"from t_user_info ti";
jsp页面(pageEncoding(GBK 和UTF-8都使用过了))
使用<logic:iterate>标签
<bean:write name="user" property="user_sex" filter="false"/></td>