4.12

/**
 * function： 验证登录
 */

public static boolean login(String account, String password) {
    Connection connection = null;
    boolean success = false;

    try {
        connection = com.example.test_one.utils.JDBCUtils.getConn();

        if (connection != null) {
            String query = "SELECT * FROM user WHERE account = ? AND password = ?";

            try (PreparedStatement pstmt = connection.prepareStatement(query)) {
                pstmt.setString(1, account);
                pstmt.setString(2, password);

                try (ResultSet rs = pstmt.executeQuery()) {
                    if (rs.next()) {
                        Log.d("MysqlHelp_denglu", "用户名和密码匹配成功！");
                        success = true;
                    } else {
                        Log.d("MysqlHelp_denglu", "用户名和密码不匹配。");
                        success = false;
                    }
                }
            }
        } else {
            Log.d("MysqlHelp_denglu", "无法获取数据库连接。");
        }
    } catch (Exception ex) {
        Log.e("MysqlHelp_denglu", "验证登录时发生异常", ex);
        success = false;
    }

    return success;
}