在Tomcat下虚拟目录里JSP登录页面连接MYSQL数据库具体的文件代码以及图片。。


答案：login.jsp
登录页面
<%@page contentType="text/html;charset=gb2312"%>
<html>
 <head>
  <title>登录</title>
  </head>
  <body>
   <center>
    <h1>用户名及密码</h1>
    <hr>
    <br>
    <br>
    <form action="login_conf.jsp" method="post">
     <table>
      <tr>
       <td colspan="2">用户登录</td>
       </tr>
       <tr>
        <td>用户名：</td>
        <td><input type="text" name="uname"></td>
        </tr>
        <tr>
         <td>密码：</td>
         <td><input type="password" name="upassword"></td>
         </tr>
         <tr>
          <td colspan="2">
           <input type="submit" value="登录">
           <input type="reset" value="重置">
          </td>
          </tr>
         
      </table>
     </form>
    </center>
   </body>
 </html>
 
login_conf.jsp
数据库连接
<%@page contentType="text/html;charset=gb2312" import= "java.sql.* " language="java"%>
<html>
 <head>
  <title>登录</title>
  </head>
  <body>
   <center>
    <h1>用户名及密码</h1>
    <hr>
    <br>
    <br>
    <%
       String name = request.getParameter("uname");
       String password = request.getParameter("upassword");
       
       boolean flag = false;
       
    %>
    <%
       final String DBDRIVER = "com.mysql.jdbc.Driver";
       final String DBURL = "jdbc:mysql://localhost:3306/zrj";
       final String DBUSER = "root";
       final String DBPASSWORD = "123456";
       
       Connection conn = null;
       Statement stmt = null;
       ResultSet rs = null;
       String sql = null;
    %>
    <%
       try
       {
        Class.forName(DBDRIVER);
        conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);
        stmt = conn.createStatement();
        sql = "SELECT name FROM user WHERE id='"+name+"' and password='"+password+"' ";
        rs = stmt.executeQuery(sql);
       if(rs.next())
       {
         
       }
       rs.close();
       stmt.close();
       conn.close();
       
       
       }
       catch(Exception e)
       {}
    
    %>
    
    <% 
       if(flag)
       {
    %>
       <jsp:forward page = "login_success.jsp"/>
        
    <%
       }
       else
        {
        
        %>
         <jsp:forward page="login_fail.jsp"/>
        <%
        }
        
        %>
        
    </center>
   </body>
 </html>

 
 
login_success.jsp
登录成功页面
<%@page contentType="text/html;charset=gb2312"%>
<html>
 <head>
  <title>登录</title>
  </head>
  <body>
   <center>
    <h1>用户名及密码</h1>
    <hr>
    <br>
    <br>
    <h2>登录成功</h2>
    <h3>欢迎<font color="red" size="15">
     <%=request.getParameter("name")%>
     </font>光临！！</h3>
   
    </center>
   </body>
 </html>
 
登录失败页面
login_fail.jsp
<%@page contentType="text/html;charset=gb2312"%>
<html>
 <head>
  <title>登录</title>
  </head>
  <body>
   <center>
    <h1>用户名及密码</h1>
    <hr>
    <br>
    <br>
    <h2>登录失败</h2>
    <h3>错误的用户名及密码！！！</h3>
   <a href="login.jsp">重新登录</a>
    </center>
   </body>
 </html>

上一个：js中如何取得jsp中的List；例如下边jsp中代码，代码简单写的，只要具体的解决方法，最好有代码实例
下一个：jsp页面怎么传值啊？求大牛详细代码！！！急...

更多图片编程知识: