Java Servlet 连接数据库 HTML界面实现登录

最新推荐文章于 2023-03-17 19:24:39 发布

梦さん

最新推荐文章于 2023-03-17 19:24:39 发布

阅读量459

点赞数

本文链接：https://blog.csdn.net/qq_45041558/article/details/102737313

版权

Dlu.html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>登录</title>
    <style>
        tr{
            height:50px;
        }
        td{
            text-align: center;
        }
    </style>
</head>
<body>
<form action="myServlet02" method="get">
    <h1 align="center">登录</h1>
    <table width="500" border="1" cellspacing="0" cellpadding="0" align="center">
        <tr>
            <td>账号：</td>
            <td><input type="text" name="username" /></td>
        </tr>
        <tr>
            <td>密码：</td>
            <td><input type="password" name="password" /></td>
        </tr>
        <tr>
            <td colspan="2"><input type="submit" value="登录" /></td>
        </tr>
    </table>
</form>

</body>
</html>

Servlet02.java

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.SQLException;

@WebServlet("/myServlet02")
public class Servlet02 extends HttpServlet {
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

        //获取表单数据
        String uname = request.getParameter("username");
        String pwd = request.getParameter("password");
        //登录验证
        response.setContentType("text/html;charset= UTF-8");
        PrintWriter out = response.getWriter();

        /*
        if ("aaa".equals(uname) && "123".equals(pwd)){
            out.println("<h1 align='center'>登录成功!</h1>");
        }else {
            out.println("<h1 align='center'>登录失败!</h1>");
        }
        */
//3.连接数据库，验证登录信息
        QueryRunner qr = new QueryRunner(DruidUtils.getDataSource());
        String sql = "select * from t_user where username = ? and password = ?";
        User user = null;
        try {
            user = qr.query(sql, new BeanHandler<User>(User.class), uname, pwd);
        } catch (SQLException e) {
            e.printStackTrace();
        }

        if(user != null){
            //登录成功
            out.println("<h1 >登录成功！</h1>");
        }else{
            //登录失败
            out.println("登录失败！");
        }



    }

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        this.doPost(request, response);
    }
}

User.java

public class User {
    private int id;
    private String username;
    private String password;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }
}

DruidUtils.html

import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.pool.DruidDataSourceFactory;

import javax.sql.DataSource;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

public class DruidUtils {
    //Druid德鲁伊,据说是魔兽世界中的一个角色,森林女神
    public static DruidDataSource dataSource;//数据库连接池

    //1.初始化Druid连接池
    static {
        //第二种方式:使用软编码通过配置文件初始化
        try {
            Properties properties = new Properties();
            //通过类加载器加载配置文件
            InputStream inputStream = DruidUtils.class.getClassLoader().getResourceAsStream("druid.properties");
            properties.load(inputStream);
            //创建连接池
            dataSource = (DruidDataSource) DruidDataSourceFactory.createDataSource(properties);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    //2.获取连接
    public static Connection getConnection() {
        try {
            return dataSource.getConnection();//从连接池中获取连接
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return null;
    }

    public static DataSource getDataSource(){
        return dataSource;
    }

    //3.释放资源
    public static void closeAll(Connection connection, Statement statement, ResultSet resultSet) {
        //释放resultSet
        try {
            if (resultSet != null) {
                resultSet.close();
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        //释放Statement
        try {
            if (statement != null) {
                statement.close();
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        //释放Connection
        try {
            if (connection != null) {
                connection.close();
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

}

web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"
         version="3.1">
    <welcome-file-list>
        <welcome-file>Dlu.html</welcome-file>
    </welcome-file-list>
</web-app>

druid.properties

#连接设置
driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/db_book
username=root
password=root

#<!-- 初始化连接 -->
initialSize=10
#最大连接数量
maxActive=50
#<!-- 最小空闲连接 -->
minIdle=5
#<!-- 超时等待时间以毫秒为单位 6000毫秒/1000等于60秒 -->
maxWait=6000

梦さん

关注

0
点赞
踩
2

收藏

觉得还不错? 一键收藏
1
评论
Java Servlet 连接数据库 HTML界面实现登录

Dlu.html<!DOCTYPE html><html lang="en"><head> <meta charset="UTF-8"> <title>登录</title> <style> tr{ height:50px; } ...
复制链接

扫一扫