資料庫使用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>
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/13048.html
標籤：Java相關