📄 in14_logon_role.htm
字号:
null) {</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> if
("request".equals(mapping.getScope()))</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体">
request.removeAttribute(mapping.getAttribute());</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> else</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体">
session.removeAttribute(mapping.getAttribute());</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> }</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> </span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> // Forward control to the
specified success URI</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> return
(mapping.findForward("success"));</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> </span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> }</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> </span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> </span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> </span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> //
------------------------------------------------------ Protected Methods</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> </span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> </span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> /**</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> * Look up the user, throwing an
exception to simulate business logic</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> * rule exceptions.</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> *</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> * @param database Database in
which to look up the user</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> * @param username Username
specified on the logon form</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> *</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> * @exception ModuleException if
a business logic rule is violated</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> */</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> public String CheckUser(String
username,String password)</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> {</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> Connection con = null;
</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> try </span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> {</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> con = pool.getConnection();</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> String sql = "SELECT * from
dbo.users WHERE username = ? AND password= ?";</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> </span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> PreparedStatement ps = null;</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> ResultSet rs = null;</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> </span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> try {</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> if (con.isClosed()) {</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> throw new
IllegalStateException("error.con.isClosed");</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> }</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> <b> ps =
con.prepareStatement(sql);</b></span></p>
<p class="MsoNormal" style="text-indent: 21.1pt"><b>
<span lang="EN-US" style="font-family: 宋体"> ps.setString(1,username);</span></b></p>
<p class="MsoNormal" style="text-indent: 21.1pt"><b>
<span lang="EN-US" style="font-family: 宋体"> ps.setString(2,password);</span></b></p>
<p class="MsoNormal" style="text-indent: 21.1pt"><b>
<span lang="EN-US" style="font-family: 宋体"> rs = ps.executeQuery();</span></b></p>
<p class="MsoNormal" style="text-indent: 21.1pt"><b>
<span lang="EN-US" style="font-family: 宋体"> </span></b></p>
<p class="MsoNormal" style="text-indent: 21.1pt"><b>
<span lang="EN-US" style="font-family: 宋体"> String returnstr="";</span></b></p>
<p class="MsoNormal" style="text-indent: 21.1pt"><b>
<span lang="EN-US" style="font-family: 宋体"> while(rs.next())</span></b></p>
<p class="MsoNormal" style="text-indent: 21.1pt"><b>
<span lang="EN-US" style="font-family: 宋体"> { </span></b></p>
<p class="MsoNormal" style="text-indent: 21.1pt"><b>
<span lang="EN-US" style="font-family: 宋体">
returnstr+=";"+rs.getString("role");</span></b></p>
<p class="MsoNormal" style="text-indent: 21.1pt"><b>
<span lang="EN-US" style="font-family: 宋体"> }</span></b></p>
<p class="MsoNormal" style="text-indent: 21.1pt"><b>
<span lang="EN-US" style="font-family: 宋体"> return returnstr;</span></b></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> </span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> </span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> } catch (SQLException e) {</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> e.printStackTrace();</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> throw new
RuntimeException("error.ps.executeQuery");</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> } finally {</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> try {</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> if (ps != null)</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> ps.close();</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> if (rs != null)</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> rs.close();</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> } catch (SQLException e) {</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> e.printStackTrace();</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> throw new
RuntimeException("error.rs.close");</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋体"> }</span></p>
<p class="MsoNormal" style="text-indent: 21.0pt">
<span lang="EN-US" style="font-family: 宋⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -