📄 login_conf.jsp

📁 一个JSP写的留言本
💻 JSP
字号:
<%@ page language="java" import="java.util.*" pageEncoding="gbk"%>
<%@ page import="java.sql.*"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
    <base href="<%=basePath%>">
    
    <title>My JSP 'login_conf.jsp' starting page</title>
    
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">    
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->

</head>

<body>
<center>
<h1>留言管理范例 —— JSP + JDBC实现</h1>
<hr>
<br>
<%!
 String DBDRIVER    = "net.sourceforge.jtds.jdbc.Driver" ;
  String DBURL    = "jdbc:jtds:sqlserver://127.0.0.1:1433/jspdemo" ;
   String DBUSER    = "sa" ;
   String DBPASSWORD   = "sa" ;
   Connection conn    = null ;
   PreparedStatement pstmt = null ;
   ResultSet rs    = null ;
%>
<%
   // 声明一个boolean变量，用于保存用户是否合法状态
   boolean flag = false ;
    // 接收参数
    String id = request.getParameter("id") ;
    String password = request.getParameter("password") ;
    %>
<%
   String sql = "SELECT name FROM person WHERE id=? and password=?" ;
   try
   {
    Class.forName(DBDRIVER) ;
    
    conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD) ;
    pstmt = conn.prepareStatement(sql) ;
      System.out.println(id+password);
    pstmt.setString(1,id) ;
    pstmt.setString(2,password) ;
    rs = pstmt.executeQuery() ;
    if(rs.next())
    {
  
     // 用户合法
     flag = true ;
     // 将用户名保存在session之中
     session.setAttribute("uname",rs.getString(1)) ;
    }
    else
    {
     // 保存错误信息
     request.setAttribute("err","错误的用户名及密码！！！") ;
    }
    rs.close() ;
    pstmt.close() ;
    conn.close() ;
   }
   catch(Exception e)
   {}
    %>
    <%
    // 跳转
    if(flag)
    {
       // 用户合法
    %>
       <jsp:forward page="login_success.jsp"/>
    <%
    }
    else
    {
       //用户非法
    %>
       <jsp:forward page="login.jsp"/>
    <%
    }
    %>    
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -