Welcome 布拉格

(1)createUser!input.jsp

<FORM id="form1" METHOD=POST ACTION="createUserAction.jsp" onSubmit="return check();">
?<TABLE? class="inputTable">
? <TR><Th>用戶名</Th><TD><INPUT TYPE="text" NAME="username" id="username"><span class="require">(*)</span></TD></TR>
??<TR><Th>密碼</Th><TD><INPUT TYPE="password" NAME="password" id="password"><span class="require">(*)</span></TD></TR>
??<TR><Th>重輸密碼</Th><TD><INPUT TYPE="password" NAME="repwd" id="repwd"><span class="require">(*)</span></TD></TR>
??<TR><Th>&nbsp;</Th><TD><INPUT TYPE="submit" value="創建新用戶"></TD></TR>
?</TABLE>
</FORM>

(2)

createUserAction.jsp

<sql:query var="rs" dataSource="${dataSource}" >
?select * from tb_user where username=?
?<sql:param value="${param['username']}"/>
</sql:query>

<c:choose>
<c:when test="${rs.rowCount==0}">
?<sql:update var="rs" dataSource="${dataSource}" >
??insert into tb_user(username,password) values(?,?)
??<sql:param value="${param['username']}"/>
??<sql:param value="${param['password']}"/>
?</sql:update>
?
?<c:redirect url="listUser.jsp"/>
</c:when>

<c:otherwise>
?<SCRIPT LANGUAGE="JavaScript">
?<!--
??alert("該用戶名已存在");
??history.go(-1);
?//-->
?</SCRIPT>
</c:otherwise>
</c:choose>


(3)

editUser!input.jsp

<sql:query var="rs" dataSource="${dataSource}" >
???select * from tb_user where id = ?
???<sql:param value="${param['id']}"/>
??</sql:query>

??<c:set var="user" value="${rs.rows[0]}"/>

??<FORM METHOD=POST ACTION="editUserAction.jsp" onSubmit="return check();">
??<INPUT TYPE="hidden" NAME="id" value="${user.id}">
???<TABLE class="inputTable">
????<TR><Th>用戶名</Th>
????<TD><INPUT TYPE="text" NAME="username" id="username" value="${user.username}"><span class="require"> (*必填)</span></TD></TR>
????<TR><Th>舊密碼</Th><TD><INPUT TYPE="password" NAME="oldPassword"? id="oldPassword" ><span class="require"> (*必填)</span></TD></TR>
????<TR><Th>新密碼</Th><TD><INPUT TYPE="password" NAME="password"? id="password"><span class="require"> (*必填)</span></TD></TR>
????<TR><Th>重輸新密碼</Th><TD><INPUT TYPE="password" NAME="repwd" id="repwd"><span class="require"> (*兩次密碼必須相同)</span></font></TD></TR>
????<TR><Th>&nbsp;&nbsp;&nbsp;&nbsp;</Th><TD><INPUT TYPE="submit" value="編輯"></TD></TR>
???</TABLE>
??</FORM>

(4)

editUserAction.jsp

<sql:query var="rs" dataSource="${dataSource}" >
?select password from tb_user where id = ?
?<sql:param value="${param['id']}"/>
</sql:query>

<c:choose>
<c:when test="${rs.rows[0].password!=param['oldPassword']}">
?<SCRIPT LANGUAGE="JavaScript">
?<!--
??alert("舊密碼錯誤!");
??history.go(-1);
?//-->
?</SCRIPT>
</c:when>

<c:otherwise>
?<sql:query var="rs" dataSource="${dataSource}" >
??select * from tb_user where id <> ? and username = ????????????? ??? <>??不等于
??<sql:param value="${param['id']}"/>
??<sql:param value="${param['username']}"/>
?</sql:query>
?
?<c:choose>
?<c:when test="${rs.rowCount==0}">
??<sql:update var="rs" dataSource="${dataSource}" >
???update tb_user set username = ?,password = ? where id = ?
???<sql:param value="${param['username']}"/>
???<sql:param value="${param['password']}"/>
???<sql:param value="${param['id']}"/>
??</sql:update>
??
??<c:redirect url="listUser.jsp"/>
?</c:when>
?
?<c:otherwise>
??<SCRIPT LANGUAGE="JavaScript">
??<!--
???alert("該用戶名已存在");
???history.go(-1);
??//-->
??</SCRIPT>
?</c:otherwise>
?</c:choose>

</c:otherwise>
</c:choose>

(5)
deleteUserAction.jsp

<sql:update var="rs" dataSource="${dataSource}" >
??delete from tb_user? where id = ?
??<sql:param value="${param['id']}"/>
</sql:update>
?
<c:redirect url="listUser.jsp"/>