switch.jsp

来自「这是＜＜JBuilder2005实战JSP开发＞＞的 源代码．」· JSP 代码 · 共 27 行

<%@page contentType="text/html; charset=GBK" errorPage="error.jsp" %>
<%@page import="bookstore.*"%>
<%@page import="java.sql.*"%>
<jsp:useBean id="userBean" scope="page" class="bookstore.User"/>
<jsp:setProperty name="userBean" property="*"/>
<%
  Connection conn = null;
  try {
    conn = DBConnection.getConnection();
    PreparedStatement pStat = conn.prepareStatement(
        "select USER_NAME from T_USER where USER_ID=? and password = ?");
    pStat.setString(1, userBean.getUserId());
    pStat.setString(2, userBean.getPassword());
    ResultSet rs = pStat.executeQuery();
    if (rs.next()) { //密码正确
      userBean.setUserName(rs.getString(1));
      session.setAttribute("ses_userBean", userBean);
%>
<jsp:forward page="welcome.jsp"></jsp:forward>
<%} else { //密码错误%>
<jsp:forward page="fail.jsp"></jsp:forward>
<%
  }} finally {
    if (conn != null) conn.close();
  }
%>