jsp+Mysql实现简单用户登陆

来源:互联网 发布:app网络推广招聘 编辑:程序博客网 时间:2024/05/22 02:20

登陆界面:login.jsp

 

<%@page contentType="text/html" pageEncoding="gbk"%>

<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=gbk">
        <title>登陆</title>
    </head>
    <body>
        <center>
        <form name="form1" method="post" action="conf.jsp">
            <h1>用户登录</h1>
            <p>用户名:
                <input type="text" name="name">
            </p>
            <p>用户密码:
                <input type="password" name="password">
            </p>
            <p>
                <input type="submit" name="Submit" value="登陆"> &nbsp;&nbsp;
                <input type="reset" name="Submit2" value="重置">
            </p>
        </form>
        </center>
    </body>
</html>

登录验证界面:conf.jsp

 

<%@page import ="java.sql.*"%>
<%@ page import="java.io.*"%>
<%@ page import ="java.util.*"%>
<%
            Class.forName("org.gjt.mm.mysql.Driver");
            Connection conn = null;
            String url = "jdbc:mysql://localhost:3306/tf";
            String user = "root";
            String password = "123";
            conn = DriverManager.getConnection(url, user, password);
            Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);

            String name = request.getParameter("name");
            byte b[] = name.getBytes("ISO-8859-1");
            name = new String(b);
            String password2 = request.getParameter("password");
            String strSQL = "select * from member where name='" + name + "' and password='" + password2 + "'";
            ResultSet rs = stmt.executeQuery(strSQL);
            int count = 0;
            while (rs.next()) {
                count++;
            }
            if (count > 0) {
%>
<jsp:forward page="chenggong.jsp"></jsp:forward>

<%} else {
%>
<jsp:forward page="shibai.jsp"></jsp:forward>
<%            }
%>