DBHepler实现简jsp单登陆

最新推荐文章于 2024-05-09 20:08:47 发布

心若相惜丶在所不惜

最新推荐文章于 2024-05-09 20:08:47 发布

阅读量171

点赞数 1

分类专栏： web 文章标签： jsp

本文链接：https://blog.csdn.net/qq_20787417/article/details/50838706

版权

web 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

相信大家学习jsp都用过jdbc吧,这种访问数据库的方式基本都是常用的,今天我们学习了一种直接利用封装连接数据库方法的方式链接数据库,简洁了自己的代码量,直接利用里面的方法访问数据库,DBHelper以简洁的的方式连接,直接引用
这里写图片描述
login1

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
    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>登陆</title>
</head>
<style>
.f {
    width: 300px;
    height: 200px;
    border-width: 1px;
    border-style: solid;
    -moz-border-radius: 11px;
    -khtml-border-radius: 11px;
    -webkit-border-radius: 11px;
    border-radius: 11px;
    padding: 5px;
    margin-top: 200px;
}
</style>
<body>
    <center>
        <form action="login2.jsp" method="post" class="f">
            <h3>
                <div style="margin-top:20px ;color:#9b8d8d">登陆</div>
            </h3>
            <input type="text" name="account" placeholder="请输入用户名"><br>
            <br> <input type="password" name="password" placeholder="请输入密码"><br>
            <br> <input type="submit" value="登陆">&nbsp <input
                type="reset" value="重置">
        </form>
    </center>
</body>
</html>

login2

<%@ page language="java" import="java.util.*,java.sql.*,DBHelper.*"
    pageEncoding="UTF-8"%>
<%
    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>接收</title>



</head>

<body>
    <%
        String name = request.getParameter("account");
        String password = request.getParameter("password");
        String sql = "select*from test where name=? and password=?";
        Object[] params = new Object[] { name, password };
        ResultSet ra = DBHelper.getResultSet(sql, params);
        if (ra.next())
            out.print("登录成功");
        else
            out.print("登录失败");
    %>
</body>
</html>